• Jay Pipes, Tobias Asplund
• Finding out the number of rows that would have been returned (MyISAM and InnoDB)
  • SQL_CALC_FOUND_ROWS and FOUND_ROWS()
  • COUNT(*)
  • MEMORY table
  • if query cache is on, then it makes no difference
  • if it's off
    • Memory MyISAM is fastest
    • FOUND_ROWS() is slightly slower than count(*)
  • more in the slides that I'll add later
• quite a lot of humor, these guys are fun
• query union vs index_merge union
  • SELECT … WHERE a UNION SELECT … WHERE b
    vs
    SELECT … WHERE a AND b
  • index_merge wins
• composite index vs index merge
  …

connector/odbc 3.51.25 and 5.1.4 were released today. the new 5.1 release has been deemed “generally available,” which is our really ridiculous term for a non-alpha/beta/rc release.

it was the day for the connectors team to do releases — previews of connector/openoffice.org and pdo_mysqlnd made it out before us, and i believe that a connector/net release is in the wings.

I’m pleased to say that I was able to see these in the flesh, but if you aren’t lucky enough to be here (or just want to watch them again), Zack has posted up videos on YouTube of the opening keynote presentations:

• MySQL Conference Keynote 2008 - Marten Mickos
• MySQL Conference Keynote 2008 - Jonathan Schwartz
• MySQL Conference Keynote 2008 - Werner Vogels

Sadly these are only snippets, but if you like what you see, make sure to book your place for next year’s conference early!

ebizApril 16, 2008Kickfire and Open Source Partners Team to Deliver BI Solutions on MySQL Database Appliance (http://www.ebizq.net/news/9416.html?grss)

Here is the quick notes from the session Falcon from the beginning by Jim Starkey and Ann Harrison

• Why Falcon
  • Hardware is evolving rapidly, world is changing, so taking advantage
  • Customers need ACID transactions
• Where hardware is going
  • CPUS breed like rabbits (more sockets, cores, threads/core)
  • Memory is bigger, faster and cheaper
  • Disks are bigger and cheaper but not much faster
  • In general boxes are getting cheaper
• Where applications are going
  • batch - dead
  • timesharing - dead
  • departmental computing - dead
  • client server - fading fast
  • application servers for most …

Minutes ago (when writing this), we have released a first preview version of PDO_MYSQLND for PHP together with the first preview version of MySQL Connector/OpenOffice.org. Minutes ago, both new developments have been announced at the MySQL Conference.

PDO_MYSQLND announcement explained

We will explain you in more detail what both products are about during the next days. Let me start with a brief overview on PDO_MYSQLND and allow me to cite the announcement.

The first preview version of PDO_MYSQLND for PHP has been released. PDO_MYSQLND is a new driver for PDO (PHP Data Objects) which can be …

You’ve probably seen the release announcement of MySQL Workbench this week at our User Conference and I wanted to add my public congratulations to the team.  At my last company, I oversaw a product line of many database tools for Oracle, SQL Server, MySQL, and others. And without question, out of the monitoring, admin, development, and other tools we produced, there was no other product that required more brainpower to produce than the modeling tool we sold (ER/Studio).  And that’s why I think the delivery of MySQL Workbench is so special - underneath the covers, there is a ton of complexity and hard work that other tools just don’t require. Modeling tools are just a different beast and the teams that build and maintain them are extreme developers - they have to be.  Mike Zinner and his team are just such developers and we’re lucky to have them.

Download and try out …

• Phil Hilderbrand of thePlatform for Media, Inc presents
• classic partitioning
  • old school - union in the archive tables
  • auto partitioning and partition pruning
  • great for data warehousing
  • query performance improved
  • maintenance is clearly improved
• design issues in applying partitioning to OLTP (On-Line Transaction Processing)
  • often id driven access vs date driven access
  • 1 big clients could be 80% of the whole database, so there's a difficulty selecting partitioning schemes
• partitioning is only supported starting from MySQL 5.1
• understanding the …

I know I’m a little late to the discussion, but Brian Aker posted a thought-provoking piece on the imminent death of MySQL replication to scale reads.  His premise is that memcached is so cool and scales so much better, that read replication scaling is going to become a think of the past.  Other MySQL community people, like Arjen and Farhan, chimed in too.

Now, I love memcached.  We use it as a vital layer in our datacenters, and we couldn’t live without it.  But it’s not a total solution to all …

ebizQApril 16, 2008Kickfire and Open Source Partners Team to Deliver BI Solutions on MySQL Database Appliance (http://www.ebizq.net/news/9416.html?grss)