June 19, 2013

Post: Experiences with the McAfee MySQL Audit Plugin

May 23, 2013 By 4 Comments

… to the log (all the lists in these variables are comma separated). As pointed …more knowledgeable in MySQL internals can enlighten me here. – audit_record_objs : List of database objects (tables…, which has made using MySQL in PCI or SOX compliant environments, to name just two, artificially …

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

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

… the target database:  mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1  (dynamic variable) Prepare the backup using the… steps 7 and 10 in two scripts: mysql -N -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS…

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

Post: Percona Server for MySQL 5.5.30-30.2 now available

April 10, 2013 By 10 Comments

… index with the same name. Fixed by detecting such … Nin). Running the DDL statement while variable innodb_lazy_drop_table …MySQL would re-create the test database when using rpm on server upgrade, even if the database…Percona Server for MySQL was missing help texts in the MySQL client because the…

Filed Under: MySQL

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

April 24, 2013 By Leave a Comment

… index with the same name. Fixed by detecting such … Nin). Running the DDL statement while variable innodb_lazy_drop_table …MySQL would re-create the test database when using rpm on server upgrade, even if the database…Percona Server for MySQL was missing help texts in the MySQL client because the…

Filed Under: MySQL, Percona Software

Post: Troubleshooting MySQL Memory Usage

March 21, 2012 By 5 Comments

…uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ? memory tables ? In… TABLE_SCHEMA: test TABLE_NAME: tmp ENGINE: MEMORY NAME: #sql516_1c42_1 TABLE…Database pages 8252672 Old database pages 3046376 Modified db pages 23419 I’m using…

Filed Under: Insight for DBAs, MySQL

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 keeps two global variables…

Filed Under: MySQL

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

February 26, 2013 By 1 Comment

…in our database directory: -rw-rw—-. 1 mysql mysql 8632 Feb 20 15:54 dir_test_innodb.frm -rw-rw—-. 1 mysql mysql…name of a table that has a FT index for the global variable…optimize_start_time | | | optimize_end_time | | | stopword_table_name | | | use_stopword | 1 | | table_state | 0 | …

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

Post: Replication checksums in MySQL 5.6

February 15, 2013 By 3 Comments

…use… show databases like ‘sakil%’; +——————-+ | Database (sakil%) |…global variables like ‘binlog_checksum’; +—————–+——-+ | Variable_name | Value …mysql-bin.000001′ at 2896.’ Conclusion You should not assume that replication checksums in MySQL 5.6 will ensure data integrity in…

Filed Under: MySQL Tagged With: , , ,

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

March 4, 2013 By 7 Comments

… what comes back: mysql: SET GLOBAL innodb_ft_server_stopword_table=’test/innodb_myisam_stopword’; ERROR 1231 (42000): Variable ‘innodb_ft_server… looking for someone’s full name, which I knew to be present only once in the 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: MySQL Wish for 2013 - Better Memory Accounting

December 31, 2012 By 6 Comments

…in MySQL 5.6 I think we’re in …in global buffers growing to consume much more for some unknown needs leaving me puzzled whenever it is user variables… consumption by various database operations is reasonable. … “wait names” we could get something similar in … which connection is using most memory. We…

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance
« Older Posts