… extent SQL Server handle better. JOIN has long been something MySQL has done badly, people have been ragging on about it… why it has taken several years before we’ve seen MySQL look to actually overhaul the optimizer to start to resolve… increasing emergence of drop-in replacements for MySQL like Percona and MariaDB which are either tweaking or flat out overhauling their query…
Comment: Performance impact of complex queries
February 13, 2007 By 11 Comments
… who has to build reporting queries that run on Oracle, MySQL and PostgreSQL, I can say that the biggest change you… it doesn’t, you can tweak a few parameters to make it do the right thing. In MySQL, you just need a… enough, a lot of the things you can do in MySQL will also help in PostgreSQL or Oracle, like creating summary…
Comment: Looking for MySQL 4.0 Support post EOL ?
December 16, 2008 By 9 Comments
… may not have the best business model, it needs some tweaking to cover all cases, but to me the post just… to be a little…grabby. It seemed to be saying “MySQL isn’t supporting this any more, but WE AT PERCONA ARE!” When really, EOL does not mean MySQL does not support customers running those releases. It actually has…
Comment: How to find wrong indexing with glance view
August 22, 2008 By 27 Comments
… environment. Another tip, turn off caching on your testing environment MySQL that way the queries are re-executed. Cached results can… of records, you may have better results just by tweaking the MySQL config settings rather than spending time optimizing your queries, especially… for particular solutions (multi-column index in this case) in MySQL.
Comment: Percona XtraDB Cluster: SElinux is not always the culprit !
January 3, 2013 By 5 Comments
…’t make any tweaks besides adjusting the security context to keep your MySQL data files somewhere other than /var/lib/mysql, understanding SELinux…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log… pages. However, I can’t help but wonder if some tweaks could be made to the page flushing algorithm to be…. In any case, if you run any kind of production MySQL server, you should be monitoring your Checkpoint age and your…
Post: Fishing with dynamite, brought to you by the randgen and dbqp
November 16, 2011 By Leave a Comment
… of these bugs!) This brings us to our first bug: mysql process crashes after setting innodb_dict_size The basics of… had to do was copy an existing test case and tweak our server options and randgen command line as needed. 2… command to execute the test: ./dbqp.py –default-server-type=mysql –basedir=/path/to/Percona-Server –suite=randgen_basic innodbDictSizeLimit_test…
Comment: Stripped MySQL builds, the optimization that isn't
December 8, 2010 By 7 Comments
… company and you have a customer bogging down some shared MySQL instance because of bad indices and bad queries, “creating a custom MySQL build” isn’t going to do jack squat to help… actually can make some economic sense to spend the time tweaking on it, but again I still think its a kind…
Comment: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 16, 2009 By 16 Comments
…. I run into many applications which 100% of its stored MySQL data is hot, and many times adding a caching layer… scalable or not as MySQL. Replication, sure… then? Sharding… if you plan for this, or with some tweaks in the API of…
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
…. (Yes, I am simplifying some of the scalability issues with MySQL on big machines, but I have faith that Yasufumi is… few very busy tables, and move them onto their own MySQL server. Partition-by-function keeps the architecture still simple… be able to migrate users to/from shards you can tweak and rebalanced to make sure that all your hardware is…
