Oracle Virtualization and Cloud Consulting
view counter

MySQL Feed

Oracle MySQL resources, news, and support articles.

Announcing Percona XtraDB Cluster 5.5.27-23.6

Percona is glad to announce the release of Percona XtraDB Cluster on September 7th, 2012. Binaries are available from downloads area or from our software repositories.


Measuring free space in InnoDB’s global tablespace

With innodb_file_per_table=1, InnoDB places every table’s data and indexes in a separate .ibd file, but there is still a “global” system tablespace, stored by default in a file named ibdata1. This contains some of each table’s data, such as the undo log and insert buffer. If it is fixed-size, you can fill it up and crash the server, as I’ve mentioned in a few recent blog posts.

Great Talks on Percona Live,NY!, Free Pass opportunity inside

You surely have heard about Percona Live,NY taking place October 1-2 in New York, you however might have been wondering what kind of talks you would see on this event and why would should you attend.

Detecting MySQL server problems automatically

I previously blogged about work I was doing on automatically finding problems in a MySQL server, with no hardcoded thresholds or predetermined indicators of what is “bad behavior.” I had to pause my studies on that for a while, due to time constraints. I’ve recently been able to resume and I’m happy to report that I’m making good progress.

How common_schema split()s tables - internals

This post exposes some of the internals, and the SQL behind QueryScript's split. common_schema/QueryScript 1.1 introduces the split statement, which auto-breaks a "large" query (one which operates on large tables as a whole or without keys) into smaller queries, and executes them in sequence.

What’s your opinion of High Performance MySQL?

The second edition of High Performance MySQL has 27 reviews on Amazon, but the third edition only has 5 so far. By this point I assume many of you have a copy and have read it cover to cover. I’d really appreciate your reviews — when purchasing, people look not only at the star rating but at the number of reviews. You can create a review here. And thanks!

Write contentions on the query cache

While doing a performance audit for a customer a few weeks ago, I tried to improve the response time of their top slow query according to pt-query-digest‘s report. This query was run very frequently and had very unstable performance: during the time data was collected, response time varied from 50µs to 1s.

Announcing Percona Server 5.5.27-28.1

Percona is glad to announce the release of Percona Server 5.5.27-28.1 on September 5th, 2012 (Downloads are available here and from the Percona Software Repositories).

Table split(...) for the masses

(pun intended)

common_schema's new split statement (see release announcement) auto-splits complex queries over large tables into smaller ones: instead of issuing one huge query, split breaks one's query into smaller queries, each working on a different set of rows (a chunk).

view counter