As you might know ANALYZE TABLE just quickly updates table statistics using index dives, unlike with MyISAM when it scans indexes holding table lock for long period of time.

So ANALYZE TABLE should be very fast and non intrusive operation doing just little update on the data. Right ?

Wrong! There is the bug or rather MySQL Design Feature which causes ANALYZE TABLE to block all accesses to this table while it could be flushed from the table cache.

What does this mean in practice ? If you have some long running query accessing Innodb table and you run ANALYZE TABLE you will be unable to access that table with "Waiting for table" lock until the first query completes.

For applications which run short transactions it may not be the big deal but if you mix long reporting …

August was a great month for MySQL Certifications. There are now fourteen new Developers, Thirty-four new Database Administrators, three Cluster DBAs, and a dozen new Associates! This was our best single month without a MySQL Users Conference.

So what about the rest of you without your MySQL Certifications? Try the sample questions for the Associate, Developer, DBA or Cluster DBA for free. Maybe you are closer than you realize.

Lenz just posted pointers to a great presentation of his about MySQL HA and Drupal,

Seems like a small part of me did go to Szeged afterall :)

I have been hearing about the Memcached UDF for MySQL for a while now, so I decided to spend some time playing with them. Being the geek I am, playing for me is to get my hands dirty with the code so I cloned the source repository from: http://hg.tangent.org/memcached_functions_mysql/.

With the source code and a cup of coffee available I ran:

trond@opensolaris:compile> ./config/bootstrap
trond@opensolaris:compile> ./configure CC=cc --with-myslq=/usr/mysql/bin/mysql_config
[... cut ...]
checking for DEPS... configure: error: Package requirements (libmemcached >= 0.17) were not met:
[... cut ...]
    

I know that there is a version of libmemcached in OpenSolaris (I was involved during the integration), so the version is either too old or configure isn't …

Lenz just posted pointers to a great presentation of his about MySQL HA and Drupal,

Seems like a small part of me did go to Szeged afterall :)

I finally got around to reading this update from Red Hat about Spacewalk, the open source version of Red Hat Network Satellite, launched in June.

Other than the progress in attracting participants and patches, the interesting news is that PostgreSQL support is being added after being demanded by the community. The roadmap confirms that work on support for PostgreSQL is scheduled to begin in mid-October.

The Path to PostgreSQL page, meanwhile, indicates that the idea will enable Red …

UPDATE Log4LUA 0.2 released. Go to the project page.

After the dust about backend connection handling in MySQL Proxy had settled, I begun working on other parts of HSCALE again. (I’ll return to the backend handling later after talking to Jan Kneschke about their plans.)

One of the issues that bothered me the most was logging. Until now I just had used a simple debug function that could be enabled or disabled using an environment variable. The pretty straightforward approach a lot of people use. But there is more to logging than to print debug messages. So I searched the web and of course I found …

Features:
* CPU optimisations in both MONyog (server) process (in particular when ‘Monitors/Advisors’ page was being viewed) and browser processes (viewing Dashboard could cause high CPU usage in Firefox browser in particular).

Bug fix:
* Fixed a dependency with the SSH library that could cause failure to install in Win2K. This was an issue with the updated SSH library introduced with version 2.5.

Miscellaneous:
* The RPM installer scripts for Linux were updated in various ways. This solves issues on specific distributions including: 1) uninstall with the SuSE/YaST ’software management’ GUI was not possisble. 2) It was not always possible to install on top of a running MONyog service - sometimes it was necessary to stop service manually before upgrading. Also note: when updating from trial to single/multi server or from single server to multi server it …

Part 1 covered Network Edition backup features, today’s snips apply to all editions.

First among the lesser known additions: We recently provided the possibility for a nice performance boost to some environments by adding the ability to turn on batched indexing in ZCS 5.0.3 (you can even fine tune it at the localconfig, COS, and account level). We’re not talking about when you re-index an entire account here, this is a change to the index-as-received model; now new items can sit in a ‘queue’ (really a ‘indexing deferred’ flag on the mail_items table of the pertaining mboxgroup database in MySQL) to run all at once when it reaches the zimbraBatchedIndexingSize threshold, saving you from all the tiny disk thrashing. It might not be …

Watch for Zend, MySQL, Asterisk, PHP and Apache conferences coming to a city near you! READ MORE