… amazing MySQL manual, especially the option and variable reference table. But…udfsblogpercona.commanual ansiblogpercona.commanual auto_increment_incrementblogpercona.commanual auto_increment_offsetblogpercona…._timeoutblogpercona.commanual Slave_open_temp_tablesblogpercona.commanual Slave_received_…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…table doesn’t get dropped. It’s not really transactional — it just doesn’t auto…mysql-bin.000007 …. omitted …….. Exec_Master_Log_Pos: 207 slave1 > show status like ‘%temp%’; +————————+——-+ | Variable_name | Value | +————————+——-+ | Slave_open_temp_tables…
Comment: MySQL VIEW as performance troublemaker
November 22, 2010 By 57 Comments
… (overall for auto completion purposes). instead of “select * form my_view where my_field = $prm”, I create a temporary table at the start of the process “create temporary table my_temp as (select * from my_view)”, and do the selects on the temp table. Yet, mysql has a long walk…
