June 19, 2013

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

May 21, 2013 By 8 Comments

… time? To find an answer to these questions, let’s create a simple replication configuration with one master and two slaves, all…_Running: Yes [...] The error log tells us why the IO thread has not started: 2013-05-17 13:21:26 3130… = 1; mysql> start slave; and let’s create a new table on the master: mysql> create table test.t (id int not null auto…

Filed Under: MySQL Tagged With: , ,

Post: Migrating between MySQL schemas with Percona Xtrabackup

June 10, 2013 By 2 Comments

… 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… mind for this technique would be: Targeted schema migration (to new schema name) using –include=”^orig[.]“ (i.e. functional partitioning) Combine…

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

Post: Implementing SchemaSpy in your MySQL environment

June 4, 2013 By 2 Comments

… been working with a set of customers on a longer term basis which has given me time to explore new tools using their… will need a Java driver for your database — I’m using the MySQL Connector/J Install the graphiz package Creating a mysql.properties file While not explicitly required, I prefer to create this once so that the…

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

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

May 28, 2013 By 1 Comment

… 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…

Filed Under: Events and Announcements, Insight for DBAs, MySQL, MySQL Webinars Tagged With: , , , , , , , , ,

Comment: MySQL Performance Forums

June 9, 2013 By 18 Comments

… 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…

Filed Under: Events and Announcements Tagged With:

Post: MySQL Query Patterns, Optimized - Webinar questions followup

June 3, 2013 By 2 Comments

… and testing the query optimizer.  The developers have to make a decision about which query patterns the optimizer recognizes, and which… refactor manually.  There could also be some cases where optimizing a query automatically would be more costly than just running the… up matching rows in `title` by a secondary index.  But the result was that it created a temporary table to count the movies…

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

Comment: MySQL alternative Percona Server 5.1.68 -14.6 now available

May 28, 2013 By 3 Comments

Hi, I can’t 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!

Filed Under: MySQL, Percona Server, Percona Software Tagged With: , , , ,

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

May 27, 2013 By 8 Comments

… to automatically pick the correct binlog position when switching to a new master. Old-style replication will work. That being said, I…

Filed Under: MySQL Tagged With: , ,

Comment: Sphinx search performance optimization: multi-threaded search

May 24, 2013 By 10 Comments

… index looks as if it was one index, you can create a virtual index with type = distributed that has all the local… instead, hence only run indexer on idx1p0,idx1p1,idx1p2. Have a nice weekend! Aurimas

Filed Under: MySQL Tagged With: , , ,

Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 10, 2013 By 3 Comments

…. The log tracker thread was unaware of the situation when the oldest untracked log records are overwritten by the new log data… tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum counter values… path separator between the directory and file name components in a bitmap file name could stop the server starting if the…

Filed Under: MySQL, Percona Server, Percona Software Tagged With:
« Older Posts
Newer Posts »