FOSDEM 2013, another nice open source event in Europe!

FOSDEM is a free event that offers open source communities a place to meet, 
share ideas and collaborate.
It is renowned for being highly developer-oriented 
and brings together 5000+ geeks from all over the world.

 
This year again, be sure that FOSDEM will be the place to be in February!

Do you have any doubts? Really ? Dude, repeat after me :

  1. Free event
  2. During a week-end
  3. Beer
  4. 5000+ open source geeks
  5. Beer
  6. MySQL and Friends devroom
  7. NoSQL devroom
  8. No registration needed (open source man!)

Ok, that sounds good?

Well, here are the informations to attend this terrific event :

  • How to register? : Are you kidding me?
  • When : 2 & 3 February 2013 (Hurry up guys!)
  • Where : Brussels (beers!!!)
  • Website : https://fosdem.org/2013/

Max and I will be at FOSDEM for the first time this year.
Hope to see you there

PS1 : If you didn’t vote for the [Plus] Readers Choice 2012 yet, do it now!
PS2 : And if you want to stay on the move, ask for these cute stickers, your laptop will love them!

[Plus] readers choice 2012 : It’s time to vote!

Oh yes, 2012 was an incredible year for the MySQL Community!
That’s why I would like to change the rules this year and I would like to offer you a new survey for this [Plus] reader’s choice 2012.

Community users, bloggers and events made the whole community last year, tell us how you used this community?
It will only take 5 minutes of your precious time, votes will be closed Jan. 31.

Vote for what you used! (with your heart, again…)

What was your most useful blogs in 2012? (Two possible answers)

  • MySQL Performance Blog (Percona Team) (57%, 73 Votes)
  • The MariaDB Blog (MariaDB Team) (17%, 22 Votes)
  • SkySQL Blog (SkySQL Team) (13%, 17 Votes)
  • Xaprb Blog (Baron Schwartz) (9%, 12 Votes)
  • The Data Charmer (Giuseppe Maxia) (9%, 11 Votes)
  • Openark Blog (Shlomi Noach) (6%, 7 Votes)
  • The Scale Out Blog (Robert Hodges) (6%, 7 Votes)
  • Domas Mituzas's blog (5%, 6 Votes)
  • OpenLife.cc (Henrik Ingo) (4%, 5 Votes)
  • Pythian Blog (Pythian Team) (4%, 5 Votes)
  • Yoshinori Matsunobu's blog (4%, 5 Votes)
  • Dba Square (Maciej Dobrzanski & Piotr Biel) (4%, 5 Votes)
  • Johan Andersson's Cluster and HA Blog (3%, 4 Votes)
  • Chris on MySQL (Chris Calender) (3%, 4 Votes)
  • MySQL[Plus] (Cédric Peintre) (3%, 4 Votes)
  • Ulf Wendel's blog (2%, 3 Votes)
  • Hack MySQL (Daniel Nichter) (2%, 3 Votes)
  • MySQL Optimizer Team Blog (2%, 3 Votes)
  • Oracle's MySQL Blog (Oracle Team) (2%, 3 Votes)
  • MySQL Documents by Rick James (2%, 2 Votes)
  • Sergey Petrunia's blog (2%, 2 Votes)
  • LinuxJedi's /dev/null (Andrew Hutchings) (2%, 2 Votes)
  • Sheeri Dot Com (Sheeri K. Cabral) (2%, 2 Votes)
  • Karlsson on databases and stuff (Anders Karlsson) (2%, 2 Votes)
  • MySQL Fanboy (Mark Grennan) (1%, 1 Votes)
  • varokism (Stéphane Varoqui) (1%, 1 Votes)
  • MySQL Expert (Ronald Bradford) (1%, 1 Votes)
  • Roland Bouman's blog (1%, 1 Votes)
  • mySQL DBA (Dathan Pattishall) (1%, 1 Votes)
  • Mastering MySQL (Mark Leith) (1%, 1 Votes)
  • sqlhjalp (Keith Larson) (1%, 1 Votes)
  • mysqlboy (Andrew Moore) (0%, 0 Votes)
  • Andrew Morgan’s MySQL Cluster Database Blog (0%, 0 Votes)
  • Webyog blog (Webyog Team) (0%, 0 Votes)
  • Racker Hacker (Major Hayden) (0%, 0 Votes)
  • Todd's MySQL Blog (Todd Farmer) (0%, 0 Votes)

Total Voters: 127

Loading ... Loading ...

What was your most useful forum in 2012? (or exchange platform)

  • stackoverflow.com (41%, 38 Votes)
  • Twitter (18%, 17 Votes)
  • forums.mysql.com (13%, 12 Votes)
  • dba.stackexchange.com (10%, 9 Votes)
  • Facebook (10%, 9 Votes)
  • LinkedIn Groups (7%, 6 Votes)
  • Yahoo Answers (1%, 1 Votes)
  • dbforums.com/mysql (0%, 0 Votes)
  • Viadeo Groups (0%, 0 Votes)

Total Voters: 92

Loading ... Loading ...

What was the best MySQL event in 2012?

  • MySQL Conference & Expo (37%, 33 Votes)
  • Percona Live London (30%, 27 Votes)
  • FOSDEM (10%, 9 Votes)
  • Percona Live New York (8%, 7 Votes)
  • MySQL Connect (7%, 6 Votes)
  • Percona Live DC (3%, 3 Votes)
  • MySQL/NoSQL/Cloud Latin America conference (3%, 3 Votes)
  • OSCON (1%, 1 Votes)

Total Voters: 89

Loading ... Loading ...

What would you like to test in 2013? (Two possible answers)

  • Galera Replication (Percona Cluster or MaraDB Cluster) (49%, 60 Votes)
  • MySQL 5.6 (45%, 55 Votes)
  • MariaDB 10 (35%, 43 Votes)
  • Tungsten Replicator (13%, 16 Votes)
  • MySQL 5.5 (Oracle, Percona or MariaDB) (11%, 14 Votes)
  • NoSQL/NewSQL databases (8%, 10 Votes)
  • iPhone 6 (3%, 4 Votes)
  • NDB Cluster (2%, 2 Votes)
  • Other (Leave a comment) (2%, 2 Votes)

Total Voters: 123

Loading ... Loading ...

Have fun in 2013!

Be careful with innodb_io_capacity! (with standard HDDs)

A beautiful picture is sometimes better than words :

With standard HDDs (here in RAID 10), the innodb_io_capacity variable may have non expected effects.

You can see on this picture the result of a test on one of my server with only the replication thread activated. The value of the innodb_io_capacity variable was the single modification during the period.

So, don’t touch this parameter without a strong reason…

[EDIT1 2013-01-08]: I know 30k is a too high value for innodb_io_capacity, I used this value to make the graphe really eloquent.
Read this excellent post from Chris for more details : http://www.chriscalender.com/?p=201

[EDIT2 2014-09-12]: Tuning this variable is of course needful in some cases. Do your own tests

And a happy new year!

I wish you all my best wishes for this new year.
I hope 2013 will be as exciting as 2012 for the MySQL community.

Thank you for spending time on MySQL[Plus] in 2012, I hope to have more and more readers in 2013.

If you would like to read (or read back) my posts published in 2012, here is the summary :

And all the most useful slides of 2012 are also on [Plus] :  http://www.mysqlplus.net/mysql-docs/

Don’t forget to follow me on twitter for the latest news about the MySQL ecosystem :


And if you didn’t discover MyXplain before, please, take a look : http://myxplain.net

Happy new year again on [Plus]