Thursday, December 16, 2010

Thanks for releasing MySQL 5.5 GA!

  I am excited to see that MySQL 5.5 GA (5.5.8) has been finally released . All of my ex-colleagues at MySQL/Oracle have done amazing jobs. I was also positively surprised that 5.5 was released on schedule:). So far I have felt that Oracle is leading MySQL development and product management very well.
  5.5 has lots of practical features not only for web services providers, but also for enterprise users. Especially I like the following features.

Improved concurrency

  Very often lots of concurrent sessions access to the same table. In such cases, one of MySQL internal global mutexes (LOCK_open) becomes very hot and serious concurrency problems have happened. Increasing table_cache have caused even negative impacts (because MySQL has to do linear search here. See bug#33948 for details). In 5.5, the problem has been fixed. Here is a very simple concurrent PK lookup benchmark result(using mysqlslap). It's good to see that the worst performance line has been significantly improved in 5.5.

  Other global mutexes such as InnoDB kernel mutex are still hot, but overall performance becomes much better.
  It's also great that the limit of 1023 concurrent data-modifying transactions has been raised in 5.5.

4-byte UTF-8

  I'm not sure how many people are aware of this issue, but this is important for users in APAC regions such as China/Japan/Korea. Most of multi-byte characters consume 2 or 3 bytes in UTF-8 per character, but some characters (a few hundred Japanese characters) consume 4 bytes. Prior to MySQL 5.5, 4-byte UTF-8 characters were not supported. If people need to handle these characters, they have to use local character sets such as cp932, gbk5. Now we can use UTF-8 safely (You need to use "utf8mb4" charset).

Audit Plugin Interface

  Lots of users in financial industries have wanted this feature for a long time. They frequently want to audit following information.
- Login/Access Timestamp
- Failed login/access information
- Database username
- Client IP/Hostname or terminal name
- Accessed table/view/other objects name and action
- Full executed query string
- The number of affected/retrieved rows
  MySQL general query log has most of the above information, but it does not have any filtering feature so you have to parse huge general logs, which is not efficient. By writing audit plugins, you can log only specific events.

Semi-Synchronous Replication

  By using Semi-Synchronous replication, the likelihood of the data loss on slaves in case of master crash will be much more reduced. Since this is not fully synchronous approach, you still have risks to lose data in case of crash. But in practice this can be very helpful for less strict users (i.e. web services providers).

"Change buffering" in InnoDB (speeding up DELETEs)

 InnoDB have supported "Insert Buffering" feature for a long time. Insert Buffering can significantly improve insert performance if you have lots of non-unique secondary indexes.
  On the other hand, insert buffering does not have any effect for delete-marking or purging index entries. In general, modifying indexes cause random disk reads when target index leaf blocks are not cached, which significantly slows down response time. That's one of the reasons why bulk deletes(and updates that modifies lots of secondary indexes) were not fast in InnoDB. In 5.5, "Insert Buffering" feature was extended to "Change Buffering", which is effective not only for inserts, but also for deletes. Here is a slide (p.18) from MySQL team that shows the effect of Change Buffering (160x faster response time for bulk deleting 100k rows).

  I am also interested in Performance Schema. I like FILE_SUMMARY_BY_INSTANCE table which enables to fetch per-file disk i/o statistics. If Performance Schema can also be used to fetch per-index statistics (like userstats patch) and can be disabled/enabled dynamically, that would be great.


Baby ear infection said...

I am pretty much pleased with your good work. Toenail fungus infection Raw food diet Common digestive disorders

WOW Gold said...

mutually beneficial for both parties.

Eden Eternal
Eden Eternal Gold
Eden Eternal Review

Marissarachelle said...

Thanks for sharing and letting cheap wow gold aware about this buy wow gold information. This is a great thread, so much ls a good article and love your RS Gold words , so charming and make people learn a lot , thanks !

Cheap Aion Kina said...

On another hand, insert buffering does not have any effect for delete-marking or purging index entries. In general, modifying indexes cause arbitrary disk reads when concentrate on index leaf blocks are not cached.

When we paly the online games, we don't need to think about the other things and even not need to worry about the boring things, we can be relax during playing the game; we can play the online games more easy with much RS Gold, we can get the WOW Gear in different ways, and we can even sold out the WOW Items Gold for the real money !

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

Runescape Gold said...

Popular games above video card have been recently remodeled to any new generation total. These classics have been created as a digital game titles. Best video card games are electronic games adapted effectively. These games are played on game consoles and on individual computers.

rs gold said...

I really wish I hadn't seen this as I really want one now!

rs gold
runescape gold

Anonymous said...

If we have to replica watches for sale burberry specify a meaning of the reproduction

Breitling watches, they are best replicas rolex the exact copies of those genuine Breitling

watches in style, color and material. The divergence depends on the quality of materials. These copied ones are crafted from lower

quality metals or electronic new hermes shoulder bags components. Replica Breitling

watches equal to fake Breitling watches which appears so unlikely that numerous people do not want to purchase them.

Buying WOW Gold said...

To be honest, we are receive you letter for a long time, so we did not know the any information about this letter.

fm transmitter said...

Thanks for always giving us informative articles like this .

Anonymous said...

Go light on the vices, such as carrying on in society. The social ramble ain't restful. cambridge satchel|cambridge satchels|cambridge satchel|cambridge satchels|cambridge satchel companycambridge satchel co|the cambridge satchel company|cambridge satchel bag|cambridge satchel company briefcase bag|the cambridge satchel|cambridge satchel company review|cambridge satchel company 11 satchel|cambridge leather satchel|cambridge satchel company bag|satchel cambridge|cambridge satchel company discount|cambridge satchel bags|cambridge satchel company discount code

ambersbridal said...

Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need, thanks for all the enthusiasm to offer such helpful information here.lace wedding gowns
cheap wedding dresses plus size
wedding dresses 2012
lace wedding dress

ambersbridal said...

A holy church, rings, a bouquet, a 3-floor wedding cake, lace wedding dress
champagne, and the moving promise “ I do”, make up the happiest moment in one’s life. Then it is the wedding.
lace wedding gowns
A gorgeous wedding dress has been inside a girl’s dream since she was five years old. It is widely said that the bride is the most beautiful woman all over the world.
Bridal gowns vary in different parts of the world. For example, cheap wedding dresses plus sizein traditional Chinese culture, the color red is regarded for centuries as the symbol of good luck; while in the Occident, wedding dresses 2012 a full-length white wedding dress is always associated with romance and sanctity. But, with the globalization, wedding dresses tend to be alike in the whole world.

teracheapgold said...

If you have much free WOW gold while you aslo need RUNESCAPE GOLD or Maplestory mesos/ NX, so you can Sell WOW Gold to us , because we have and also need much more wow gold,RUNESCAPE GOLD or swtor creditsat the same time, so we can exchange with each other.

cunnilingus said...

I will bookmark this site and visit again. It is very informative. Thanks for sharing.
cervical mucus
ovulation symptoms

rsgoldorder said...

It is our hornor to have a see at your blog,it really is great. This helped me out a lot. Very well written and easy to follow. Thanks so much for your love to all. I'm a editor of that offers runescape gold for sale, buy runescape money / buy runescape items / runescape power leveling. I hope you also play this.

BERITA said...

Considerably, this post is really the sweetest on this notable topic. It is pleasing to look you express from the heart and your clarity on this significant content can be easily looked. produk kecantikan

GuildWars2Items said...

D3 Gold Sale it takes strength to be polite to someone when that person has been rude to you, D3 Gold it takes strength to persist in the face of obstacles, when it would be much easier to simply give up Buy D3 Gold, It takes strength to do what must be done when the work is unpleasant and uncomfortable.

GuildWars2Items said...

At twenty years of age, the will reigns; at thirty, the wit; and at forty, the judgment gw2 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 gw2 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 gw2 gold.

GuildWars2Items said...

It takes strength to be polite to someone when that person has been rude to you Cheap Diablo 3 Gold, It takes strength to build for the future Diablo 3 Gold Sale, It takes strength to resist temptations and distractions Diablo 3 Gold Sale.

GuildWars2Items said...

You laugh at me for being different, but I laugh at you for being the same Maple Story Mesos, the past is gone and static. Nothing we can do will change it MapleStory Mesos The future is before us and dynamic. Everything we do will affect it Maple Story Mesos.

Maria Arredondo said...

Pray for powers equal to your tasks.Then the doing of work shall be no miracle, but you shall be the miracleRunescape Gold, Fear not that the life shall come to an end, but rather fear that it shall never have a beginning rs gold, At twenty years of age, the will reigns; Runescape Gold at thirty, the wit; and at forty, the judgment. What gets us into trouble is not what we don't know.It's what we know for sure that just ain't so.

Maria Arredondo said...

The bravery of each bull is then rated with care according to the number of times he demonstrates his willingness to charge in spite of the sting of the blade Runescape gp, Henceforth will I recognize that each day I am tested by life in like manner. If I persist, if I continue to try, if I continue to charge forward, I will succeed rs gp, Your future depends on your dreams Runescape2 Gold. So go to sleep. Do not keep anything for a special occasion..

dte said...

The consequences of today are determined by the actions of the past scarlet blade gold. To change your future, alter your decisions today scarlet blade gold, Experience is a hard teacher because she gives the test first, the lesson afterwards scarlet blade gold, but it takes character to keep you there.

buyGuildwars2gold said...

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 rs gold, 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 Runescape Gold, In the Orient young bulls are tested for the fight arena in a certain manner rs gold. Each is brought to the ring and allowed to attack a picador who pricks them with a lance..

adeoe said...

I am excited to see that MySQL 5.5 GA (5.5.8) has been finally released . All of my ex-colleagues at MySQL/Oracle have done amazing jobs. I was also positively surprised that 5.5 was released on schedule:). guild wars 2 gold So far I have felt that Oracle is leading MySQL development and product management very well.
5.5 has lots of practical features not only for web services providers, but gw2 gold also for enterprise users. Especially I like the following features.

dolinna said...

That is really cool. Thanks for finding it. Some really good ideas there, this is going to be a real time sink. I am a china tour lover,You can learn more: China tour operator | China tour packages | China city travel

jimmy wilson said...

Outstanding post I adore your current document; adore and the choice of outlined as much as possible, what you are doing a terrific job the majority of other people as if you by means of which sort of beneficial weblogs provide understanding for you to us all in connection with many things. We go through other sorts of useful websites through your web sites in addition to I'm so much engaged using your blogging and site-building abilities, We likewise began to write write-up this also type discussion genuinely assist everyone out there. I previously bookmarked ones page and shared your internet sites for you to my own co-workers not only me yet these people including your current blogging ability, expect an individual compose a lot more useful weblogs such as this 1 and all the best . for the potential weblogs.
Jimmy Wilson-Marlboro Man Leather Jacket Replica

jimmy wilson said...

Outstanding post I adore ones post love and the choice of identified things, you are carrying out a fantastic work lots of other folks as you as a result of of which kind of educational sites provide recognition to help you linked to lots of things. I examine some other interesting websites from a internet websites along with We are much curious with all your blogging ability, My spouse and i additionally started to produce websites and this also type weblogs genuinely assist me away. My partner and i currently bookmarked ones web site in addition to shared ones internet sites in order to my own co-workers not merely me personally but all of them including your current running a blog ability, hope an individual generate more interesting blogs similar to this one particular along with all the best to your long term sites.

Jimmy Wilson from Mass Effect Cosplay

panca-samudera said...

The article posted was very informative and useful
thanks for sharing.
jaring futsal , jaring futsal murah , jual jaring futsal , toko jaring futsal , agen 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

Nazmul Aoto said...

essay writing services

Pretty much as in typical paper composing, the school exposition must be separated into sections. Each one section can expand a point examined. Economy of words is an alluring quality. The school paper is preferably one written in a centered style, since a meandering style can occupy the peruse.

Paul Smith said...

To tell the truth, I am also excited to see that MySQL 5.5 GA (5.5.8) has been finally released. It's a grandiose news for me. The best paper writing services will be able to provide you with well-written and fully-fledged academic projects.

Packers And Movers Bangalore said...

A good informative post that you have shared and appreciate your work for sharing the information.....!! kindly visit us Packers And Movers Bangalore
Packers And Movers Hampinagar
Packers And Movers JP Nagar
Packers And Movers Doddakallasandra

Ifa Fernandes said...

- Obat Jerawat
- Jual Obat Jerawat

Candy Sim said...

All the best blogs that is very useful for keeping me share the ideas
of the future as well this is really what I was looking for, and I am
very happy to come here. Thank you very much
earn to die
earn to die 2
earn to die 3
Hi! I’ve been reading your blog for a while now and finally got the
earn to die 4
courage to go ahead and give youu a shout out from
earn to die 6
Austin Texas! Just wanted to tell
earn to die 5
Hi! I’ve been reading your blog for a while now and finally got the
happy wheels
strike force heroes
you keep up the fantastic work!my weblog
age of war
earn to die 5
good game empire
tank trouble
tank trouble 2
strike force heroes

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 <<

ICC World Cup 2015 said...

Diwali 2016 Images Download
Rangoli 2016 Images
Rangoli Designs Images 2016

ICC World Cup 2015 said...

Images for Veterans Day 2016
Thank You Veterans Day Images for Facebook
Raees Worldwide Collection

ICC World Cup 2015 said...

Scary Halloween Cliparts
Halloween Quotes for all
Halloween Pumpkin Carving 2016
Pumpkin Carvings Free Printable
Scary Pumpkin Faces Ideas 2016

Liman Kwanlai said...

Bermain SBOBET Online tentunya akan memberikan pengalaman tersendiri untuk pemain judi bola online. Hal ini tidak jauh berbeda saat anda main di maupun .

lina sexshop said...

thanks for the information, I wait for other information , greetings from us Hammer Of Thor Asli

aiya rae said...

This is one of the festival, this day people forget their all tensions and worries these day people get much excited to celebrate it.This festival comes one time in a year so people don’t want to miss to celebrate it holi images free download
holi wishes wallpaper
radha krishna holi images hd
holi ki images
Holi Best Wishes

Hemant Sharma said...

Mother's Day 2017 India

Mothers Day Date 2017

Mothers Day Quotes

Happy Mother’s Day


Mother’s Day Messages

Mothers Day SMS in Hindi

Happy Mothers Day Quotes

Happy Mothers Day Images,Sms,Quotes
Happy Mother"s Day

Cretu Ciprian said...

Very interesting blog. A lot of blogs I see these days don't really provide anything that I'm interested in, but I'm most definately interested in this one. Just thought that I would post and let you know.

Blogger said...

eToro is the #1 forex trading platform for beginning and professional traders.

Jason Borne said...

Avast Support | Avast Help
Norton Support | Norton Help
Gmail Customer Support

john wick said...

Office Setup

Office Com Setup

Printer Tech Support

hp Printer Tech Support

Printer Technical Support number

norton com setup

hhiii said...

JioFi WiFi Router Specifications, Plans and price

Akshay Thakur said...

Take Step Two is the Technology blog where we update the Blogging Solutions, SEO Techniques and Many More Reviews. Moto is Next Step Towards Technology, Blogging, SEO. Take Step Two is the blog which deals with latest technology reviews and other tech related subjects.

Technology Solution or Guoyinet is the blog where you found the all Technology Solution Under one Roof. We update the latest solutions for technonoly and Internet Marketing Solutions. Guoyinet provides Technology stuffs and some creative ideas which works in future..

Technology News Blog is the tech blog. CTTPJ gives you latest technology news and information related upcoming electonics gadgets. Here you also found the breaking news in the Technology World. It also provides the major source regarding the health and fitness..

Tech News Update PdaPhonez, it's another great tech blog based on Internet solutions and Digital Trends. It covers lots of stuffs related with Technology, health, Education, Finance, Business, Auto and many more.. This Technology blog covers most of news related with tech world.

Technology Review Blog , Manyouken blog shares some intresting facts regarding the technology. However it will helps people regarding the tech problems... Manyoken prodives all news regarding the gadgets, tech culture, apps and more things. It's a gadget freak blog..

Tech Lab is the tech Innovative blog with moto of Lab of Tech Innovations. Tech blog provides the reviews regardng the latest released tech gadgets in the Market. 4k-Lab is the place where you found the hot tech news and upcoming trends in the Technology field or more information and reviews in Gadgets.

Neil Jakson said...

nice blog and MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts.

MySQL Cluster Community Edition is available as a separate download. The reason for this change is so that MySQL Cluster can provide more frequent updates and support using the latest sources of MySQL Cluster Carrier Grade Edition.
dissertation Writing Service


Thank you for sharing in this article
I can learn a lot and could also be a reference
I am happy to find your website and can join to comment

information our new website Obat Hammer Of Thor
=> Jual Hammer Of Thor Di Bogor
=> Jual Hammer Of Thor Di Medan
=> Jual Hammer Of Thor Di Semarang
=> Jual Hammer Of Thor Di Bandung
=> Jual Hammer Of Thor Di Bandar Lampung
Obat Good Man | Obat pembesar penis | Vimax Asli | Vimax Extender Asli

Games 2 Girls said...

This is a great article. It gave me a lot of useful information. thank you very much.

Post a Comment