… connections might have created and forgot to remove (or still use for processing). Of course …can do better as you can query temporary tables too: mysql> select sum(data_length+index_length) from information_schema… it should be and I‘m very hopeful future releases of MySQL, MariaDB or Drizzle bring …
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…I‘ve since discovered the blog post in which I mention it: drop table fail (on the road to removing… MySQL 5.5 you can find in sql/datadict.cc a function named dd_frm_type(). In MySQL 5… TABLE RENAME TABLE DROP VIEW open table filling INFORMATION_SCHEMA tables (I think it is actually the TABLES table,…
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 10 Comments
…INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = @query_id ), 2) AS Pct_R, COUNT(*) AS Calls, SUM(DURATION) / COUNT(*) AS “R/Call” FROM INFORMATION_SCHEMA…Calls | R/Call | +———————-+———-+——-+——-+————–+ | removing tmp table | … can…I developed for High Performance MySQL…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…Removing of stale queries in this case can be done through some sort of garbage collection. Support for Delayed Invalidation Many MySQL…can be improved and data about Query Cache content and operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL… this list. I also challenge …
Post: Innodb vs MySQL index counts
November 29, 2011 By 6 Comments
…. The first recommendation I got was to simply use the INFORMATION_SCHEMA.INNODB_SYS_INDEXES table, which exists in Percona Server 5.1, but doesn’t appear in MySQL…removes the existing index in Innodb, which might not be desirable, but at least you can…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…how long it takes, and by the fact removing slave read traffic from non warmed up … load on IO subsystem ? This can take many forms. It can be you running backup through …which queries mysql. I‘ve seen monitoring updates which would add excessively expensive and frequent query on information_schema …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…recommended setup is 3 nodes and you can add / remove nodes almost transparently. It is…of MySQL EC2 setups suffer from lacking a good HA schema. With Galera, we can setup …to copy only changes during this period. I believe that, with integration with Percona… Wiki page with a bunch of information …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…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 3 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: 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 …
