…are at any level of tuning, from completely untuned to …I’m in — obviously a FreeBSD box is different). For example, [percona@…RHEL and I know the kernel — knowing this may tell …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 focused… 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…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…do not need to do anything. On Linux, FreeBSD, Solaris you need to set innodb_flush_method… specific kernel versions may have other settings to play with. Finally you can try locking MySQL in memory… what is more important Innodb algorithms are finely tuned with consideration what is in memory and …
