… a.m. Pacific, I’ll present Percona’s next webinar, “SQL Query Patterns, Optimized.” Based on my experiences solving tough SQL problems for Percona training and consulting, I’ll classify several … of queries with which developers struggle. I’ll test several SQL solutions for each type of query objective, and show how…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… the table structures: mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database: mysqladmin create orig_old Load… into the target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare…’ AND ENGINE=’InnoDB’; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT(‘ALTER TABLE `’, table_name, ‘` IMPORT TABLESPACE;’) AS _ddl…
Post: MySQL Query Patterns, Optimized - Webinar questions followup
June 3, 2013 By 2 Comments
… doesn’t though.) Why don’t you try writing a SQL query optimizer and see how easy it is? ;-) Generative grammars like SQL can produce an infinite variety of queries. The query optimizer…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
… 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
…, and tables with the string NULL instead of the actual SQL NULL value. This is basically a quick sanity check of…
Comment: Neat tricks for the MySQL command-line pager
June 3, 2013 By 13 Comments
On *nix systems, before your sql statement enter: \P more or \P less
Comment: ZFS on Linux and MySQL
May 31, 2013 By 17 Comments
… that the source is not seen for example aggregating Oracle, SQL Server and MySQL into one source that the user or…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… 5.7 the checks will be stricter: in the default SQL mode, a duplicate index will throw a warning instead of…
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…
Comment: Is Synchronous Replication right for your app?
May 20, 2013 By 18 Comments
… is really focused on the more typical workloads of a SQL database — small transactions.
