28 Nov
Posted by Coder as Best practices, MySQL, Performance, Profiling, SQL, Scalability
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 [...]
06 May
Posted by Coder as Best practices, Performance, SQL
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 [...]
27 Mar
Posted by Coder as Performance, SQL
How to use Exended SQL Trace for detail information when tuning inefficent query….
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.
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 [...]
| M | T | W | T | F | S | S |
|---|---|---|---|---|---|---|
| « Jul | ||||||
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |