Hi David,
I have a new server trying to setup everything, but i have a lot of high cpu load and slow searching.
My indexes:
{link saved}
atm i run on 1 core 1 gig this will be 2 hope this help.
but what does a mysql database need for good perfomance for ?
i have check the node of perfomance database.
Hope you can help me :)
Thx
HEnk
Hi David.
Hope all Is well!
Just wondering what new indexes are created for search? Would be interested in adapting the indexes. Easily explained?
Hi Steve,
Probably the best thing to do is download the latest distribution and checkout setup.sql where you will see the new index structure against the `products` table.
The main difference is a minimal field set in the SELECT clause in the initial query; with indexes in place that can be used when GROUPing by (search_)name, both of which greatly reduce the probability that the database has to create a temporary table.
After the result set has been found, the remaining fields required for search results display are then re-queried, which you'll see in search.php lines 365-392.
I have a dbmod.php script to apply the new indexes - drop me an email and I'll send you a copy and if you're not sure of the changes at all attach the files mentioned above and I'll patch them for you...
Cheers,
David.
--
PriceTapestry.com
Hello Henk,
The main performance parameters in my.cnf are key_buffer_size and sort_buffer_size - setting both to around 250M seems to get good results.
However, I know you are running a large site that has been online for many years, so I think you would benefit from the new search indexes. If you would like to email me your search.php and products.php as I know your versions are heavily customised I'll implement the new index strategy code for you to try...
Cheers,
David.
--
PriceTapestry.com