…how to switch to…running MySQL 5.6 with GTIDs disabled. First try: configure only one of the servers…servers) or GTID-based replication only (gtid_mode=on for all servers). Additional question: how can you know…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql…how SchemaSpy identifies the relationship, and whether you need to provide a hint or not. Running SchemaSpy (with Foreign Keys) When you run…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… of this blog know (or should know) about Linux swappiness setting, which basically controls how important is the file …the backups to S3. Why? The push to S3 was especially puzzling since MySQL was not involved. The server was running with … si so bi bo in cs us sy id wa st Fri Mar 22 10:03:22 …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…ability to measure the ad’s value? Is it enough to know how many …to. This goes back to what data you really need to make your business run…to build your aggregate tables to avoid joins. Watch Data Types Does your ad ID… to my next point: Use InnoDB Assuming that you will use the stock MySQL server…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…physical id : 1 siblings : 4 core id : 3…to look at MySQL Assuming I don’t see anything noteworthy here, I’ll move on to the MySQL server…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…to really know how to write queries and how…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
…to know about=
Post: How to know if you're updating Slave you should not ?
April 11, 2010 By 8 Comments
…runs out of sync first question you often ask is if someone could be writing to the …thread. There is however a way to know which is which – based on server_id. Here is snippet from …mysql-bin.000002 | grep “server id 101″ | grep Query #100411 19:11:22 server id 101 end_log_pos 360 Query thread_id…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…server id 1 end_log_pos 856 Xid = 85 COMMIT/*!*/; Note how…MySQL server or causing all the connections to get depleted. There are some other interesting consequences as well for application that use MySQL…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…how do you know if this is happening to you? Here’s how I diagnosed it on one customer’s server. The server is running…10.14.82.196] # Thread_id: 3329398998 Schema:…to know all this code, and I don’t know it all, but I’m 80% confident that Quit; is purely in the server…improvements to the MySQL source …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…continues with an overview of how to install and run FlexCDC, and concludes with… .pid file so you know what process to HUP. $ ./consumer_safe.sh –ini=consumer…mysql> select * from flexviews.test_demo\G *************************** 1. row *************************** dml_type: 1 uow_id: 10 fv$server_id…
