How to recover a single InnoDB table from a Full Backup

Sometimes we need to restore only some tables from a full backup maybe because your data loss affect a small number of your tables. In this particular scenario is faster to recover single tables than a full backup. This is easy with MyISAM but if your tables are InnoDB the process is a little bit [...] [...more]

MySQL Comments (0)

Satiro Array Table

Package: Satiro Array Table Summary: Generate a HTML tables froman options array Groups: HTML Author: Jeferson Inacio Siqueira Description: This class can generate a HTML tables froman options array… Read more at http://www.phpclasses.org/package/7291-PHP-Generate-a-HTML-tables-froman-options-array.html View full post on PHP Classes: Latest entries [...more]

PHP Comments (0)

PHP Slice image into HTML table

Package: PHP Slice image into HTML table Summary: Slice image into a HTML table similar to Photoshop Groups: Graphics, HTML, PHP 5 Author: ikhsan Description: This class can slice an image into a HTML table similar to Photoshop… Read more at http://www.phpclasses.org/package/7284-PHP-Slice-image-into-a-HTML-table-similar-to-Photoshop.html View full post on PHP Classes: Latest entries [...more]

PHP Comments (0)

Beware the Innodb Table Monitor

As I stated in my last post, I decided to use the Innodb Table monitor to diagnose an Index count mismatch error a customers found in their mysqld.err log to verify if the problem still existed. The Innodb Table Monitor has existed for basically forever in Innodb (the MySQL manual discusses it back in the 4.1 [...] [...more]

MySQL Comments (0)

MySQL Performance Blog: MySQL opening .frm even when table is in table definition cache

or… “the case of Stewart recognizing parameters to the read() system call in strace output”. Last week, a colleague asked a question: I have an instance of MySQL with 100 tables and the table_definition_cache set to 1000. My understanding of this is that MySQL won’t revert to opening the FRM files to read the table [...] [...more]

Drizzle Comments (0)


 

February 2012
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
272829