view counter
Home

MySQL Feed

Oracle MySQL resources, news, and support articles.

Comments are broken — again

A few users have reported that their comments are randomly not showing up on the site. We can’t find them in the database; they aren’t getting put into the spam queue, etc. I just got another report of this and found the INSERT for the comment in the database’s binary log. Of course, the comment is not in the database, as usual. I’m looking into this now.

May 01, 2011 6:32pm

Hours remain for Percona Live NYC Early Bird Discount

Just few short hours remain for Early Bird Discount for Percona Live, New York City. This is your last chance to grab the ticket at almost 50% discount, for $129 instead of $259. We have a Great Session Lineup and outstanding networking opportunities !

Apr 30, 2011 1:34pm

Is this a new feature?

Is this an amazing new feature or the next step after the change to bugs.mysql.com? I was about to file a bug report to improve the MySQL manual, but that won't happen now:

  1. Go to page for MySQL Reference manual
  2. Type text in "Search Manual" box on the left-hand side of the page
  3. End up at login.oracle.com sign in page
Apr 29, 2011 5:08pm

Sysbench with support of multi-tables workload

We just pushed to sysbench support for workload against multiple tables ( traditionally it used only single table).

It is available from launchpad source tree lp:sysbench .

This is set of LUA scripts for sysbench 0.5 ( it supports scripting), and it works following way:

- you should use --test=tests/db/oltp.lua to run OLTP test
i.e. prepare

./sysbench --test=tests/db/oltp.lua --oltp-tables-count=25 prepare

run:

Apr 29, 2011 9:52am

Percona Server 5.5.11-20.2 Stable Release

Percona Server Percona Server 5.5.11-20.2 is now available for download, including an experimental build for MacOS.

Released on April 28, 2011, it is the current stable release in the the 5.5 series.

Apr 28, 2011 5:18pm

Scalr and MNPP

Good news for all Percona Software users out there. There are more ways how you can get access to Percona Software. If you’re using Scalr (See also Scalr Project on Google Code) you might be interested in Percona Server roles support Scalr team has announced recently.

Apr 28, 2011 2:33pm

Replication : different points of view

The following quotes are the first sentences in the replication chapter of two similar books. Both are admin cookbooks. One is for PostgreSQL, one for MySQL.

Replication isn't magic, though it can be pretty cool. It's even cooler when it works, and that's what this chapter is all about.

Apr 27, 2011 11:34pm

Labs.MySQL.Com — server snapshots

Warning — for testing purposes only!

Apr 27, 2011 9:24am

OTN Developer Day for MySQL - Santa Clara, CA

Oracle Technology Network (OTN) Developer Day for MySQL will take place on May 3rd in Santa Clara, CA to help DBAs and Developers get started and get better with MySQL. In this free, one-day event, we will cover topics from database design, application development, to MySQL administration and management. You'll also learn the guidelines and best practices in performance tuning and scalability. 


Attend this event and gain the knowledge to:
    •    Develop your new applications cost-effectively using MySQL
    •    Improve performance of your existing MySQL databases

Apr 27, 2011 8:45am

The four fundamental performance metrics

There are many ways to slice and aggregate metrics of activity on a system such as MySQL. In the best case, we want to know everything about the system’s activity: we want to know how many things happened, how big they were, and how long they took. We want to know precisely when they happened. We want to know resource consumption, instantaneous status snapshots, and wait analysis and graphs. These things can be expensive to measure, and even more importantly, they can require a lot of work to analyze.

Apr 27, 2011 7:47am
view counter