…how to really use DTrace with MySQL…complex systems since before I was born. Two, this is a session that will teach you how to think about replication, not what to…queries and all sorts of things in MySQL — and that’s just for performing this task on a single server, not to…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
…how it would compare to…to the people ? Yes! but it also adds high level of complexity because it will not be easy to…to customer winning. When Falcon looses to Innodb in certain cases it makes Jim to…to optimizes certain types of queries with MySQL, it is not easy to…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…to your MySQL server version for the right syntax to use near ‘by pwd’ at line 1 It would be much better if MySQL would give error give exact position of error (with complex auto generated queries… one. How do you expect to decode from…engine interface Sun/MySQL spends some time to make things …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…STATUS output and how to use this info to improve MySQL Performance. To start with …- before falling back to complex wait using sync_array Innodb tries to “yield” to OS … 442 mysql tables in use 1, locked 0 MySQL thread id 8079, query … has to ensure data makes it to the disk – just passing it to OS…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…mysql-patch/mytools What makes fractal indexes so interesting is the amount of IO operations to…to run custom reporting queries on logs. To do this, you often need many, often complex…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
… running complex queries. It is usually much better to simply check it. Start MySQL With 10GB Innodb buffer pool for example and see how large…. Depending on OS you may want to do different VM memory adjustments. You may want to make MySQL to use Large Pages for allocating Innodb Buffer…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…complex conectors. I have not yet tested PDO but would not > expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as well – I would go for using…query can’t reference data in two separate databases in the same instance of MySQL. If nothing else, it makes…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
…which makes me want to voice a recurring mistake I see in how…query_time=0 and use mk-query-digest to capture queries. Run them through MySQL‘s EXPLAIN command. Do your queries SELECT *, only to use… decreases complexity. Avoid adding complexity by only optimizing what is necessary to meet your …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not corrupted. So we looked at how to get your data back from simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…complex case:…to simple MySQL using multiple indexes on most selective columns would be good idea for performance of such queries…how many rows you need to scan to resolve order by (this can be found in slow query…make sense to precompute results so you can query them for positions. So instead of query…
