June 20, 2013

Post: Percona Server 5.6.11-60.3 first Release Candidate now available

June 3, 2013 By 3 Comments

… server starting if the innodb_data_home_dir variable didn’t have the path separator at the end. Bug fixed #1181887… an incomplete result set. Bug fixed #1185040. The INNODB_CHANGED_PAGES table couldn’t be queried if the log tracker wasn’t running…

Filed Under: MySQL, Percona Server, Percona Software Tagged With: ,

Comment: ZFS on Linux and MySQL

May 28, 2013 By 17 Comments

…’t think the Linux port is that inferior to make a sizeable difference. Seems very consistent with Solaris at least. @Raghavendra: b…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Comment: Sphinx search performance optimization: multi-threaded search

May 24, 2013 By 10 Comments

Hi Robert, – you don’t actually need to merge sphinx indexes – it does that on … all the indexes you want to merge on the fly (e.g. SELECT cols FROM idx1p0,idx1p1,idx1p2 WHERE …), otherwise if… “merged”. See here for some explanation. And btw, you don’t want to run indexer for the virtual index, you want…

Filed Under: MySQL Tagged With: , , ,

Post: ZFS on Linux and MySQL

May 24, 2013 By 17 Comments

… tpcc test and that’s maybe just normal.  We didn’t try too hard to get better performance because we already… and it is surprisingly cheap.  In fact the best tpcc results I got were when using compression.  I still have to… database, which contains a lot of random data that doesn’t compress well showed a compression ration of 1.70 with…

Filed Under: Hardware and Storage, Insight for DBAs, MySQL Tagged With: , , , ,

Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency

May 22, 2013 By Leave a Comment

… the hot run, as hash indexes are faster than a b-tree index. Also accessing pages from the buffer pool should… usually only when the buffer pool is cold. Please don’t take away that you should be using MyISAM for everything…

Filed Under: Benchmarks, MySQL Tagged With: , , , , , , ,

Comment: Sphinx search performance optimization: attribute-based filters

June 12, 2013 By 11 Comments

…, so we applied the technique described here, but the search results have gone from milliseconds to more than 43 seconds

Filed Under: Insight for Developers, MySQL Tagged With: , ,

Post: Percona MySQL University @Portland next Monday!

June 12, 2013 By Leave a Comment

… work with MySQL, then this is an event you can’t afford to miss… :)   So register now! Please also join the…

Filed Under: Events and Announcements, MySQL, Percona MySQL Consulting, Percona MySQL Support, Percona MySQL Training, Percona MySQL University, Percona Remote DBA Tagged With: ,

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

June 11, 2013 By 3 Comments

Hi Moazam, 1) no, you don’t have to export databases, you can use the existing mysql …

Filed Under: MySQL, Percona Server, Percona Software Tagged With:

Comment: Percona Playback 0.6 for MySQL now available

June 10, 2013 By 1 Comment

I don’t see the reason for inventing such a tool – isn’t the overhead of reading/parsing query logs and tcp dumps very large? Doesn’t this affect the performance metrics? Why not just replay binary logs (simulating concurrent connections using script) or proxy live data to a second server.

Filed Under: MySQL Tagged With: , , ,

Comment: MySQL Performance Forums

June 9, 2013 By 18 Comments

…, Sorry you encountered an issue accessing the forums. I don’t see any issues with them – they are up and running…

Filed Under: Events and Announcements Tagged With:
« Older Posts
Newer Posts »