… on RHEL 5. I add the following line to /etc/my.conf: innodb_log_file_size = 104857600 #also tried innodb_log_file…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… any other conf file other than /etc/my.cnf [root@tstlx1 mysql]# locate my.cnf /etc/my.cnf /etc/my.cnf.old /etc/my.cnf.rpmnew [root@tstlx1 mysql]# cat /etc/my.cnf | grep log…
Comment: Getting MySQL Core file on Linux
April 19, 2012 By 1 Comment
I was trying to do the same but adjusting to my environment (and also puppetising) and could not get things to… 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
… 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… time working on Drizzle. Mentoring: we’re Doing It Wrong My Talk: Multi-tenancy, multi-master, sharding, scaling and analytics with…
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 …-only mode, and also in read/write (50/50) mode? my current conf: (for MySQL 32bit) [mysqld] max_connections=2000 key_buffer…
Comment: Why MySQL could be slow with large tables ?
August 22, 2010 By 139 Comments
Eddie, this depends on 1. Your MY.CONF settings http://www.notesbit.com/index.php/web-mysql/mysql/mysql-tuning-optimizing-my-cnf-file/ 2. The type of table it is — is it MYISAM or INNODB? For InnoDB, you may also fix the INNODB specific settings.
Comment: What's required to tune MySQL?
July 27, 2011 By 4 Comments
I must 100% agree to Baron, few months ago I did “tuning” and bench-marked results. Configuring my.conf for InnoDB 70% read workload gave me only 5-7% improvements of query response times.
Comment: 5.4 in-memory tpcc-like load
May 3, 2009 By 11 Comments
… case it’s important to know both). What was your my.conf during this test and how many sessions did you run…
Comment: Returning to InnoDB scalability
August 4, 2006 By 42 Comments
… usable was to put innodb_thread_concurrency=4 in our my.conf . For the SHOW MUTEX STATUS output , here you go :: mysql…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… 5.6 on a system with 32 GB of memory: My sysctl.conf looks like this: # Memory optimization vm.nr_hugepages = 14336 vm.hugetlb_shm_group = 27 kernel.shmmax = 8589934592 kernel.shmall = 4194304 My…: 0 Hugepagesize: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this…
