… of what the system can look like while this process is ongoing: mysql> show processlist; +—-+——+———–+——+————+——+——————-+———————————————————————-+ | Id | User | Host | db | Command | Time | State | Info…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… I need to know how many physical spindles are under the box, and how fast they are. I …. So at this point, it looks like MySQL is probably a good place to look for performance…db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql….
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…meantime, how do you know if this is happening to you? Here’s how …see queries that have mostly very fast performance, and occasionally have much worse, ….82.196] # Thread_id: 3329398998 Schema: app_db # Query_time: 0.306486 Lock_… that’s where improvements to the MySQL source code are necessary. But …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…temporarily ) outside the DB. Think memcached. Almost everyone loves memcached, it’s simple, fast, and just works… threw more memory at it!! How can that be! Memcached is not a cure all. …MySQL coupled with the still large # of reads takes its toll. Another place where I have seen this kill clients is…
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… to filter the data. There is replicate-do-db and replicate-ignore-db options which closely mirror behavior of … because query execution on such slave is very fast) and what is more important you will get into more …well for you. P.S It is in my todo to see how well MySQL 5.1 row based replication …
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
… or more “CREATE TABLE db.schema … AS SELECT” and/or “INSERT INTO db.schema … AS SELECT”…is not useful, simply ignore this column. It is used to prevent wide innodb primary keys on the MV. mysql… this helps you understand how Flexviews can help you ensure fast response times in your application…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…how fast do you need to be able to recover from backups and how much your load variance is…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…is very limited and I had to transform files to quote each field. After that load statement is: mysql -S /tmp/mysql…how fast they are in different queries. First favorite query for any database benchmarker is…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… from MySQL Cluster, which is more special-purpose, this is probably the best general-purpose way to get fast …completely unusable for a long time. To measure how much this really matters, I did some …pages up into gigabytes. Here’s the result: db_table active passive + SELECT passive site.benefits …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…how to use this info to improve MySQL Performance. To start with basics SHOW INNODB STATUS is… writes these logs writes are pretty fast. ———————- BUFFER POOL AND MEMORY ———————- Total memory …buffers 0 Database pages 258053 Modified db pages 37491 Pending reads 0 Pending …
