[HoneyMonitor is a MySQLTM GUI Tool for WindowsTM Systems. Server Administration, Database and Database Objects Administration, Code Development, Server Monitoring, Performance Monitoring, Performance Auditing. Read more on http://www.honeysoftware.com]
We are pleased to announce the availability of HoneyMonitor Pro and HoneyMonitor Audit Pro!
Press Release available at:
http://www.honeysoftware.com/news/pressreleases/20080714-honeymonitor-performance-tuning.php.
The …
[Read more]On Windows® - but I guess it’s the same on another O.S. that does not support cluster - I noticed the following behavior when trying to execute a CREATE LOGFILE GROUP syntax like this:
CREATE
LOGFILE GROUP `test`
ADD UNDOFILE ‘test’
INITIAL_SIZE = 33M
UNDO_BUFFER_SIZE = 8M
ENGINE = NDBCLUSTER;
In v.5.1.25-rc, v.5.1.24-rc and v.5.1.23-rc, only SQL warnings are shown:
mysql> CREATE
-> LOGFILE GROUP `test`
-> ADD UNDOFILE ‘test’
-> INITIAL_SIZE = 33M
-> UNDO_BUFFER_SIZE = 8M
-> ENGINE = NDBCLUSTER;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> SHOW WARNINGS;
…
Introduction
MySQL® 6.0.5-alpha, the latest version of the 6.x branch of the
Database Server, is available for download from the SUN|MySQL Web
Site.
Metadata (data about the data) are very important, especially for software developers. In this article we will see what’s new in FALCON metadata handling doing some comparison with the old 6.0.4-alpha version.
New tables in the
`information_schema`
database
As you know, the source for metadata is the database
`information_schema`. To start, let’s see which tables related
with FALCON metadata are included in that database:
mysql> SELECT VERSION();
+—————————+
|
VERSION()
|
…
Yesterday, during the talk of Ivan Zoratti, at the meeting with Marten Mickos and the Italian Team of SUN | MySQL in Rome, there was a question about Falcon performance: a guy pointed out that InnoDB is better than Falcon.
Well, this is not really the truth.
How many processors are you using for Falcon benchmarking?
Falcon is designed to make optimal use of modern large-memory multi-CPU/multi-core hardware. So when comparing performance of Falcon and InnoDB, you can’t leave this out of consideration!
Please, see the shoots below:
| … |
