June 18, 2013

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

…changes are …MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql…in the database (this does not include constraints identified via metadata files!) Anomalies – Identifies possible relationships between columns/tables based on names…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: ,

Post: 10 years of MySQL User Conferences

April 11, 2013 By 6 Comments

…change in MySQL versions for the year. 2005 was the first year O’Reilly partnered with MySQL…databases and technologies in NoSQL and BigData space – PostgreSQL, EnterpriseDB, Hadoop,Hbase, MongoDB, CouchBase providing compliments and alternatives to MySQL. The MySQL…

Filed Under: Events and Announcements, Insight for DBAs, Insight for Developers, MySQL, Percona Live Tagged With: , , ,

Post: Is your MySQL buffer pool warm? Make it sweat!

April 16, 2013 By 6 Comments

… replicating from the active master. In theory, failing over is the…mysql-schema schema_name –query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes…a production database backup to our test database so that our test database was …

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software Tagged With: , , , , , , ,

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

…implied an implicit secondary index with the same name. Fixed by detecting such cases and omitting …data. In some corner cases this could lead to assertion errors in the log parser or bad changed page… for MySQL would re-create the test database when using rpm on server upgrade, even if the database …

Filed Under: MySQL

Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue

April 24, 2013 By Leave a Comment

…implied an implicit secondary index with the same name. Fixed by detecting such cases and omitting …data. In some corner cases this could lead to assertion errors in the log parser or bad changed page… for MySQL would re-create the test database when using rpm on server upgrade, even if the database …

Filed Under: MySQL, Percona Software

Comment: SimCity outages, traffic control and Thread Pool for MySQL

March 21, 2013 By 16 Comments

… a very smart engineer at eBay who’s name escapes me. Because eBay wanted to have a …and gives you an indication of the numbers of database connections the thread pool supported. I was not …changed in a 6 years in code base and MySQL versions, but it was very surprising to find out just few threads in…

Filed Under: MySQL Tagged With: , , , ,

Post: Using Flexviews - part two, change data capture

March 25, 2011 By 26 Comments

…. It seemed like an appropriate name. The Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to determine what rows have changed. Because of…

Filed Under: Insight for DBAs, Insight for Developers, MySQL

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…changes. Unfortunately, I think that hope may be premature. While it is true that InnoDB full-text search in MySQL…in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: InnoDB Full-text Search in MySQL 5.6: Part 2, The Queries!

March 4, 2013 By 7 Comments

…in MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In… InnoDB results change? No, they are exactly the same, although the scores did change slightly. What…database, and I used double quotes to group the search terms as a single phrase: With 5.5: mysql: SELECT id, full_name…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: How to create/restore a slave using GTID replication in MySQL 5.6

February 8, 2013 By 7 Comments

…in which GTID is the master and set it on the slave. MySQL… –all-databases –single-… global variables like ‘gtid_purged’; +—————+——-+ | Variable_name | Value | +—————+——-+ | gtid_purged | | +—————+——-+ …changing GTID_PURGED manually but we can’t change…

Filed Under: MySQL
« Older Posts