MySQL 5.0 vs MySQL 5.5

  • Default storage engine: MyISAM (5.0) , InnoDB (5.5)
    InnoDB I/O subsystem changes enable more effective use of available I/O capacity.

Some new features added to MySQL 5.5

  • Enterprise Thread Pool
  • Enterprise Audit
  • Pluggable authentication (LDAP, Kerberos, PAM, or Windows login IDs)
  • Improve operation on Solaris
  • Semisynchronous replication
  • New Unicode character sets include: utf16, utf32, and utf8mb4.
  • Partitioning (RANGE COLUMNS partitioning and LIST COLUMNS partitioning)
  • Now can do: delete all rows from one or more partitions of a partitioned table
  • XML – add supported to the statement load_xml_infile
  • IPv6 support
Advertisements

TPC-W Benchmark (Web Commerce)

TPC-W is a transactional web e-Commerce benchmark, it specifies an e-Commerce workload that simulates the activities of a retail website which produces heavy load on the backend database.

The last version of TPC-W is Version 1.8.

Download: http://www.tpc.org/tpcw/spec/tpcw_V1.8.pdf

The TPC-W Version 2 is now available for public review.

Download: http://www.tpc.org/tpcw/spec/TPCWV2.pdf

Details at: http://www.tpc.org/tpcw

Implementation of a J2EE implementation of the TPC-W Benchmark.

(JBoss 3.2.x, EJB 2.0, MySQL 4.1.x, )

 

 

Quick Guide for upgrade MySQL 5.0 to 5.5 in CentOS 5.x/CentOS 6.x

Quick Guide for upgrade MySQL 5.0 to 5.5 in CentOS 5.x/CentOS 5.6

  1. Install the MySQL 5.1 (just for migration), you can’t update directly from 5.0.x to 5.5, install the MySQL 5.5;
  2. Backup/Execute sql_dump the MySQL 5.0 databases;
  3. Stop the MySQL 5.0 databases;
  4. Upgrading MySQL 5.0 databases to MySQL 5.1 databases; (dump and restore upgrade ou in-place upgrade)
  5. Start the MySQL 5.1 databases;
  6. Execute the MySQL migration tool (mysql_upgrade) in MySQL 5.1 databases;
  7. Backup/Execute sql_dump the MySQL 5.1 databases;
  8. Stop the MySQL 5.1 databases;
  9. Upgrading MySQL 5.1 databases to MySQL 5.5 databases; (dump and restore upgrade ou in-place upgrade)
  10. Execute the MySQL migration tool (mysql_upgrade) in MySQL 5.1 databases;
  11. Remove the MySQL 5.1;
  12. Start the MySQL 5.5 databases.

Note:
MySQL 5.1 should not be used in production environments.

Red Hat Enterprise Linux 5.9 is released

Redhat 5.9 is released at 07-Jan-2013.  (version with java 1.7 supported)

Some new features:
Kernel: system call events have been added: sys_enter, sys_exit
Red Hat Enterprise Linux 5.9 adds hardware checksum support for UDP running over IPv6.
The file: /proc/<pid>/limits file (is writable).

New Packages

RHEA-2013:0011 — new packages: php53-odbc64
RHEA-2013:0035 — new packages: libitm
RHEA-2013:0049 — new packages: scl-utils
RHEA-2013:0074 — new packages: ant17
RHEA-2013:0084 — new packages: java-1.7.0-openjdk
RHEA-2013:0088 — new packages: rsyslog5
RHEA-2013:0089 — new packages: java-1.7.0-ibm
RHEA-2013:0090 — new packages: java-1.7.0-oracle
RHEA-2013:0111 — new packages: hypervkvpd

redhat
redhat