…-sys-maint”,”host”:”localhost”,”cmd”:”Connect”,”query“:”Connect”} {“msg-type”:”activity”,”date”:”1369155747373″,”thread-id”:”6439″,”query-id”:”219309″,”user”:”debian-sys…-sys-maint”,”host”:”localhost”,”cmd”:”Quit”,”query“:”Quit”} {“msg-type”:”activity”,”date”:”1369155747383″,”thread-id”:”6440″,”query-id”:”0″,”user”:”debian-sys…
Comment: INSERT INTO ... SELECT Performance with Innodb tables.
May 22, 2013 By 22 Comments
… lock(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table….label_id, cai.inventory_id All 4 tables in the query are locked!
Comment: Maatkit Now Supports Memcached
May 21, 2013 By 11 Comments
… value $source in pattern match (m//) at /usr/bin/pt-query-digest line 2676, chunk 1. Pipeline process 3 (TcpdumpParser) caused… value $source in pattern match (m//) at /usr/bin/pt-query-digest line 2676, chunk 2. Pipeline process 3 (TcpdumpParser) caused… /usr/bin/pt-query-digest line 2676, chunk 3. … when running memcached on localhost and running pt-query-digest on the tcpdump…
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
Hi Oleksii, thanks for viewing my webinar and your comments. I use the short index names because the alternative would require the font size on the slides to be very small. I know that abbreviated index names are harder to understand, but hopefully the tradeoff is the right one.
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
… tuples P.S. just an one small thing, yes, I understand – there is just an example, small space etc, but using names…
Post: How to fix your PRM cluster when upgrading to RHEL/CentOS 6.4
May 29, 2013 By 2 Comments
…: [ p_mysql:2 ] After the update and after fixing some small issues like the one bellow, you are able to start…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… fast as older SSDs. But the newer SSDs are as big, and much faster than the 300GB HDDs, on MySQL type…
Comment: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… and production for a few years now. Performance was a big hit to start with. Mainly due to random IO caused…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… per controller, I have 2 for the whole setup. A small but yet interesting saving. All put together, ZFS on Linux…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on… feature has been implemented that can be used for dispatching queries to MySQL database servers. This feature introduces new –thread-pool… MySQL database server. Bug fixed #1070824 (Vlad Lesin). Multi-line query parsing has been improved. Bug fixed #1080648 (Vlad Lesin). Missing…
