… being the a large stretch. I would hope Sun/MySQL would tone it down and actually spend time on making things to scale inside MySQL rather than asking you to run tens of MySQL instances to get… T5440 is never good for MySQL. It may work quite well for some cases, for example when a lot of small MySQL instances…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… me say the creation of theMariaDB Foundation is a good thing for the MariaDB Community and I’m very pleased to be in the group of those… MySQL, High Quality, and small but High Value changes focused on the most pressing problems we observe in the demanding environments our customers…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
…the things that you can usually see by running EXPLAIN on the query. The patch will now allow you to see the…small hash array representing the entire buffer pool, because it could take a lot of memory to map all the pages. The inaccuracy grows with the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… good start to this. What to look for during the audit During the audit I look for outliers and anomalies in every aspect of the…” unless the client really insists “I don’t want to know.” That’s also why I’ll comment on things that seem good… 6 months ago was a small encyclopedia!” The mistake here was that the consultant didn’t show all the things he’d checked, which was…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… decisions and actions instead of having steady paycheck, but I guess I felt that for only couple of weeks. The thing which was harder…. I’m not the great person for such routine operations so it was not always done well. Good enough we’ve find… settings. It is more the question of knowing there to change things rather than changing things ourselves. We love these small project which often lead…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… a good answer to it while googling.“What is the good way to split memory between INNODB buffers and OS?†Of course this depends on all kinds of things, but the only rule of… be possible to implement online reorganize which locks and reorganizes small portions of table online. Q38: Seems that adaptive hash indexes are…
Post: Thoughts on MySQL Replication
July 7, 2006 By 18 Comments
… MySQL replication. The piece I find missing however is good description of warning about limits of this approach as well as things you need to… simple master slave replication ? – Small database size. Small meaning working set fits in memory. This reduces waste of storage, removes problem with cache…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…the cluster will wait for the data to be actually replicated (committed) before serving the read. The great thing…the best performance possible. So far so good. We can make cluster to handle significant load with small…
Post: MySQL and Sun - Oportunity for smaller companies ?
March 26, 2008 By 10 Comments
… frame. Over years things have changed both from pricing standpoint and quality standpoint – MySQL Support is still very good compared to many… and use it to solve most of your problems quickly. In my experience as small business owner the problem tends to happen when… companies work – if you’re small company you can get commodity services relatively simple for relatively good price but if you want…
Post: A case for MariaDB's Hash Joins
May 31, 2012 By Leave a Comment
…the case of joining two tables on a equijoin condition. So the first thing would be to designate the smallest of the two tables as the…good if you need many scans of the right operand (in this case the table lineitem). Another difference with the…a really small subset of rows, as then scanning the …
