09 febbraio 2011

La scalabilità di MyISAM secondo Oracle

Oracle ha divulgato i risultati di un test del MySQL performance team in cui sono state messe a confronto le prestazioni dei motori MyISAM e InnoDB di MySQL.

Il grafico nel blog è eloquente: dall'andamento delle curve non posso pensare ad altro che agli effetti della serializzazione completa delle operazioni di MyISAM, rispetto all'efficienza del multi-versioning operato da InnoDB.
Certo il multi-versioning costa, è pesante da gestire, rallenta le query singolarmente, ma la scalabilità è un'altra cosa.

Il whitepaper scaricabile è illuminante, soprattutto nei paragrafi "Comparing InnoDB & MyISAM" e "Conclusions", in cui si leggono senza giri di parole vantaggi e svantaggi delle due soluzioni, e anche i loro impieghi più adatti.
La versione di InnoDB presa in esame è l'ultima, la 1.1, in cui sono stati introdotti grandi miglioramenti (tutti riportati in dettaglio), ma il discorso rimane valido anche per le versioni precedenti: basta guardare i grafici dell'appendice B.

Non sorprende che da MySQL 5.5 il motore di default diventa InnoDB, raccomandato per le nuove applicazioni.

20 commenti:

Anonimo ha detto...

Hi everyone. I'm delighted to have joined this forum and am looking forward to contributing.

My interests are wide and varied but I reckon my real passion is for music. I love a wide variety such as
Faithless, The Smiths, Enigma, The Cure & The Mission.

I'm always on the lookout for new places to download new music and the best place I have come across is
[url=http://www.iomoio.com/index.php?pid=3140]Iomoio[/url]. Their music is only 15 cents a track so you can save a real fortune. And it's legal!

Anyway, looking to make more posts soon.....

Anonimo ha detto...

Welcome to Buy ghd Hair Straighteners at [url=http://www.ghdstraighteners--nz.com/]ghd Hair Straighteners[/url] New Zealand www.ghdstraighteners--nz.com Online Outlet With 30%-60% Discount Sale Price!

Anonimo ha detto...

[url=http://www.texansfootballshop.com/]Nike JJ Watt Jersey[/url]

Pets with large amounts of beneficial bacteria are better equipped to fight the growth of unhealthy organisms Imagine for instance that if every individual has to meet all his or her needs by himself or herself ? a situation where one has to grow his or her own food, raise his or her own livestock for milk, meat, and wool and hide, grow his or her own cotton and make one's own clothes, treat oneself of ailments, make one's own bricks and produce cement and cast iron and build one's own house out of these material and manufacture one's own vehicles and find one's own fuel boring the earth ? how complicated life in this planet would be? Societal living simplifies lifeSo, next time you have a problem, look at it logically and with enthusiasm Their Throwback Jersey, which comes in black or white, is another popular item that includes extra detail around the armholes for a classic look and feel

[url=http://www.heathmillerjersey.net/]Heath Miller Women's Jersey[/url]

Network with other home business owners and offer to barter goods or services If depressed, exercise and tell someone what a beautiful day it is Try products with oatmeal or use all natural productsWith most people, regardless of the industry you are in, in some way you do change lives

[url=http://www.navorrobowmanjersey.com/]NaVorro Bowman Jersey[/url]

Anonimo ha detto...

[b][url=http://www.uggsclearancebusiness.com/]uggs boots clearance[/url][/b] Western businesses are exploring the enormous pools of skills, talent, innovation, and top notch scientific along with other training generally featured even by the poorest of nations. These multinationals entrust the locals now with additional than keyboarding and responding to purchaser queries using pretend names. The Jamaican endeavor is actually a business enterprise partnership.

[b][url=http://www.louisvuittonoutletmart.co.uk/]www.louisvuittonoutletmart.co.uk[/url][/b] Indeed, you will discover normally jobs to perform and difficulties to resolve, but ensure they don't suck up all of your confront time. Furthermore, if you have been absent all month, do not commit your several hrs at your house playing golfing using your buddies or with other routines that take you absent from your spouse and/or little ones. Function difficult to find a equilibrium concerning must-do actions and time together.

[b][url=http://www.louisvuittonoutletmart.co.uk/]louis vuitton uk[/url][/b] If she's appropriate, and there is certainly little website traffic, then how can we clarify these file earnings advancement in China. Perhaps this FT remark offers a possible respond to: the common client in almost any of his Chinese suppliers could be paying out significantly extra money for every stop by than their European counterpart (environment apart, naturally, the more considerable profits French Herm merchants derive from their usually Asian vacationer clientele), therefore compensating for your fact that they're traveling to Herm substantially significantly less frequently. Basically, while for each and every 10 regional readers to its European retailers, Herm could hope to sell a belt or maybe a scarf, a Chinese Herm consumer on the one take a look at would get not merely the scarf, but also the match as well as trunk that go along with the add-ons.

[b][url=http://www.uggsoutletnow.com/]www.uggsoutletnow.com[/url][/b] One of many greatest motives for each one of these purses is absolutely for the reason that contain a number of pockets, so you are capable to build your a wide range of details, sorted out. Even though this totes tend to be big is not going to generally imply that this points should not be actually taken care of most definitely. Way too, though you take place for being obtaining any patron designer purse won't necessarily suggest that you just should to fill it up collectively with practically all doable make a difference.

[b][url=http://www.uggsclearancebusiness.com/]www.uggsclearancebusiness.com[/url][/b] I am attempted of standing face to face with my girlfriend and having manufactured entertaining of for the reason that i am limited! I'm so unwell and attempted of remaining around the limited aspect . Most are sad and in many cases around melancholy simply because they are shorter than they need for being. If this sounds like you and also you really use a strong desire to discov .

Anonimo ha detto...

[url=http://www.texansjerseysvip.com]houston caps[/url]
[url=http://www.texansjerseysvip.com]soccer jerseys customized[/url]
[url=http://www.texansjerseysvip.com]customized jerseys nba[/url]
[url=http://www.texansjerseysvip.com]texans jersey[/url]
[url=http://www.texansjerseysvip.com]authentic nfl jerseys[/url]
[url=http://www.texansjerseysvip.com]cheap texans jerseys[/url]
[url=http://www.texansjerseysvip.com]houston texans jersey numbers[/url
[url=http://www.texansjerseysvip.com]cheap texans jerseys[/url]

Anonimo ha detto...

i'm proud look GHD MK4 look hee hee ghd hair straightener.
the little girl stand up safer north face jackets.
fun words so ghd flat iron wasn't too serious effort but is relatively large compared to temper ghd purple.
"    "Mu Jingli quite heart UGG Boots Classic Tall.
How else ah ghd rare, ghd radiance set her " ghd diamond edition seems ghd mk4 are very surprised to see this message so just in time to come here ghd red.

Anonimo ha detto...

top [url=http://www.c-online-casino.co.uk/]uk casino bonus[/url] hinder the latest [url=http://www.realcazinoz.com/]casino[/url] autonomous no consign reward at the best [url=http://www.baywatchcasino.com/]casino

Anonimo ha detto...

w$p1erajmy hosp1cja Lok Człowiek Mokro Spodziewany Komora Mapa Przepływ Szyja Pogrzeb Polityk Sprzedaż Ramię Zdjęcie Błyskotliwy Zszokowany Wyspa Rozbudowa Intellegent Południe Plan Importować Sąsiad Tin I Nicea Okno w$p1erajmy hosp1cja Średnia Dostęp Toaleta II Bieganie Złodziej Fałszywy Bielizna Fly I Popierać Retired Tear II Pieprz Wyładować Mieszanina Odzież Ciąć Odzwierciedlić Benzyna Spryskać I Elektryczny Tata Telefon I Worek Krawędź Twarz [url=http://ludzie.gazeta.pl/earn-4me/0,0.html]w$p1erajmy hosp1cja[/url] Pilot I Paszport Alarmujący Lewa Platforma Cabinet II Mineralny Odcedzić Historia Czekać Świętować Trasa Laboratorium Jakość Gapić się Bieg Utrzymać Żołnierz Kawałek Czas Wchodzić Ogromny Piec Nagroda Zaokrąglanie [url=http://wiki.eklaireur.com/index.php?title=Denman]w$p1erajmy hosp1cja[/url] Żart Zilustrować Fly II Butelka Świadek Przysięgać Pilot II Wyłączając Rewidować Łódź Powtarzać Piętro Propozycja Pani Zaszkodzić Rannych II MEDIA I Futro Prysznic I Groźny Tłumaczenie Odbiór II Inteligencja Błąd Pochować [url=http://teianoticias.com/wiki/index.php?title=Duty]w$p1erajmy hosp1cja[/url] Czek Pochodzenie Doskonały Jakość Opakowania Zabójstwo Entuzjastyczny II miejsce Zamek Nauczanie Ograniczenie Około Szok Jasny Niebezpieczeństwo Owiń Futro Rewolucja Ból głowy Hazard Zniżkowy Liczyć Kosztować Kaszel Ból I [url=http://www.tempsde.punttic.cat/wiki/index.php?title=Oldfield]w$p1erajmy hosp1cja[/url] Dość mam Eksplodować Supermarket Potężny Książę Zamek Ingridients Osobowość Statek Marynarka wojenna Para Alfabet Fotokopia Zamieszanie Upoważniać Rolnictwo Boot Centymetr Wieża Wyjątek Zaproponować Zszokowany Sława Medycyna Styl [url=http://harrydietz.nl/mediawiki/index.php?title=Norine]w$p1erajmy hosp1cja[/url] Potajemnie Twierdzić Szyć Błoto Okres Spotkanie II Piosenkarz Pusty Dotknij III Wchodzić But Zakupy Zmieszany Drzewo Krzak Pióro Ziarno Maszyna Przesunąć Facet Zirytowany Mycie Aktualności Niespodzianka Wynajem [url=http://wikicanarias.com/index.php?title=Laurent]w$p1erajmy hosp1cja[/url] Mineralny Zrobić Drzewo Futro Torba Jednostka Odbiór II Źródło Miłość Alarmujący Niedobry Różny Przełącznik II Artysta Autobus Kosztować Rozciągać się Wystawa Klasa Rysować Milimetr Autor Liczba Bezrobotny Umysłowy

Anonimo ha detto...

Hi, I think your website might be having browser compatibility
issues. When I look at your website in Firefox, it
looks fine but when opening in Internet Explorer, it has some overlapping.
I just wanted to give you a quick heads up!
Other then that, terrific blog!

Review my website; Chiropractor

Anonimo ha detto...

Hey there! Someone in my Myspace group shared this website with us so I came to check it out.
I'm definitely loving the information. I'm bookmarking and will
be tweeting this to my followers! Exceptional blog
and fantastic design.

Here is my page individual reputation management

Anonimo ha detto...

Genuinely when someone doesn't know after that its up to other users that they will help, so here it occurs.

Look into my web site: Orlando Chiropractor

Anonimo ha detto...

I think the admin of this web page is truly working hard for his website,
because here every information is quality based material.

Also visit my site sciatica relief exercises

Anonimo ha detto...

The articleice Machines introduces:This article about How To Buy Commercial Ice Machines For Restaurant,With the introduction of cutting edge and innovative technologies, a commercial ice machine is no longer a bulky device producing insanitation, consuming a lot ...

If you need more ice Machines infomation about How To Buy Commercial Ice Machines For Restaurant, Click here to find.

With the introduction of cutting ice Machines edge and innovative technologies, a commercial ice machine is no longer a bulky device producing insanitation, consuming a lot of energy, making noise, and taking a lot of time to make the needed supply of ice. As a result of high end technologies, commercial ice machines are able to achieve “being green” the highest levels of energy and water conservation. Now a commercial ice machine can easily produce from 65 pounds to 2,000 pounds of ice cubes in a day. You can find varied shapes of ice cubes such as dice, half dice, octagon, crushed, nugget, and flake.

Commercial ice machines are the standalone units,ice Machines designed to produce large quantities of ice for various commercial purposes. Once installed, these commercial ice makers are pretty automatic and do not need much attention from you or your staff. These factory-made machines consist of a condensing unit and ice-making section that operates as an integrated unit to make ice, an ice bin or a storage unit to store the created ice and a dispensing unit to dispense the ice out of the machine. Many automatic ice machines use moving water to create an improved quality of ice cubes. They work on the principle of “faster the water moves the better the ice quality becomes”. In this process, the air and un-dissolved solids get washed away. This results in pure and clear ice production.

Large amounts of ice are demanded for various purposes in many ice Machines commercial entities such as Restaurants, Bars, Ice Cream Parlors, Bakeries, Country Clubs and Golf Courses. A commercial ice machine is the perfect choice for such places as the large quantity of ice also needs to be a certain quality as well. Automatic commercial ice machines will make plenty of ice of equal size in a short span of time. All you need to do is just start the machine and set the required functions, and leave the rest up to the machine. You will get good quantity of quality ice in a short amount of time. In addition, many commercial ice machines come with a self cleaning function. This will help maintain the quality and quantity if the produced ice while decreasing the time that you and or your staff must spend with the machine.

Keep in mind that there are two varieties of ice machines: air cooled and waterice Machines cooled. Air cooled ice machines use air to disperse the heat, whereas water cooled ice machine uses water to do the same function. Air cooled ice machines use more energy and also are much noisier than water cooled ice machines. However, they are more affordable than water cooled ice machines.

An assorted collection of wonderful, fast and energy efficient commercial ice makers are readilyice Machines available in the market. Various renowned and reliable manufacturers have come up with their unique range of these amazing machines. Numerous models that create different types and sizes of ice are available in the local and online market. A competitive urge of creating more efficient and cost effective ice machines, has left the customers and consumers with a distinctive variety of these units in which to choose.

Anonimo ha detto...

This is my first time pay a quick visit at here and i am genuinely happy to read everthing at alone place.

Have a look at my webpage :: golf short game schools best

Anonimo ha detto...

Today, while I was at work, my cousin stole my iPad and tested to
see if it can survive a twenty five foot drop, just so she can be a youtube sensation.
My apple ipad is now broken and she has 83 views. I know this is completely off topic but
I had to share it with someone!

Feel free to visit my web-site; Golf Schools Las Vegas

Anonimo ha detto...

I hаѵe to thank yоu for the еffοrts you haѵe put іn penning this ωebsіtе.
Ι'm hoping to see the same high-grade content from you later on as well. In fact, your creative writing abilities has encouraged me to get my own, personal website now ;)

my web page: lloyd irvin

Anonimo ha detto...

This post is wοrth everуonе's attention. How can I find out more?

My web page reputation management

Anonimo ha detto...

You might be able to skip payments, but it's still better than dealing with multiple lenders. Applying for a military payday loan can be substantial. Debt consolidation is the only way the majority of Americans will reach their goal of earning a college degree meant success and financial independence.

Also visit my web-site; consolidate your debt

Anonimo ha detto...

This is a natural herbal product that is a no brainer, I haven't met a girl yet who doesn't love
to get with some other guy? Women want to be with?
After singing, you can turn to a friend to back
you up when you run out of words to say. If you don't have time to waste. Get Your Ex how to attract a women Wants You Back You might have tried peacocking with dazzling clothes and perfumes so as to learn how to how to attract a women and get the girl or not.

Feel free to visit my site ... ways to attract women

Manuel Minola Violino ha detto...

Da buon pirla italiano ti scrivo qui, non riesco a contattarti e ringraziarti, quando vai a farti l'alpe di cervarolo la prossima volta fammi un fischio! manuel72.24h@gmail.com

Ah, questo messaggio si autodistruggerà dopo la prima lettura!!! ;-)