I followed the article, mysql is working fine now, but i dont see any innodb tables in phpmyadmin, when “check table” it says table does not exist
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT …optimizer and the MySQL version, we always recommend to check manually the optimizations proposed by Percona Toolkit. The …
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…. Percona, Michael Coburn <tables> <table name=”parent” comments=”Parent table“>
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… there are different types of subqueries (correlated, non-correlated, derived tables, scalar subqueries) and we saw in my presentation that sometimes…-by-case decision. There are other drawbacks to using temporary tables in this way, for example when using replication, a temporary… again for attending my webinar! Here are some more tips: Check out upcoming Percona Training classes in North America and Europe…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS…. Bug fixed #1186831. Reduced the overhead from the Handle Corrupted Tables check as it was missing branch predictor annotations. Bug fixed #1176864…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…_port=10002; mysql> start slave; # And then check the number of records from the t table s1> select count(*) from t; +———-+ | count…’ column would have been useful. In our case we can check that 3ec18c45-c3ae-11e2-b986-0800272864ba is the server UUID…
Comment: Using Flexviews - part two, change data capture
March 22, 2013 By 26 Comments
process_rows() always check table_ordinal_is_unsigned, why continue check it in bulk insert mode?
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
…, to efficiently purge purge data from huge tables pt-table-checksum/pt-table-sync, to check if data on replicas is in sync with… purge data from a huge table without putting too much load on your server How to check which tables are affected when someone accidentally wrote to a replica and fix the problem without rebuilding the tables How…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex…. Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup failures that are caused by the… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex…. Making the interval configurable allows to reduce the time between checks which can prevent XtraBackup failures that are caused by the… crash when preparing the 5.6 backup with partitioned tables. Bug fixed #1169169. Tables that were dropped between taking a full backup…
