… the same availability zone) running RedHat Enterprise Linux 6.2 64bit (I use m1.xlarge size). You put hostnames of the…
Post: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… beware of random writes to RAID5. Operating System First – run 64bit operating system. We still see people running 32bit Linux on… you wrestle OS so it would not swap out MySQL out of memory. MySQL Innodb Settings The most important ones are: innodb… about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM…
Comment: Integers in PHP, running with scissors, and portability
March 27, 2007 By 34 Comments
… 64bit PHP with crc32() function which magically started to return different values. I think MySQL had much better approach in this regard. MySQL internal integer math was always 64bit even on 32bit platforms…
Post: xtrabackup-0.7 (RC)
May 21, 2009 By 4 Comments
… we added binary builds for FreeBSD 7 64bit platform You can download current binaries (64bit) RPM for RHEL4 and RHEL5 (compatible with… and .tar.gz for FreeBSD 7: http://www.percona.com/mysql/xtrabackup/0.7/. By the same link you can find…
Post: Microslow patch for 5.1.20
July 18, 2007 By 3 Comments
… general log now) and slow log to CSV tables mysql.general_log and mysql.slow_log respectively. The patch will not work as intended with those tables, because there is no space for storing 64bit… by the slave thread. This can be achieved by running MySQL with startup time parameter –log-slow-slave-statements. Please note…
Comment: MySQL, AIX5L and malloc()
February 18, 2009 By 11 Comments
Let me give you a little advice for running mysql on aix5.3(powerCPU) After a migration from SLES9 (Intel ….3 (Power6) we run into severe performance problems with MySQL 5.0. (64bit) MySQL and IBM Support were involved to analyze, optimize and… real cpu´s and virtual cpu´s. Mysql supplied many new compiled (Xlc + gcc) mysql 5.0.x versions. Even though all…
Comment: Speeding up GROUP BY if you want aproximate results
March 8, 2008 By 24 Comments
…(lower(page))) | +————————————+ | 83101 | +————————————+ 1 row in set (0.44 sec) mysql> select count(distinct md5(lower(page))) from (select page from… you see high collision rate for. P.S I wish MySQL would get some good 64bit Int hash function built in 
Comment: How innodb_open_files affects performance
April 14, 2010 By 4 Comments
… the os ulimit of “open files”, mysql setting “open_file_limit” affects the OS/MySQL and I believe is non-biased to… open_file_limit is 65535, does this mean a linux 64bit server could never have more than that opened at a…? How would you work around this and why wouldn’t MySQL use LRU algorithm to close OS open’ed files if…
Comment: Innodb Performance Optimization Basics
November 1, 2007 By 75 Comments
… set your buffers and settings too high and restart your mysql server, mysql wont instantly complain. What I think happens is it…. This can seriously impair your performance! My only wishes for mysql would be that they would allow you to log queries… the kid gloves off and run my database on a 64bit machine with a more acceptable amount of ram. After being…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
… a half year we had pretty good track record with MySQL Performance Blog – there were times when site was slow (especially… they had good price for hardware with decent base specs – 64bit CPUs, RAID remote reboot and serial console, backup etc. Plus… less lucky and in about a week after we moved MySQL Performance Blog to the new server, it stopped responding. I…
