… should. These are essential practices for building successful applications, which everyone should be …memory is a big step towards better performance, and archiving can help do that. …3. Capture and Store Historical Data Likewise, it is vital to have something recording metrics over time. A lot…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… an hour long, if we’re discussing a lot of things like how to build for massive scalability, how to do… to help me find the biggest tables and so forth. If the server is heavily loaded or has a lot of…A lot of times, customers will tell us up front to limit the work to some number of hours, such as 3…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
…build complete refresh views on top of incrementally refreshable view, which can give you a lot… | 1 | 689 | 770793 | 3811 | | 2 | 6543 | 754138 | 3740 | | 3 | 5337 | 742034 | 3674 | | 4 | 5825 | 738420 | 3593 | | … I hope this helps you understand how Flexviews can help you ensure fast …
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
… didn’t start at all. That’s a lot of rules to handle. Since all aspects … node=”testvirtbox” score=”INFINITY”/>
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… MySQL builds … SELECT whatstheweatherlike(3); +———————————————————–+ | whatstheweatherlike(3) | +———————————————————–+ | …a profile for each of the queries individually. I think this is pretty cool and it helped me a lot…
Post: MySQL 5.1 went to GA. Was it a good move ?
December 10, 2008 By 4 Comments
…it in production since 3.23.3 or so, when it was in the Alpha stage still. A lot of bugs were…big and famous companies shipping MySQL 4.1 beta build into their hardware solutions. This is to tell …become found with very wide use. Finally it was helpful for corporate users who are stuck with 5….
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 3
October 19, 2009 By 25 Comments
… in Part 3 we are going to look at a possible …Helping clients pick the right solution is one of the things we do here at Percona. If an application requires a… but neither is a relational database. Before building your next … a lot of requests for cassandra #’s, but what else? Drop a comment…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…is command which prints out a lot of internal Innodb performance counters, … printout Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR OUTPUT … For certain workloads it may help to decrease the time thread… index is hash index Innodb builds for some pages to speed…
Post: Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
November 26, 2012 By 4 Comments
…lcf bfa 19:17:01 trime P 3 3 node3 Sync T/T 0 0 35…each second and reports that. There’s lot of other reports it can run, but… entire cluster at a glance. Sometime in the future, I’d like to build a tool that…bfa is brute force aborts. This should be helpful to understand that these conflicts are or…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… peak performance we see the number is 2.3 for Percona Server 5.1 and around 6 …pfs_rw_lock_s_lock_fu nc,btr_search_build_page_hash_index,btr_search_info_update_slow,…a lot worse in this workload and innodb_adaptive_hash_index_partitions=16 available for partitioning adaptive hash index does not help…
