var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Optimizing large MySQL table
Today I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..
1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?
2.- Should I repair it using phpmyadmin or just from the shell?
3.- Should I stop http traffic during this optimization?
This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
On the other side, i have the same hardware for the webserver..
# Try number of CPU's*2 for thread_concurrency
max_heap_table_size = 48M
tmp_table_size = 48M
Do you have any suggestions?
Yes, don't bother running OPTIMIZE; it probably doesn't do much for you anyway.
Originally Posted by
Try reducing the interactive_timeout and wait_timeout value to 20 or 30 seconds. And increase query_cache_size=64M.
This will help in increasing the speed.
By digitalpioneer in forum Hosting Security and Technology
Last Post: 05-12-2008, 12:16 PM
By jon31 in forum Programming Discussion
Last Post: 07-10-2007, 07:51 PM
By sasha in forum Programming Discussion
Last Post: 06-28-2006, 09:49 AM
By kalinga in forum Hosting Security and Technology
Last Post: 03-26-2006, 12:58 AM
By International Player in forum Hosting Security and Technology
Last Post: 05-26-2005, 03:24 AM