Showing entries 25286 to 25295 of 44108
« 10 Newer Entries | 10 Older Entries »
FOSDEM Call For Participation opened - submit your talks now!

FOSDEM, the Free and Opensource Conference, will again take place in Brussels, Belgium on Saturday and Sunday (6th and 7th February, 2010). Now happening for the 10th time (congratulations!), it is one of the largest Open Source conferences in Europe, with a strong focus on developers. Sun/MySQL have been regular sponsors of and contributors to the event in the past and it is alway a great experience to be there. It's very rare to meet so many well-known and bright people from such a wide range of OSS projects.

They have now opened their Call for Participation - the organizers are seeking input on talks for the main conference tracks (deadline: 2009-11-22) , …

[Read more]
MySAR, a Sidekick for Other Monitoring Tools

I’m sure that most people have at least one of the tools listed in Ronald Bradford’s article: Monitoring MySQL Options. Many of these tools, such as Nagios and Cacti, also monitor the operating system. However, in the same way that a quick look at sar‘s output can give you some insight on the OS, with MySAR you can do the same for the MySQL server. This is especially useful when  it is not possible to access a monitoring tool’s graphic interfaces.

What Was Going On Around 2:30pm?

This is a question a customer asked us. To answer it we ran MySAR for a few days and queried the results for analysis. Looking at the data, we determined that the number of INSERT operations was significantly higher than any …

[Read more]
More changes in the Facebook patch

I pushed more changes to the Facebook patch on Launchpad. These include replacing SHOW TABLE_STATISTICS with an information_schema table, adding the option time_query_overhead to enable/disable the use of extra timers for performance monitoring and adding an option to measure more mutex contention.

SHOW TABLE_STATISTICS has been replaced by the table information_schema.table_statistics. The command FLUSH TABLE_STATISTICS has been replaced with FLUSH STATISTICS which will flush other stats tables we add in the future. The statistics are only kept for InnoDB and MyISAM tables. I would love to find out that in a future version of MySQL there is one method I can modify in the handler to avoid changing MyISAM, InnoDB and every other storage engine. The table information_schema.table_statistics has the following columns:

  • TABLE_SCHEMA - database name, mysql is …
[Read more]
MySQL-Memcached or NOSQL Tokyo Tyrant – part 3

This is part 3 of our series.  In part 1 we talked about boosting performance with memcached on top of MySQL, in Part 2 we talked about running 100% outside the data with memcached, and now in Part 3 we are going to look at a possible solution to free you from the database.  The solution I am going to discuss here is Tokyo Cabinet and Tyrant.

I am not going to give you a primer  or Tutorial on Tyrant and Cabinet, there are plenty of these out there already.  Instead I want to see what sort of performance we can see compared to MySQL and Memcached, and later on other NoSQL solutions.  Tokyo actually allows you to use several types of databases that are supported, there are hash databases which …

[Read more]
GreenSQL-FW: 1.1.0 released

GreenSQL 1.1 is primarily a bug fix update of the previous GreenSQL version. One of the main fixes is to ensure code compliance with the MySQL version 5.0 protocol. During the MySQL protocol handshake, we disable MySQL built-in compression and encryption as GreenSQL does not yet support them. Old versions of GreenSQL were not aware of the compression and encryption at all, so by disabling them, we are able to check and forward the database queries.

The GreenSQL team is proud to announce that version 1.2 is already in an advanced development phase scheduled to be released in early December. It will include many new features, such as a new management GUI, advanced support for SQL protocols, and improved performance and reliability.

The GreenSQL team is also excited to announce new support services which we will be offering with the release of version 1.2. GreenSQL open source is available for free, as always. The …

[Read more]
2nd IKS Workshop: The Web 3.0 and Open Source Semantic Search

Rome is a great city and it will host a bunch of great people (including me ) at November 12-13. This is when the second IKS Project workshop will take place. The goal of this workshop is to start working on an Open Source software stack that allows other Open Source projects and software vendors to leverage semantic search technologies.

IKS is an EU-funded project with an overall budget of 8.5 million Euros. The first workshop back in May saw two dozen of bright Open Source CMS minds discussing a semantic stack in general. This time, it will also make sense for non-CMS-related Open Source projects and vendors to join.

There will be interesting presentations from some key figures at the second workshop in Rome, such as Peter Mika of Yahoo! Research talking about “The Role of …

[Read more]
How MySQL Cluster executes queries

This post describes how MySQL Cluster executes queries. First of all, Cluster is a storage engine. It doesn't actually execute queries because it doesn't speak SQL. That is why you use a MySQL server, which parses your queries and sends low-level storage engine API calls to the Cluster data nodes. The data nodes know how to retrieve or store data. Or you can talk to the data nodes directly using the NDB API(s).

MySQL Cluster has various means of executing queries. They boil down to:

  1. Primary key lookup
  2. Unique key lookup
  3. Ordered index scan (i.e., non-unique indexes that use T-trees)
  4. Full table scan


Let's say you have 4 data nodes in your cluster (NoOfReplicas=2). This means you have 2 node groups and each one has half the data. Cluster uses a hash on the primary key (unless you've controlled the partitioning using the 5.1 partitioning features). So for …

[Read more]
Building MariaDB/MySQL with Buildbot and KVM

Testing and automation. These two are key to ensuring high quality of software releases.

Ever since I worked briefly in the team at MySQL AB that is responsible for creating the binary (and source) packages of MySQL releases, I have had the vision of a fully automated release procedure. Whenever someone pushes a new commit to the release branch revision control tree, the continuous integration test framework should kick in and do all the steps needed for producing release packages:

  • Checkout the new revision.
  • Build a source tarball, and save it.
  • For each platform, build a binary package from the source tarball. The build should be done in a freshly installed machine without any revision control checkouts, previous build trees, or extra installed software, to ensure that no unwanted dependencies or stray …
[Read more]
Shinguz's Blog (en): MySQL useful add-on collection using UDF

I really like this new toy (for me) called UDF. So I try to provide some more, hopefully useful, functionality.

The newest extension I like is the possibility to write to the MySQL error log through the application. Oracle can do that since long. Now we can do this as well...

A list of what I have done up to now you can find here:

If you have some more suggestions, please let me …

[Read more]
MySQL useful add-on collection using UDF

I really like this new toy (for me) called UDF. So I try to provide some more, hopefully useful, functionality.

The newest extension I like is the possibility to write to the MySQL error log through the application. Oracle can do that since long. Now we can do this as well...

A list of what I have done up to now you can find here:


If you have …

[Read more]
Showing entries 25286 to 25295 of 44108
« 10 Newer Entries | 10 Older Entries »