… whose code you are unwilling or unable to change. We also want to know the operating mode you expect us to work in. Maybe you want us to analyze… on 64-bit hardware, which is important if you want to allocate a lot of memory to mysqld. Next I look at a couple… “I don’t want to know.” That’s also why I’ll comment on things that seem good. Clients need to know that I…
Post: MySQL Query Cache
July 27, 2006 By 70 Comments
… – in this case you can set query_cache_type to “DEMAND” and use only SQL_CACHE hint for queries which you want to have cached – such as SELECT SQL_CACHE col from foo where id=5. If you run in default mode you can… be all you need. Especially if it is mostly read only scenario. Why Look for alternatives ? There are few reasons why Query Cache…
Post: Introducing Zend DBi as a MySQL Replacement on IBM i
May 8, 2012 By Leave a Comment
… users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have assisted Zend to introduce… on the IBM i platform. Zend approached us to say that they want to ensure there’s a way forward for IBM i…. If you want to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona…
Post: Rendundant Array of Inexpensive Servers
August 21, 2008 By 15 Comments
… rate you also should be thinking about automation – for frequent failures you want to recovery (like getting spare Web server and putting it online) to… File System. In particular you want to make sure Error Detection is on the good level. For example if you‘re running the system… is paranoid and this is how you want your data storage to be. This is also why Sun is so proud about checksums on…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
… the value is decreased, only few however understand why they need MaxClients to be set to some high number. First lets talk about… you need at least 30 workers, otherwise if Amazon (or your network connection to Amazon) slows down site may become inaccessible. If you want your visitors to wait for 3 seconds or…
Comment: Replication of the NOW() function (also, time travel)
November 29, 2012 By 6 Comments
… with no reason why (and a typo, the option is sysdate-is-now, not sysdate-as-now): “If you want to use the SYSDATE function in your app in DML statements, make sure you use the –sysdate-as-now option to mysqld.” You show… is to make sure it’s replication-safe? So I’m not sure why you‘re recommending “sysdate-is-now” if people want to use…
Post: "Shard early, shard often"
November 16, 2009 By 6 Comments
… a while back that said why you don’t want to shard. In that post that I tried to explain that hardware advances such… you shard first, and then decide you want to tune query/index/schema to reduce server count, you find yourself in a more difficult position – since you have to apply your…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 5 Comments
… is easily enforced with queue. Today I am going to show you how to take almost any function, and treat any size cluster… is a set of words. Before you read further, I want to tell you why I’ve decided to use the words of the Constitution of… primes which you want to divide, and you want to use 1024 way parallelism: select min(result) == 0 is_prime from ( select mod({$NUMBER_TO_FACTOR}/prime…
Post: On Benchmarks on SSD
July 14, 2010 By 4 Comments
… does. So why TRIM is the problem for the benchmark – basically if you delete all files, it returns the card to fresh state… run you cover all states A->B->C, and the final result is pretty much useless. So as the conclusion if you want to see the result from steady state you should make sure you have it in your benchmark. As…
Post: The #1 mistake hosting providers make for MySQL servers
July 25, 2008 By 30 Comments
… them to install a 64-bit operating system. If you don’t then you will come to a point where your needs grow and you want to use more memory — and they will gladly install 8 or 16GB of memory for you, but MySQL can… turned into a pretty expensive mistake. I do not know why the hosting providers keep doing this. Just yesterday I got…
