Very often people not expert ask me some simple detailed directions on how to install MySQL from fresh.

The following is a simple one that if you will follow step by step should give you a MySQL working installation.

this articule assume that you have the possibility to attach different storage for:

System and binaries

MySQLData

MySQLLogs

Prerequisite:

1) You need to have access to the client area for download the MySQL software from somwere possible points are: www.mysql.com www.askmonty.org www.percona.com

2) Perl DBI and DBD::mysql installed on the machine (See How to Install MySQL Perl module guide)

3) Root privileges

Steps:

1) Install the Perl modules

2) Create a directory layout as follow:

/mysql_data/
|-- data
|   |-- mysql
|   `-- test
`-- lost+found 
 …

Received a "certificate of attendance as speaker" for recently concluded FISL 10.



This is sweet, thanks FISL organizers! It certainly adds a personal touch to the whole experience.

I don't remember receiving a personal certificate like this :)

Technorati: conf fisl brazil glassfish netbeans mysql eclipse

For anyone, who has questions about MySQL query cache tuning, try this tuning assistant:

http://mituzas.lt/tech/query-cache-tuner/

Thursday night I will be recording a conversation with Brian Aker about his work with the Drizzle database.  We will cover everything from why Drizzle was created to what he is currently doing day-to-day.

This will be turned into the initial podcast for the  Open Source Database Magazine podcast.  My goal is release a podcast around the same time as each issue of the magazine. While the magazine will certainly be technical in nature, I don’t see the podcast as going that direction. The podcast will focus more on the people behind the open source products.  The “human side” of open source databases. I find printed interviews of people to be minimally satisfying at best. Interviews are a natural for podcasts. Can’t say that technical content won’t ever sneak in there — but it will definitely focus on the “softer” side of open source databases.

…

I have made an update to the DBT2 clone where I packed in all my
benchmarking support scripts.

This update adds a new script bench_prepare.sh that should be run
from the benchmark server and uses the input of 3 tarballs, the
DBT2 tarball, the sysbench tarball and a MySQL tarball. It will
automatically build all needed binaries on both the benchmark
server and on the MySQL Server machine (they could be on same
machine or on different machine).

The script only requires one parameter --default-directory where
one configuration file called autobench.conf should be placed.
This directory will also be used to house all result files,
builds and generated configuration files for all involved scripts.

The aim is to continue develop such that we can also benchmark
easily using different Linux versions.

The tarball can be …

Received a "certificate of attendance as speaker" for recently concluded FISL 10.



This is sweet, thanks FISL organizers! It certainly adds a personal touch to the whole experience.

I don't remember receiving a personal certificate like this :)

Technorati: conf fisl brazil glassfish netbeans mysql eclipse

Received a "certificate of attendance as speaker" for recently concluded FISL 10.



This is sweet, thanks FISL organizers! It certainly adds a personal touch to the whole experience.

I don't remember receiving a personal certificate like this :)

Technorati: conf fisl brazil glassfish netbeans mysql eclipse

We like to invite you to the PHP 5.3 release party which is an event to celebrate the 5.3 release, happening Friday, the 17th of July in Munich. The release party offers a chance to come together with other php enthusiasts and enjoy that php is alive and kicking. And of course people in favour of a decent barbecue, together with some beer and other drinks are invited.

The happening will take place at Waldwirtschaft beer garden, at any weather.
We will meet at 19:00 o’clock - open end.

The location is famous for its huge beer garden (2500 available seats, a children’s playground) and its typical Bavarian but also international food. On sunny weather you even may enjoy live-music and listen to the sounds of Jazz, Blues, Swing or Dixi.

Catering will be provided …

We like to invite you to the PHP 5.3 release party which is an event to celebrate the 5.3 release, happening Friday, the 17th of July in Munich. The release party offers a chance to come together with other php enthusiasts and enjoy that php is alive and kicking. And of course people in favour of a decent barbecue, together with some beer and other drinks are invited.

The happening will take place at Waldwirtschaft beer garden, at any weather.
We will meet at 19:00 o’clock - open end.

The location is famous for its huge beer garden (2500 available seats, a children’s playground) and its typical Bavarian but also international food. On sunny weather you even may enjoy live-music and listen to the sounds of Jazz, Blues, Swing or Dixi.

Catering will be provided …

Speed of InnoDB recovery is known and quite annoying problem. It was discussed many times, see:

http://bugs.mysql.com/bug.php?id=29847

http://dammit.lt/2008/10/26/innodb-crash-recovery/

This is problem when your InnoDB crashes, it may takes long time to start. Also it affects restoring from backup (both LVM and xtrabackup / innobackup)

In this is simple test, I do crash mysql during in-memory tpcc-mysql benchmark with 16 running threads.
MySQL params are:

PLAIN TEXT CODE:

1. innodb_buffer_pool_size=16G
2. innodb_log_files_in_group=3
3. innodb_log_file_size=512M

So let's take standard MySQL …