… table to store an interim result set, and then use that to ultimately produce the result you want… distribution of matching rows that you’ll get skewed results. For instance, if there’s a … MySQL Conference and Expo in Santa Clara, California starting March 31, 2014. Watch more webinars from …
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…result. That’s why I prefer the structure from .frm files over taken from…gets created it will have minimal `ID` among the indexes of the table. mysql> select * from… 4 | +———-+——+———————+———-+——+——-+———+ SYS_COLUMNS Table SYS_COLUMNS stores fields names and…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…purposes, I also include the numbers from the vCache test where …based flushing allows the backing store to be written to at… vCache actually appears to get *better* over time; I’…results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… tracking exact rows used from query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local memory… if we can get MySQL protocol to support such light compression in addition to zlib we could stream compressed results directly from storage and…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… also get the table row format from the Information Schema: mysql (information_schema) > SELECT ROW_FORMAT from TABLES… speed: 104857600 B/sec All pages are stored in a single directory with some subdirectories …2212 FIELDS: emp_no from_date [...] The second method has the same result, 0-26 is our …
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
… evaluated as math expression and the result will be IN(-2) which is…performance. At some point the gains from indexes you add will be less…store as VARBINARY(16) for performance reasons. In any case you would likely to get… by scanning data in index order MySQL gets data in already sorted order and …
Post: Handling big result sets
June 26, 2006 By 13 Comments
…gets two parameters and second one is result mode : MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT. (Also there can be used pair mysql_real_query / mysql_use_result…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… would not invalidate query cache so you can get results even if table is locked and is being … or stored procedure calls are not, even if stored procedure would simply preform select to retrieve data from table…. their result set but MySQL has no way to identify which one of them would so it gets rid…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… of the process is rather simple – to get result from the cache and ship it back, so … long term storage If you need something stored long term or something which needs to … different level (ie single object constructed from multiple query results) MySQL Query Cache may improve performance of your…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…MySQL server development: there is support for it in the MySQL Test Framework, DBQP, and the server source is properly annotated to get… hard to find out that mutex_get_waiters is called from mutex_exit and there we …counters at the same time. As a result, some of the stores might be lost, with the …
