…our first alpha of Percona XtraBackup 2.1 for MySQL and with it we included the ability to … which is what some people have used in the past. A big benefit of using the built-in encryption is …if you are using cloud storage to store your backups but also applies to simple off-site backups. Percona …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… of customers who do click analysis, site analytics, search engine marketing, online advertising, user …use statement-based replication. You can save that work by either using MySQL 5.1′s row-based replication, or in MySQL… joins are not all that fast on big joins; the query optimizer can sometimes …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…touching the INFORMATION_SCHEMA can take a barely-running site and bring it down, so I do this … really bad that can be fixed and bring big gains. Schema, query, and index optimization Analyzing and ….) If it’s not possible to use a patched binary, we can use MySQL Proxy, packet sniffing, or other …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and … variable reference for all three sites in one! abort_slave_….commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona…._nullblogpercona.commanual sql_big_selectsblogpercona.commanual sql_big_tablesblogpercona.commanual …
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… uses dynamic SQL in stored procedures extensively. They found that it was awkward because of the limits of the procedure language MySQL… only takes one SQL injection vulnerability to cause a big problem. Your site is only as secure as its weakest link, which… input data strings I should use to find a security bug in my code? This is a big topic. One simple answer…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
… of 90s when MySQL appeared on the market many web applications were simple and often not using database at all. MySQL did not… performance of MySQL is often the problem even for medium scale sites. As response to these things few things happen – MySQL kept being… customization of data store and processing was using non SQL and not systems – Google Big Table, Amazon Dynamo and SimpleDB, Hadoop, CouchDB…
Post: Site was down today, support and web hosting.
August 31, 2007 By 27 Comments
…pretty good track record with MySQL Performance Blog – there were times when site was slow (especially when backup…to deal with clueless support stuff working for big companies/big call centers ? Of course call again. I…with Aplus Value Server which we’ve been used as well as with our racks with …
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… a planned or unplanned failover. This isn’t a big problem on small systems, but with buffer pools in …The buffer pool contains over 8G of data for the site.benefits table on the active master, but if you … It doesn’t have to be the tools I used — it could be MySQL Proxy or a TCP sniffer or anything …
Post: Web Site Optimization: FrontEnd and BackEnd
June 26, 2008 By 12 Comments
…not the frontend web server commonly used in many architectures but rather optimization…sites which have relatively well optimized backends but have not spent time on the frontend optimization. In this case not a big… data from MySQL database it does not make sense to focus on MySQL optimization. …
Post: Using flow control functions for performance monitoring queries
May 24, 2008 By 12 Comments
…’m not big fan on flow control functions like IF or CASE used in MySQL Queries as they are often abused used to create… can hardly be optimized well by MySQL Optimizer. One way I find IF statement very useful is computing multiple aggregates over different… single query sweep. Here is how I like to use it for web site performance analyzes. As you can see in this…
