… 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 14 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…
Post: linux.conf.au 2012 roundup
January 24, 2012 By Leave a Comment
… the software stack. For those that don’t know: linux.conf.au is one of (if not the) most awesome technical… helping people admin machines – go and watch those talks. linux.conf.au (for me) is one of the cannot-miss events… few (err… only) talks that is repeatedly accepted into linux.conf.au. Why? Because Jon manages to compress a whole year…
Post: Lighttpd as reverse proxy
June 17, 2008 By 28 Comments
… file lighttpd-1.4.XX/doc/lighttpd.conf and put to /etc/lighttpd/lighttpd.conf Create directory to store log files, e… actual directory with web documents Uncomment next lines in lighttpd.conf server.modules = ( … “mod_auth”, “mod_status”, “mod_proxy”, … ) mod_status… protect access to /server-status put next lines to lighttpd.conf auth.backend = “htpasswd” auth.backend.htpasswd.userfile = “/var/www/.htpasswd…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
…(self): test_cmd = (“./gentest.pl ” “–gendata=conf/percona/innodb_dict_size_limit.zz ” “–grammar=conf/percona/translog_concurrent1.yy ” “–queries=1000 ” “–threads… server with a test bed test_cmd = “./gentest.pl –gendata=conf/percona/bug826632.zz ” retcode, output = execute_randgen(test_cmd, test…
Comment: Percona build7 with latest patches
November 20, 2008 By 26 Comments
Yasufumi, how the less or more optimal my.conf file should looks for persona MySQL to keep let’s …, and also in read/write (50/50) mode? my current conf: (for MySQL 32bit) [mysqld] max_connections=2000 key_buffer_size…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… on a system with 32 GB of memory: My sysctl.conf looks like this: # Memory optimization vm.nr_hugepages = 14336 vm…_Free: 14336 HugePages_Rsvd: 0 Hugepagesize: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock…
Comment: Why do you need many apache children ?
February 17, 2008 By 15 Comments
…, web server thanks to this article. Timeout setting in httpd.conf do great harm to so many mysql connections in sleep… in mysql error log. After changing Timeout directive in httpd.conf, all seems to be ok. Mysql connections in sleep state…
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.
