…convinced that PBXT’s implementation of the log-based I/O is optimal at this stage. This …of MySQL 5.4. The Backup API makes it possible to pull a consistent snapshot of an entire database…relevant with the rise of Solid State technology. As random read access times decrease clustering of data will …
Post: Guidance for MySQL Optimizer Developers
September 20, 2009 By 4 Comments
… in terms of disk IOs/Seeks in same way for all data sets. In practice some people have their database 100% in… can be due to optimizer picking the wrong plan, such as doing full table scan when Index access is better or because MySQL simply does not have execution method to resolve query in optimal way – loose…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
…money implementing things as optimal as possible. If you’re using 50 5000$ database servers to run the…and ask about expected growth, to help to access if minor face lifting such as MySQL Server…overhaul, adding/changing caching infrastructure and other things. Of course it is not black and white, …
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…sorting. So besides optimizing DDL directly, expand_fast_index_creation may also optimize index access for subsequent … “… you can generally speed the overall process of creating and loading an indexed table …a dump created with –innodb-optimize-keys (the test database contained only the table I used…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
… handful of scenarios where this was desirable. For example, sometimes there is no access to the database server. I’ve seen this when access… receive in total, much of which might have nothing to do with the task you’re trying to optimize or analyze. You… tools can do a lot of work for you. Or, you can log queries to a database table and then use SQL…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…be fixing access problems, completing application changes, QA, scheduling downtime to implement changes and millions of other things. Second – waiting on database (or…surprisingly a lot of things can be done in completely remote mode – we’ve done not only basic optimizations but architecture …
Post: Announcing Percona Performance Conference 2009 on April 22 & 23
February 5, 2009 By 5 Comments
…databases. Attendance is free of charge for everyone. Experts in many types of technologies — databases, search, cloud computing, massively parallel computing, client-side optimization…see a lot of people who live locally, and we know that the easy accessibility for attendees of the MySQL Conference…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
…of double buffering and I can save the limited amount of file system cache I would normally have on database…table which was not optimized for prolonged period of time, so it reflect natural state of the table …MySQL has about data which will be accessed next – in case of full table scan, index scans …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… (sums of columns), but they’re ad-hoc (can access any columns) and it seems tailor-made for a column-oriented database. I… into MySQL. It’s a complete server with a different optimizer, etc. This point was hammered home during the LOAD DATA… quite sure it’s useful for “general-purpose” database use — there are a number of limitations (concurrency, for one) and it looks…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… this time is “per database transactions” – so if you modify data in number of databases you may see partial changes… row pointer file which is expected to be accessed a lot on each row read and row …holes” it should have rather compact foot print in optimal case. On other hand because it leaves old…
