…But fsck? These days this amounts to running a journal replay. Takes under a second in most circumstance …queries on last month. All last month will be hot on the slave which is doing reads but only last few…of operation to work. This is not to mention other things you can do with MySQL Replication, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, too. The last three commands …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…in to do some further work about 6 months after Peter helped a client. Now, if Peter worked with the client 6 months… it a day before the audit…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
… with MySQL 5.1 stability. I know people who are happy with MySQL 6.0 and Falcon stability for months now – it works for… release. MySQL Release Quality Guildines devaluated during last years probably worse than dollar in the last century. In early days it was “no known bugs in release…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… last week’s event in only a few months, without momentum, and we had to work with the space and dates that were available. In 2013 we have none of those limitations: the conference is a day… for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The SkySQL/MariaDB, Sphinx, and Drizzle day…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… (Google, Yahoo, MSN) provides real-time reporting last time I was involved with them (and …day and then you do a lot of queries over 365-day ranges for year-over-year analysis, aggregate again by month…work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…days is removed. This is very convenient feature and allows you to cost effectively store long term backups with little additional work…MySQL in parallel using all your resources available Downloading from s3 in…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
…in my sample file so we can see performance throughout the day…. the time I sampled statistics last week and now, they went… at $0.10 per GB-month of provisioned storage, which I …in various cloud services with great results. In particular, it can be made to work really well if the database fits in…
Post: What’s a good buffer pool read/write ratio?
May 31, 2011 By 6 Comments
… Percona Live last week, someone showed me a graph from their Cacti monitoring…from day to day. I’d just check them once in a while — maybe once a week I’d look at the monthly view…graphs are still working, and haven’t gotten broken due to some problem like privileges or firewall rules. In the ideal …
Post: MySQL Releases first real Community Release
March 18, 2007 By 2 Comments
…days ago MySQL released MySQL…MySQL this one has some community features added, which is great. Also over last half a year MySQL…Sales and Marketing frequently works – lets go ahead…continue to flow in. In fact we …MySQL follows its promises we now will not see any more community binaries for few months…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
…MySQL. I have done dozen of MySQL HA related engagements while working for Sun/MySQL over the last…high-availability solution is running in recovery mode for months without nobody caring …in case of a worse case scenario. For example, 98% availability means a downtime of a little more than 7 days…
