Originally Posted by
Slicker
So I have to ask.... I'm normally a SQL Server or Oracle guy. Only for Collatz do I use MySQL. I tried hosting it on a Windows server and didn't work well at all (due to BOINC never closing the connections which meant thousands and thousands of connections to the database when Windows limits it to 1024 and requires a huge makeover to allow more than that which I consider to be a major BOINC bug but since it supposedly can use any database on any platform -- NOT!) Anyway, do you use MySQL for all the BOINC Stats? If so, how do you keep if from disk thrashing since MySQL seems to perform well only when the entire database is loaded into memory? I had started a stats app a while back and decided that inserts were soooo slow after the table had a couple hundred thousand rows that I just gave up. Are the MySQL performance tips that everyone is keeping secret? Or, does using SSD drives eliminate the IO bottleneck?