… | count(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so…event across the cluster a monotonically incremental identifier for each event. Notice …the number of records from the t table s1> select count(*) from t; +———-+ | count(*) | +———-+ | 2 |…
Comment: What Are Full, Incremental, and Differential Backups?
May 22, 2013 By 9 Comments
… once per week using full on the first week, then incremental for 7 weeks thereafter. Using 25MB on week1 then various… of the weeks. Can you give an example in a table? I am doing a project with Open university, and would…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 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… tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t…
Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
June 10, 2013 By 8 Comments
… replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2. Updates involving… – It is not possible to mix non-transactional tables (such as MYISAM) with innodb tables within the same transaction. The same issue…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… the resultset is huge, it eventually starts creating a temp table on disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up. If… as ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written to the… the server up with –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple…
Comment: How to change innodb_log_file_size safely
June 6, 2013 By 17 Comments
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
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
…, or certain features don’t work past N number of tables? In my experience, the schemas I have under SchemaSpy reach at max approximately 3,000 tables per schema and perhaps 10,000 tables per mysqld instance. SchemaSpy does take some… as to how well it scales at this volume of tables.
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…
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…
