… predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows on a 4GB RAM system, Red Hat Enterprise with dual SCSI… will have to do this check in the application. Just my experience. I know some big websites are using MySQL, but…
Comment: Why you should ignore MySQL's key cache hit ratio
March 1, 2010 By 28 Comments
Patrick, can you substantiate that assertion more? In my experience, “tuning by ratio” leads to wildly stupid results that … people would’ve been better off not touching their default my.cnf at all. So I’d flip things around: in 80… finger and poked it into the breeze: “I have 4GB of RAM and 1GB of indexes on disk, so 256MB of key…
Comment: Why MySQL could be slow with large tables ?
August 21, 2006 By 141 Comments
… Linux. The box has 2GB of RAM, it has dual 2.8GHz Xeon processors, and /etc/my.cnf file looks like this. [mysqld… new row). Up to about 15,000,000 rows (1.4GB of data) the procedure was quite fast (500-1000 rows…
