…to create or drop a table, or the database itself. Likewise, if a system administrator leaves a temporary… restarted recently. It is surprising how often a server crashes, perhaps …mysql-status is also very flexible and can be used to trigger an alert on almost anything from SHOW VARIABLES and SHOW…
Post: How well does your table fits in innodb buffer pool ?
December 9, 2010 By 12 Comments
…table with partitions to show you will have the real “physical” table name which identifies table down to…temporary measures. I often check these stats during warmup to see what is really getting warmed up first as well as how…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
…to remove this limitation. In 2008 Igor Chernyshev of eBay implemented true-VARCHAR support for MEMORY tables for MySQL…how to request it explicitly and how to set the data block size at CREATE TABLE…tables are still used for temporary tables where the MEMORY tables…
Post: Percona Live: Venu Anuganti; early bird registration expires tomorrow
January 25, 2011 By Leave a Comment
… worked as a database kernel engineer at companies like SolidDB, MySQL, ANTs Data Server and Yahoo! Venu will be presenting on… to thank for the SHOW TEMPORARY TABLES feature which has made its way into to Percona Server, and for detailed investigative blog posts such as How…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…00 sec) Now let’s see how performance is affected when turning… seen from the SHOW PROFILE output, copying the data to a temporary table without updating …TABLE OPTIMIZE TABLE is mapped to ALTER TABLE … ENGINE=InnoDB for InnoDB tables and thus, is just a special case of the previous one: mysql…
Post: MySQL EXPLAIN limits and errors.
July 24, 2006 By 6 Comments
… have access to this dynamic component. If you suspect EXPLAIN is lieing you you can use SHOW STATUS “Handler” statistics to see if… is impossible to tell at which stage MySQL actually perform the sort or creates temporary table and so how much rows will be stored to temporary table. Sometimes…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… know how to read these, there’s a full explanation in our book, High Performance MySQL 2nd … is used to determine when an in-memory temporary table will be converted to an on-disk table, which…the desired modifications to the query or the table. We explain how to interpret what we’re showing, and why…
Post: MySQL VIEW as performance troublemaker
August 12, 2007 By 57 Comments
…Temporary Tables views which you join together you may have serious issues because such tables do not get any indexes. Let me now show…tables it will become nightmare. So be very careful implementing MySQL VIEWs in your application, especially ones which require temporary table…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
…to omit the details and keep this clean. Let’s take a look at the tables. mysql> show table…table: dim1 type: range key_len: 195 rows: 18790 Extra: Using where; Using temporary; Using filesort *************************** 2. row *************************** table… to see how long it would run. How do…
Post: Air traffic queries in InfiniDB: early alpha
November 2, 2009 By 19 Comments
… data files. SHOW TABLE STATUS does not really help there, it shows Name: ontime … load, until someone points me how to get real size, and also …TABLES, which is big limitation from my point of view. As workaround I tried to create temporary table, but got another error: mysql> create temporary table…
