My.cnf Configuration Differences in MySQL 5.4 from MySQL 5.1

Configuration Differences in MySQL 5.4 from MySQL 5.1

There are Several variables and options are new or changed in MySQL 5.4 to provide more flexible runtime configuration, and better “out of box” configuration of default values for MySQL operation on up to 16-way x86 servers and 64-way CMT servers with 4GB or more memory.

Note

The changes to InnoDB configuration values may cause issues if you upgrade to MySQL 5.4 from an older version or MySQL, or if you upgrade from MySQL 5.4.0 through 5.4.2 to 5.4.3 or higher. See Section 2.12.1.1, “Upgrading from MySQL 5.1 to 5.4”.

These system variables are new:

More information about the new system variables can be found in the InnoDB Plugin Manual at http://www.innodb.com/products/innodb_plugin/plugin-documentation.

The default or minimum value of these existing system variables has changed:

These system variables have been made dynamic and can be modified at runtime:

This status variable is new:

This server option is new:

  • --super-large-pages: Boolean option. Large page support is enhanced for recent SPARC platforms. Standard use of large pages in MySQL attempts to use the largest size supported, up to 4MB. Under Solaris, a “super large pages” feature enables uses of pages up to 256MB. This feature can be enabled or disabled by using the --super-large-pages or --skip-super-large-pages option.

Not the SQL of My Kindergarten Days « So Many Oracle Manuals, So

The acronym SEQUEL was later shortened to SQL because SEQUEL was a trademarked name; this means that the correct pronunciation of SQL is sequel not es-que-el (The 1995 SQL Reunion: People, Projects, and Politics).


So Many Oracle Manuals, So Little Time – http://iggyfernandez.wordpress.com/

MSDN Blog Postings » Blog Archive » Walkthrough setting up SQL

The scripts below and the video capture walkthrough setting up a Microsoft SQL Server Replication Distributor using SQL commands. As discussed in previous posting, the Distributor is a key role in Replication.


MSDN Blog Postings – http://msdnrss.thecoderblogs.com/

GadBall.com – Chicago IT Jobs: Java PL/ SQL Developer in Chicago, IL

We are currently seeking a Java PL/ SQL Developer for our client in the Consulting domain. We value our professionals, providing comprehensive benefits, exciting challenges, and the opportunity for growth. This is a contract position


GadBall.com – Chicago IT Jobs – http://gadballchicago.blogspot.com/

MSDN Blog Postings » Blog Archive » SQL Server Vs. The Database

So a lot of my customers and partners have been asking me about numbers around SQL Server, so I thought of getting this quick blog post up to show you an aggregate view of some of those articles – Thanks to Mark and Sunny for helping me


MSDN Blog Postings – http://msdnrss.thecoderblogs.com/

Detect SQL Injection Attacks – Networking – CNET Australia Forums

This is SQL Injection Attacks. The main trend Firewall currently will not alarm when there is SQL attack because of the SQL Injection is via normal point and hidden and difficult to be detected, seemingly normal website visit.


CNET Australia Forums – http://forums.cnet.com.au/