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

Displaying posts with tag: MySQL 5.5 (reset)

Leveraging the InnoDB Plugin
+3 Vote Up -0Vote Down

Beginning with MySQL 5.1 as an additional plugin and included by default in MySQL 5.5 the InnoDB plugin includes many performance improvements. To leverage the support of new file formats however a very important setting is necessary.

#my.cnf
[mysqld]
innodb_file_per_table

The use of innodb_file_per_table with an existing system or during an upgrade to 5.1 or 5.5 requires a complete reload of your database to use effectively. In summary.

  • Backup all InnoDB tables via mysqldump
  • Drop InnoDB tables
  • Verify InnoDB not used
  • Stop MySQL
  [Read more...]
Interesting MySQL 5.5 upgrade gotcha
+10 Vote Up -1Vote Down

Today I discovered an interesting upgrade problem with a client migrating from MySQL 5.0 to 5.5. The client who is undertaking the upgrade reported that MySQL 5.5 did not support the DECIMAL(18,5) data type. I easily confirmed this not to be the case:

mysql> drop table if exists x;
mysql> create table x (col1 DECIMAL(18,5));
Query OK, 0 rows affected (0.01 sec)

Delving more into the issue in question, I looked at the complete CREATE TABLE statement, recreating the syntax.

mysql> drop table if exists x;
mysql> create table x ( MinValue DECIMAL(18,5));
Query OK, 0 rows affected (0.00 sec)

No problem …

  [Read more...]
New year & new blog
Employee_Team +2 Vote Up -0Vote Down

The new year is here and I have moved my (so far quite silent) blog to use WordPress and MySQL 5.5 GA.

Since I am using Ubuntu I downloaded a compressed tar archive. I installed it in a custom directory and for starting I wrote a little upstart script.

$ cat /etc/init/mysql-5.5.conf
start on startup
stop on shutdown …
  [Read more...]
Oracle TechCast Live: "MySQL 5.5 Does Windows"
Employee_Team +0 Vote Up -0Vote Down

Interested in MySQL on Windows? Join our next Oracle TechCast Live on Tuesday January 11th at 10.00 am PT! MySQL Product Manager Mike Frank will then tell you all about the major MySQL 5.5 performance gains on Windows.

 

In case you're not familiar with the Oracle TechCast Live events, they're akin to online "fireside chats" with experts about new tools, technologies and trends in application development. They …

  [Read more...]
Oracle TechCast Live: "MySQL 5.5 Does Windows"
Employee_Team +3 Vote Up -0Vote Down

Interested in MySQL on Windows? Join our next Oracle TechCast Live on Tuesday January 11th at 10.00 am PT! MySQL Product Manager Mike Frank will then tell you all about the major MySQL 5.5 performance gains on Windows.

 

In case you're not familiar with the Oracle TechCast Live events, they're akin to online "fireside chats" with experts about new tools, technologies and trends in application development. …

  [Read more...]
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...]
10 Newer Entries Showing entries 31 to 40 of 51 10 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.