Finally, it's time to start putting MySQL 5.1.12-beta through the wringer. First order of business, convert the existing table schema to one that supports partitioning...

I made some minor changes to the configuration for partitioning, namely innodb_file_per_table and innodb_open_files. I set innodb_open_files to 1000 based on the tables and partitions I plan on supporting.

This is what the new table schema looks like with partitioning:

CREATE TABLE `network_daily` (
  `entity_id` int(11) NOT NULL default '0',
  `buyer_entity_id` int(11) NOT NULL default '0',
  `buyer_line_item_id` int(11) NOT NULL default '0',
  `seller_entity_id` int(11) NOT NULL default '0',
  `seller_line_item_id` int(11) NOT NULL default '0',
  `size_id` int(11) NOT NULL default '0',
  `pop_type_id` int(11) NOT NULL default '0',
  `country_group_id` int(11) NOT …

Tonight is a game night/potluck (aka have a large crowd of people descend on my house to play board games).

So what do I do while waiting for people to show up? Read RSS.

Tonight's find:
http://radar.oreilly.com/archives/2006/11/ten_things_i_wa.html

Tim is commenting on what people want in a cell phone. What do I find interesting in this?

Integrate with other non-phone communication methods (e.g. email and IM, for phones that don't support it), and use all the same metrics as in #1 above to give me an address book that reflects my true social network.

Somewhere back in the beginnings of the 90's I wrote a problem that sat in my .forward file to capture all of the email addresses that went through my email account. Why?

Because at the time I found I …

You are tired of writing your UDFs in C or never wanted to write them in C at all ? How about writing them in lua ?

LUA is

• easy to learn
• easy to embed
• easy to use

functions

As example we want to read the real startup time of the errorlog.

-- we are run with the permissions of the mysqld
--
-- let's try the read the "ready for connections" from the errorlog and look
-- for the last [Note]:
--
-- 061124 17:28:39 [Note] /usr/sbin/mysqld-max: ready for connections.

local f = assert(io.open(params[1], "r"))
local readysince = nil

while true do
        local line = f:read()

        if not line then break end

        local match = string.match(line, "^([0-9]+ [0-9:]+) %[Note%]")

        if match then
                readysince = match
        end
end …

I am happy to announce version 0.3 of mylvmbackup, a tool that performs consistent backups of a MySQL server's tables using Linux LVM snapshots.

Special thanks go to Fred Blaise, who contributed the majority of the new features that have been added to this new release:

• It is now possible to use an external configuration file /etc/mylvmbackup.conf to store the options. This is probably more convenient than having to pass a slew of options on the command line or having to hack the script itself to change the default values. This new feature requires the Config::IniFiles Perl module to be installed, a sample configuration file is included in the package.
• The logging to the console has been …

I am happy to announce version 0.3 of mylvmbackup, a tool that performs consistent backups of a MySQL server's tables using Linux LVM snapshots.

Special thanks go to Fred Blaise, who contributed the majority of the new features that have been added to this new release:

• It is now possible to use an external configuration file /etc/mylvmbackup.conf to store the options. This is probably more convenient than having to pass a slew of options on the command line or having to hack the script itself to change the default values. This new feature requires the Config::IniFiles Perl module to be installed, a sample configuration file is included in the package.
• The logging to the console has been …

I've been very busy testing and testing MySQL 5.1.12-beta and on the surface, it passes my tests. But first, let me set the stage as far as what we are trying to accomplish at RightMedia...

All of our adserving data is aggregated into our reporting database, which runs MySQL version 5.0.22. The database is so large, that we split it across 6 machines. Each of these machines has a similar configuration: 2 Dual core Opteron CPUs, 16GB of memory and 3 146GB 15k RPM SCSI drives in a RAID-0 set.

Here is what one of our typical tables looks like:

CREATE TABLE `network_daily` (
  `entity_id` int(11) NOT NULL default '0',
  `buyer_entity_id` int(11) NOT NULL default '0',
  `buyer_line_item_id` int(11) NOT NULL default '0',
  `seller_entity_id` int(11) NOT NULL default '0',
  `seller_line_item_id` int(11) NOT NULL default '0',
  `size_id` int(11) NOT NULL default '0',
  `pop_type_id` …

Watch the number of average queries per second

Please pay attention to the load average of the server

I was astonished when I saw these numbers. Does anyone has the same MySQL performance?

The server we are talking about is a replicating slave server (double XEON processor, 1GB RAM) of www.inter.it, during AC Milan-Inter Milan match.

Watch the number of average queries per second

Please pay attention to the load average of the server

I was astonished when I saw these numbers. Does anyone has the same MySQL performance?

The server we are talking about is a replicating slave server (double XEON processor, 1GB RAM) of www.inter.it, during AC Milan-Inter Milan match.

Mike Kruckenberg posted recently a tip he found to create easy text bar charts using the REPEAT function, that he found at:

http://www.squarebits.com/blog/2006/11/generate_simple.html

Today I stumbled across this link:
http://www.webcheatsheet.com/php/dynamic_image_generation.php#diagram

Which, using PHP, creates a graphical bar chart using the data in a MySQL database and a small bit of math.

Both are very neat!

Hot from the Virtual Appliance Turkey Fryer, build 74 of the PostgreSQL Virtual Appliance is available for download here

This appliance features automated use of Virtual Hard disks to allow the nano sized appliance to access any size storage for its database.

This appliance provides an upgrade to PostgreSQL 8.1.4.

Enjoy.