…mysql> select concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema,”.sql”) from tables where engine=’innodb’ limit 5; +——————————————————————————+ | concat(“mysqldump “,table_schema,” “,table_name, ” >> “,table_schema…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…| | slow_query_log_file | /var/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF…Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN | | microsec_process.patch | Adds INFOMATION_SCHEMA…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE | OFF | ON | | SYNC… 200 tables in this system. innodb_stats_on_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries…
Post: MySQL Wish for 2013 - Better Memory Accounting
December 31, 2012 By 6 Comments
… from wait and stage information). Where we’re still walking blind with MySQL is resource usage -… is user variables, complex stored procedures temporary tables or something else. Not only such connection… operations is reasonable. For example if some INFORMATION_SCHEMA query were to take couple of GB…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
…the outline of improvements available in MySQL 5.6 which I thought was… new INFORMATION_SCHEMA Tables – - INNODB_METRICS – - Meta Data Information Tables – - Buffer Pool Information Tables – Improved PERFORMANCE_SCHEMA – - Reduced Overhead – - Simplified Configuration – - Table Access instrumentation…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… an example: Enable the log: general_log_file = /var/log/mysql/mysql.log general_log = 1 User correctly authenticated: 121227 8:31… information. It is important to mention that these tables are stored in INFORMATION_SCHEMA and that means that after a mysqld restart all the information…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…mysql> SET profiling=1; mysql> pager cat > /dev/null mysql…INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = @query_id ), 2) AS Pct_R, COUNT(*) AS Calls, SUM(DURATION) / COUNT(*) AS “R/Call” FROM INFORMATION_SCHEMA…| +———————-+———-+——-+——-+————–+ | removing tmp table |…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… server or MySQL time zone. Fixed bug 1079341: pt-online-schema-change checks for foreign keys on MyISAM tables. Since MyISAM tables can’t have foreign keys, and the tool uses the information_schema to find child tables, this could…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…). If the tablespace has been created with MySQL 5.0 or older, importing that table could crash Percona Server in some cases… on SELECT * FROM INNODB_TABLE_STATS or INNODB_INDEX_STATS. Bug fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB_PATCHES (actually XTRADB…
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…] Table database_name/table_name contains 8 indexes inside InnoDB, which is different from the number of indexes 7 defined in the MySQL This customer was running Percona Server 5.1 and they got this error on two tables during a… simply use the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL until 5…
