You searched for server configuration - Page 3 of 16

Announcing Percona XtraDB Cluster 5.5.29-23.7.1

January 30, 2013 By Hrvoje Matijakovic 8 Comments

Percona is glad to announce the release of Percona XtraDB Cluster on January 30th, 2013. Binaries are available from downloads area or from our software repositories. Bugs fixed: In some cases when node is recovered variable threads_running would become huge. Bug fixed #1040108 (Teemu Ollakka). Variable wsrep_defaults_file would be set up to the value in [...]

Filed Under: Events and Announcements, MySQL, Percona Software, XtraDB Cluster

MySQL 5.6: Improvements in the Nutshell

January 27, 2013 By Peter Zaitsev 16 Comments

Preparing for my talk for Percona MySQL University in Raleigh,NC, Tuesday 29th of January I have created the outline of improvements available in MySQL 5.6 which I thought was worth sharing to give a feel for how massive work have been done for this release in variety of areas. I’m sure the list is not [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: MySQL, MySQL 5.6, Peter Zaitsev

Sphinx search performance optimization: multi-threaded search

January 16, 2013 By Aurimas Mikalauskas 6 Comments

Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point is 1 CPU core and [...]

Filed Under: MySQL Tagged With: FullText Search, Performance, Sphinx, Tips

Webinar: Avoiding common traps when designing a MySQL application

January 7, 2013 By Stephane Combaudon 4 Comments

On January 16th at 10 AM Pacific/1 PM Eastern, I will give a webinar about the main traps that are awaiting you when designing and building a stable and high-performance MySQL application. I will discuss a broad range of topics, from hardware and backups to instrumentation and indexing. I often see during my consulting practice [...]

Filed Under: MySQL Tagged With: Presentation, Tips

Is there room for more MySQL IO Optimization?

January 3, 2013 By Peter Zaitsev 11 Comments

I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL [...]

Filed Under: Insight for DBAs, MySQL Tagged With: innodb_flush_method=O_DIRECT, MySQL IO Optimization, Percona Server

Announcing Percona XtraBackup 1.6.7

December 21, 2012 By Hrvoje Matijakovic Leave a Comment

Percona is glad to announce the latest stable release of Percona XtraBackup 1.6.7 on December 20th, 2012 (Downloads are available here). This release is purely composed of bug fixes to the previous stable release of Percona XtraBackup. New users should head for Percona XtraBackup 2.0 rather than 1.6. Bugs Fixed: xtrabackup_binary was not included in tar [...]

Filed Under: Percona Software Tagged With: Release, xtrabackup

The Optimization That (Often) Isn’t: Index Merge Intersection

December 14, 2012 By Ernie Souhrada 6 Comments

Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonder why the EXPLAIN plan for a given SELECT would [...]

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

Replication of the NOW() function (also, time travel)

November 28, 2012 By Justin Swanhart 6 Comments

Notice the result of the NOW() function in the following query. The query was run on a real database server and I didn’t change the clock of the server or change anything in the database configuration settings.

mysql> SELECT NOW(),SYSDATE();
+---------------------+---------------------+
| NOW()               | SYSDATE()           |
+---------------------+---------------------+
| 1999-01-01 00:00:00 | 2012-11-29 05:50:03 |
+---------------------+---------------------+
1 row in set (0.00 sec)

mysql> SELECT NOW(),SYSDATE();

+---------------------+---------------------+

| NOW() | SYSDATE() |

+---------------------+---------------------+

| 1999-01-01 00:00:00 | 2012-11-29 05:50:03 |

+---------------------+---------------------+

1 row in set (0.00 sec)

You may proceed to party like it is 1999. How can the NOW() function return a value [...]

Filed Under: Insight for DBAs, MySQL

Realtime stats to pay attention to in Percona XtraDB Cluster and Galera

November 26, 2012 By Jay Janssen 4 Comments

I learn more and more about Galera every day. As I learn more, I try to keep my myq_gadgets toolkit up to date with what I consider is important to keep any eye on on a PXC node. In that spirit, I just today pushed some changes to the ‘wsrep’ report, and I thought I’d go over [...]

Filed Under: MySQL, XtraDB Cluster

Get Me Some Query Logs!

November 22, 2012 By Bill Karwin 14 Comments

One of my favorite tools in the Percona Toolkit is pt-query-digest. This tool is indispensable for identifying your top SQL queries, and analyzing which queries are accounting for your database load. But the report you get from pt-query-digest is only as good as the log of queries you give it as input. You need a large [...]

Filed Under: Events and Announcements, Insight for DBAs, MySQL Tagged With: Conferences, MySQL, slow query, Tools

Announcing Percona XtraDB Cluster 5.5.29-23.7.1

MySQL 5.6: Improvements in the Nutshell

Sphinx search performance optimization: multi-threaded search

Webinar: Avoiding common traps when designing a MySQL application

Is there room for more MySQL IO Optimization?

Announcing Percona XtraBackup 1.6.7

The Optimization That (Often) Isn’t: Index Merge Intersection

Replication of the NOW() function (also, time travel)

Realtime stats to pay attention to in Percona XtraDB Cluster and Galera

Get Me Some Query Logs!

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA