… Load the schema into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables…tables that are missing in the incremental backup directory. Bug fixed #856400. Percona XtraBackup would leave stale xtrabackup_tmp…. innobackupex would fail if the SQL_MODE was set to ANSI_QUOTES…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…sql_modeblogpercona.commanual sql_notesblogpercona.commanual sql_quote_show_createblogpercona.commanual sql_safe_updatesblogpercona.commanual sql_select_limitblogpercona.commanual sql_slave_skip_counterblogpercona.commanual sql…tmp_table…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_5_30/tmp | /mnt/data/sandboxes/msb_5_6_10/tmp | | TABLE_OPEN_CACHE | 400…| PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES | 10000 | 1556 | | SQL_MODE | | NO_ENGINE_SUBSTITUTION | | INNODB_…224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… are used on SQL layer and apply to all storage engines. Lets start with a bit of history. When MySQL was just…. You still have some tables in MyISAM format in “mysql” database. Plus HEAP/MEMORY tables are used for temporary tables which may become MyISAM… Innodb. tmp_table_size This variable specifies maximum size implicit temporary table (created during query execution automatically) will grow as MEMORY table before it…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… sql-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 transaction-isolation=READ-COMMITTED user=mysql…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed by the slave’s SQL thread. This patch…. # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No # Filesort: Yes Disk_filesort: No Merge_passes: 0… execution Tmp_table will be set. Sometimes that table must be created on disk instead of in memory, in such case Disk_tmp_table will…
Post: CVE-2012-4414 strikes back in MySQL 5.5.29 (and what we're doing in Percona Server 5.5.29)
January 13, 2013 By 4 Comments
… rpl_mdev382: eval LOAD DATA INFILE ‘$MYSQLTEST_VARDIR/tmp/f”le.txt’ INTO TABLE `t“1` FIELDS TERMINATED BY ‘,’ ESCAPED BY ‘\\\\’ ENCLOSED… ‘You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax…: ‘db1`; SELECT ‘oops!”. Query: ‘LOAD DATA INFILE ‘../../tmp/SQL_LOAD-2-1-1.data’ INTO TABLE `t“1` FIELDS TERMINATED BY ‘,’ ENCLOSED BY…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… MySQL Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode… tables use in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table in its own…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysql> SHOW PROFILE; +——————————+————+ | Status | Duration | +——————————+————+ . . . | copy to tmp table | 184.694432 | . . . +——————————+————+ 18 rows in set (0.00 sec) mysql…
