tspore

I will turn it on tonight, but phpmyadmin show 0 slow queries.

I disabled cache, and that has already helped a ton. My forum, was going down to a crawl, it was almost unbearable for many. Ok I will leave the cache disabled, and play with it unless someone has something specific.

Thanks for replying back - Here is the other info - 2 x 2 Ghz Dual-core processors and 7 GB of 667 MHz DDR2 Ram. The server gets ~14.21 Queries per second. How can I dedicate 1 GB of ram to the server? I will also disable the Cache on the server tonight.

I really need to speed up my mysql, and I think I have a lot of room for it to go. I am running mysql - 5.0.27 on Darwin - with core2 duo, SAS drives, 7 GB ram. I was over built the server, for web / email / mysql DB sites, but it is way to slow. Currently the server has been running for 10 hours - I have used 2.5 GB ram, and the processors are only around 10%, Ram is at around 2.5 GB, Read / writes are only around 3-4 MBS. So the machine isn't being taxed at all. Non DB sites load very quick, but my issues are with DB sites. They are by far to slow. I am running my-huge.cnf but I don't think that is enough. According to phpmyadmin I see these issues after 10 hours of the server running - Slow_queries 1 - than long_query_time Innodb_buffer_pool_reads 229 - not satisfy from buffer pool Handler_read_rnd 516 k - Handler_read_rnd_next 114 M - tables index Qcache_lowmem_prunes 9,101 - decide which queries to remove Created_tmp_disk_tables 1,455 -tmp_table_size Key_reads 110 k - key_buffer_size value is probably too small. Key_reads/Key_read_requests. Select_full_join 178 - check index Select_range_check 8 - check index Sort_merge_passes 152 - sort_buffer_size system variable. Opened_tables 4,870 - Table cache to small Table_locks_waited 31- split table / use replication So above are my "problematic variables" but really out I don't know what to change, to help get them under control. Here is a real world example - I have a site on a plesk server it takes 1.3 seconds to load home page (non DB used) and then ~1.3 seconds when a product is selected to open that page (DB is used) On my Darwin server - it takes less than 1 second to load the page (Apache / DNS superior) but to open the same product takes around 2-2.5 seconds (DB is used and slow) So outside of adding in my-huge.cnf I don't know what to do. I am thinking that I would like to throw more ram at it (but not sure how to do that) and also remove the cache make it 0 (query_cache_size is 32M now) Even in memory health my key buffer usage is 74.99M but every other second the hit rate is 100% and the traffic usage is every other second 100% too. So some advise on what to do would be greatly appreciated.

Hey guys, I have created a php menu on my site. Basically all I have done, for each page is simply make a header.php, menu.php, and footer.php. For simplicity later to modify content. But I can't figure out how to get the page that I am on to show the active page in the menu. (You know I changed the css to remove the underline on that page, and be a different color. ) So right now on this page: http://fourthirdsphoto.com/special/e3links.php but the link is to that page is the same color as every other page.