…TABLES WITH READ LOCK to temporary make MySQL read only. In many cases the period for which server has to…tables and you’re not actively changing users, stored procedures etc (which are stored in MyISAM tables…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
…stored procedures…temporary_tables where engine=’memory’; +——————————-+ | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.00 sec) You can even go deeper to…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…stored procedure to hold the transaction, which this time will insert data from the temporary table into a non-temporary InnoDB table: master > delimiter // master > create procedure…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to determine when an in-memory temporary table will be converted to an on-disk table, which is an expensive operation. In…stored procedures, which are more difficult to analyze because you have to pull out the statements and analyze them individually. The goal is always to…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
…in binary log – even for backup recovery, for example dealing with temporary tables (unless they are used to populate normal tables…stored procedures), however Stored Functions are not – so if you have updates done by stored functions the tables are not taken into…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…table will perform complex operations such as full table scans, sorts, or need temporary tables…to be ignored but certain queries can have very large memory requrement for this step, especially specially crafted ones. Stored Procedures. Compex stored procedures…
