… __inet_check_established caused spin_lock. We modify /etc/sysctl.conf, add: net.ipv4.tcp_syncookies = 1 net.ipv4.tcp_tw…
Comment: Visualization tools for pt-query-digest tables
September 6, 2012 By 6 Comments
… order to have “show query” working you need to setup $conf['plugins']['explain'] settings in the config file. At least: $conn…
Comment: MySQL Partitioning - can save you or kill you
June 28, 2012 By 45 Comments
… cores 3 GHz. high speed Raid level 1 disks my.conf parameters –> key_buffer_size=512M table_open_cache = 512 sort…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… don’t see how MySQL could be using any other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 17 Comments
… RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file…
Comment: Getting MySQL Core file on Linux
April 19, 2012 By 1 Comment
… a couple of the proc changes via sysctl (/etc/sysctl.conf) that has the advantage of being durable compared to changing…
Comment: Why not make a tool to improve existing configurations?
February 11, 2012 By 4 Comments
Hi Baron, do You heared about mysqltunner.pl? Maybe this way of tunning existing mysql conf is the right one – run script on mysql machine and analyze what is needed.
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
….log: nohup /media/binlogs/livebinlog.sh /media/binlogs/livebackup.server2.conf 2>&1 > /var/log/livebinlog/server2.log & As a great…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… make it permanent, add ‘elevator=
Comment: Which Linux distribution for a MySQL database server? A specific point of view.
December 13, 2011 By 38 Comments
… config mechanisms with monolithic single static files (e.g. httpd.conf). Debian and Ubuntu increasingly use .d folders, meaning it’s…
