We have yet another opening at MySQL Performance Blog. We’re looking for Intern position (with limited compensation) to … position for the Computer Science student interested in High Performance systems design, performance optimizations and MySQL. The work done with us has… would learn a lot about MySQL Architecture, Unix/Linux Operating Systems and Hardware Performance Optimization, Performance Analysis, benchmarking and load testing…
Comment: Content delivery system design mistakes
February 11, 2007 By 9 Comments
[...] MySQL Performance Blog » Content delivery system design mistakes (tags: mysql performance) [...]
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…and performs well. The issue is even this simple design can start to have issues as the data …bigger boxes, the read-only slaves, the complex sharding systems, the discussions on cluster, more memcached. We need …in the database is silly. Yes the guy who blogs on bigdbahead.com and is writing this on …
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…’ve been reading enough database related forums, mailing lists or blogs you probably heard complains about MySQL being unable to handle… reason ? The reason is normally table design and understanding inner works of MySQL. If you design your data wisely considering what MySQL… when possible. Just do not forget about performance implications designing the system and do not expect joins to be be free. Finally…
Post: Is VoltDB really as scalable as they claim?
February 28, 2011 By 3 Comments
…partition. It is an in-memory shared-nothing system, and tables are partitioned across multiple servers …procedures, not with arbitrary SQL queries. It is designed to be very fast (hundreds of thousands of…”voter” benchmark, which is explained briefly at this blog post. VoltDB’s Tim Callaghan ran the …
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… it’s a good idea to publish those blog posts in the format I was planning. Instead, … to think about. The physical and logical database design influences greatly how much memory and disk resources … and drawbacks of RDS versus building the equivalent system yourself. RDS is nice in that it’s …
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… I’m using Query Cache on server which runs this blog. Updates are rather rare so per-table granularity is not… queries but it is still not as fast as specially designed systems such as memcached or local shared memory. It can’t… in cache effectively wasting memory. Distirbuted caching systems can effectively use memory on multiple systems so there is no duplication. Memcached is…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…utilities (anti-tuning anti-utilities?) for Oracle, specifically designed to mock and frustrate those who would … that now. This topic deserves an entire blog post, because there are many subtleties including …intervals and compare the results to your IO system‘s capabilities. MySQL doesn’t have good …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. The next characteristic of a lot of these systems (real or planned) is the desire for “real-…-part article on data archiving on my own blog a while back. The benefits of purging…or even with 10-15x fewer servers. Clever application design, and a holistic approach, are absolutely necessary. You …
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
…extremely high in the general population. This blog‘s articles often illustrate extreme cases, so…, it’s not likely to improve the system‘s performance dramatically, all things considered. More… configuration The workload The queries The schema design (table design, data types, indexing, etc) The data…
