… need to do the same for xfs… I am redoing my tpcc test with primarycache=metadata, if giving more arc to…
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: Implementing SchemaSpy in your MySQL environment
June 5, 2013 By 2 Comments
… features don’t work past N number of tables? In my experience, the schemas I have under SchemaSpy reach at max…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
… guys and beyond the scope of this post, but in my trivial VM environment, I just need to make sure that the multicast address space routes to my Galera replication interface, eth1: [all nodes]# ip ro add dev….192.0.11, so we’ll add this to our my.cnf: wsrep_provider_options = “gmcast.mcast_addr=239.192.0…
Comment: What Are Full, Incremental, and Differential Backups?
June 4, 2013 By 9 Comments
my mail is up there……..
Comment: What Are Full, Incremental, and Differential Backups?
June 4, 2013 By 9 Comments
My mail is up there……….
Comment: What Are Full, Incremental, and Differential Backups?
June 4, 2013 By 9 Comments
Im having the same issue with that project. i could really use some help right about now. its been wrecking my head for a while nw
Comment: MySQL 5.6.7-RC in tpcc-mysql benchmark
June 3, 2013 By 22 Comments
Hy, I’m new to TPC-C benchmarking and i would like to know how and what are the steps for testing MySQL with TPC-C benchmark. My goal is to compare VoltDB and MySQL under TPC-C benchmark. Thanks
Comment: Neat tricks for the MySQL command-line pager
June 3, 2013 By 13 Comments
On *nix systems, before your sql statement enter: \P more or \P less
Comment: MySQL Partitioning - can save you or kill you
June 3, 2013 By 45 Comments
Hi Great article and had fun reading all the responses. After implementing what was suggested I have also managed to reduce my query time greatly. I will bookmark this blog for future reference. Best regards Ian
