Friday, April 24, 2009

Mastering the Art of Indexing - slides available

At the MySQL Conference & Expo 2009, I did a presentation "Mastering the Art of Indexing" , and now you can get the slides from MySQL Conference site .
I was excited that so many people attended to my session. I hope the session will help you to improve indexing techniques. Feedbacks are welcome.

I was asked from some people at the conference where my blog is. I am mostly publishing MySQL technical information in Japanese, but now I believe it's a good time to start publishing in English. I plan to post mainly benchmarking & performance analysis, high availability solutions, internationalization (which sometimes people have problems), etc.

98 comments:

Baron said...

Thanks. I missed your presentation. I did not know about the I/O scheduler queue size. Very useful.

Baron

peter-zaitsev said...

Yoshinori,

Very nice prepared slides. Good work. Regarding queue size Baron mentions I'm very surprised by results - the drive itself normally can't have TCQ more than few commands (and not everyone can support it) - could something else be effect here ?

Yoshinori Matsunobu said...

Hi Peter,

My understanding is as follows.

I/O requests are handled by the following order:
syscalls(write/pwrite)
-> I/O scheduler
-> Device Driver/Disks(Command Queuing)

I/O scheduler sorts incoming i/o requests by logical block addresses,
then sending them to a device driver.
I/O scheduler does not depend on storage devices so
is helpful for some parts (i.e. minimizing disk seek overheads),
not helpful for other parts (i.e. minimizing disk rotation overheads)

TCQ(and NCQ) can handle very limited number (normally 32-64) of i/o requests
but highly optimized for storage devices.
TCQ can minimize not only disk seeks but also disk rotation overhead.


Based on the above, sorting almost all requests on I/O sheculer then
sending them to TCQ would be nice.

Suppose 100,000 random read i/o requests come.
When i/o scheduler queue size is 128 (default in many cases),
TCQ gets i/o requests by almost random order,
so pretty high disk seek overhead happens
for each (handling 32-64 i/o requests) action.

When i/o scheduler queue size is 100,000,
TCQ gets all i/o requests by sorted order, so
seek overhead can be much smaller.


This explains my benchmarking results.

I/O scheduler queue size settings would not be helpful for InnoDB because
InnoDB internally does sorts i/o requests by storage order.
MyISAM does nothing (highly depending on OS) so this helps.

jametong said...

Excellent posts.

android tablet said...

Good post. Very impressive. Thanks for sharing.

hermes birkin said...

Thank you for another essential article. Where else could anyone get that kind of information in such a complete way of writing? I have a presentation incoming week, and I am on the lookout for such information.
Hermes replica
hermes birkin replica

rs gold said...

YES! I finally found this web page! I’ve been looking just for this article for so long!!

RS Gold
Sell MapleStory Mesos

Troy Polamalu Jersey said...

we are a nfl jersey wholesaler, if you want to order nfl jersey please take look at Pittsburgh Steelers jersey

Sophia White said...

It’s a pleasure to visit this blog because it has a detailed structure.
Business IT Support London

DEWHURST TOULSON said...

That is why we have managed to create a custom writing service to help high-reaching students.
dissertation-topics-examples.info

Emily said...

Achte darauf,diablo 3 gold Juwelenschleifer eine sehr einfache tägliche Quest, die sie belohnt mit einem Token. Sie können dieses Token an einen Dragon's Eye zu erwerben. Es kann über das Auktionshaus für 100 Gold verkauft werden. Wenn Sie diese Quest jeden Tag tun, können Sie 3000 Gold pro Monat leicht. Zunächst müssen Sie Ihre Ausgaben zu minimieren. Die ungewöhnliche Qualität Juwelenschleifen Rezepte diablo 3 gold weg machen kann Juwelenschleifen viel einfacher zu Stufe nach oben. Drittens verkaufen nicht Ihre tägliche Dalaran Juweliersymbolen Marken sofort. Und in diesem Artikel werde ich Ihnen hauptsächlich erzählen,was Schnitte werden auf dem Handel Kanäle auf Ihrem Server angefordert. Wenn es mehrere Spieler das gleiche Interesse an Schnitten häufig dann zu kaufen, schneiden Rezept, weil es bedeutet normalerweise, dass das diablo 3 gold guide Angebot deutlich geringer als die Nachfrage ist.

niki 3254 said...

I just can’t stop reading this. Its so fresh, so filled with updates that I just didn’t know. I am delighted to see that people are in fact writing about this subject in such a elegant way, presenting us all diverse parts to it.Manchester meet and greet You’re a fine blogger. Please carry on with it. This post is really the sweetest on this notable topic. I harmonize with your conclusions and will thirstily look forward to your incoming updates. Saying thanks will not just be sufficient, for the phenomenal clarity in your writing. birmingham meet and greetI will directly grab your rss feed to stay informed of any updates. Admirable work and much success in your business dealings!? Please excuse my poor English as it is not my first tongue.I can’t wait to read what’s after that.Thanks so much for this! I have not been this thrilled by a blog post for quite some time! You’ve got it, gatwick meet and greetwhatever that means in blogging. Anyway, You’re definitely someone that has something to say that people should hear. Keep up the wonderful job. Keep on inspiring the people!very useful info for me.Because i'm new in blogging and i'm need good tutorial like your post. Nice to visit here, and don't forget to visit our blog to and give me more spirit to continue my blogging activities.

GuildWars2Items said...

When you're down, and the world seems dark and empty, your forever friend lifts you up in spirits and makes that dark and empty world suddenly seem bright and full Diablo iii Gold Sale, this is Forever Friendship Diablo III Gold, someone who convinces you that there really is an unlocked door just waiting for you to open it Diablo 3 Gold.

GuildWars2Items said...

At twenty years of age, the will reigns; at thirty, the wit; and at forty, the judgment c9 gold, Fear not that the life shall come to an end, but rather fear that it shall never have a beginning c9 online 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 buy c9 gold.

buyGuildwars2gold said...

And if you find such a friend, you feel happy and complete, because you need not worry Cheap Diablo iii Gold, Diablo iii Gold Sale your forever friend holds your hand and tells you that everything is going to be okay Diablo 3 Gold.

buyGuildwars2gold said...

Life is too short to wake up in the morning with regrets. So, love the people who treat you right and forget about the ones who do not buy c9 gold, Life is like a hot bath. It feels good while you're in it, but the longer you stay in, the more wrinkled you get cheap c9 gold, what gets us into trouble is not what we don't know.It's what we know for sure that just ain't so c9 money.

Jojo said...

Therefore, he thought wow gold that it should be established an effective mode of transport

wuyu said...

Since the company insists, however, that the patch is not yet cheap gw2 gold in its final version so it may be subject to change once it is officially released. In addition, Blizzard players asked to enter these days in the test servers to report any problems they buy guild wars 2 gold find to proceed to settlement.

sse said...

I enjoyed your entries on Toxic Words - such great thoughts and a wonderful reminder to watch the words I use - to be positive and kind and use words to build up rather than tear down. :) apa research paper

sse said...

Some have also these types of best topics. I enjoy seeing websites that understand the value of providing a prime resource for free. I truly loved reading your post. British Ceramic Tile

Sophie Isabel said...

nice profile Yoshinori Matsunobu, I can see you've got awesome writing skills_ thanks for sharing nice information!

web marketing company

jimmy wilson said...

Superb post I like the post; appreciate the method that you explained all things, you do an incredible job many of others that you as a result of of which style of useful sites produce consciousness for you to all of us associated with a lot of things. My spouse and i study some other fascinating weblogs from the web sites and also I will be a great deal serious with all your blogs skills, I likewise began to write article and also this variety talk really assist me available. We previously added your current page along with discussed your web sites to the fellow workers besides me personally although every one of them such as the blogging and site-building abilities, trust you produce much more useful sites similar to this a single in addition to good luck for your future websites.
Jimmy Wilson-Captain America Leather Jacket from Movie

sse said...

Keep up the great function! Awe inspiring online journal. I got a charge out of perusing This is sincerely an incredible read for me. I have bookmarked it background apps closing

AnonymousJeffers said...

Fascinating post. Something of which most people visiting this page will agree with.    Web Design Blackpool

AnonymousJeffers said...

You seemed to have gained a great response from this page. Keep it up!  Web Design Preston

AnonymousJeffers said...

Came across the page by chance, but glad I did now; very good post. Good stuff. Web Design Manchester

romesh seo said...

Simply wish to say your article is as astonishing. The clarity in your post is simply great and i could assume you are an expert on this subject. Well with your permission let me to grab your RSS feed to keep updated with forthcoming post. Thanks a million and please keep up the gratifying work.

Plastic Flow Meter

romesh seo said...

I am glad after reading that post. I was searching that topic from few days its increase my knowledge.
Plastic Butterfly Valves

john nicke said...

Article is very interesting,thanks for your sharing.I will visit this site.welcome to my site
PVC valves

mike Sales said...

An interesting post. I think your comments are expressive as well as founded. Think most people agreed on this thread.
Truflo water meter

sopiha lane said...

Great blog! I really love how it is easy on my eyes and the information are well written. I am wondering how I might be notified whenever a new post has been made. I have subscribed to your rss feed which really should do the trick! Have a nice day!

Running Shirts

mike Sales said...

Thanks for taking the time to discuss this, I feel strongly about it and love learning more on this topic. If possible, as you gain expertise, would you mind updating your blog with more information?
Hayward Plastic y-Strainers

shan said...

A very useful site. The way you have share this information is really very appreciative. Hope to see more on this topic here. Thanks for posting this information here.

Prescott AZ Real Estate

jenny maria said...

Thanks for sharing this information. Reading any event in live is really excited I am personally enjoy to read this keep doing more posting.
Office Supplies Stores

ricky james said...

Thanks for sharing this information. Reading any event in live is really.Great job!!!

Captain America Leather Jacket

AnonymousJeffers said...

Whether it be articles, designs or reports, your comments always give the guys in the office a good platform to discuss from.   SEO Preston

AnonymousJeffers said...

Great piece. The foundations for anything starts with hard work and determination. Keep it up.  SEO Blackpool

AnonymousJeffers said...

If you are looking to promote this piece then we specialise in helping small businesses get found online. Feel free to introduce yourself. SEO Manchester

habshi75 said...

Strive not to be a success, but rather to be of value.
short term apartment rental

shamoon bahader said...

I waѕ almost moved to start my own blοg (well, almοst. ..ΗaHа!) Wοnderful јοb. I reаlly enjoyed what you had to say, аnd moгe than that, how you presented it https://www.musicmindgames.com/puppyplus#comment-3780

shamoon bahader said...

i was very encouraged to find this site. I wanted to thank you for this special read. I definitely savored every little bit of it and I have you bookmarked to check out rc shop

paul leon said...

Thank you for this post. Thats all I are able to say. You most absolutely have built this blog website into something speciel. You clearly know what you are working on, youve insured so many corners.thanks
Android Rooting

jenny maria said...

Thank you very much for posting and sharing this great article. It is so interesting. I want to know some other information about this site. So please give me this news quickly. I always will be aware of you.
Reliable Office Supplies

AnonymousJeffers said...

Love the feel of the site, fascinated more by the content within it. Keep it up. SEO Bolton

AnonymousJeffers said...

The site has excellent content, if you feel promoting the site would help, feel free to contact us.   SEO Lancashire

mike Sales said...

I am really excited about the trailer which is going to get released in the coming month. I am sure that the visual effects works are going to get you a lot of fans. Thanks for sharing the updated, links and information. Keep posting.
Truflo flow meters

sadia sulaman said...

Excellent read, Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style.gavinmatthews |

fineartsprints |

theww |

euronovosti |

kuldeepbrar |

fazackarley |

voiceq |

pipelinemats |

journalistsforum |

claims-id |

mike Sales said...

A great website with interesting and unique material what else would you need. Thanks for sharing with us.
Levelpro liquid level sensors

mike Sales said...

Great post today. An interesting read for any person who would agree with your views. Long may these posts continue.
Truflo plastic flow meter

habshi75 said...

For the past 33 years, I have looked in the mirror every morning and asked myself: 'If today were the last day of my life, would I want to do what I am about to do today?' And whenever the answer has been 'No' for too many days in a row, I know I need to change something.
host grátis para jogo samp

shamoon bahader said...

World Class Learners by Yong Zhao takes a different perspective about standardized tests and international comparisons. Instead of simply questioning the validity of high stakes testing, he actually provides data that suggests these practices could actually harm creativity and innovation. Dr. Zhao also shares ideas for helping teachers and students become more engaged in important work.
cursos online

Billy William said...

Looking for a name other than junior? Browse over 1,000 baby boy names, including the most popular names, unique names, twin boy names and traditional names.
http://www.momswhothink.com/baby-names/baby-names.html

mike Sales said...

Advantageously, the article is really the best on this notable topic. I harmonize with your conclusions and will thirstily look forward to your approaching updates
levelpro level transmitter

Sohaib said...

http://www.entrec.com/services/picker-services/
ENTREC offers both jack and slide and hydraulic sliding systems equipped with both unified and non-unified jacking pump. ENTREC can provide the jacking systems, equipment, labour and expertise required for the safe and efficient loading, offloading and setting of heavy equipment.

mike Sales said...

Thanks a lot for providing individuals with a spectacular possibility to read critical reviews and posts from this site. Simply wanted to write down a word in order to say thanks.
Pro alert alarm

Billy William said...

I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! http://www.gpees.co.uk/forsaleoffice/teddington/729/

mike Sales said...

I must acknowledge you for the information you have shared. I acquisition this information actual advantageous and it has appreciably saved my time.Thanks a lot.
PVC ball valves

Billy William said...

If you want to get some property for next summer then start deciding this winter so that you may get it in next summer.
http://www.gpees.co.uk/forsaleoffice/hinchley-wood/89/

mike Sales said...

This is a terrific article, and I would like more information if you have any. I am fascinated with this topic and your post has been one of the best I have read.
Paddlewheel Flowmeter

mike Sales said...

I am so much excited after reading your blog. Your blog is very much innovative and much helpful for any industry as well as for person.
Hayward Actuator

mike Sales said...

I'll bookmark your blog and check again here regularly. I am quite certain I will learn a lot of new stuff right here! Best of luck for the next.
hayward Plastic Strainers

mike Sales said...

I am glad to land on your page. I have learned a lot about creativity and art. I am looking forward for more updates
Truflo paddle wheel flow meters

mike Sales said...

Thanks a lot for providing individuals with a spectacular possibility to read critical reviews and posts from this site. Simply wanted to write down a word in order to say thanks.
Pro alert alarm

gippy honey said...

The most important single ingredient in the formula of success is knowing how to get along with people.
Provigil Online

mike Sales said...

Article is very interesting,thanks for your sharing.I will visit this site.welcome to my site
PVC valves

Billy William said...

This is a Fantastic 5 bed detached residence in a popular location of Harborne, comprising - reception hall, through lounge, gymnasium, breakfast room, sitting room, dining kitchen, family bathroom double garage, off road parking and rear garden. the property also...
http://www.dixonsestateagents.co.uk/forsaleoffice/harborne/450/

Billy William said...

Getting best deal depends upon your knowledge, and knowledge about business can make you available low price high profitable rental property.
http://www.dixonsestateagents.co.uk/forsaleoffice/northfield/460/

mike Sales said...

Thanks for sharing such useful information; I will be checking your blog for further updates and information.
Levelpro level sensors

Sohaib said...

In real estate the business is simple for you if you have knowledge of your business.
http://www.dixonsestateagents.co.uk/forsaleoffice/solihull/467/

mike Sales said...

I am really excited about the trailer which is going to get released in the coming month. I am sure that the visual effects works are going to get you a lot of fans. Thanks for sharing the updated, links and information. Keep posting.
Truflo flow meters

mike Sales said...

Thanks you so much for sharing us very new new things we are recommending to visit your blog again and again
levelpro data logger

mike Sales said...

I enjoyed every little bit part of it and I will be waiting for the new updates.Really loved reading your we blog post. The information was very informative and helpful.
Plastic Flow Meter

mike Sales said...

I would like to appreciate your hard work you did write this post, Thanks for sharing this valuable post.
Truflo

mike Sales said...

Very nice post. I just stumbled upon your weblog and wished to say that I have truly enjoyed surfing around your blog posts. After all I’ll be subscribing to your rss feed and I hope you write again soon!
ProAlert

gippy honey said...

Success is not final, failure is not fatal: it is the courage to continue that counts.
Glass Curtains Malaga

johnanson lee said...

An organization makes progress with the help of idea management system. The employees can get more ideas from this to promote their company.
idea management systems

sadia sulaman said...

I have been searching for quite some time for information on this topic and no doubt your website saved my time and I got my desired information. Your post has been very helpful. Thanks.love wallpapers with quotes

sadia sulaman said...

I am actually getting ready to across this information, is very helpful my friend. Also great blog here with all of the valuable information you have. Keep up the good work you are doing here.Fire Door Frames

gippy honey said...

A site in which people may advertise a place of worship, or provide inspiration or seek to encourage the faith of a follower of that religion.
Modafinil Online

mike Sales said...

Thanks for this great post, it seems like more and more people are trying their best so it’s a good article with many links and resources.
Plastic PP Gauge

mike Sales said...

I really enjoyed the quality information you offer to your visitors for this blog. I will bookmark your blog.
PVDF Plastic LED Pressure Gauge

mike Sales said...

I agree with your opinion.your article is excellent. I have been examinating out some of your stories. I look forward your next article. Its a great post.
Plastic LCD Pressure Gauge

mike Sales said...

Good article! I visited many places, but clearly in addition to the author's experience. Reading your article, I learned a lot of knowledge. Thanks for sharing.
PVC Flow Meter

jhoney said...

When virtue and modesty enlighten her charms, the lustre of a beautiful woman is brighter than the stars of heaven, and the influence of her power it is in vain to resist.
Accident Lawyers St. Catharines

jhoney said...

We live in a wonderful world that is full of beauty, charm and adventure. There is no end to the adventures that we can have if only we seek them with our eyes open.
Personal injury lawyers Oshawa

panca-samudera said...


The article posted was very informative and useful
thanks for sharing.
jaring futsal , jaring futsal murah , jual jaring futsal , jaring golf , jual jaring golf , jaring golf murah ,
jaring polynet , tangga darurat , jaring truk , jaring cargo , jaring outbound , jual rumput futsal murah ,
jual rumput sintetis murah , tali tambang , cargo net , jaring tanaman , jaring kassa , jaring proyek , jaring bangunan ,
jaring gedung , jaring pengaman proyek , jaring pengaman bangunan , jaring pengaman gedung , jaring peneduh , jaring waring , kasa hijau , tangga darurat , jaring gawang futsal ,
jual jaring gawang futsal murah , jaring peneduh , jaring truk , tali tambang nylon , jaring safety , safety net , jaring , waring , polynet

justin adams said...

Picked the money you'll need. Many weeks throughout a though, ton this specific equity credit line back. It actually payday loans huntsville is effortlessly! Fluctuated with reference to is that the higher terribly beginning day development having U. S. of America day cash enhancements is plainly thought NO COST!!! That’s adequate.

Minh Vương said...

Công ty vệ sinh 5 Sạch
Dịch vụ giặt thảm tại Hà Nội
Dịch vụ giặt ghế sofa tại Hà Nội
Vệ sinh nhà sau xây dựng

slim said...

Step Up Height Increaser is a 100% Ayurvedic Body Growth System.
Step Up offers Amazing Results! After using StepUp Height Increaser you will see new confidence in yourself.
Step Up Height Increaser is a revolutionary step by step total growth system, It gives the required nutrients to
the body that help to increase height & also lead to total body growth.

Minh Vương said...

dịch vụ lau dọn nhà cửa,vệ sinh văn phòng,vệ sinh nhà cửa,giặt thảm,giặt ghế sofa,lau kính tòa nhà cao tầng ,dịch vụ vệ sinh sau xây dựng

حسام داود said...

levelشركة تسليك مجارى بالرياض
شركة تنظيف بالرياض
شركة تنظيف شقق بالرياض
شركة تنظيف منازل بالرياض
شركة تنظيف خزنات بالرياض
شركة مكافحة حشرات بالرياض
شركة رش مبيدات بالرياض
شركة تخزين اثاث بالرياض
شركة تنظيف مجالس بالرياض
شركة تنظيف فلل بالرياض

Miriam Steve said...
This comment has been removed by the author.
Miriam Steve said...

I was not able to attend but a am very grateful that you decided to post or us to catch up. Thank you very much for taking time to post, it was very interesting to read.
order personal experience essay writing

grezt said...

Obat Herbal Kutil Kemaluan Tapi tetap saja pengobatan ini juga tidak dapat menjanjikan kutil tidak akan datang kembali. untuk cara pemesanana silahkan kunjungi baca disini

grezt said...

Obat Herbal Kutil Kemaluan Tapi tetap saja pengobatan ini juga tidak dapat menjanjikan kutil tidak akan datang kembali. untuk cara pemesanana silahkan kunjungi baca disini

grezt said...

Obat Herbal Kutil Kemaluan Tapi tetap saja pengobatan ini juga tidak dapat menjanjikan kutil tidak akan datang kembali. untuk cara pemesanana silahkan kunjungi baca disini

fikri ilham said...

Jual obat herbal de nature asli untuk berbagai penyakit kelamin dan sebagainya
Obat Wasir Herbal
Obat Wasir Herbal Mujarab
Obat Wasir Herbal Ampuh
Obat Wasir Herbal Pada Pria
Obat Wasir Herbal Di Apotik
Cara Mengobati Wasir Stadium 4
Cara Mengobati Wasir Stadium 4 Tanpa Operasi
Cara Mengatasi Wasir Stadium 4
Cara Penyembuhan Wasir Stadium 4
Cara Mengobati Ambeien Stadium 4 Secara Alami
Cara Pengobatan Wasir Stadium 4
Cara Pengobatan Ambeien Stadium 4
Cara Mengobati Wasir Stadium 3 Dan 4
Cara Mengobati Wasir Stadium 3
Cara Mengobati Wasir Stadium 3 Secara Alami
Obat Wasir Herbal Apotik
Obat Wasir Herbal Untuk Ibu Hamil
Obat Wasir Herbal Terdaftar Bpom
Obat Wasir Herbal Untuk Ibu Menyusui
Obat Wasir Herbal Bandung
Cara Mengobati Wasir Stadium 3 Dan 4
Cara Mengatasi Wasir Stadium 3
Cara Mengobati Ambeien Stadium 3 Tanpa Operasi
Cara Menyembuhkan Wasir Stadium 3
Cara Mengatasi Ambeien Stadium 3
Cara Alami Mengobati Wasir Stadium 3
Cara Mengobati Ambeien Stadium 3 Secara Alami
Obat Wasir Herbal Manjur
Obat Wasir Herbal Semarang
Obat Wasir Herbalife
Obat Wasir Herbal Jogja
Obat Herbal Wasir Berdarah
Obat Herbal Wasir Dalam
Obat Herbal Wasir Akut
Obat Herbal Wasir Stadium 4
Obat Herbal Wasir Terpercaya
Obat Herbal Wasir Stadium 3
Obat Herbal Wasir Internal
Obat Wasir Herbal Alami

lina sexshop said...

Berikut kami akan membahas tentang bagai mana cara memperbesar penis dengan hasil cepat dan aman tanpa operasi
jika anda ingin memperbesar penis dengan hasil cepat,aman tanpa operasi itu mudah anda bisa pilih cara memperbesar penis dengan obat pembesar penis herbal
seperti Pembesar Penis Obat Good Man

jika anda riskan konsumsi obat pembesar penis anda bisa pilih jalan lain seperti metode trapi ( pemakaian luar ) kami juga punya solusinya anda harus punya Alat Pembesar Penis sejenis Pro Extender atau Vimax Extender

Berikut penjelasan kami :

Apa Obat Good Man itu : Obat Good Man
Apa Vimax Extender itu : Vimax Extender Asli
Apa Pro Extender itu : Pro Extender Asli

Sekarang anda bisa tau rahasia cara memperbesar penis dengan aman tanpa operasi.selamat mencoba.

Thank you for the information , I wait for more information and I ask for a return visit our new website
>> Obat Pembesar penis <<

Post a Comment