… are using statement-based replication, even on MySQL 5.1 This is a contentious topic. People love their temporary tables and will ask hopefully “are you sure this isn’t safe… the bottom of the matter. First, I stopped the slave threads so I could choose which statements to replay on the…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 38 Comments
… also have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables, per thread sort buffer which can be allocated. There are also things… you can increase it a bit to be on the safe size and scale appropriately. The third important memory consumer would…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…mysql‘ ‘–infodir=/usr/share/info’ ‘–includedir=/usr/include’ ‘–mandir=/usr/share/man’ ‘–enable-thread-safe-client’ ‘–with-comment=MySQL… root user, unless you are already (garfield:~/work/mysql-5.0.51a) % su…use on-disk temporary storage for intermediate results “tmp_table_on_disk,filesort…
Comment: How fast is FLUSH TABLES WITH READ LOCK?
April 25, 2010 By 28 Comments
… there are couple of good and easy ideas in this thread 
We can add a feature… to do anything to improve backup in MySQL because this would canibalize innodb hot backup …. Indeed this however would NOT be very safe regarding DDL but I believe most systems…to create/alter/drop any non temporary tables…
