… became slower than MySQL 4.0 for many simple operations at large extent because extensions were done without flexible architecture designed for infinite extensions from the start. Also if you compare MySQL and PostgreSQL MySQL is just flexible in different way – MySQL has…
Post: ClickAider - Track Adsense Clicks and much more
July 9, 2007 By 17 Comments
… over recent years is also quite helpful. When I was designing another Web Statistics System – SpyLOG back in 1999 you could… for all stats. Compared to SpyLOG we also significantly simplified architecture based on experience gained during the years and simply because… LAMP application at this point. We use Scale-Out MySQL architecture based on MySQL 5.1 with some partitioning and mostly Innodb storage…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…or both MySQL workshops. Scaling and Optimization for MySQL on Monday & Tuesday, April 8 & 9 This MySQL workshop will cover: Apply architecture scaling … performance. Use successful patterns behind MySQL applications, and avoid design decisions that don’t fit MySQL very well. Solve some common …
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
…people targeting. It also has number of unusual design decisions which will position it further away. … if implemented well. It is too bad MySQL Users Conference only allowed 45 minutes for …situation can be rather different. Looking at PBXT architecture there is small row pointer file which …
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…Plus there is Falcon storage engine being developed inside MySQL. All of these storage engines are however …row level locks so it is question of architecture implementation details of how it would compare to…happens with custom storage engines which are not designed to be run as core storage engines …
Comment: 7 Reasons why MySQL Quality will never be the same
December 11, 2008 By 15 Comments
… than adding more half baked features. The manor features in MySQL 4.1 were Subselects, Prepared Statements and Character Sets. All… not done by Monty and these were changes which MySQL architecture was not well designed for. SubQueries had number of bugs in particular in non trivial cases and still have serve performance limitations as of MySQL…
Post: A note about Pythian
April 17, 2008 By 4 Comments
… DBA offerings, We also do a lot of Architecture Design Scaling jobs and some custom MySQL Extensions/porting patches jobs. Paul can well… number of databases (Oracle, SQL Server, MySQL) while we provide services for number of full MySQL stacks and help people with implementing… of some 20 people we have (this includes not only MySQL Consultants but people busy with other projects as well) not…
Post: Election night
November 5, 2008 By Leave a Comment
… face the challenge: “Comprehensive MySQL Performance Audit”- to help you find the bottlenecks, to assist with architecture design and to prepare systems for approaching event. “Consultant Time Hire for MySQL“- to keep an eye…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… engine, designed to perform well on a broad range of tasks, much like InnoDB. However, PBXT’s log-based architecture makes… doing this it was important to keep the log-based architecture which was the reason for the high write performance of… PBXT (1.0.09) supports the MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
… set up. For smaller systems lets say running couple of MySQL servers running another couple can be cheaper than serious application… them if they would like me to help them to design architecture which is very easy to implement or which would be… all simple architectures scale badly – for many tasks simple architectures can be good enough, but it should be right simple architectures. In some…
