June 18, 2013

Post: Statistics of InnoDB tables and indexes available in xtrabackup

…, `mod_is` tinyint(3) unsigned NOT NULL default ‘0‘, `is_adult` tinyint(3) unsigned NOT …=1764 bytes, data/pages=10% level 1 pages: pages=84, data=711669 bytes, data/pages=51% leaf pages: …, index: site_message, space id: 12, root page 8 estimated statistics in dictionary: key vals: 1399286, leaf …

Post: MySQL extensions for hosting

…hosting2′\G *************************** 1. row *************************** User: hosting2 Total_connections: 84 Concurrent_connections: 0 Connected_time: 20 Busy_time: 1 Rows_….option_name | 287 | | hosting2.wp_usermeta.meta_key | 8 | | hosting2.wp_term_relationships.PRIMARY | 720 | | hosting2.wp…

Post: mysql-proxy, urgh performance and scalability ?

… is what performance penalty we have using mysql-proxy, version 0.7.1. So it is easy to test. (By the…-5.0.77MySQL-proxy+MySQL-5.0.77 1 660.02 349.86 2 1158.66 477.77 4 1223.84 485.21 8

Comment: How to recover a single InnoDB table from a Full Backup

…. InnoDB: Progress in %: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18… 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94… 99 100 done. 120323 4:38:52 InnoDB: Error: page 0 log sequence number 6094071743825 InnoDB: is in the future! Current…

Comment: Looking for someone with Chinese knowledge

….com/ss/%E6%88%91%E7%9A%84%E6%B1%BD%E8%BD%A6?location=0 However, I don’t think we… pretty good. So far we’re just doing Chinese UTF-8. We have some folks in China who have done some…