June 19, 2013

Comment: On Benchmarks on SSD

great write up, heres a video I did on my SSD: http://www.youtube.com/watch?v=gZJ-pPeE5lA

Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!

… referenced in that post, you can refer a post by Peter Boros (“Percona XtraDB Cluster reference architecture with HaProxy”) for details…

Comment: Sphinx search performance optimization: attribute-based filters

Fabian, – please note that, as stated in the article, this technique only … 10M records), then you don’t want to use this. Please see “Highly selective columns only” section for examples where it…

Post: Implementing SchemaSpy in your MySQL environment

…Server 5.6.10 sandbox: description=MySQL driver=com.mysql.jdbc.Driver connectionSpec=jdbc:mysql://127….0″ encoding=”UTF-8″?> www.w3.org/2001/XMLSchema-instance” xsi:noNamespaceSchemaLocation=”…do they compare with SchemaSpy?  Feel free to answer via the comments.  Thanks …

Comment: Percona XtraBackup 2.1.3 for MySQL available for download

… this may fail. Please help us make Percona Server better by reporting any bugs at http://bugs.percona.com/ key_buffer_size… may download the Percona Server operations manual by visiting http://www.percona.com/software/percona-server/. You may find information in the…

Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL

… use the existing mysql data dir. But check http://www.percona.com/doc/percona-server/5.1/compatibility.html if you’re… 2) here is the list of compared features: http://www.percona.com/doc/percona-server/5.1/feature_comparison.html 3) we…

Comment: MySQL Performance Forums

… this sort of question. Here’s the url: http://www.percona.com/forums/questions-discussions/mysql-and-percona-server I’ll sure…

Post: Private, custom Percona MySQL Training

… custom training, please contact Sally Martinez at (855) 55TRAIN or (925) 271-5054, or via e-mail at sally.martinez@percona.com.

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/

Comment: ZFS on Linux and MySQL

… has an exclusive copy of that source data. (see http://www.dbms2.com/2013/01/05/database-virtualization-data/) – Kyle Hailey