…In non-optimized binaries, the query would (in most cases) have shown directly in the backtrace. Sidenote: “in most cases“: sometimes you have to…ignore))) 3137 { 3138 res= handle_select(thd, lex, sel_result, OPTION_SETUP_TABLES_DONE); 3139 /* 3140 Invalidate the table in…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
…SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore…case in vast majority of cases. If your replication does not fall behind the SQL…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…case of Stewart recognizing parameters to the read() system call in strace output”. Last …how the Storage Engine API is called. But back to what the above strace shows. In MySQL 5.5 you can find in sql…to confirm) return the fourth byte for the DB_TYPE. i.e. what storage engine it is. We can ignore…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… 18 rows in set (0.00 sec) Now let’s see how…dump_optimized.sql $ time mysql -uroot test < dump_unoptimized.sql…cases when this optimization is not applicable: UNIQUE indexes in ALTER TABLE are ignored to enforce uniqueness where necessary when copying the data to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
… a ranking function automatically. In cases where this is not useful, simply ignore this column. It is used to prevent wide innodb primary keys… examples show how to create a complete refresh view which reads from an incrementally refreshable one. This allows the use of SQL features…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…in a little meta-table. Then your script can figure out which files it can ignore…to think about how to avoid enormous tables that are hard to…to successfully scale large click-processing and other types of event-analysis databases. In some cases I’ve been able to…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…log statements in MySQL Replication. To explain what they are, how to identify them… and how to fix… form the timestamp included in the last executed sql statement. As some of…in case the replication of events with the current server_id didn’t fetch up. There is also the possibility to use IGNORE…
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
…to populate normal tables using SQL). On the Master you can do filtering using binlog-do-db and binlog-ignore… care in use but it can be very helpful in advanced cases allowing replication to control what will be logged to … for you. P.S It is in my todo to see how well MySQL 5.1 row based replication…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… comparison available. The configuration Tom compares results to are not OpenSource and on the hardware…: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation = … I’m curious how much speed benefit did it really provide in this case. innodb_max_dirty…
