search for: mysqlperformanceblog

I am upgrading a server that mounts in a rack. Its going on the cheapest socket 775 CPU I can buy and in a 1u rack case. All its for is keeping some log files and doing some simple MYSQL/PHP database stuff. Not a work horse at all. Anyway, is it better to go 64bit or 32bit for the CentOS 5.x install? I do not see needing huge amounts of RAM or anything like that on this box. Would the 32bit

...39;ll try to find out if I'm right or wrong. BTW: Is there a way to find out which parts of a programm are swapped out without using monsters like Valgrind? Damn, sounds like an interesting start of the week... [1] http://northernmost.org/blog/find-out-what-is-using-your-swap/ [2] http://www.mysqlperformanceblog.com/2014/04/28/oom-relation-vm-swappiness0-new-kernel/ Cheers to all for the feedback and help, Shorty

Am 05.06.2015 um 18:33 schrieb Gordon Messmer: > On 06/05/2015 03:29 AM, Markus "Shorty" Uckelmann wrote: >> some (probably unused) parts are swapped out. But, some of >> those parts are the salt-minion, php-fpm or mysqld. All services which >> are important for us and which suffer badly from being swapped out. > > Those two things can't really both be

Hello! I have GlusterFS installation with parameters: - 4 servers, connected by 1Gbit/s network (760-800 Mbit/s by iperf) - Distributed-replicated volume with 4 bricks and 2x4 redundancy formula. - Replicated volume with 2 bricks and 2x2 formula. I found some trouble: if I try to copy huge amount of files (94000 files, 3Gb size), this process takes terribly long time (from 20 to 40 minutes). I

Dear all great developers. I wonder if there is any work being done or thoughts being shared regarding prepared SQL statements. Currently I am in heavy need of tuning SQL INSERTS that insert large (3MB) images into blobs. I am using rails 2.3.5 with postgres adapter and pg driver. Any information would be appreciated. Jarl -- You received this message because you are subscribed to the