… raw performance, but there are limitations which MyISAM imposes that are …my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…file_format=barracuda innodb_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
…files_open in InnoDB: my.cnf. InnoDB: fil_sys open file LRU len 0 091118 18:47:44 InnoDB: Warning: too many (68) files stay open…open_files=16384 I got about same crash recovery speed though with no warnings. So it looks like innodb_open_files_limit…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… this variable strives to provide as MySQL is typically protected by Firewall to begin with. open_files_limit = 5000 strangely enough this is where… also promises updated sample my.cnf and getting rid of old my-huge.cnf which are great. Perhaps my jokes about my-huge my-large etc referring…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…/lib/mysql and an /etc/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file…slow query log output. The stock MySQL server’s limitation of one-second granularity makes … It’s like knowing openings in chess — the great chess players study openings exhaustively, but …
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…limited MySQL command output. First one is that you can have innodb-status-file option set in your my.cnf… files (file is physically removed only after it is no longer open…MySQL process ID is: garfield ~ # ps ax | grep [m]ysqld 11886 ? Ssl 0:01 /usr/sbin/mysqld –defaults-file=/etc/mysql/my.cnf In my…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific…/mysql.sock bind-address=10.234.94.71 skip-locking key_buffer_size = 2000M max_allowed_packet = 32M # table_cache=20M # open-files-limit…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/mysqld/sys/5.5.8/share/mysql/charsets… max_heap_table_size=128M event_scheduler=ON query_cache_limit = 10M open_files_limit = 8088 back_log=128 max_allowed_packet = 50M # performance…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2…) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir = /db/mydata tmpdir = /db-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…, 31014 + 27426 = 58440 os file descriptors. So – 1) Do I get errno: 24 becuase I have the open_files_limit set to 40000? 2…) my.cnf: [mysqld] server-id = 2 port = 3306 basedir = /usr/local/mysql datadir = /db/mydata tmpdir = /db-logs/ibdlogs/dbtmp pid-file = /db/mysql.pid… thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp…
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…. Remove ‘/var/lib/mysql//grastate.dat’ file and restart if you …my.cnf Then we can insert in both nodes without any problem when the connection between the nodes is gone: percona1 mysql… trivial donor: options: gcs.fc_limit=9999999; gcs.fc_factor=…42:51.292 INFO: Shifting OPEN -> PRIMARY (TO: 19) 2012…
