June 18, 2013

Post: Galera Flow Control in Percona XtraDB Cluster for MySQL

May 2, 2013 By 5 Comments

…. This setting traditionally defaulted to 0.5, meaning the queue had to fall below…mysql> set global wsrep_provider_options=”gcs.fc_limit=500; gcs.fc_master_slave=YES; gcs.fc_factor=1…might be the result of some brief performance issue on a given node, or perhaps … 0 0 0.9 1 109 0 0 09:22:23 myclu P 3 …

Filed Under: Insight for DBAs, Percona Live, XtraDB Cluster Tagged With: , , ,

Post: The write cache: Swap insanity tome III

April 19, 2013 By 5 Comments

… been something bad for MySQL performance but it is even more important for HA …populate option. That solves most of the swapping issues but… I recently ended up in a situation…27637 8 7 80 5 0 Fri Mar 22 10:03:28 UTC 2013 1 4 291992 …47872 3350 125712 24148 21633 3 4 70 23 0 Fri Mar 22 10:03:40 …

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , ,

Post: TPC-H Run on MySQL 5.1 and 6.0

April 10, 2008 By 16 Comments

…So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data…be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6…MySQL to use CPUs and hard drives this system has more efficiently. Parallel query will be growing issue for MySQL…

Filed Under: Benchmarks

Post: InnoDB in self-compiled MySQL 5.1

September 13, 2007 By 9 Comments

…issue. What I usually do to fast compile and test is ./configure –prefix=/dir/to/mysql…MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1… | DEFAULT | Default engine as of MySQL 3.23 with great performance | NO | NO | NO | …

Filed Under: Insight for DBAs Tagged With: ,

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

March 4, 2013 By 7 Comments

…MySQL 5.6: Part 2, The Queries![/caption] This is part 2 in a 3 part series. In part 1… when performed against …5; +———+——————+——————-+ | id | full_name | score | +———+——————+——————-+ | 74717 | James R Peterson | 23…mode search issue, but…

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

Post: Top 5 Wishes for MySQL

June 29, 2007 By 10 Comments

…Apache, PHP or Linux Kernel. Yes in MySQL 5.1 the situation is changes – now … MySQL server with improved performance and high availability. Of course there is MySQL …we had successful production on 3.23 alpha). However many of new … issues. I’m saying about SubSelects which were added in MySQL 4.1 …

Filed Under: Insight for DBAs Tagged With:

Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

February 4, 2013 By 10 Comments

…1…MySQL instance are contingent upon how/when it was launched, and if you don’t restart your MySQL server very often, this issue…23:59:37)# service mysql restart Shutting down MySQL (Percona Server)… SUCCESS! Starting MySQL (Percona Server).. SUCCESS! [~] (root@revolution 23…performance…

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

Post: How many partitions can you have ?

December 5, 2009 By 19 Comments

… VALUES LESS THAN(1000001) ); I used MySQL 5.1.41 for my tests increasing … 23 seconds for 1000 partitions, which means it slows down 2.5 … issue. The Update path for MyISAM without indexes took 10 seconds for 1…cost you. From this benchmarks the performance remains reasonable with about 100 partitions…

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

Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes

July 25, 2012 By 6 Comments

…perform an insert, this first insert will take longer: percona1 mysql> insert into percona values (0,’percona1′,’vadim’); Query OK, 1…: 120723 23:45:30 [ERROR] WSREP: Local state seqno (6) is greater than group seqno (5): states…generates a lot of problem in case of issue on one of the nodes. It’s …

Filed Under: MySQL, XtraDB Cluster

Post: Statement based replication with Stored Functions, Triggers and Events

December 16, 2011 By 4 Comments

… VALUE(NEW.i); mysql> insert into t VALUES(1),(2),(3); Binary Log: #111213 23:16:21 server id 1 end_log_pos 269…()); mysql> insert into t VALUES(this_year()); Binary Log: #111213 23:25:46 server id 1 end_log_pos 676 Query thread_id=5… and then using it to perform writes. The issue is fixed only in Percona server 5.5.17-22.1. AUTO INCREMENTAL VALUES In order…

Filed Under: MySQL
« Older Posts