dbForge Studio for MySQL has the Database Designer functionality that allows you to build and view the structure of your database using the diagrams. You can read more about it in Getting Started with Database Designer article.

(Andrew Morgan) One of the better kept secrets about MySQL Cluster appears to be the flexibility available when setting up replication. Rather than being constrained to implementing a single replication scheme, you can mix and match approaches.

(Shlomi Noach) I’ve encountered the same problem twice for different customers, so I guess it’s worth a discussion.

(Diego Medina) There are times when you don’t need a MySQL server to handle your queries, this could come handy when you are automating tests, or writing interesting Lua scripts.

(Michael McLaughlin) Installing MySQL is pretty straightforward, especially on a Windows operating system. However, recently I was surprised to find out that there were folks who didn’t know you could install multiple version on their Windows development machine. Here’s are the step-by-step instruct

If you often need to create and modify views in your MySQL development you will like dbForge Studio for MySQL in-place query editing feature. This feature allows integration of powerful Query Builder tool with view editor without annoying copy/paste.

(George J. Trujillo Jr.) One of the common mistakes made by new MySQL DBAs is forgetting to consider the MySQL temporary directory. If an internal heap table exceeds the size of the MySQL parameter TMP_TABLE_SIZE, MySQL will create a temporary MyISAM file on the disk to buffer the data.

(Peter Zaitsev) Every so often I run into situation when I need to kill a lot of connections on MySQL server – for example hundreds of instances of some bad query is running making server unusable. Many people have special scripts which can take the user, source host or query as a parameter and perf

(Shlomi Noach) When working with InnoDB, you have two ways for managing the tablespace storage: –Throw everything in one big file (optionally split). –Have one file per table.

(Dathan Vance Pattishall) There are two PRIMARY directions to sort data in SQL: Ascending (ASC) and Descending DESC.