(Peter Galli) Enterprise customers are using open-source software more and more, but issues of interoperability are still a stumbling block to widespread adoption, say customers and open-source software vendors.

(George J. Trujillo Jr.) 2007 has been an interesting year with MySQL. MySQL really seems to have broken out this year. Organizations are absolutely choking on their database and software licensing costs. More and more organizations, large and small are now recognizing MySQL databases as a viable so

(Nilpo) If you are a web developer, you are undoubtedly aware that there are constant threats to your site. SQL injections are one type of threat that you must be aware of and make every attempt to prevent.

(George J. Trujillo Jr.) Proper installation of a MySQL database environment will make a tremendous difference in the management of the MySQL database server. This image shows key areas that need to be considered in defining the MySQL configuration. MOCA is used to demonstrate important points to co

December the 17th we upgraded the majority of our servers that had been running version 4.1.22 of MySQL to 5.0.45. This was not a small undertaking and is something that I had been planning for about five months. It had been initially slated to take place in September, but due to the release of a ne

(Jag Singh) Table partitioning in data warehouses is used to divide a large database table into smaller physical tables called partitions that are easier to manage. The partitions still retain a single logical view for the user query execution. Range partitioning by date facilitates historical ETL p

(Xaprb) I’ve written before about how to figure out which connection is holding the InnoDB locks for which other connections are waiting. In other words, how to figure out who’s blocking you from getting work done when you get InnoDB lock timeouts or other InnoDB lock contention. The short and sweet

(Stephen Shankland) For years, the center of open-source software, at least from a commercial perspective, was with companies such as Red Hat, Novell, MySQL, and a number of smaller players. Those companies continued grinding away at their collaborative programming projects and support-centric busin

(David Walsh) The ability to return random records from a MySQL table is invaluable. Returning random records is helpful when: –featuring items without showing favoritism to one –testing different result sets in your PHP –looking to display specific items in a non-specific order

(Jonathan) I have been talking about many theories in the past and in my last post, I decided to start doing something instead of just talking about it.