Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 46 6 Older Entries

Displaying posts with tag: MySQL 5.5 (reset)

A step by step guide to upgrading to MySQL 5.5
+3 Vote Up -1Vote Down

MySQL 5.5 has created a lot of hype and its not just hype, there are major performance enhancements not only in the MySQL server itself but in the newer InnoDB plugin shipped with MySQL 5.5. That's exactly the reason why I have myself upgraded to MySQL 5.5 (The server running this blog run MySQL 5.5). Now since I haven't come across a guide to help in upgrading to MySQL 5.5, I thought why not make one myself

Semi-sync replication (5.5)
+5 Vote Up -0Vote Down

A bit unorthodox, I normally just write about MySQL Cluster here, but I just wanted to understand how much latency semi-sync replication adds.

The test was very simple:

  • two mysql servers, interconnected (same switch) on a 1 Gig-E network
  • one table (see below)
  • comparing insert performance (one thread) with 'no replication at all' and 'semi sync replication enabled'.
  • bencher (had to hack it a bit to make it work with vanilla mysql) running one thread, inserting 4B+128B+4B = 136B of data
CREATE TABLE `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`data` …





  [Read more...]
MySQL 5.5 is GA!
Employee_Team +0 Vote Up -0Vote Down

It is my pleasure to announce that MySQL 5.5 is now GA and ready for production deployment.  You can read Oracle's official press release here.

I am excited about 5.5 because of the performance and scalability gains, new replication enhancements and overall …

  [Read more...]
MySQL 5.5 is GA!
Employee_Team +18 Vote Up -0Vote Down

It is my pleasure to announce that MySQL 5.5 is now GA and ready for production deployment.  You can read Oracle's official press release here.

I am excited about 5.5 because of the performance and scalability gains, new replication enhancements and overall …

  [Read more...]
IDC Insight Report: "MySQL Thrives"
Employee_Team +2 Vote Up -2Vote Down

In its "Insight" Research Report from October 2010 "Messages from Oracle OpenWorld 2010: Exadata Exceeds Expectation and MySQL Thrives", IDC Carl W. Olofson notes:

 

"Last but not least, Oracle announced the MySQL 5.5release candidate, which solidifies the commitment the company has made to continuing the development and the independence of MySQL as an open source relational DBMS. This announcement came along with continued assurances that MySQL is and will remain autonomous. Nonetheless, useful MySQL intellectual property may find its way into other Oracle products, and Oracle's database development …

  [Read more...]
Tracking IO with PERFORMANCE_SCHEMA
Employee +6 Vote Up -0Vote Down

Mark Callaghan over at Facebook wrote a note recently about InnoDB disk IO counters in SHOW STATUS, with some extra things that he wanted to track. I posted a quick comment over there, but I thought this deserved it’s own write up.

MySQL 5.5’s PERFORMANCE_SCHEMA has had a fair bit written about it in terms of tracking synchronization point contention (mutexes etc.), but it currently tracks two orders within the wait class - these are …

  [Read more...]
Discover What's New in MySQL 5.5 Replication
Employee_Team +7 Vote Up -0Vote Down

UPDATE: An on-demand replay for the webinar discussed below is available here:
http://mysql.com/news-and-events/on-demand-webinars/display-od-572.html

And there is a new whitepaper for MySQL Replication posted here:
http://mysql.com/why-mysql/white-papers/mysql-wp-replication.php

The recent announcement of the MySQL 5.5 Release Candidate included some pretty staggering increases in performance and scalability. 

Replication is also an area where many enhancements …







  [Read more...]
Found a nasty COALESCE() related bug in 5.5.6-rc
+2 Vote Up -0Vote Down

Seeing as it looks like 5.5 is shortly about to go GA I thought I’d give it a run and see how well it works. The only way really to test it is to give it a bit of load and look for things which break. That I did with the 5.5.6-rc community rpms, compared to the 5.1 advanced rpms I usually run.

My colleagues, Ben and Peter, found a horrible problem which means that I can’t use this even for any real usage on my real servers. See: bug#57095 for all the gory details. Thanks to them both for finding the problem and then digging down and figuring out the real cause. Sometimes …

  [Read more...]
Tracking mutex locks in a process list, MySQL 5.5’s PERFORMANCE_SCHEMA
Employee +11 Vote Up -0Vote Down

Internally MySQL uses various methods to manage (or, block) concurrent access to shared structures within the server - the most common being mutexes (or Mutual Exclusion locks), RW Locks, or Semaphores. Each have slightly different properties on how different threads are allowed to interact when trying to access these synchronization points.

There has been much written on the various hot spots in the server around these locking/blocking constructs …

  [Read more...]
Oracle Announces MySQL 5.5 Release Candidate
Employee_Team +7 Vote Up -0Vote Down

Yesterday, Sept. 19, 2010 at the inaugural MySQL Sunday event at Oracle OpenWorld, we announced the MySQL 5.5 Release Candidate. The MySQL 5.5 release candidate helps improve the performance and scalability of applications across multiple operating environments, including Windows, Linux, and Mac. Enhancements include:

Improved performance and scalability:

  • MySQL Server and InnoDB have been enhanced to provide optimum performance and scalability when running on the latest multi-CPU and multi-core hardware and …
  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 46 6 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.