…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: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
…how it needs to work and you don’t suffer critical problem when you have enough nodes. But how… is no more than one primary component in the cluster. In our 2 nodes setup, …In this case, service means accepting queries. Back to our test, we check that the data is the same on both nodes: percona1 mysql…
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…
Post: Goal driven performance optimization
December 22, 2008 By Leave a Comment
… just looking to see how you can get most… queries“. It is surely good all search queries complete in one …in your work. For small and medium size applications you can log all requests to MySQL table for larger ones…mysql, memcache, sphinx, web services etc. For web applications doing processing in…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
…MySQL service we recognize that reliable backups are one of the most important things we can bring to the table. In…in a future blog post. Tips/Tricks: run with –kill-long-queries… blog post that showed how mysqlbinlog in 5.6 could be…term backups with little additional work Tips/Tricks: –add-header=…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
…services? You can purchase my book SQL Antipatterns: Avoiding the Pitfalls of Database Programming in…how to escape input that contains non-printing characters. The standard API function mysql…working…in the database must be protected again if you use query results in a subsequent SQL query…
Post: Living with backups
November 6, 2008 By 28 Comments
…MySQL data directory will result in a total disaster after MySQL stops responding to the incoming queries…one-liners) On Linux there is also a utility called ionice. It allows to affect how…working instance of MySQL. Such danger may for example come from an unexpected spike in… data recovery services…
