… much of the problem in MySQL 3.23 when there would …a lot larger problems with MySQL 5.5 with addition of user variables, …you can use this simple script: while true do date >> ps.log…of resources prepared statements take on server. There is no …leaks like valgrind are too slow to run in production. So…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
…which this box had. MySQL Also was very slow running some queries so we changed scripts a bit to kill …off time to 3 hours to give MySQL more time to complete the queries: Query MySQL 5.0.23 MySQL 6.0….Query22108.56100.720.93 As you can see on 100G data set MySQL 5.1 could only complete 10 out of…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… : 1 siblings : 4 core id : 3 cpu cores : 4 fpu : yes… some cases): vmstat 5 5 iostat -dx 5 5 If you don… anything worth commenting on there. Depending on the workload, there…hackmysql.com/scripts/mysqlsla perl mysqlsla -lt slow /path/to/slow.log By… in the slow query log output. The stock MySQL server’…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… recently. In MySQL 3.22->3.23 upgrades or 3.23->… of people established slow by safe upgrade procedures -…to recent MySQL 5.0 before upgrading to MySQL 5.1 – …MySQL changes name to “mysql“. Come On, as I remember MySQL…script or MySQL install script but simply I find no mysql user after upgrade. MySQL…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… of other things. In MySQL 5 number of Innodb performance… Innodb will print: ===================================== 060717 3:07:56 INNODB MONITOR OUTPUT…, if you’re writing scripts to look at SHOW…. OS Waits are relatively slow, and if you get…and writes are pending requests on buffer pool level. Innodb…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
…experience, if you are getting even 5% of tcpdump packets dropped by the…slow. Recently, I got more than 60% dropped packets on a server with roughly 50MB/s of traffic on… Here is a draft of a script to automate this; use at … tcp[1] & 7 == 2 and tcp[3] & 7 == 2′ 2>/dev/null \ | ssh $REMOTEHOST — “cat…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… users running their queries on a single database instance…slow log live, but that is a bit ugly solution. That is where this patch can be very useful. With simple MySQL… | 1 | 3 | | hosting2.wp_options | 6586 | 200 | 400 | | hosting2.wp_postmeta | 5 | 2 | 6 …that can be fed into scripts to bring you …
Comment: Debugging sleeping connections with MySQL
May 20, 2009 By 28 Comments
… requests increase 2. mysql queries increase 3. mysql slow queries increase 4. apache connections start to wait on slow mysql queries 5. apache connections take longer… mysql & apache reach max_connections 9. server slows to a crawl Solution: – Reduce the time a mysql connection is open during script…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL… by running modprobe dm-snapshot 3) Now you have created logical…5) Mount backup Filesystem: mount /dev/Main/dbbackup /mnt/backup 6) Copy data to backup. Normally you can skip slow… you’re interested in ready script you can try…
Post: Testing the Group Commit Fix
July 13, 2011 By 13 Comments
…times wrote about. The fix came into MariaDB 5.3 and Mark Callaghan tested it recently . We …oltp read-write workload. All scripts, raw results and config files are available on our launchpad results page….5.1.57 with the Group Commit Fix applied. The first graph shows the results when we have a slow…
