…systems that are at any level of tuning, from completely untuned to a system …whatever environment I’m in — obviously a FreeBSD box is different). For example, [percona@db1 ~]$ …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…
Post: Back from RIT2007
April 20, 2007 By 6 Comments
… me – there were talks starting from very technical such as FreeBSD kernel tuning, Web QA or AJAX Development, number of Project Management… inconvenient. As you guess you can’t tell much about MySQL Performance Optimization in just 15 minutes so I had to… wrote specially for this conference on MySQL Presentations page. Next week I’m going to MySQL Users Conference to have some more…
Comment: Beware of MyISAM Key Cache mutex contention
January 12, 2010 By 10 Comments
… end to a 3 weeks long 24×7 research. MySQL 5.0.81 on FreeBSD 7.0 4 quad core Xeon 16gb I… load average, mysql master restart needed and apache servers as well. At first I did standard tuning and query tuning but it seemed… and later and the investigation was moving on two tracks: FreeBSD bugs, MySQL bugs. One of the nights I got your post…
Comment: PBXT benchmarks
November 18, 2007 By 14 Comments
… the figures showing the performance details. Do you ever use FreeBSD for MySQL benchmarks? To my dismay, I noticed that the 5… RAM pentium 4 box running FreeBSD 6.2. I went through the Performance Tuning tips found at MySQL‘s website, but it doesn…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… you also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, …do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_…what is more important Innodb algorithms are finely tuned with consideration what is in memory and …
Comment: Choosing innodb_buffer_pool_size
January 20, 2011 By 39 Comments
…. my question: i want to tune a big database. we recently upgrade to mysql 5.5.8 @ freebsd 7.1. the main db is innodb, myisam is used for the mysql-system-tables… 16GB of RAM, most of this would be available to mysql because there is no other productive service running. so far…
