Posted by Coder.
Results > Posts Filed Under > SQL
Nov
28
Posted by Coder.
Identifying MySQL slow queries | MDLog:/sysadmin
… steps in optimizing and tuning mysql is to identify the queries that are causing problems. How can we find out what queries are taking a long time tocomplete? How can we see what queries are slowing down the mysql server? Mysql has the answer for us and we only need to know where to look for it…
May
6
Posted by Coder.
Performance Tuning Best Practices for MySQL – Google Video
…where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively find the “low hanging fruit” on the tree of bottlenecks. It’s not rocket science, but with a bit of acquired skill and experience, and of course good habits, you too can do this magic! [The talk is delivered by] Jay Pipes [who] is MySQL’s Community Relations Manager for North America.
Mar
27
Posted by Coder.
How to use Exended SQL Trace for detail information when tuning inefficent query….
Jan
23
Posted by coder.
developerWorks : Blogs : Grady Booch
Distributed two-phase commit will be avoided by recoverable messaging to applications (via services) that consult and modify the database and send a recoverable reply. Database size will become a non-issue. We’ll see lots of low-latency asynchronous replication of reference data among databases serving various applications and their associated service interfaces.
Jan
19
Posted by coder.
AskTom “”Not to do” Things”
don’t accept string literals from end users and concatenate them into your SQL (eg: DO use binds in almost all cases)
don’t test on an empty database or a database with a small percentage of the real system. Importing statistics from a “real” database doesn’t work. You need real data volumes if you want to see what will actually happen in real life.
don’t test with a single user, scalability issues will never make themselves apparent.
don’t say …