You searched for back to usa - Page 3 of 13

When is MIN(DATE) != MIN(DATE) ?

September 4, 2012 By Ernie Souhrada 5 Comments

Inspiration for this post is courtesy of a friend and former colleague of mine, Greg Youngblood, who pinged me last week with an interesting MySQL puzzle. He was running Percona Server 5.5.21 with a table structure that looks something like this:

CREATE TABLE foo (
 id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
 uid INT UNSIGNED NOT NULL,
 update_time DATETIME NOT NULL,
 ....
 INDEX `uid` (uid, update_time),
 INDEX `bar` (some_other_columns)
 ....
) ENGINE=InnoDB;

CREATE TABLE foo (

id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

uid INT UNSIGNED NOT NULL,

update_time DATETIME NOT NULL,

....

INDEX `uid` (uid, update_time),

INDEX `bar` (some_other_columns)

....

) ENGINE=InnoDB;

When he ran this query:

SELECT MIN(update_time) FROM foo WHERE update_time IS NOT NULL AND update_time <> '0000-00-00 00:00:00';

1	SELECT MIN(update_time) FROM foo WHERE update_time IS NOT NULL AND update_time <> '0000-00-00 00:00:00';

The result came back as 2012-06-22 10:28:16. [...]

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

MySQL Indexing Best Practices: Webinar Questions Followup

August 16, 2012 By Peter Zaitsev 4 Comments

I had a lot of questions on my MySQL Indexing: Best Practices Webinar (both recording and slides are available now) We had lots of questions. I did not have time to answer some and others are better answered in writing anyway. Q: One developer on our team wants to replace longish (25-30) indexed varchars with [...]

Filed Under: Insight for DBAs, MySQL

Impact of memory allocators on MySQL performance

July 5, 2012 By Alexey Stroganov 11 Comments

MySQL server intensively uses dynamic memory allocation so a good choice of memory allocator is quite important for the proper utilization of CPU/RAM resources. Efficient memory allocator should help to improve scalability, increase throughput and keep memory footprint under the control. In this post I’m going to check impact of several memory allocators on the [...]

Filed Under: Benchmarks, MySQL

Data compression in InnoDB for text and blob fields

May 30, 2012 By Michael Coburn 2 Comments

Have you wanted to compress only certain types of columns in a table while leaving other columns uncompressed? While working on a customer case this week I saw an interesting problem where a table had many heavily utilized TEXT fields with some read queries exceeding 500MB (!!), and stored in a 100GB table. In this [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Percona Software

Testing Intel SSD 520

May 1, 2012 By Vadim Tkachenko 8 Comments

Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB into my hands. In this post I show the results of raw IO performance of this card.

Filed Under: Benchmarks, Hardware and Storage, MySQL

Joining many tables in MySQL – optimizer_search_depth

April 20, 2012 By Peter Zaitsev 8 Comments

Working on customer case today I ran into interesting problem – query joining about 20 tables (thank you ORM by joining all tables connected with foreign keys just in case) which would take 5 seconds even though in the read less than 1000 rows and doing it completely in memory. The plan optimizer picked was [...]

Filed Under: Insight for DBAs, MySQL

Percona Live MySQL Conference & Expo Was A Great Event

April 17, 2012 By Baron Schwartz 2 Comments

Thanks to all of our sponsors, speakers, speaker selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand people, the event made a good comeback after last year’s event, but more importantly, the mood was strongly optimistic. I think a lot of people arrived with [...]

Filed Under: Events and Announcements, MySQL

Join Optimizations in MySQL 5.6 and MariaDB 5.5

April 4, 2012 By Ovais Tariq 4 Comments

This is the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post is targeted at the join related optimizations introduced in the optimizer. These optimizations are available in both MySQL 5.6 and MariaDB 5.5, and MariaDB 5.5 [...]

Filed Under: Benchmarks, Insight for DBAs, MySQL Tagged With: batched key access, BKA, hash join, io, JOIN Performance, join_buffer, MariaDB, mrr_buffer, multi range read, MySQL Performance, nested loop join, Optimizer, random read, read_rnd_buffer, sequential read

Announcing Percona XtraBackup 2.0.0 GA

April 4, 2012 By Stewart Smith 11 Comments

I’m really excited to today announce the first GA (Generally Available; i.e. stable) release of Percona XtraBackup 2.0. We have worked hard since our last major release on improving the reliability and user experience of Percona XtraBackup as well as adding features to make it better suited to more environments. The 2.0.0 release contains no [...]

Filed Under: MySQL

How to Monitor MySQL with Percona’s Nagios Plugins

February 22, 2012 By Baron Schwartz 11 Comments

In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features and intended purpose. I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of MySQL monitoring plugins? The typical problem with Nagios monitoring (and indeed with [...]

Filed Under: Insight for DBAs, MySQL

When is MIN(DATE) != MIN(DATE) ?

MySQL Indexing Best Practices: Webinar Questions Followup

Impact of memory allocators on MySQL performance

Data compression in InnoDB for text and blob fields

Testing Intel SSD 520

Joining many tables in MySQL – optimizer_search_depth

Percona Live MySQL Conference & Expo Was A Great Event

Join Optimizations in MySQL 5.6 and MariaDB 5.5

Announcing Percona XtraBackup 2.0.0 GA

How to Monitor MySQL with Percona’s Nagios Plugins

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA