Back in 1995 we had the Initial releases of the Apache Server,
MySQL and
PHP. Three major
open source projects that still power the web today. Majority of
them running on GNU/Linux platforms. Apache then soon also added Tomcat as well to
the mix to further enhance this powerful combination. So what is
next?
Now that we are well into the 21st century, what will be the next
stable projects of the Internet? What will change how we use the
Internet? Certainly we have great projects like …
According to Aspersa\'s user manual,
\"Aspersa is a collection of open-source system utilities primarily designed to ease the work of Percona consultants. This manual is the primary documentation for Aspersa tools. Please contribute your improvements.\"
I am reading the announcement about the Percona MySQL event in place of the O'Reilly.
What I see and what I feel is that the whole MySQL community, including Oracle, Percona, SkySQL,MariaDB and any other company doing business with MySQL have lost a good opportunity (so far).
For many years we have seen and hear comments about having this event more focus on users, and less bound to a single company. Now what? We will have a single company promoting the event. I don't care if it is done by Percona instead Oracle or SkySQL, actually I like all of them and I knew personally almost all of them as well.
What I care/like is to have this event NOT limited to a single company.
There was an attempt to have it organized in a different way (see Giuseppe and …
[Read more]According to maatkit home page,
Maatkit is a toolkit for users, developers, and administrators of open-source databases. It is high-quality, formally tested software that is well documented and has an active open-source developer community.
Abstract: In this article we provide a little JMeter WebShop Example Benchmark for MySQL.
For our Advanced MySQL Developer Workshop we have one exercise Benchmarking MySQL with JMeter. For this exercise we are using the FoodMart-2.0 [1] Schema and simulating a simple WebShop Transaction:
- Logging in
- Put some articles into the basket
- Buy the articles
- Log out
I found it pretty hard to find good and detailed examples how to do this with JMeter and I wasted a lot of time searching and figuring out how it works.
So I decided to provide my example ( …
[Read more]I love Percona Live. I think it is a great meeting of the minds. However, I do not think it is a good replacement for the big April MySQL conference. In fact, neither does Baron Schwartz:
"The conference is organized and owned by MySQL, not the
users. It isn’t a community event. It isn’t about you and me
first and foremost. It’s about a company trying to successfully
build a business, and other companies paying to be sponsors and
show their products in the expo hall."
Baron Schwartz, April 23, 2008.
http://www.xaprb.com/blog/2008/04/23/like-it-or-not-it-is-the-mysql-conference-and-expo/
Switch "MySQL" for "Percona", and that is exactly what Baron said in …
[Read more]
Percona has announced Percona Live MySQL Conference and Expo 2012.
Kudos for their vision and entrepreneurship. I have seen comments
praising their commitment to the community and their willingness
to filling a void. I have to dot a few i's and cross some t's on
this matter.
That was not the only game in town.By the end of June, there were
strong clues that O'Reilly was not going to organize a
conference. The question of who could fill the void started to
pop up. The MySQL Council started exploring the options for a
community-driven conference to replace the missing one. The
general plan was along the lines of "let's see who is in, and
eventually run a conference without the big organizer. If nobody
steps up, the IOUG can offer a venue in Las Vegas for an
independent MySQL conference". The plan required general …
A colleague of mine has been benchmarking mysqldump data load vs.
various versions of LOAD DATA INFILE. He created a sample data as
a text file with either 100k or 20M rows of five integers each,
the first column of which is the pk.
CODE:
perl -MList::Util=shuffle -e '@k=shuffle(1..20e6);
for (@k) {
print $_, " ", join(" ", map int(rand(1e9)), 0..3), "\n";
}' > loadme_nonpkorder.txt
perl -e 'print ++$i, " ", join(" ", map int(rand(1e9)), 0..3), "\n"
for 1..20e6' > loadme_pkorder.txt
All insertion has been done on empty and new tables. The text
files we read at least once before to warm up the OS disk cache.
The tables have …
We’re thrilled to announce that we have signed a contract with the Hyatt Regency Santa Clara and the Santa Clara Convention Center, to host a Percona Live MySQL Conference and Expo on April 10-12, 2012. This event is part of our Percona Live series of conferences, but it’s not just another event in the series.
We all know that the entire MySQL community has been waiting to see if there will be a MySQL conference next year in the traditional date and location. To the best of our knowledge, no one else was planning one, so we decided to keep the tradition …
[Read more]
To follow up on a post by Dave --
The MySQL Community Team would like your feedback about MySQL 5.6
! What are you excited to see and test? What have you tested and
benchmarked? Did you previously see the advantages of going to
MySQL 5.5 and now eager to try 5.6? What are your favorite new
features: Full Text Search InnoDB tables, Binary Log API, Binary
Log Group Commit, multi-thread slaves, memcached-to-InnoDB? Feel
free to email keith.larson[@]oracle[.]com with feedback.
If you have been busy with development, and not realized that
previews of MySQL 5.6 are available, then now is your chance.
Previews of MySQL 5.6 are available at http://labs.mysql.com
for you to evaluate.