Hi,
I´m having a serious performance problem with my MySQL. The CPU is most of time with a load of 60%-95%.
I´m using MySQL-4.0.14 on a FreeBSD-5.1 box. It´s a Celeron-2.0 Ghz - 512 Mb RAM - 40 Gb of Hard Disk.
I think the main problem the queries struct wrongly build, but at this time I need to solve the main problem (slower pages) at first. And after that, change the site structure with more calm times.
Does any good soul could give some tips to solve my problem? Upgrade my MySQL would solve part of the problem? What version should I use?
My application has 71 tables + 261 indexes. It has 3 tables with almost 2.000.000 of records and the orthers have an average of 1.000 records.
Any help would be appreciated.
Thanks, Ronan
Ronan,
You haven't given us much to go on. Is this application running on a web server?
1) How many rows are your queries returning? (on average) and how long does it take?
2) How many connected users do you have?
3) Are these queries using multi-table joins?
4) Can you provide us with the table structure and query for the slow queries?
5) Can you provide us with a "Show Status"
6) Are you using MyISAM or InnoDb tables?
The more information you can provide, the more accurate the answer will be.
The MySQL manual has plenty of articles on optimization: http://www.mysql.com/doc/en/MySQL_Optimisation.html
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
