…-io devices. This feature implementation is considered BETA quality. Percona Server has introduced innodb_read_views_memory and innodb_descriptors_memory… introduced a regression that could cause a memory leak if query cache was used together with InnoDB. Bug fixed #1170103. Fixed…
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.
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem possible. Further discussion… same server. This will allow you to compare and restore values (potentially corrupted via user error or other issues) with SQL rather than needing to import from a remote server. This can allow for more targeted…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
…. Basically I have a problem regarding long running select query. A query runs for say 300 seconds and because the resultset is… table on disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table… have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent size server where I have…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… wrong and this may fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com… abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in…
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… gives us more flexibility by allowing users to extend the server‘s functionality with their own code, and this is what…-sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys…
Post: Percona MySQL University @Portland next Monday!
June 12, 2013 By Leave a Comment
… with a talk titled, “Conquering BigData with MySQL and Shard Query” Daniel Nichter, lead of the Percona Toolkit development team, will…
Comment: Impact of logging on MySQL’s performance
June 11, 2013 By 8 Comments
Slow Query should be run on as-needed basis, and re-actively …-actively. I’ve actually see worse performance caused by slow query turned on, especially for very large (but not necessarily slow) queries. It’s a good tool but it should only be …
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
… services or development systems, many people are using a single server with some backups configured, and then simply take the downtime…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 11, 2013 By 4 Comments
… data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re planning to switch back from Percona Server 2) here is the list of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we’re not planning…
