Friday, 29 August 2008 15:42
Multiple column index vs multiple indexes
there were questions raised about Index Merge on Multiple Indexes
vs Two Column Index efficiency. I mentioned in most cases when
query can use both of the ways using multiple column index would be
faster but I also went ahead to do some benchmarks today.
Read more...
Tuesday, 26 August 2008 17:26
MySQL Commands Referance
This is a list of handy MySQL commands that I use time and time
again. At the bottom are statements, clauses, and functions you can
use in MySQL. Below that are PHP and Perl API functions you can use
to interface with MySQL. To use those you will need to build PHP
with MySQL functionality. To use MySQL with Perl you will need to
use a Perl module.
Read more...
Friday, 22 August 2008 13:06
Missing Data - rows used to generate result set
As Baron writes it is not the number of rows returned by the query
but number of rows accessed by the query will most likely be
defining query performance. Of course not all row accessed are
created equal (such as full table scan row accesses may be much
faster than random index lookups row accesses in the same table)
but this is very valuable data point to optimize query anyway.
Read more...
Friday, 11 July 2008 06:52
Connecting to MySQL database with C code
MySQL databases may be used by programs written in the C programming language on Socrates and Plato and on the IS Solaris workstations. Full details of the C API (Application Program Interface) are given in the MySQL manual at http://www.mysql.com/doc/en/C.html.
Read more...
Tuesday, 01 July 2008 05:29
MySQL: The SHOW Commands
MySQL users often wonder how to find out what their server is actually doing at any point in time—usually when things start to slow down or behave strangely. You can look at operating system statistics to figure out how busy the server is, but that really doesn't reveal much. Knowing that the CPU is at 100% utilization or that there's a lot of disk I/O occurring provides a high-level picture of what is going on, but MySQL can tell far more.
Read more...
