On 8/23/2011 4:32 PM, Reindl Harald wrote:
you are knowing that most buffer-sizes are per connection and so if you have 100 connections your machine will consume 3200 MB Memory for each per-connection buffer?
I was doing a single user import + search validation test initially, so that's fine.
I've tried your 5.5 recommendations, scaled down to my VM's RAM allocation (3GB). I appreciate the help!
Do you build your MySql 5.5 from source, by the way? Since their changeover to CMake, I've had problems getting the sources to build completely. I suspect I need to read more documentation about how to pass configuration options to the CMake build tools.
try the settings below and i bet your machine will be much faster your "innodb_log_buffer_size" is way too small and instead wasting memory for per-connection buffers use it for "innodb_buffer_pool_size" which should be in a perfect world as big as the whole database
Thanks for these, Reindl! I have the database files located on ext4 formatted to *NOT* use a journal, as I figured to give this the best chance to perform well.
=R= _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
