… use sphinx to our website where we have about 1200 tables each with hundreds of thousands of records, for we use…
Comment: Sphinx search performance optimization: attribute-based filters
June 12, 2013 By 11 Comments
Comment: How to change innodb_log_file_size safely
June 6, 2013 By 17 Comments
I followed the article, mysql is working fine now, but i dont see any innodb tables in phpmyadmin, when “check table” it says table does not exist
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors…MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/schemaspy driverPath=/usr/share/java/mysql…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
…unresolved package dependencies when installing Percona Server 5….read any bitmap files. Bug fixed #1184427. Incorrect schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE…MySQL clients to return bogus error number for host-not-found errors…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… set of databases and tables. With this method, every … with, I’d suggest reading over the manual’s …: How do you monitor MySQL to determine when it’s not responsive?…got some variant of this message: 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… backup at a point in time. When running Percona Server, you can utilize the…mysql/orig_old Make sure that the files are owned by mysql: chown mysql:mysql /var/lib/mysql/orig_old/* For each table, run: ALTER TABLE… restore values (potentially corrupted via user error or other issues) with SQL rather …
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… more low concurrency SSB tests when Peter blogged about the …TABLE ENABLE KEYS. my.cnf [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql…32 table_open_cache_instances=8 sort_buffer_size=128k read_…update=off [mysqld_safe] log-error=/var/log/mysqld.log pid…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
…mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error…mysql> change master to master_auto_position = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table…file-based replication when gtid_mode is… downtime or read-only mode, …
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona … need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file …
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… like this in MySQL 5.5, you will succeed without errors or warnings: mysql> ALTER TABLE test ADD INDEX … tool when run on the same table, correctly identifying the redundancy: $ pt-duplicate-key-checker –tables test.test # ######################################################################## …
