June 19, 2013

Comment: MySQL and Percona Server in LinkBench benchmark

The unstable result problem I met (e.g. 32G BP was faster than …

Comment: MySQL Performance Forums

…. I don’t see any issues with them – they are up and running – but maybe there was some short-term glitch…

Comment: MySQL Performance Forums

… different table (unrelated to the select query) also get hang up. If I do show processlist, the update queries show up with state =’Updating’ or some others with state =’query end’; …

Comment: ZFS on Linux and MySQL

… not easy going from Linux to illumos ZFS by giving up 10% total ram for metadata caching, but it is just…

Comment: GROUP_CONCAT useful GROUP BY extension

I just wrote up a tiny example to demonstrate the group_concat function. I´m just posting this here since it might be useful for you : http://www.giombetti.com/2013/06/06/mysql-group_concat/

Post: Summertime Percona MySQL training update

… you and your team. Summer is the time to brush up on those critical skills needed to ensure all systems are…

Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera

… synchronous clusters I’ve seen a lot of people setting up clusters with 3-6+ nodes on 1 Gbps networks.  1… a sysbench test on one node and measuring the outbound (UP) bandwidth on that same node: # 2 nodes in the cluster eth1 DOWN:24 KB/s UP:174 KB/s eth1 DOWN:25 KB/s UP:172 KB/s eth1 DOWN:27…

Comment: What Are Full, Incremental, and Differential Backups?

my mail is up there……..

Comment: What Are Full, Incremental, and Differential Backups?

My mail is up there……….

Post: Implementing SchemaSpy in your MySQL environment

… old data if you don’t need to?).  I get up to speed a lot faster and can contribute to the… each run, so I find it convenient to set it up on crontab so that schema changes are automatically picked up.  Nice, eh? Usage of this tool is very straightforward and …