It’s August 1st, 2011, and five years ago on or about this date (who can remember clearly?) Peter Zaitsev and Vadim Tkachenko founded Percona. What’s happened in the last five years?
Percona XtraBackup 1.6 is now available for download and is the current stable release version of XtraBackup.
You probably saw the Twitter storm over Oracle’s pricing changes and InnoDB in the last few days. The fear about Oracle removing InnoDB from the free version of MySQL was baseless — it was just a misunderstanding. Still, in the years since MySQL has been acquired by Sun, and then by Oracle, many MySQL users […]
The Percona team participated at this year’s O’Reilly MySQL Conference & Expo held April 12-15, 2010 in Santa Clara, California. We gave a lot of talks on…
Author: Peter Zaitsev, Justin Swanhart
MySQL Graphing and Trending with Cacti
Author: Baron Schwartz
Percona‘s Performance and Feature Enhancements to MySQL and InnoDB
Author: Bill Schuler, Baron Schwartz…a Bottleneck
Author: Morgan Tocker
XtraBackup Hot Backups and More
Author: Vadim Tkachenko, Morgan Tocker
You can also read more about this conference on Percona site.
Many Percona employees will be at the 2010 MySQL conference. We’ll be giving a lot of informative technical talks on various topics. Here’s a list: Morgan Tocker, Baron Schwartz: Diagnosing and Fixing MySQL Performance Problems Peter Zaitsev: Scaling Applications with Caching, Sharding and Replication Baron Schwartz: EXPLAIN Demystified Vadim Tkachenko: An Overview of Flash Storage […]
After having reviewed the definition my the previous post (The definitions), the next step is to respond to some questions. Do you need MySQL High-Availability? That question is quite obvious but some times, it is skipped. It can also be formulated “What is the downtime cost of the service?”. In the cost, you need to […]
We made new binaries for MySQL 5.0.67 build 10 which include next fixes: We addressed concerns about potential logging and statistics overhead, so now you can fully turn on / off query statistics for microslow patch and user statistics in runtime. Next variables were added:
| slow_query_log | ON |
| slow_query_log_file | /var/lib/mysql/slow_query.log |
for compatibility with MySQL 5.1
| userstat_running | OFF |
to control gathering of user statistics.
With both slow_query_log = OFF and userstat_running = OFF […]
We made new binaries for MySQL 5.0.67 build 7 which include patches we recently announced. The -percona release includes:
| innodb_check_defrag.patch | Session status to check fragmentation of the last InnoDB scan | 1.0 | Percona <email@example.com> | GPL | The names are Innodb_scan_* |
| userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS |
| show_patches.patch | SHOW PATCHES | 1.0 | Jeremy Cole | N/A | |
| innodb_io_patches.patch | Cluster of past InnoDB IO patches | 1.0 | Percona | GPL | This patch contains fixed (control_flush_and_merge_and_read, control_io-threads, adaptive_flush) |
| innodb_show_hashed_memory.patch | Adds additional information of InnoDB internal hash table memories in SHOW INNODB STATUS | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
| innodb_io_pattern.patch | Information schema table of InnoDB IO counts for each datafile pages | 1.0 | Percona <email@example.com> | GPL | INFORMATION_SCHEMA.INNODB_IO_PATTERN |
| microsec_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
| innodb_locks_held.patch | Add locks held, remove locked records in SHOW INNODB STATUS | 1.0 | Baron Schwartz <email@example.com> | GPL | Bug #29126 fix |
| microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona <firstname.lastname@example.org> | GPL | |
| mysqld_safe_syslog.patch | Patch allows redirect output of error.log to syslog-ng | 1.0 | Percona <email@example.com> | GPL | Ported from Debian |
| innodb_fsync_source.patch | Information of fsync callers in InnoDB | 1.0 | Google | GPL | |
| innodb_show_bp.patch | show innodb buffer pool content | 1.0 | Percona <firstname.lastname@example.org> | GPL | |
and -percona-highperf release additionaly includes
| split_buf_pool_mutex_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | |
| innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0 | Yasufumi Kinoshita | BSD |
You can download RPMs for RedHat / CentOS 4.x and 5.x for x86_64, binaries, sources and patches there
Percona will be at Southeast Linux Fest tomorrow and Saturday. We’re supporting the event, and we hope to meet you there. If you’ve never been, this is a great regional show that’s grown enormously in the last few years. Peter and I will both be speaking: Peter about optimizing MySQL configuration, and I will talk […]
Percona, the company maintaining MySQL Performance Blog has a good presence on the conference this year. We have me (Peter), Vadim, Aurimas, Baron and Andrew attending the show. Alexey had to stay because he could not get Visa in time and Maciek is staying to be able to reliably service emergencies arising with our customers.