June 18, 2013

Post: Implementing SchemaSpy in your MySQL environment

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

Post: 10 years of MySQL User Conferences

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

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

… 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 …

Post: Percona Server for MySQL 5.5.30-30.2 now available

…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

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

…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

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

… 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

Post: Using Flexviews - part two, change data capture

…. 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…

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

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

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

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

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

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