O/S: Linux 2.4.20-021stab028.18.777-enterprise - Fedora CPU: GenuineIntel, Intel(R) Xeon(TM) CPU 2.80GHz MySQL: MySQL 3.23.58 --------------------------------------------------------------- I doubt it's anything to do with Plesk, but I'm pulling my hair out here..... I hope I can find a solution to this..... I have one on these VPS with Plesk 7.5.4 from a hosting company. I have this serious problem concerning MySQL.... It keeps crashing, or just gives up. This is a bit of the log: Ok, I added: to my.cnf, ok, great......... However, it still crashes (without the innodb advice), and the error log doesnt give me a reason as to why it crashed/stopped: ..... It crashed 3 times in a space of 24 hours today........ This problem has just appeared (from early December 05), and my hosting support isnt giving me any useful advice, and this problem is affecting my web site(s)...... Anyone have any ideas? Okay. I have a table of 128meg..but that shouldnt make a difference... MySQL is capable of huge tables, no?.. and seeing the log doesn't give me a reason to the crash, let alone which database, how am I supposed to identify the problem? The blind leading the blind here..... Totally stupid...... UPDATE: It looks like its a problem with huge tables/databases, as when I REPAIR TABLE tbl_name EXTENDED, mysql crashed.... am trying it in shell now..REPAIR TABLE tbl_name EXTENDED.... <whistle.. whistle.. whistle..>..... <8 minutes later>.. Table OK.. CHECK TABLE tbl_name.....<1 second later>....Table OK..... Ok, lets try a search in my search engine (beta) for games: Fast, but a bit too slow? However, a week ago it was 12.xxx seconds lol.... Not good at all.. So I'm wondering if my problem is with HUGE tables? If so, I can kiss my search engine bye! and its only indexed 25,312 pages ..... Search Engine Database stats: total number of records in its database is 26,100 - with a total size of 94.4mb (decreased in REPAIR)... If this is the case, then my Directory will suffer too, as the site count is only 31,687 (but a lot pending) - and total number of records in its database is 124,550 - with a total size of 12.4mb... Its ok for now, but in the future? So, is my theory with the big databases valid or flawed?