My last post Using Partitioning in MySQL™ 5.1 would be the last post of the Series “Using Feature XXX in MySQL™ 5.1″.
I started write this series of articles on August 2008 when I heard about the MySQL™ 5.1 Use Case Competition and decided to let the Community Team of MySQL™ know about what I’ve developed and included in HoneyMonitor, the HoneySoftware’s GUI for MySQL™.
I’ll comment about the 5.1 UCC later on a new post.
Here’s the links of the articles included in the series:
[Read more]This is a short tutorial on the features implemented in HoneyMonitor for the use and administration of Partitioning in MySQL™ 5.1. It could be useful for Users who are new to the product and want to get start with it or to whom want to learn the basis of Table Partitioning in MySQL™ 5.1.
Contents
1. Introduction
2. Partitioning a Table
2.1 Creating a Partitioned Table using the Create Table Wizard
and the Partition Editor - A Range Partitioning Example
2.2 Partitioning a Table that already exits - An Hash
Partitioning Example
3. Creating and Dropping Partitions
3.1 Adding Partitions
3.2 Dropping Range (or List) Partitions
3.2.1 Multi-Dropping of Partitions
3.3 Aggregating Hash (or Key) Partitions
4. Reorganizing Partitions
5. Repartitioning a Table
6. Removing Partitioning
7. Retrieving Information about Partitions
7.1 Partitions’ …
I am happy to announce that mylvmbackup version 0.10 has been released.
You can download the updated package from the project home page or via the openSUSE Build Service.
This version fixes some bugs and includes new functionality:
I am happy to announce that mylvmbackup version 0.10 has been released.
You can download the updated package from the project home page or via the openSUSE Build Service.
This version fixes some bugs and includes new functionality:
When optimizing queries for customers, the first thing I do with a slow query is figure out what it's trying to do. You can't fully optimize a query unless you know how to consider alternative ways to write it, and you can't do that unless you know what the query "means." I frequently run into a situation where I'm forced to stop and ask the developers what they were trying to do with COUNT(). This is database-agnostic, not related to MySQL.
The problem is when the COUNT() contains a column name, like this:
PLAIN TEXT SQL:
If you know your SQL well, you know COUNT() has two meanings. 1) count the number of rows 2) count the number of values. Sometimes, but not always, these are the same thing. COUNT(*) always counts the number of rows in the result. If …
[Read more]It is no secret that I am the Program Chair for the MySQL Conference & Expo 2009, and am truly excited about it (big shoes to fill in from Jay). I expect it to be a great conference, with over 2,000 attendees and lots and lots of great talks. The paper submissions have been coming through, the excellent voters have been voting, and the progress is impressive. Its a great learning experience.
Now, I’m excited to tell you that I’m also going to organise the Open Source Databases MiniConf at linux.conf.au 2009. Its going to be in Hobart, Tasmania, in January 2009, and again, I’m excited. Read the …
[Read more]Greetings from the University of Latvia in Riga, where the local activities related to Software Freedom Day 2008 are in full swing! We've just finished the introductionary talk "Software freedom in Latvia" by Evijs Taube (LATA) and Leo Trukš
Greetings from the University of Latvia in Riga, where the local activities related to Software Freedom Day 2008 are in full swing! We've just finished the introductionary talk "Software freedom in Latvia" by Evijs Taube (LATA) and Leo Trukš
I had the pleasure of sitting right across the MySQL GUI Tools Team, and decided to try my hand at Workbench (Workbench for Linux, that is). Congratulations to the entire team for the great work! I am excited.
First up, the things you need on Ubuntu 8.04 (I created a fresh install, and installed all the updates), if you’re downloading the binary:
It works. It starts up. Its exciting. Of course, when I try to edit a table name or even create a table, it fails by segmentation fault. Segfaults are annoying… so the best way to debug it, is of course to run catchsegv. …
[Read more]
Well, I'm back in "Blighty" (that's slang for Britain). I've been
trying for the last 2-3 weeks to find jobs in the UK.Since I
wrote a while ago "Which Database to Choose When Looking for a
Job", I wanted to continue it with some of my findings. I did
a lot research on IT specific job sites and used 2 main
searches, "database developer" (because that's what I want to do)
and "mysql" to help me find job posts that I was interested
in.
Jobs Situation for "Database Developer"
I'll describe the results for this search in
percentages. Firstly, 90% of the jobs are for MS SQL server.
Those jobs usually stick to mainly developing and not
administrating. In those 90% you have a good mix of junior
positions(22-28k GBP per year), medium paid positions (30-45k GBP
per year) and advanced positions (50-70k GBP per …