…mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb-buffer-pool-size=5600M innodb-file-format=barracuda innodb-file-per-table innodb…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or … can be locked sub-second. Even with innodb only this can greatly cut down on the lock time … putting in the current charset mysqldump … -d -R –skip-triggers, out to the schema file create …
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package) old_passwords=1 skip-locking key_buffer = 384M …variable = innodb_buffer_pool_size=100M set-variable = innodb_additional_mem_pool_size=10M innodb_flush_log_at_trx_commit=1 #skip-innodb skip-name-…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
… from the Percona Software Repositories). Based on MySQL 5.1.66, including all the bug …locks, these S locks prevent X locks from being taken and block the real changes. This fix introduces a new option innodb_locking… optimization, even though it is sufficient to skip just one (e.g. the first one). …
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… with dual SCSI RAID: [mysqld] long_query_time=5 skip-bdb skip-innodb skip-locking query_cache_limit=1M query_cache_size=32M query_cache… set-variable=max_connections=1500 log_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority… fine. MySQL, I have come to realize, is as good as a file system on steroids and nothing more. InnoDB doesn’t…
Comment: FreeBSD tests
August 4, 2006 By 15 Comments
… lot. I used next configs: –port=3306 \ –socket=/tmp/mysql.sock \ –user=root $LOGERR \ –datadir=$FSPATH \ –basedir=$BASEPATH \ –max_…=64M \ –skip-locking \ –server-id=1 \ –innodb_status_file=0 \ –innodb_data_home_dir=$FSPATH \ –innodb_data_file_path=ibdata1:100M:autoextend \ –innodb_log_…
Post: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…bugs: MySQL 5.6.7 locks itself on CREATE INDEX MySQL 5.6.7-rc crashed under tpcc-mysql …MySQL configuration: [mysqld] gdb innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb…10G myisam_repair_threads = 1 myisam_recover user=root skip-…
Post: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
…TABLE option2 (id int not null primary key) engine=innodb; INSERT INTO option2 VALUES (1); # start from 1 # … zone. Ping times are ~0.5ms between nodes. –skip-name resolve is enabled on the server. There … suspect is better described as waiting on a lock. Option #2 will likely scale better in auto_…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…) with the default value of innodb_autoinc_lock_mode=1. Bug fixed #1035225 … the tablespace has been created with MySQL 5.0 or older, importing …skip-innodb crashes on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB…
Comment: MySQL Server Memory Usage
May 17, 2006 By 21 Comments
…[mysqld] user = mysql port = 3306 socket = /var/run/mysqld/mysqld.sock basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp skip-locking key_buffer = …=mysql-bin #innodb_buffer_pool_size = 11468M #innodb_log_file_size = 2867M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb…
