…MySQL Assuming I don’t see anything noteworthy here, I‘ll move on to the MySQL server. I…INFORMATION_SCHEMA can take a barely-running site and bring it down, so I do this with great care! If it’s not appropriate I…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… in INFORMATION_SCHEMA that can help us to find the different indexes and types. mysql (information_schema) > select i.INDEX_ID, i.NAME FROM INNODB_SYS_INDEXES as i… remove the innodb_table_monitor. C) Check the size on disk of every indes This is very dependent of the table schema…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
…the details of the release can be found in the …fixed #905334 (Laurynas Biveinis). Querying I_S.GLOBAL_TEMPORARY_TABLES … (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … … fixed #896439 (Stewart Smith). Removed the INFORMATION_SCHEMA table INNODB_PATCHES (actually XTRADB…
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
…another side – so I have say 10GB of OS cache used on the server but how can I tell what …this tool MySQL can easily add amount of cached data per table for MyISAM and Archive tables to INFORMATION_SCHEMA (or …is a “tail” of pages which just were not removed from the cache yet. As Innodb does not …
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…1. ibdata1 is erroneously removed 2. ibdata1 is …with a hex editor. I would like to …a user(you can see them in information_scheme database…mysql> select * from `INNODB_SYS_TABLES` where `SCHEMA` = ‘sakila’ AND `NAME` = ‘actor’G *************************** 1. row *************************** SCHEMA…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
I‘ve seen a few people link to an INFORMATION_SCHEMA query to be able to find any indexes …in an effort to find out what indexes should be removed. This method is flawed – here’s the first… in MySQL and can be a much wider window (15-60%) depending on the circumstances. In this case, MySQL flipped…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…schema and running standard MySQL ® 5.0.83, and assume we want to copy order_line table to different server. Note I… XtraBackup, and you can just specify table or…recovery. InnoDB: Reading tablespace information from the .ibd files……i_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Next step is to remove…
