I don't know why you can't see the InnoDB plugin. I've never seen that happen.
You can also use this method to check what version of InnoDB you have loaded:
mysql> SHOW VARIABLES LIKE 'innodb_version';
If it returns a number, then you're using the InnoDB plugin. If it returns nothing, then you're using the builtin InnoDB (or no InnoDB at all).
I suggest that you upgrade to MySQL 5.5. You don't have to fuss with loading the InnoDB plugin, it's loaded and enabled by default, and the builtin InnoDB is not present. Also, MySQL 5.1 is officially end-of-life, and it's no longer a supported product as of 2013-12-31.
Then, is there any other way through which I can upgrade InnoDB plugin related Dll files?
Virtually everyone does this by upgrading the version of MySQL, for example 5.1.58 (2011-07-05) to 5.1.73 (2013-12-03). As you can imagine, there were a lot of important fixes, including security fixes, in the 29 months between these two versions.
In theory, you could download a Zip file of 5.1.73, unpack it and retrieve the InnoDB plugin DLL, and manually move it into the plugin directory of your installed 5.1.58 instance. You should shut down the MySQL Service before doing this.
The caveat is that you would be enabling a version of the plugin (5.1.73) that was never tested with the older version of MySQL. They aren't supposed to break backward compatibility between point-releases, but internal interfaces aren't as strict about that.
Also, upgrading only the InnoDB plugin would not include any fixes implemented in the rest of the MySQL code outside the storage engine.
PS: For what it's worth, the InnoDB plugin existed in MySQL before the Oracle acquisition of MySQL.
- 2005-10-07: Oracle announces acquisition of Innobase Oy.
- 2008-04-15: First alpha of the InnoDB plugin.
- 2009-09-01: First beta release of the InnoDB plugin in MySQL 5.1.38.
- 2010-01-27: Oracle completes the acquisition of Sun Microsystems.
- 2010-04-06: First GA release of the InnoDB plugin in MySQL 5.1.46.
Round to the beginning of the month:
SELECT trunc(EntryDate,'MM'), COUNT(OrderNo)
FROM Orders
GROUP BY trunc(EntryDate,'MM');
In oracle 8i the results are sorted because of the internal algorithm used by the database to do the 'GROUP BY'. In higher Oracle version beginning with 10g a different algorithm is used and the results will not be sorted. So if you want a sorted result you should tell it the database by querying
SELECT trunc(EntryDate,'MM'), COUNT(OrderNo)
FROM Orders
GROUP BY trunc(EntryDate,'MM')
ORDER by trunc(EntryDate,'MM');
even if the result will be sorted by accident.
To get exactly the output of your query execute the following statement:
SELECT to_char(trunc(EntryDate,'MM'),'MonYY'), COUNT(OrderNo)
FROM Orders
GROUP BY trunc(EntryDate,'MM')
ORDER by trunc(EntryDate,'MM');
Best Answer
Plugins are deployed on the OMS and the agents as well. First you should upgrade the plugin on the OMS, then on the agents.
You don't need to upgrade between versions sequentially, you can upgrade to the highest available.
Yes, there are. Currently 12.1.0.5 is the latest version, and there are quarterly PSUs as well. Check the below MOS note:
Oracle Recommended Patches (PSU) for Enterprise Manager Base Platform (All Releases) (Doc ID 822485.1)
There is no PSU released for 12.1.0.5 yet.