I’ve been following Percona’s developments closely for years and am impressed with the products.
My machine has an AMD dualcore 185 with 2GB of RAM. Linux 2.6.9. It also has PHP and Lighttpd running on it. I’m still using MySQL 4.1.22 with MyISAM tables and the database is about 3.7GB in 67 tables. The tables with text data have been broken up so that the main meta data are in fixed tables and the text is mostly cached so those tables aren’t read from much. The DB is heavy on the read side with a lot of composite primary keys. Also, backups are made nightly using mysqlhotbackup (which locks the DB for about 10min).
My question: Is it worth it to upgrade to Percona’s 5.5? I’m concerned that the new version will use up more RAM or increase IO, which would increase the load on the sever with no real benefit.
Some details from my.cnf:
thread-cache-size = 10
query-cache-min-res-unit = 2048
Any thoughts on the direction to take?