…data that I showed how to maintain cheaply in the previous …in MySQL servers I work with when they’re running a simple read-mostly workload with most data in… government work. First, I’ll aggregate arrivals and completions in one-second…a number of queries with longer service times arrive in a clump. …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…ask us how we do a performance audit (it’s our most popular service). I …the operating mode you expect us to work in. Maybe you want us to analyze …query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries that are faster than one second (which in…
Post: How Web Services world affect LAMP Stack
May 22, 2006 By 1 Comment
…querying service if it is down and thus avoid having each page generated with maximum allowed response time. Graceful failure. Web services…how frequently you can call Web Services. So you might want to cache data on Disk – in files or MySQL…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL consulting and other services for MySQL…MySQL Want your developers to learn MySQL best practices ? How to work with large data sets in MySQL or how to optimize queries…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…work. How can I recover deleted rows? We’re going to follow the same example as in…in our data recovery service and it’s open source. I’m going to explain the full process in…Query OK, 3 rows affected (0.01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql…
Post: New MySQL Community Release Policies published
August 9, 2007 By 9 Comments
…queries over half a year ago. These patches had a good support from MySQL Professional Services…in the distributions in 6 months or so, especially more community controlled ones such as Debian. But again if all distributions ship MySQL…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
…MySQL which just happened to come with OS and queries which no one ever run EXPLAIN for which just happen to work…MySQL or does not, in the new versions it becomes possible for someone to be an expert in one area and familiar with one…
Post: Caching techinques
August 8, 2006 By 11 Comments
… you retrieve product information from Amazon Web Services, you have no way to get …objects in cache once underlying information is updated. This is how MySQL Query Cache works by removing all queries … approaches efficiently. For example I worked with one company having trouble with some Full Text …
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
…Service Companies. Let me give you an example This shows how MySQL Support Prices looked back in…Query. All of these companies should offer more personal professional services than MySQL and would be more open to customize services…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… to Software as Service providers which …work in Oracle MySQL Server. set userstat_running=1 and run following query: mysql> select * from information_schema.user_statistics where user=”#mysql…query log and mk-query-digest. This method is great for one… capacity as well as how long replication warmup…
