… logs created because SELinux restricts console output as MySQL changes name to “mysql“. Come On, as I remember MySQL And Redhat should be partners or is… the problem about having this a a symlink – I like this approach a lot because it allows you to have database logically in same standard…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 11 Comments
…Change Data Capture (CDC)? As the name implies, CDC software captures the changes made to database rows and makes those changes available in a …MySQL. Change Data Capture can be used to: Monitor a database table, or tables for changes. Improve ETL performance by identifying the data which has changed…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…MySQL 5.0 database with MySQL 5.1 with no problems in most cases. When storage type changes…to be affected. If you’re something like SELECT name FROM users WHERE id=5 you can probably go to the earliest MySQL… Sharded envinronment you often approach things a bit differently – upgrading one shard with …
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… the SLAVE. Since MySQL 4.0 this process is a bit more involved having … replication to work properly you need to have proper “snapshot” – consistent state of the database as …CHANGE MASTER TO accepts Master_Log_File parameter, while you actually want to use Relay_Master_Log_File instead. This naming…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 94 Comments
…to a level where we started looking at other ways of achieving higher availability using MySQL…a master and slaves. The only thing that may change here is clone-max=”3″ which should match the number of database…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…to compare performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL…a difference here and improves performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database…
Post: Introducing tcprstat, a TCP response time tool
August 31, 2010 By 12 Comments
…a database, memcached, Apache, and so on. You can use this information for historical metrics, capacity planning, troubleshooting, and monitoring to name just a…MySQL, this is the moral equivalent of a query’s response time. The statistics we chose to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…changes to the database may have happened since the backup was taken. Replaying the binary logs brings the database up-to-date by replaying the changes…changes to a particular transaction id. Logically, you can not apply changes past the transaction id to…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to change. An example of this is a third-party product whose code you are unwilling or unable to change. We also want to…database. The first step is to find out what MySQL instances are on the machine. It doesn’t do to just assume there’s a… Variable_name | Value | Value | …
Post: check-unused-keys: A tool to interact with INDEX_STATISTICS
June 26, 2009 By 10 Comments
…MySQL server host –ignore-databases Comma-separated list of databases to ignore –ignore-indexes Comma-separated list of indexes to ignore db_name.tbl_name.index_name…changes to…
