(Rob Gravelle) The Data Manipulation Language (DML) includes the major commands, INSERT, UPDATE, DELETE, and SELECT…INTO. Today’s article focuses specifically on the uber-useful INSERT, UPDATE, DELETE, and SELECT statements.

(Peter Zaitsev) I worked with application recently which has great memcached hit ratio – over 99% but yet still has average page response time over 500ms. Reason ? There are hundreds memcached gets and even though they have some 0.4ms response time they add up to add hundreds of ms to the total resp

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. (R)

(Justin Swanhart) MySQL supports two different algorithms for views: the MERGE algorithm and the TEMPTABLE algorithm. These two algorithms differ greatly. A view which uses the MERGE algorithm can merge filter conditions into the view query itself. This has significant performance advantages over TE

(Ronald Bradford) It is critical that you do not use the default MySQL installation security, it’s simply insecure.

(Baron Schwartz) I’ve been talking and writing a bit lately about the scaling problems I’m seeing on fast servers running lots of queries. As a rough guide, I’m seeing this in servers running 20k queries per second and higher, lots of memory, lots of CPU cores, and most queries are running faster th

(Giuseppe Maxia) When you are importing large amounts of data from other sources LOAD DATA is a common method of inserting data into a table.

(Maciej Dobrzanski) The problem I am going to describe is likely to be around since the very beginning of MySQL, however unless you carefully analyse and profile your queries, it might easily go unnoticed. I used it as one of the examples in our talk given at phpDay.it conference last week to demons

(Satoshi Nagayasu) Yesterday, I tried to build a PostgreSQL master-slave replication system with new feature “Streaming Replication (SR)”, which is coming in the next PostgreSQL major release 9.0 as a built-in replication solution, and it worked well on my servers.

(Rob Gravelle) Many third parties create rich applications to facilitate database management, database development and database administration. Here are ten outstanding graphical interfaces for MySQL.