Introduction to MySQL 5.5
What’s New in MySQL 5.5
It’s been a busy year for MySQL. Perhaps you’ve heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to beta test the 5.5 release and give feedback to the MySQL engineering team.
Improved Performance and Scalability
- InnoDB Becomes Default Storage Engine
- MySQL sometimes gets knocked about features such as as ACID-compliant transactions, foreign key support, and crash recovery. These features are strongest in the InnoDB storage engine, but MyISAM has always been the default, so new users could get the wrong impression. Starting in MySQL 5.5, InnoDB is the default storage engine, so that everyone can see this reliability and stability out of the box. As a bonus, the level of InnoDB in MySQL 5.5 is InnoDB 1.1, a rearchitected InnoDB with many performance and scalability features over and above the built-in InnoDB in 5.1 and before. (Since we are unifying the InnoDB within MySQL using the best and fastest technology, we are phasing out the
Plugin
versusBuilt-In
distinction; MySQL 5.5 comes with the latest and greatest InnoDB 1.1.) Read more about the latest InnoDB enhancements below. - Better Metadata Locking within Transactions
- If a table is referenced within a transaction, no other transaction can perform DDL such as DROP TABLE or ALTER TABLE until the first transaction commits. Previously, the lock was released at the end of a statement rather than the whole transaction. Read more about metadata locking within transactions.
- Improved Performance and Scale on Win32 and Win64
- If your company uses Windows by itself or in a mixed environment, you probably want to deploy MySQL databases on Windows. To make that a reality, the MySQL team has incorporated a number of Windows-specific features for speeding up and scaling up.
- Windows API calls for much of the I/O done inside MySQL (a community contribution, hat tip to Jeremiah Gowdy).
- Ability to build engines and other plugins as DLLs on Windows.
- Network support for auto-detecting the MAC address (a community contribution, hat tip to Chris Runyan).
- Much cleanup and simplifying of threading code.
Improved Availability
- Semi-Synchronous Replication
- This feature improves the reliability of failover, to avoid failing over to a slave that is missing some committed changes from the master. You can choose to have commits on the master node wait until at least one slave has logged the relevant events for the transaction. The
semi-synchronous
aspect is because the master does not wait for all the slaves to acknowledge, and there is a protocol to avoid the master waiting too long if the slaves fall behind. Read more about semisynchronous replication. - Replication Heartbeat
- In replication, the
heartbeat
is a message sent at regular intervals from a master node to the slave nodes. You can configure the heartbeat period. If the message is not received, the slave knows that the master node has failed. You can now avoid the spurious relay log rotation when the master is idle, rely on an more precise failure detection mechanism, and have an accurate estimation for seconds behind master. (This is a different feature thanLinux heartbeat
, which is a similar health-checking system for cluster nodes.) To use this feature, you issue commands like:STOP SLAVE; CHANGE MASTER TO master_heartbeat_period= milliseconds; START SLAVE; SHOW STATUS like 'slave_heartbeat period' SHOW STATUS like 'slave_received_heartbeats'
Improved Usability
- SIGNAL/RESIGNAL
- The SIGNAL and RESIGNAL statements allow you to implement familiar exception-handling logic in your stored procedures, stored functions, triggers, events, and database applications that call those things. SIGNAL passes execution back to an error handler, like THROW or RAISE statements in other languages. You can encode the error number, SQLSTATE value, and a message in a consistent way that can be interpreted by an error handler in the calling program. RESIGNAL lets you propagate the exception after doing some amount of error handling and cleanup yourself. With RESIGNAL, you can pass along the original error information or modify it. Read more about SIGNAL/RESIGNAL.
- More Partitioning Options
- With the new RANGE COLUMNS and LIST COLUMNS clauses of the CREATE TABLE statement, partitioning is now more flexible and also can optimize queries better. Instead of expressions, you specify the names of one or more columns. Both of these clauses let you partition based on DATE, DATETIME, or string values (such as CHAR or VARCHAR). Partition pruning can optimize queries on tables that use RANGE COLUMNS or LIST COLUMMS partitioning, and WHERE conditions that compare different columns and constants, such as
a = 10 AND b > 5
or
a < "2005-11-25" AND b = 10 AND c = 50
• Twitter • StumbleUpon • Digg • Delicious • Facebook
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
Introduction to MySQL 5.5 | Source and Code System…
I like this website it is really informative i will be sure to book mark it and come back to it occassionally…
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
Cheap Yankee Candles…
[...]here are some links to sites that we link to because we think they are worth visiting[...]…
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
Sources…
[...]check below, are some totally unrelated websites to ours, however, they are most trustworthy sources that we use[...]……
Link To Your Site From SWTOR Website Found…
[...]Is thеrе a site which make іt east tо understand blogs аnd podcasts? I wоuldn't present an iPod, dоеѕ that matter?. [...]…
Buy Yankee Candles at Half Off…
[...]the time to read or visit the content or sites we have linked to below the[...]…
affiliate marketing…
[...]here are some links to sites that we link to because we think they are worth visiting[...]…
Sites we Like……
[...] Every once in a while we choose blogs that we read. Listed below are the latest sites that we choose [...]……
adult social network…
[...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…
TV Lamps…
The Truth behind Television Replacement Lamps….
Found=> Recommends Your Page…
[...]very fеw websites which аre detailed below, from your standpoint are undoubtedly really worth checking out[...]…
Great Clips Coupons…
[...]listed below are a handful of urls to sites I always link to seeing that we believe they will be worth visiting[...]…
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Check this out…
[...] that is the end of this article. Here you’ll find some sites that we think you’ll appreciate, just click the links over[...]……
Travail de Yesturdays pour le demain – un regard à quelques exemples…
Noté cet exemple, par l’intermédiaire de arnold McCormick dessus Twitter et trouvé lui pour être extrêmement instructif et trop le point…
Read was interesting, stay in touch……
[...]please visit the sites we follow, including this one, as it represents our picks from the web[...]……
Summer is here ~ come and cool down with our cool news !…
[...]here are some sites that we think it will cool you down[...]…
Looking around…
I like to surf around the internet, often I will go to Digg and read and check stuff out…
Top Blogger Post Here…
This is certainly one of the most choice blog stories I have seen in the past few days….
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
buy damansara house…
[...]you will find information that’s relevant to you if you want to buy damansara house[...]…
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
News info…
I was reading the news and I saw this really interesting information…
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
You should check this out……
[...]always a big fan of linking to bloggers which I love[...]……
Great website…
[...]we like to honor many other internet sites on the web, even if they aren’t linked to us, by linking to them. Under are some webpages worth checking out[...]……
affordable webhosting…
[...]Sharing this information with our webhosting purchasers[...]…
Grandma Always Said…
It was my grandma who always told me that I should visit more blogs like this….
basketball drills…
[...]here are some links to sites that we link to because we think they are worth visiting[...]…
Recommended websites……
[...]as the sites we connect to above are certainly not related to us, however are worth going to[...]……
Informative and precise…
Its difficult to find informative and precise info but here I noted…
Sites we like……
[...]these are generally sites of interest that we have a link to[...]……
outer banks nc rentals…
[...]below you’ll find the link to some sites that we think you should visit[...]…
Latest news from all around the world, you need to see this !…
[...]blow are some sites that we think it will be helpful and fun to read[...]…
Ipad Stylus…
[...]listed below are a handful of references to internet websites I always connect to because we think there’re worthy of checking out[...]…
hotels…
[...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…
Trabalho para o amanhã – um olhar de Yesturdays em alguns exemplos…
Apenas observado este exemplo, através de David halign sobre Facebook e encontrado lhe para ser um tanto informativo e demasiado o ponto…
Tumblr article…
I saw a writer talking about this on Tumblr and it linked to…
New ideas ? Great Ideas ? Best Ideas ?…
[...]below you’ll find the link to some sites that we think you should visit[...]…
Recent Blogroll Additions…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]…
Top Reading of the Day…
The excellent blog post….
Trackback Priority…
I will immediately snatch your rss as I can’t to find your e-mail subscription hyperlink or newsletter service. Do you have any? Please allow me understand so that I may just subscribe. Thanks….
Featured…
…These are some featured websites that we choose to honor with a link back to their site……
Websites worth visiting…
[...]here are some links to sites that we link to because we think they are worth visiting[...]……
I would like to exchange links with your site http://www.sourcencode.com
Is this possible?
it was very interesting to read http://www.sourcencode.com
I want to quote your post in my blog. It can?
And you et an account on Twitter?