(Bill Ramos) In this blog post, I’ll walk through the various options you have for controlling data type migration changes within SQL Server Migration Assistant for MySQL v1.0 (SSMA). SSMA provides several difference ways to map data types from MySQL to SQL Server that includes: project level settin

(Anders Karlsson) MySQL 5.1 and up has EVENTs, but this features seems to be little used. I started using them some time ago, and once I was using them, I found them more and more useful. There are a few bugs with them, I reported this one for example, and this alone tells me that probably not too m

(Baron Schwartz) There are many ways to slice and aggregate metrics of activity on a system such as MySQL. In the best case, we want to know everything about the system’s activity: we want to know how many things happened, how big they were, and how long they took.

(Trent Hornibrook) A drop table can be a timely locking operation though if a few preconditions are met we can reduce the locking time on the server and intern any performance consequence.

(Mark Johnson) MySQL has those curious size attributes you can apply to integer data types. For example, when creating a table, you might see:

(Partha Dutta) In the process of building a new benchmark tool for Yahoo, I needed a good “guinea pig.” I think I found the one by showing how much more powerful covering indexes can be with InnoDB.

(Shinguz) A customer who is handling digital certificates had a problem with one of those. So we had to investigate.

(Peter Zaitsev) I have mentioned few times Innodb caches data in pages and even if you have working set consisting of relatively few rows your working set in terms of pages can be rather large. Now I came to do a little benchmark to show it in practice.

(Shinguz) If you ask around about shared hosting setups with MySQL everybody is frightened. In fact it looks like shared hosting is one of the most difficult setups you can get.

(Vadim Tkachenko) There have been recent discussions about DROP TABLE performance in InnoDB.