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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
