…:56:45 [ERROR] /usr/sbin/mysqld: Incorrect key file for table ‘/tmp/#sql_21b2_0.MYI’; try to repair it 120326 16… key to understanding what really happened. MySQL created a temporary table, using the MyISAM storage engine, and when the disk filled… to a solution. PS: You may wish to get a copy of MySQL Troubleshooting by Sveta Smirnova — I have not read…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… | | setup | 0.000027 | | creating table | 0.002255 | | After create | 0.000050 | | copy to tmp table | 61.816063 | | rename result table | 0.161528 | | end | 0.000007….000040 | | creating table | 0.002176 | | After create | 0.000058 | | copy to tmp table | 18.083490 | | restoring secondary keys | 17.824109 | | rename result table | 0.162041…
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…we may make a copy of the table, make the proposed …
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… and then CTRL-C to copy it. Paste this into a text file on shard1 called “/tmp/servers.txt” and run the…-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size=64M…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 7 Comments
… “salaries” table: Discard the tablespace of the salaries table: mysql> set FOREIGN_KEY_CHECKS=0; mysql> ALTER TABLE salaries DISCARD TABLESPACE; Copy the salaries.ibd files from the backup to the database data directory: # cp /tmp/2012-01…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 12 Comments
… 1G-2G where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options… max_allowed_packet = 32M # table_cache=20M # open-files-limit=20000 table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer… #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname tmpdir =/mysql_tmp/:/tmp/ # Uncomment the following if you are using BDB tables #bdb_cache…
Post: Resyncing table on MySQL Slave
June 29, 2008 By 10 Comments
…: LOCK TABLE tbl WRITE; SELECT * FROM table INTO OUTFILE ‘/tmp/tbl.txt’; DELETE FROM tbl; LOAD DATA INFILE ‘tmp/tbl.txt’ INTO TABLE tbl; UNLOCK TABLES; This will dump master’s table… and besides same data loaded to “rep” table you will get the copy of old table in “rep_old” – this can be very…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 10 Comments
… | Pct_R | Calls | R/Call | +———————-+———-+——-+——-+————–+ | removing tmp table | 0.095135 | 55.10 | 3 | 0.0317116667 | | Copying to tmp table | 0.046175 | 26.74 | 1 | 0… | 0.46 | 6 | 0.0001336667 | | Creating tmp table | 0.000548 | 0.32 | 1 | 0.0005480000 | | Opening tables | 0.000196 | 0.11 | 1 | 0…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…-storage-engine’ ‘–without-bench’ ‘–with-zlib-dir=bundled’ ‘–with-big-tables‘ ‘–enable-assembler’ ‘–enable-local-infile’ ‘–with-mysqld-user=mysql’ ‘–with… -m64 -mtune=generic’ ‘CXX=gcc’ ‘LDFLAGS=’ Take your output and copy&paste it to some notepad for later. Next step is… a comma-separated string. [qc_miss, full_scan, full_join, tmp_table, tmp_table_on_disk, filesort, filesort_on_disk] It allows you to…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…Table If we simply copy .frm file back to the database we will see the following MySQL creative error message: mysql> show tables; +—————-+ | Tables…/tmp/test_innodb.frm . cp: overwrite `./test_innodb.frm’? y [root@test3 test]# mysql test; Reading table information for completion of table …
