… lets run SELECT Query: —TRANSACTION 12303, ACTIVE 26 sec mysql tables in use 2, locked 0 MySQL thread id 53038, OS thread handle…, ACTIVE 9 sec mysql tables in use 2, locked 2 8316 lock struct(s), heap size 1948088, 10008317 row lock(s) MySQL thread… key. Lets now see about writes: —TRANSACTION 12304, ACTIVE 3 sec fetching rows mysql tables in use 1, locked 1 9417 lock…
Post: Percona Server on the Raspberry Pi: Your own MySQL Database Server for Under $80
February 25, 2013 By 10 Comments
… Linux has this preset) Also, Arch Linux has sshd already active (sshd=ssh daemon, a software package allowing you to connect… mysqld Connect using the mysql client: [root@alarmpi ~]# /usr/bin/mysql Welcome to the MySQL monitor. Commands end with ; or \g. [...] mysql> SHOW ENGINES… few other points: This setup uses Percona Server for MySQL with the latest mysql client, which is untested, but should be “ok…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
…(32) ); Query OK, 0 rows affected (0.02 sec) node2 mysql> show create table autoinc\G *************************** 1. row *************************** Table: autoinc Create Table…: 1 Changed: 1 Warnings: 0 node1 mysql> SHOW ENGINE INNODB STATUS\G … ———— TRANSACTIONS ———— … —TRANSACTION 83B, ACTIVE 50 sec 2 lock struct(s), heap size 376, 1 row lock(s), undo log entries 1 MySQL thread id…
Post: Is your MySQL Server Loaded ?
March 19, 2010 By 6 Comments
… running the benchmark/stress test – how do you tell if MySQL server is really loaded ? This looks like the trivial question… more uniform – there are cases when actually 32 queries are active (this is test with 32 connections) – but you can see… response back yet. This is a very broad measure of activity – if query is waiting on IO, blocked on Mutex, table…
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… web. Since that time I matured and so did MySQL ecosystem. MySQL is powering a lot more demanding and business critical applications… applications which have not been actively developed recently are also more likely to run on old MySQL release which is understandable as… support RHEL4 with MySQL 5.1 but support with MySQL 5.5 is not needed as people doing major MySQL upgrade usually would…
Post: MySQL - to use or not to use
May 28, 2007 By 10 Comments
… too dynamic in development (nothing stops you from starting to actively break old code though). Indeed there are some problems which… articles speaking about MySQL for Enterprises speaking about MySQL with full pack of services from MySQL AB. Obviously this is how MySQL AB wants… MySQL issues with help of Google rather than MySQL Support Team. You also may want to buy some services from MySQL simply so MySQL…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
… of the few cache implementations which I’d call an Active Cache meaning it takes care of the misses itself, without… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so … 8 3 0 active sync /dev/sda3 1 8 19 1 active sync /dev/sdb3 2 8 35 2 active sync /dev/sdc3 3 0 0 3 removed 4 8 67 4 active…
Post: ACTIVE with Locks – Now thats a problem !
June 2, 2011 By 2 Comments
… ACTIVE state. Especially ACTIVE transactions which do not currently run any query are suspicious. There are however cases when screaming fire about ACTIVE… is when you have long enough ACTIVE transactions which have some locks, like in this case: MySQL thread id 2059, query id… log entries 1 MySQL thread id 1720, query id 1011283 10.10.10.10 user —TRANSACTION 2 1418397881, ACTIVE 317 sec, process…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… that you can fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, this is probably the… (with some new features) to watch the traffic on the active master and replay SELECT queries against the passive one. I…-digest to watch the traffic on the active master: mk-query-digest –processlist h=active \ –filter ‘$event->{arg} =~ m/^SELECT/i’ –execute…
