… away from Percona MySQL University at Portland, Oregon next Monday, June 17. The latest in a series of FREE one-day educational…, Andrew Ferlitsch will share with how MySQL can be used to provide access to government data. The daylong event will be held… networking possibilities and free drinks for event attendees. If you’re in the Portland area and work with MySQL, then this is…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
…and which are candidates for dropping (why keep old data if you don’t need to?). I get … 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127.0.0.1:5610/… write into your metadata file. Donate – This is free software and John Currier asks for donations so …
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… it. All of Percona’s software is open-source and free, all the details of the release can be found in… #1167109. Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on… started returning data to indicate an incomplete result set. Bug fixed #1185040. Fixed the upstream bug #69379 which caused MySQL clients to…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
…a copy on write filesystem, the snapshots are free, no performance penalty. You can easily run …The tpcc database, which contains a lot of random data that doesn’t compress well showed a … on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona …All of Percona’s software is open-source and free, all the details of the release can be… after an INNODB_CHANGED_PAGES query started returning data to indicate an incomplete result set. Bug fixed #…
Post: How people are using MySQL... from 1 user to 100 million (upcoming conference talk)
June 11, 2013 By Leave a Comment
MySQL can be deployed in several ways, and that means you …, because of asynchronous replication, you can end up having inconsistent data on the nodes and encounter replication errors, which you have… me know if you plan on attending – and also feel free to post questions in advance below.
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
…-checksum/pt-table-sync, to check if data on replicas is in sync with data on the master pt-stalk, to gather… tables without downtime You can reserve your spot for this free MySQL webinar now. If you can’t attend you’ll receive… on “5 Percona Toolkit Tools for MySQL That Could Save Your Day”Percona Toolkit for MySQL is a must-have set of…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… of Percona’s software is open-source and free, all the details of the release can be… was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost…. (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
… of Percona’s software is open source and free, all the details of the release can be… was used with –innodb-optimize-keys and –no-data options, all secondary key definitions would be lost….1032139. Percona Server was missing help texts in the MySQL client because the help tables were missing. Bug …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… linkbench dataset has 10M ids(after load of data size of datadir ~10GB). We used this dataset…Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate…, char const*, unsigned long) | |–99.14%– buf_LRU_free_block(buf_page_t*, unsigned long) | | | |–100.00%–…
