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.

30 comments:

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 info.it 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 http://www.ambersbridal.com/wedding-dresses/lace-wedding-dresses.html
cheap wedding dresses plus size http://www.ambersbridal.com/tag/cheap+wedding+dresses+plus+size
wedding dresses 2012 http://www.ambersbridal.com/wedding-dresses.html
lace wedding dress http://www.ambersbridal.com/wedding-dresses/lace-wedding-dresses.html

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 rsorder.com 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

Post a Comment