… ALTER TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb… default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache=16384 innodb…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
…innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb… a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes… mysql 12u REG 253,10 0 16 /tmp/iblnLBhO (deleted) The 4th column contains…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…InnoDB my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf –apply-log –export /tmp/2012-01-22_14-13-20/ Now we’re going to delete some data from one table…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_mutex patch). my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size=15G innodb_data_file_path=ibdata1:10M:autoextend innodb_file_per_table=1 innodb_flush…_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… contains a mix of innodb and myism tables and run on linux with 16gigs or ram. Here is our my.cnf # sammple MySQL config… max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer… you are using InnoDB tables #innodb_data_home_dir = /usr/local/mysql/data/ #innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend #innodb_log_group…
Comment: Why MySQL could be slow with large tables ?
November 14, 2008 By 141 Comments
…_read_rnd_next 4,483 M Created_tmp_disk_tables 5,270 Created_tmp_tables 5,274 Created_tmp_files 37 k Key_reads 4… my.cnf are not modified. Why? Where are written this configs? – do i switch table from MyISAM to InnoDB (if yes, how to configure InnoDB for best performance?) – what parameters i need to insert manually in my.cnf…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…GB – RAM 12 Core Processor 1TB – Disk My.cnf ========== freehold: [client] port=3323 socket=/tmp/mysqld_mdmp.sock character-sets-dir=/home/…innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb_open_files=2048 #Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…. If you don’t specify it in my.cnf file, the remaining part of the configuration … string. [qc_miss, full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk] It …InnoDB extensions msl patch for MySQL 5.0.51a with InnoDB extensions msl patch for MySQL 5.0.54a with InnoDB…
