… for your feedback. * How do you define large schemas, and what do you mean by can’t cope? * Is this a… features don’t work past N number of tables? In my experience, the schemas I have under SchemaSpy reach at max…
Comment: MySQL Query Patterns, Optimized - Webinar questions followup
June 5, 2013 By 2 Comments
… P.S. just an one small thing, yes, I understand – there is just an example, small space etc, but using names like…
Comment: Profiling MySQL Memory Usage With Valgrind Massif
June 5, 2013 By 3 Comments
… so much for this very useful post. I was wondering – what is the performance penalty of running mysqld (or any other… going to vary a lot, but I wonder if it’s like barely noticeable or is it more like you-don…
Post: Multicast replication in Percona XtraDB Cluster (PXC) and Galera
June 5, 2013 By
…/s eth1 DOWN:81 KB/s UP:368 KB/s eth1 DOWN:78 KB/s UP:363 KB/s This isn’t much traffic in my… 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…
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
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 2 Comments
… in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of… path separator between the directory and file name components in a bitmap file name could stop the server starting if the innodb…
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
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
…(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the ideas of… able to recover data from the crashed master, but that’s another story). In this case, you will have to promote…? There is a solution of course, but very poor in my opinion: look for the binlog file/position of the last…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… is crashed and I have this error in my log : 07:53:55 UTC – mysqld got signal 11 ; This …_size)*max_threads = 4432877 K bytes of memory Hope that’s ok; if not, decrease some variables in the equation. Thread… wrong… stack_bottom = 7f9244a8fdb8 thread_stack 0×40000 /usr/sbin/mysqld(my_print_stacktrace+0×35)[0x7d0765] /usr/sbin/mysqld(handle_fatal_signal…
Comment: Is there a performance difference between JOIN and WHERE?
May 29, 2013 By 30 Comments
… code. If your boss is wildly deviating what he needs on a continual basis, he’s either incompetent, lazy, abusive, or just…
