June 19, 2013

Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see

… kinds of architectures. InnoDB Compression: Present and Future - (Nizameddin Ordulu, Justin Tolmer, Facebook… some exciting things for their 3.0 release. Day 3 Migrating to …MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION - (Marco Tusa, Pythian) — This seems like a great 5

Post: XtraDB storage engine release 1.0.4-8

… glad to present you release 8 of XtraDB. The release includes following new features: The release is base on 1.0.4… for sponsoring and testing the port of XtraDB to 1.0.4 MySQL 5.1.39 as a base release Fixed bugs: Bugs… Number of mysql-tests are fixed The builds for RedHat4,5 and Debian are located on http://www.percona.com/mysql/xtradb/5.1…

Post: MySQL and PostgreSQL SpecJAppServer benchmark results

Listening to Josh Berkus presentation on OSCON today I decided to take a closer look … big issue is using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved in 5.0.37 which I’d… slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL 5.2

Post: Data Recovery Toolkit for InnoDB Version 0.1 Released

… pretty decent set of features: Supports both REDUNDANT (pre mysql 5.0) and COMPACT (mysql 5.0+) versions of tablespaces Works with single tablespaces and file… to another table and/or was partially destroyed Supports all MySQL data types except BLOBs, SETs and BITs (will be implemented… of the cases) Results are presented in CSV file format which could be used with MySQL‘s LOAD DATA function So, if…

Post: Percona Server 5.1.52-12.3

…. Functionality Added or Changed Percona Server 5.1.52-12.3 is now based on MySQL 5.1.52. New Features Added: HandlerSocket… it was enabled before” was sometimes reported after upgrading from MySQL 5.0. (Yasufumi Kinoyasu) Bug #643463 – Shutting down XtraDB could take up… check is now made to see if clock_gettime() is present in librt at the configure stage. If yes, -lrt is…

Post: High-Performance Click Analysis with MySQL

… lifecycle of your application in advance. What about partitioning in MySQL 5.1?  I know there are some cases when it… can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work on… OpenSQL Camp to talk to Alex Esterkin and see him present on it, and based on that exposure, I think they…

Post: Should we give a MySQL Query Cache a second chance ?

… core of original implementation which appeared in MySQL 4.0 Query Cache was designed to work … same “cheat” as MySQL 5.5 uses for Innodb Buffer Pool and have multiple MySQL Query Cache instances … and operation can be presented as some INFORMATION_SCHEMA tables. Self Refresh MySQL Query Cache causes …

Post: Looking for RAID Controller without Battery Learning problems ?

…its impact to MySQL Performance. Here are …5.2-0 (18252) Firmware : 5.2-0 (18252) Driver : 1.1-5 (24702) Boot Flash : 5.2-00, Segment 0 : Present (0,1) WD-WXL1E11WFZ23 Group 0, Segment 1 : Present (0,0) WD-WX11DB003670 Group 1, Segment 0 : Present (0,2) WD-WX11DB006532 Group 1, Segment 1 : Present (0

Post: MySQL Northern European Customer Conference

presentation about MySQL features and Roadmap. Not what it was something new but it was good to hear about release plans for MySQL 5.1 (Q1 2008) and MySQL 6.0 (Q4 2008) – which sounds pretty ambitious to me but we shall see how many resources 5… ? Well It was perfect presentation from Marketing side perhaps the speaker kept quoting benefits of MySQL Enterprise from MySQL Marketing Materials . There is…

Post: Aligning IO on a hard disk RAID – the Benchmarks

… Memory, BBU Present BBU | 100% Charged, Temperature 34C, isSOHGood= VirtualDev Size RAID Level Disks SpnDpth Stripe Status Cache ========== ========= ========== ===== ======= ====== ======= ========= 0(no name) 1… running on a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/run/mysqld… a hard time thinking how it would be best to present results so it’s not too stuffed and actually interesting…