… 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: Converting Character Sets
June 12, 2013 By 22 Comments
… – http://dev.mysql.com/doc/refman/5.1/en/alter-table.html “For a column that has a data type of…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… – as well as go into more detail about using pt-table-checksum tool to verify replication integrity And finally, Andrew Ferlitsch…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
…. – audit_record_objs : List of database objects (tables, according to the docs) for which you want events written to the log. – audit_whitelist…, 2584 audit_json_file=1 audit_json_socket_name=/tmp/audit.sock #audit_json_socket=1 audit_json_log_file=/var/lib/mysql/audit.log audit_record…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… -B <<'EOF' > discard-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` DISCARD TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE… -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… replicate a specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is still written to the… is also somewhat similar to Oracle RAC; all of the SQL nodes in a MySQL Cluster installation are going to be…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…. Percona, Michael Coburn <tables> <table name=”parent” comments=”Parent table“>
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… there are different types of subqueries (correlated, non-correlated, derived tables, scalar subqueries) and we saw in my presentation that sometimes… optimizer and see how easy it is? ;-) Generative grammars like SQL can produce an infinite variety of queries. The query optimizer…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
…Duplicates: 0 Warnings: 0 mysql> SHOW CREATE TABLE test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO…5.7 the checks will be stricter: in the default SQL mode, a duplicate index will throw a warning instead …
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1
May 21, 2013 By 8 Comments
… it: mysql> show slave status\G [...] Slave_IO_Running: No Slave_SQL_Running: Yes [...] The error log tells us why the IO… slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment primary key); Executing SHOW TABLES FROM test on both slaves shows that the table has been created everywhere. So once…
