Am 03.07.2013 01:25, schrieb Andy Wallace:
> Thanks for the response:
>> how large is your database?
> about 33GB, and growing
>> how large is innodb_ubber?
> from my.cnf:
> # You can set .._buffer_pool_size up to 50 - 80 %
> # of RAM but beware of setting memory usage too high
> innodb_additional_mem_pool_size = 20M
>> how large is the table?
> about 60MB, 95K rows
>> for innodb innodb_buffer should be a large as the whole databases
>> not only the one, all of them, dumb but fact
> Yeah, to do that we'll have to throw a lot more memory in the machine.
> Thanks for the info
[!!] InnoDB data size / buffer pool: 7.8G/5.5G
Variables to adjust: innodb_buffer_pool_size (>= 7G)
2 GB innodb_buffer_pool is a joke for a dataset of 33 GB
that leads in permanently I/O on mixed load at the chances
are high that there are times where nothing needed to
operate is in the buffer_pool and on concurrent load
mysqld ends in repeatly swap data in and out of the pool
at least all repeatly accessed tables should fit
permanently in the buffer
Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc