… the buffer pool. A benchmark is worth a thousand words, so let’s repeat the last test with innodb_buffer_pool… . . . | copy to tmp table | 19.805849 | | restoring secondary keys | 53.885502 | . . . +——————————+———–+ 19 rows in set (0.00 sec) So, as expected, a small buffer…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…TABLE from .frm file ? Recovering from .frm for Innodb Table If we simply copy…buffer. mysql> show create table test_innodb; +————-+—————————————————————————————————————————-+ | Table | Create Table…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… image) to help configure the cluster and it uses a copy of this text on this page. To use it, ensure…] socket=/tmp/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-flush-log…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… You can copy …table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer…innodb_buffer_pool_size = 8000M #innodb_additional_mem_pool_size = 80M # Set .._log_file_size to 25 % of buffer pool size innodb…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
…backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults-file=/etc/my.cnf –export /tmp/ Then …”salaries” table: Discard the tablespace of the salaries table: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries DISCARD TABLESPACE; Copy the …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… If the InnoDB buffer pool is…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… a copy of the table, …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘CXX=gcc’ ‘LDFLAGS=’ Take your output and copy&…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…
