… tables in this way, for example when using replication, a temporary table could vanish if the slave restarts and then subsequent queries against the temp table fail. Q: Why doesn’t the query… up the row with “=” instead of “>” and be guaranteed to find exactly one match. But the tradeoff of this solution is…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… one good way to find out: test it. … show status like ‘%temp%’; +————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open_temp_tables | 1 | +————————+——-+ …Query Server_id: 1 End_log_pos: 288 Info: use `test`; drop temporary table…
Comment: Can MySQL temporary tables be made safe for statement-based replication?
May 27, 2008 By 8 Comments
…Pos: 300 Event_type: Query Server_id: 1 End_log_pos: 272 Info: use `test`; CREATE TEMPORARY TABLE `test`.`temporary_table` ENGINE = InnoDB …really find any consistency. If I create two temp tables, the BEGIN occurs between the two, however if I do create temp table, drop temp table, create temp table…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… by the number of queries issued or any other information find active tables which do not have any indexes used meaning table scans nag users… MySQL performance counters broken down by users (full joins, table scans, disk temp tables, etc.) limiting command availability to SUPER users only or…
Post: Introducing our Percona Live speakers
May 10, 2011 By 4 Comments
… MySQL is very bad at. For example, think about using MySQL to find the top N most important rows per group of… the whole set. That’s a nightmare of temp tables and filesorts and multiple queries and all sorts of things in MySQL — and…, without worrying about paying for drinks or rushing off to find food before you faint of hunger. We don’t have…
Comment: Slow Query Log analyzes tools
December 14, 2007 By 84 Comments
… the search query. After reading this article, I was able to find my problem was that the search query was creating a temp table and populating it with topic ID’s and then building the results off that. After analyzing the long query log… you, thank you, thank you for posting such advanced and useful information.
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
…useful for query optimization, is it? Well, I can still aggregate the slow query log with mk-log-parser and find…
