Storage Engines
MySQL Admin 101 for System Admins – key_buffer_size
As discussed in my presentation to NYLUG , I wanted to provide system administrations with some really quick analysis and performance fixes if you had limited knowledge of MySQL. One of the most important things with MySQL is to tune memory properly.
Read moreCalculating your database size
I generally use the following MySQL INFORMATION_SCHEMA (I_S) query to Calculate Your MySQL Database Size . This query and most others that access the MySQL INFORMATION_SCHEMA can be very slow to execute because they are not real tables and are not governed by physical data, memory buffers and indexes for example but rather internal MySQL data structures.
Read moreUnderstanding Innodb Transaction Isolation
The MySQL Innodb storage engine provides ACID compliance, the ‘I’ being isolation. There are four states defined in MySQL with the tx_isolation system variable, READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ and SERIALIZABLE. Generally MySQL installations do not modify the default value of tx_isolation = REPEATABLE-READ, however I have seen with a number of clients the default value has been changed to READ-COMMITTED.
Read moreEngine agnostic MySQL test cases
Mark writes Now we all need the storage-engine independent test suite . I could not agree more. I have made comments about this probably as early as 4 years ago, and both before and while working for MySQL Inc.
Read moreHow do I create a simple MySQL database
I was asked this question recently “I am wanting to create a simple MySQL database consisting of 5 tables”? While it’s easy to tell people to RTFM, the question does warrant an answer for the MySQL beginner to provide a more specific guidance as to where to start, and what to do.
Read moreUnderstanding the various MySQL Products & Variants
The MySQL marketplace today is far more complex then simply choosing between a particular version of MySQL that Sun/MySQL produces. The MySQL server product in general is released under the GNU General Public License (GPL) v2 , however you should carefully review the MySQL Legal Policies {#s0rl} as a number of exceptions and different license agreements operate for companion tools such as MySQL Cluster, MySQL client libraries and documentation for example.
Read moreBeginner CSV Engine issues
I’ve just started using the CSV engine for a practical application and I’ve come across a few subtle and unexpected issues/limitations. First, you can’t create any columns in your CSV table nullable.
Read moreInfobright Community Edition(ICE) – It’s Free
The March NY MySQL Meetup featured a presentation from Infobright , a data warehousing solution built on the MySQL Product. With a pitch of “Simplicity, Scalability and low TCO” I became more impressed with the capability to delivery on these as the presentation proceeded.
Read moreThe new kid on the block – Drizzle
Before today, Drizzle was known as a light form of rain found in Seattle (among other places). Not any more. If you have not read the news already today, Drizzle, Clouds, “What If?
Read moreThe pursuit of a synchronous world
Well at least your MySQL database world. As Paul eluded to , PrimeBase Technologies has a project to provide synchronous replication for MySQL in a High Availability environment. It is more then an idea, there is a plan.
Read moreStorage Engines at the MySQL Conference
I’ll be following closely the progression of Storage Engines available in the MySQL Database server, well soon to be available when 5.1 gets to GA (hopefully by end of Q2 which is what we have been told).
Read more