June 18, 2013

Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

… Yes [...] The error log tells us why the IO thread has not started: 2013-05-17 13:21:26…> start slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto_increment…file-based replication when gtid_mode is ON? I cant think of any use case, so in practice, you…

Post: Implementing SchemaSpy in your MySQL environment

…working with a set of customers on a longer term basis which has given me time to explore new tools …parent and child_B is properly displayed: Table child_A can be made to display if you tag the …but it doesn’t help SchemaSpy at all.  This is where Metadata files come in to play Creating a Metadata …

Post: Migrating between MySQL schemas with Percona Xtrabackup

… used Xtrabackup simply to clone a server (for replication or migration) or migrate an existing schema to a new server.  However, given the…:  mysqldump –no-data orig > /tmp/orig.schema.sql Create the new target database:  mysqladmin create orig_old Load the schema into the target… issues) with SQL rather than needing to import from a remote server.  This can allow for more targeted restores, easier comparison, and…

Post: Choosing a MySQL HA Solution - Post-Webinar Q&A

a single port. [Don’t try more than 2; the additional work that the kernel has to do in reordering TCP packets can… described in the MySQL manual. You can configure the slave to only replicate a specific database, a set of databases, or specific tables… are seeing. But, if you can connect and run a simple query and receive a response back in a reasonable (what is reasonable is…

Post: MySQL Query Patterns, Optimized - Webinar questions followup

… common.  It can be helpful to simplify the development of a report, but whether it’s a benefit to performance is a case-by… doesn’t though.) Why don’t you try writing a SQL query optimizer and see how easy it is?  ;-)  Generative grammars like SQL can… up matching rows in `title` by a secondary index.  But the result was that it created a temporary table to count the movies…

Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available

Hi, I cant find any 5.1 files in the yum repos. Have they been moved to a new location (for example, I’m checking repo.percona.com/centos/5/os/x86_64/ )? The apt repo seems to be okay though. Thanks!

Comment: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 1

You can replicate from MySQL 5.6 to MariaDB 10.0 or vice versa. You just won’t be able to use the GTID features to automatically pick the correct binlog position when switching to a new master…

Comment: Sphinx search performance optimization: multi-threaded search

… don’t actually need to merge sphinx indexes – it does that on the fly. If you are using sphinxql, you can actually… the index looks as if it was one index, you can create a virtual index with type = distributed that has all the local… “merged”. See here for some explanation. And btw, you don’t want to run indexer for the virtual index, you want…

Post: Choosing a MySQL HA Solution - MySQL Webinar: June 5

… thinking about HA in a holistic fashion and help guide you towards asking the right questions when considering a new or upgraded HA deployment. This webinar will be both technical and non-technical in nature, beginning with a discussion… stack) and then conclude with some typical use cases where a given approach may be well-suited or particularly contraindicated. If…

Comment: MySQL Performance Forums

… seems to be down. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because the resultset is huge, it eventually starts creating a temp table on… by set global query_cache_size = 0; All this on a fairly decent size server where I have 6GB innodb_buffer…