… id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad… available here and from the Percona Software Repositories). Based on MySQL 5.6.11, including all the bug fixes in it….31-30.3). New Features: Percona Server has implemented Log Archiving for XtraDB. Currently this feature implementation is considered ALPHA quality…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… should try to improve to get optimal response times pt-archiver, to efficiently purge purge data from huge tables pt-table… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of… use some of these tools to solve typical, real-world MySQL database administration challenges, such as: Selecting which queries you should…
Post: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 6, 2013 By 2 Comments
During the Percona Live MySQL Conference & Expo 2013 the week before last, we quietly released … Toolkit 2.2.2 with a few bug fixes: pt-archiver –bulk-insert may corrupt data pt-heartbeat –utc –check always… more The first two bugs are important. Those using pt-archiver –bulk-insert with UTF-8 data should definitely upgrade. Those…
Post: Adventures in archiving
February 11, 2013 By 16 Comments
…’s inbuilt row compression MySQL‘s inbuilt compress() function leveraging zlib to provide compression of data. MySQL‘s Archive storage engine. Tooling The… need to be aware that Archive does not have good performance. e.g. mysql> select id from archive_table order by id desc limit 1; +———+ | id | +———+ | 1143883 | +———+ 1 row in set (2.04 sec) mysql> select…
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
…-commerce application. The status may be ‘payed’, ‘shipped’, ‘canceled’ or ‘archived‘. If you use a string, a VARCHAR(15) could be…). If you make the field an ENUM(‘payed’,'shipped’,'canceled’,’archived‘), the values will be stored internally as an integer and… nature. Q: Are these recommendations true of all versions of MySQL? If not which versions? The recommendations I made are valid…
Post: Is your MySQL Application having Busy IO by Oracle Measures ?
January 8, 2012 By 1 Comment
… external storage. 500MB/sec would be exceptional for traditional MySQL as MySQL optimizer with its nested loops joins does not favor sequential… techniques to archive this but it is not the same thing. How many of us are running 5TB per MySQL instance ? 20TB… is to continue to be significant difference between MySQL and Oracle deployments, yet as MySQL is getting better and better handling large…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I… to me, this seems compelling. Managing data and data archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION…
Post: Percona Toolkit 2.1.8 released today with beta support for MySQL 5.6
January 9, 2013 By Leave a Comment
… newer: pt-table-chcecksum pt-online-schema-change pt-archive pt-mysql-summary pt-heartbeat pt-variable-advisor pt-config-diff pt…-query-digest now handles this correctly. Fixed bug 1015590: pt-mysql-summary doesn’t handle renamed variables in Percona Server 5…: pt-heartbeat handles timezones inconsistently. Previously, pt-heartbeat respected the MySQL time zone, but this caused false readings (e.g. very…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 8 Comments
… I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were few main… makes Timour explanation somewhat conflicting though as if we assume MySQL users do not join lots of tables (less than 7… plan computation would be more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… file: -rw-rw—- 1 mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql 984628803 Nov 12 11:29… – almost half the size of archive table. I guess this is due to incremental compression which Archive engine uses, still it should… 40% better than compressed by gzip. I wish Archive storage engine would specify archiving method and compression level. Some people may like…
