Wednesday, April 13, 2011

Slides: Linux and H/W optimizations for MySQL

On Monday I presented 3-hour tutorial "Linux and H/W optimizations for MySQL" at the MySQL Conference and Expo 2011, and published the slides at SlideShare.

39 comments:

Lachlan Mulcahy said...

Thanks Matsunobu-san -- That was a really valuable talk!

pachanga said...

This is epic! Thank you so much for sharing your knowledge!

BTW, you have slides about developing social games in Japanese, do you happen to have the English version as well? :)

Yoshinori Matsunobu said...

@pachanga

The Japanese slides you mention is probably "Database design practices for Social Games". This was more database design oriented talk rather than focusing on MySQ onlyL. I have not presented in English yet. If there are any good places to present, I'll do it:)

Mark Callaghan said...

Thanks for the amazing slides. They are a great reference and I learned much by reading them. This required a huge amount of work by you.

Jeremy said...

HandlerSocket now this, awesome learning - nice :)

Thanks for your efforts.

dathan said...

Great Slides! BTW what did you use to do benchmarks / profiles of your various iops stats at certain thread levels?

matt harrison said...

Wow, very thorough. Good stuff, even for those of us with a postgres inclination.... :)

Alex said...

thanks a lot =)

Yoshinori Matsunobu said...

@dathan

I used my own simple multi-threaded, O_DIRECT file i/o program. You can do almost same thing with fio (http://freshmeat.net/projects/fio/).

the brinkman said...

Hi Yoshinori, any benchmarks on MySQL Cluster? Particularly Cluster vs regular MySQL (InnoDB/MyISAM)?

Michael Kalas said...

Hi Yoshinori, great set of slides / presentation.

You reference ext* (ext3 and ext2 in particular) up against XFS. With multiple threads writing to the same file (using O_DIRECT to open), can we expect the same -- is ext4 included in "ext*" -- issues, with the numerous allocation changes made in ext4? Is XFS preferred over ext4?

vzctl said...

Have you tried to use hugetlbfs [1]? I't would be nice to see some benchmarks on your environment.

[1] http://dev.mysql.com/doc/refman/5.1/en/large-page-support.html

best web hosting said...

I am worried a lot. I had been missed to attend that tutorial. I saw that slide show. Thanks for sharing.

Sagging skin said...

Your post really grabbed my attention and interest for the reason that the content is not just informative but also simple yet meaningful.

Natural laxative foods Stomach gas Hard stool treatment Health benefits of almonds White spots on skin
Cure ear infection Under eye wrinkles Baby ear infection Prevent prostate cancer Prevent prostate cancer Lemon tea healh benefits Lemon tea healh benefits Prevent candida yeast infection Prevent candida yeast infection Health benefits of papaya Health benefits of papaya Benefits of peppermint oil Benefits of peppermint oil Stop hiccups Stop hiccups Water and weight loss Water and weight loss Wart Removal Wart Removal Health benefits of oatmeal

Sinus headache said...

Your post really grabbed my attention and interest for the reason that the content is not just informative but also simple yet meaningful.

Natural laxative foods Stomach gas Hard stool treatment Health benefits of almonds White spots on skin
Cure ear infection Under eye wrinkles Baby ear infection Prevent prostate cancer Prevent prostate cancer Lemon tea healh benefits Lemon tea healh benefits Prevent candida yeast infection Prevent candida yeast infection Health benefits of papaya Health benefits of papaya Benefits of peppermint oil Benefits of peppermint oil Stop hiccups Stop hiccups Water and weight loss Water and weight loss Wart Removal Wart Removal Health benefits of oatmeal

Raj Satya said...

Thanks for sharing your extensive work on SSD based MySQL scaling.
On Page 78 mentions about storing relay log position in innodb table instead of relay log info text file.
Could you please clarify why relay log status should be stored in innodb table?

aion gold said...

Japan slides that you mention is probably the practices of database design for social games. It was more about the design-oriented databases instead of MySQ onlyL. I still have not submitted in English. If there are good places to submit, I do

I am a video games fan, WOW Items Gold make my account strong!Do you know where to Buy WOW Gold and Buy WOW Items,I know some sites sells Cheap WOW Items,taht sites also provede other game gold like some Cheap Tera Gold, you an have many choice choose a good place to Buy Tera Gold and WOW Gold !

Runescape Gold said...

YES! I finally found this site! I looked specifically for this article for so long!

Anonymous said...

Women from all over the globe replica watches sale just love to shop for designer items. These include shoes, clothes, accessories, and bags. What is more, these women love to look for HYSEK Watches Sale bargains, where they can buy their favorite designer product for a lesser price. Among all types of Hermes Birkin Python branded items, the most expensive would be designer handbags.

wow gold said...

Just how much has this told her i Buy Tera Goldwould WOW Gold bring forth during the past? Work concerning the item earlier than you purchasing the point. BoEs may well change well inwards evaluate by server that will help you waiter, to’MT striving Crummy Aion Golden adequate how of import a to discover the industry unity’ray working with. Lay out conseverative with RS Gold the help of everyone of the payments. Wearable’metric ton run off and buying a lot of BoEs that were enough products only usually requires nearly a year to trade first earnings. BoEs ar parlous, high up wages pieces, gum olibanum an excellent make a motion can result in briny network,Inexpensive Aion Amber World Of Warcraft Gold only a tight relocation could make you recede riot golden.

Vee Eee Technologies said...

Excellent pieces. Keep posting such kind of information on your blog. I really impressed by your blog.
Vee Eee Technologies

lace wedding gowns said...

Woman’s beauty mermaid wedding dresses with the passing years, so does the vintage wedding dresses. Slipping into a piece of vintage clothing bestow the magic of provenance upon your original attractiveness. Our lace wedding dress collectibles capture this very essence of historical statement by flashing back to the pristine demeanor while infusing some modern interpretation. Then and there, your cherished memory flows out with the singing of Yesterday Once More.

Sell RS GP said...

Thank you for sharing. Glad to see you.It is really a good post.http://myblog-mee-nu.asso-web.com/actualite-32-on-this-day-of-web-as-well-as-whitening-communication.html
http://maplestoryyo.bloging.ro/336842/different_companies_provide_a_great_deal_of_company_logo_pack.html
http://runescapeeden.eklablog.com/choosing-a-proper-web-site-design-agency-is-usually-a-difficult-task-a29356112
http://yourlocalblog.com/edengoldyon88/38104/+If+you+would+like+your+organization+have+great+results.html
http://wowrsgold.podbean.com/2012/01/03/you-happen-to-be-endowed-sufficient-to-run-your-company-and-you-also-wish/
http://edengoldyon88.allmyblog.com/17-you-might-be-fortunate-sufficient-to-own-your-organization.html
http://wowgoldb2c445.posterous.com/ever-see-desires-a-prosperous-internet-site-t

Buy Runescape Gold said...

I really like your blog it's really nice. I really enjoy here. & Your article its so unique its amazing. Thanks a lot for sharing. Keep blogging.
http://wowuna.allmyblog.com/2-fashion-conscious-men-and-women-want-to-look-stylish-and-be-comfortable.html
http://wowouna.blogspot.com/2012/01/best-way-to-always-be-in-fashion-is-to.html
http://blogya.de/wowuna/534340/Clothes+play+a+basic+role+to+make+somebody+elegant+and+attractive.html
http://unarsgold.blog.fc2blog.net/blog-entry-4.html
http://maplestoryuna.eklablog.com/drawing-clothes-on-a-fashion-figure-is-absolutely-essential-a30682886
http://maplestoryuna.eblog.cz/use-an-oval-for-the-head-and-rectangle-for-the-torso

Lakeview Boot Camp said...

Its great and very effective and knowledgeable post to me. Thanks.

doberman puppies for sale in georgia said...

I really like your post.It’s really informative and interesting.I really appreciate that.

cheap cambridge satchel said...

This season Cambridge Satchel Bag must remind your shopping desire, so how to choose? Now he brought everyone to see the red carpet fashion show and the wonderful deduce.


There are some beautiful single product accessories, in all you need is Cambridge Satchel, embroidery, and offer flowers, etc, are not miss the details. Highlight a primitive and natural flavour, it is suitable for female people wear the fashion wind.

free sex said...

An estimated five hundred million units are sold in this state each year, which require initial deposits that increase the state’s income by two million dollars, according to the study’s findings.

GuildWars2Items said...

I love you not for the things you would bring to me but to accept everything you could bring [url=http://www.gameim.com]Diablo 3 Gold[/url], The true love is not for showing, but I am sure that even if all other people abandon me [url=http://www.d3-gold.org]D3 Gold[/url], you will still be my side [url=http://www.d3-gold.org]Buy D3 Gold[/url].

GuildWars2Items said...

Being happy doesn't mean that everything is perfect. It means that you've decided to look beyond the imperfections guild wars 2 gold,
Do not pray for tasks equal to your powers.Pray for powers equal to your tasks.Then the doing of work shall be no miracle, but you shall be the miracle guild wars 2 gold, fear not that the life shall come to an end, but rather fear that it shall never have a beginning guild wars 2 gold.

GuildWars2Items said...

Would you write to please D3 Gold just yourself? Or others? Or yourself by writing for others Cheap D3 Gold? It takes strength to do what must be done when the work is unpleasant and uncomfortable D3 Gold Sale, And of what would you write: Of love? Hate? Fun? Misery? Life? Death?Nothing Everything?

GuildWars2Items said...

The ordinary bat that flies around at night, who is a remarkable nim in the air, cannot take off from a level place aion gold, if it is placed on the floor or flat ground, all it can do is to shuffle about helplessly and aion gold, no doubt, painfully, until it reaches some slight elevation from which it can throw itself into the air. Then, at once, it takes off like a flash aion gold.

GuildWars2Items said...

It takes strength to be truthful when a lie would be more convenient D3 Gold, it takes strength to be polite to someone when that person has been rude to you Buy D3 Gold, it takes strength to persist in the face of obstacles, when it would be much easier to simply give up Cheap D3 Gold.

GuildWars2Items said...

No matter the ending is perfect or not, you cannot disappear from my world [url=http://www.goldd3.com]Cheap D3 Gold[/url], sometimes, people cry not because they're weak. It's because they have been strong for too long [url=http://www.goldd3.com]D3 Gold Sale[/url], listen quietly, to the sound of your heart. Cheerful melodies may rise. Some simple, some profound, some gentle, some loud [url=http://www.diabloiiigoldbuy.com]Diablo iii Gold[/url].

Sell Breitling Watch said...

It was really a nice trick it has increased my knowledge things you have to sharing with us.

regards
Breitling Watches

de wo said...

There is also fifty to one hundred percent of chance to receive cheap rs gold an additional five points of rage. In cheetah form, you could have fifty to one hundred percent of chance to re-obtain an additional combo point after increased that of skills to cause a deadly blow runescape money

Cahaya Mandiri said...

Great Post. I have not been visiting the site recently. Took a visit again and there were some great comments on the site. Excellent post. Keep up the good work.
tips cara agar cepat hamil l CARA BELAJAR BAHASA INGGRIS l the best acne treatment l how to lose weight fast easy
margahayuland l BISNIS ONLINE l tips cepat hamil l how to get rid of acne home remedies l
home remedies for acne l how to cure acne fast l
baju batik modern l toko sepatu online l grosir jam tangan online l
jual jam tangan l toko jam tangan murah peluang usaha online l is acne no more for you l how to get rid of acne naturally
how to clear acne l cure acne naturally
best natural remedies for acne l acne no more l tempat belajar bisnis online
peluang usaha rumahan l cara mendapatkan uang dari internet
makanan sehat agar cepat hamil l penyebab tidak bisa hamil lcara agar cepat hamil


Tim Sentraloker said...

I appreciate you for sharing these records. The knowledge ended up being pretty assist plus rescued loads of my own time. This tends to definitely visiting help me to inside my obligation.

CPNS Sulbar 2013

sadia sulaman said...

I would like to thank you for your nicely written content,its useful and your writing style helped me to read it without any difficulty.Your blogs and information attracts me to come back again n again.manorfarmbarns.co.uk |

thinkaboutthings.co.uk |

mouldingdies.co.uk |

loungepillow.co.uk |

carschools.co.uk |

townbakery.co.uk |

thegreendivision.co.uk |

haflingersgb.co.uk |

netrevelation.co.uk |

ataleof2oceans.co.uk |

Post a Comment