…we often hit the … is how…_tables’, ’102′ ‘Com_update‘, ’15146253′ ‘Com_update_multi’, ’0′ …’Slave_open_temp_tables’, ’0′ ‘Slave_retried_transactions’, ’0′ ‘Slave_running…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql…
Post: Read/Write Splitting with PHP Webinar Questions Followup
January 23, 2013 By 4 Comments
… RBR is faster than statement based, correct? A: Often that’s true, Row-Based Replication (RBR) …to. Q: What about write splitting (updates,inserts) on multiple MySQL servers? Or is it possible to split…distinction. It means that the slave could have an inaccurate idea of how much it’s lagging, if…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… often means “never” because MySQL servers are restarted frequently enough. Even once per 3 months is often …also may be getting different plans on different slaves with same data. Another difference when it… to NULL in both tables and see how values change: mysql> update antest set c=NULL; Query OK, …
Comment: Upgrading MySQL
January 17, 2010 By 24 Comments
… can take and also how you are using MySQL. MySQL often recommends (if possible) doing an upgrade by doing a MySQL dump of the databases… to update the server itself. This of course gets picked up by the slaves and breaks replication as it fails on the slaves…’s often best to build a new master (originally just a slave which has been upgraded), and then put all existing slaves underneath…
Post: Reasons for run-away main Innodb Tablespace
June 10, 2010 By 2 Comments
…MySQL CACTI Templates will have the graphs you need. If you’re looking at SHOW INNODB STATUS this is how…. One related question I get asked often is why Master and Slave may get so much different table … workload is very different. On one hand slave has all updates going from one thread so it has …
Post: Predicting Performance improvements from memory increase
August 7, 2008 By 6 Comments
… anyway. Interesting enough because of MySQL scaling issues it is also…Consider for example bunch of transactions updating single row in the table…. without serialization issues (say reporting slave) which is very IO bound … guess how much data application to get some ballpark figure and often it…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
… and MIT). I can’t say exactly how it is improved, because the engine…mysql-patch/mytools What makes fractal indexes so interesting is the amount of IO operations to update… logs. To do this, you often need many, often complex indexes which gives us …it may good fit to non-critical slave where you can …
Post: Using Flexviews - part one, introduction to materialized views
March 23, 2011 By 3 Comments
…output of a SQL statement. MySQL even includes a SQL … of the result set are updated periodically, not each time the…computing the results. You can often generate multiple different blocks …can be done on a slave dedicated to such work. And… posts: Change Data Capture – How Flexviews figures out what …
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… taking backups from slave is often recommended solution. However the current state of MySQL replication makes restoring slave a bit…info) are not synchronized on disk after each update, and even wrose – in case with NFS … each write, but I can’t predict how much performance penalty we will see here, …
Comment: Is DNS the Achilles heel in your MySQL installation?
May 31, 2008 By 16 Comments
…very useful for some setups. They are often easier to digest at a glance than IPs… vendors). How well does the mysql hostname cache work? I thought mysql cached hostnames internally? If mysql is …slaves. There are another 15 boxes in the cluster. We’ve some scripts to keep /etc/hosts files updated…
