… a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.*EDIT….287,581.295,11.042,63.366,14.573 InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket… #we value throughput over response time, get a good plan optimizer-prune-level=0 partition=ON port=3306 read-buffer-size…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… as it gets in terms of optimizations in this space. To keep test alligned to my previous experiments I was running with… raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18… raise the value of innodb_max_files_open in InnoDB: my.cnf So we can see Innodb may with to have so…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… more than simply looking at your my.cnf file. It’s sometimes possible to look at the my.cnf file and see something wrong…. I prefer to speak specifically of configuring, or of performance optimization, or something more descriptive and concrete instead.
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation…_flush_method = O_DIRECT First the options are somethat benchmark optimized – for example doublewrite is disabled; checksums are disabled; binary log… better for operations. innodb_log_file_size = 1600M – another Benchmark optimization. Such large logs typically will cause too long recovery time…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… focus so much on my.cnf. This. At my last job we ran the MySQL off of the ‘small’ cnf (other than max connections… of thing could be said about people trying to find optimal datatypes. I have never seen a performance difference between a…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… the table) – 1 As with any performance optimization effort, you will want to optimize for the common case. If you have a… of the PK lookups). In other words, if you’re optimizing for throughput in this scenario, you will tune innodb_concurrency…=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my.cnf settings: innodb_buffer_pool_size=24G innodb_data_file_path…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… use indexes and that do use some of the new optimizer features. query_cache_size RAM is allocated even if query… per second at high query rates is likely to be optimal until full benchmarking to determine perfect size can be done… do it in the server defaults but in the default my.cnf file that we ship. It’s also done by the…
Comment: Learning about MySQL Table Fragmentation
August 21, 2009 By 20 Comments
… just worked. I add the line to mysqld within my.cnf. I then optimized the fragmented table and the free data went away. However, I did not need to recreate the table unless optimize took care of this already? Also is having innodb_file… better way to go? Or should I disable this once my fragmentation is repaired? Thanks again!
Post: How much memory can MySQL use in the worst case?
February 12, 2009 By 17 Comments
… say “set @@sort_buffer_size := 1 * 1024 * 1024 * 1024;” and my sort_buffer_size is now 1GB. And a single query…’s not forget about the memory needed to parse and optimize and execute queries; mysqld creates internal structures for the query… how it varies. When I’m initially setting up a my.cnf for a server, I usually calculate the Big Ones like…
Comment: Should you have your swap file enabled while running MySQL ?
April 6, 2008 By 31 Comments
… 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 /proc/meminfo looks… Hugepagesize: 2048 kB My limits.conf looks like this: mysql soft memlock unlimited mysql hard memlock unlimited My my.cnf looks like this: large…
