On 12/15/15 20:22, Bryn Hughes wrote: > MySQL is clever enough that it won't assign memory until it actually > needs it.
This is true to a point. It is NOT true of the InnoDB buffer pool, which is pre-allocated at startup time and cannot be dynamically resized prior to MySQL 5.7. It is generally accepted that the "sweet spot" for InnoDB performance begins with the buffer pool size 25% to 30% larger than the total volume of InnoDB data plus indices. However, the unconfigured compiled-in default size is 8MB. If you have an 8MB buffer pool and 300MB of data you will be hurting. I would advise that you set your InnoDB buffer pool somewhere in the range of 512MB to 1GB for now, and monitor for data growth. Other things you want to consider: - What MySQL version are you running? The 5.5 branch will be end-of-life on December 31, and anything older already is. At this point you should be running 5.6 or 5.7. - If you're running 5.5 or later, you should be using innodb_file_format = Barracuda. This becomes the default in 5.7. - If you're running 5.5 or later, you should also be using innodb_file_per_table. This id the default from 5.6 on. - If you want to change either of those two after the fact, the best method is to do a full dump, reinitialize the InnoDB global tablespace, then reload. - Consider Percona Server. It is free to use and has a number of performance tweaks and improvements vs. community MySQL. Also, it includes meaningfully useful hash algorithms for checksumming. While you're at it, consider installing Percona Toolkit. (Community MySQL supports only MD5, which is slow, and crc32, which is worthless. Percona Server adds fnv64 and murmur, both of which are cryptographically secure and much faster than MD5.) -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
