…MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to stripe the LV when we need to…to start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you … on the nodes and encounter replication errors, which you have to deal with. Even later, when asynchronous or single-threaded replication… the application gets really popular, sooner or later you have to think about write scalability, and implement sharding ultimately. I will…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… time? To find an answer to these questions, let’s create a simple replication configuration with one master and two slaves, all running MySQL… replication This time, we will enable GTID replication on slave #1, but not on slave #2: # slave #1 mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to the select query) also get hang up… ‘Table_locks_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent…
Comment: MySQL VIEW as performance troublemaker
May 23, 2013 By 57 Comments
i have been burned by ms access queries. now that i am into mysql… i certainly want to hear all these view stories. even though i have not yet used them.lol.
Comment: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
… 10,000 tables per mysqld instance. SchemaSpy does take some time to execute but this is generally no more than a couple… this schema into Workbench so I can’t comment as to how well it scales at this volume of tables.
Comment: Derived Tables and Views Performance
May 21, 2013 By 16 Comments
… KEY (`id`)) —————————————————————————————————— $mysql=mysql_connect(’127.0.0.1′,’root’,”); mysql_select_db(‘test’,$mysql); function display_menu($parent, $level) { $result = mysql_query(“SELECT a.id….id = Deriv1.parent WHERE a.parent=” . $parent); echo “”; while ($row = mysql_fetch_assoc($result)) { if ($row['Count'] > 0) { echo “” . $row[‘label…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload … be somewhat mitigated using innodb_old_blocks_time, but that is outside the scope of this … and allow remote users to compare on a live system without needed to grant access to another “backup” server. …
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… want events written to the log. – audit_whitelist_users : This one is undocumented on the wiki at the time of writing, and…”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} In conclusion, the plugin API seems to be opening new possibilities of extending MySQL‘s behavior in…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… 32-bit builds due to a typo. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an…_PAGES query started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to…
