Am 24.08.2011 01:51, schrieb Robin Horforth: > 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.
yes but depending of max allowed connections your machine will crash and useless big buffers are slowing down things because the memory must be allocated > I've tried your 5.5 recommendations, scaled down to my VM's RAM allocation > (3GB). I appreciate the help! is it faster now? the settings below was also important, i tried only to split because i was not sure which version you are using > Do you build your MySql 5.5 from source, by the way? yes, with a lot of optimizing for Core2 and SSE 4.1, -O6 and so on > Since their changeover to CMake, I've had problems getting > the sources to build completely. i take the orioginal fedora srpms, make my changes for params and compiler flags and build a natvie RPM package - raw source builds are bad because with rpmbuild i have everytime a fresh buildroot and on the other hand i need the packages for 23 machines on the same VMware-Cluster > I suspect I need to read more documentation about how to pass configuration > options to the CMake build tools. i read docs too, but i like it more to optimize the builds of my distribution because they usually knwoing what they are doing and including often a lot of patches, many of them for the build-process depending on the current GCC version > 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 boah do not do this in production below my mount-options and i thought they are a little on the dark side :-) "barrier=0" is ok here because there are two UPS sytems and the SAN-Storage is battery backed too, means the buffers are safe at every time defaults,data=writeback,commit=60,barrier=0,nobh,delalloc,async,noatime,nodiratime,noacl,nouser_xattr,noexec,inode_readahead_blks=64
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
