Hi,

Few days back, I had blogged about “Tryst with MySQL“. Today, I shall move ahead and give an insight on database management with MySQL using NetBeans.

Its meant for Windows user only, rest can follow too, though just for the content and may try exploring these steps for their OS as well.

MySQL Tools -

Apart from being a popular open source database. It also has some amazing tools, which have been formed, due to years of users invaluable feedback, on their forums. Here’s what the website describes about MySQL Administrator;

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your …

We've sailed past 200 responses! Thanks to all those community members that have taken the time to survey. That leaves us 800 responses to go. Please spread the word far and wide to make this the most comprehensive MySQL community survey.

I blogged in an earlier post that the survey was going to be offline for system upgrades. At the time of this post, it's up and running.

Have you surveyed?MySQL DBA & Programming Blog by Mark Schoonover

We've sailed past 200 responses! Thanks to all those community members that have taken the time to survey. That leaves us 800 responses to go. Please spread the word far and wide to make this the most comprehensive MySQL community survey.

I blogged in an earlier post that the survey was going to be offline for system upgrades. At the time of this post, it's up and running.

Have you surveyed?MySQL DBA & Programming Blog by Mark Schoonover

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:

Yesterday, at the meeting with Marten Mickos and the Italian Team of SUN | MySQL in Rome, Giuseppe had a talk about the MySQL® Community.

If you are a newbie and you want to learn more about the fabulous MySQL® Community, please check this page the next week for his presentation!

Yo, don’t forget the MySQL® Magazine Survey:

1. proposal: http://www.paragon-cs.com/wordpress/2008/05/26/mysql-survey-online/
2. update: http://www.paragon-cs.com/wordpress/2008/05/28/mysql-survey-update/
3. take it now: …

Great conference yesterday at “La Sapienza” University in Rome with Marten Mickos and the Italian Team of Sun | MySQL.

I’ve just returned in Triest, my hometown, after 8 hours :( train ride.

Slides should be available the next week, here.

Marten, thank you for coming, I hope to see you in Italy once again!

Why? In brief, it is said that mysql is not as stable as postgresql. Postgresql or pgsql focuses on a single database engine as compared to mysql which has a pluggable engine architecture and has multiple engines. Also postgresql is well designed as compared to mysql. psql console is much better than mysql console (you will realize it when you use it). It is supposed to be much more scalable and

Many vendors are going to performance based testing, also known as hands on exams. Most of the criticisms I receive on a regular basis that that all Certification Exams are PICKY or rely too much on the memorization of trivia. 'Besides, a real {DBA|Developer} never uses most of those commands in Real LifeTM!'

Well, your next MySQL Exam just may eschew most of those complaints. Developers could be asked to normalize tables, DBAs could be asked to set up replication, and Cluster DBAs could be asked to set up a full cluster. There are many details to be worked out.

One of these details are tools that do not come with your MySQL Server. I find the MySQL Administrator a very valuable tool for quick, day-to-day DBA tasks. I am probably not alone in using it. But would it be fair to allow it on a hands on exam? How about other tools?

So, if YOU have an opinion, please let me know and help guide the …

In preparation for the book’s launch next month, I’ve created a website for it: High Performance MySQL. You may notice that the URL isn’t the same as the site for the first edition. It proved to be difficult to transfer that domain. If we accomplish it later on, I’ll set up a redirect.

Why an official site? To give you free stuff, of course. Final drafts of the front matter (TOC, preface, foreword), a sample chapter, and the index are there already. When the final quality control is done, I’ll update these. Right now they don’t have professionally drawn figures. That will change soon.

Also, you’ll eventually various things such as errata* and book-related info that I feel belongs there instead of here. You can subscribe to the site’s RSS feed to find out when these planned additions become reality.

* Surely there will be no errata, right? Right? …

I've opened a 'feature request' bug on this at http://bugs.mysql.com/bug.php?id=37107

Many third party tools designed for MySQL are designed such that referential integrity constraints may only be defined on InnoDB tables. Up until recently, this was fine as a hard coded limitation because only InnoDB supported referential integrity. Unfortunately, the reality now is that many storage engines, especially pluggable ones have many varied capabilities. There is no SQL accessible method for determining exactly what specialized capabilities any given engine has. The INFORMATION_SCHEMA.ENGINES metadata table includes XA, TRANSACTIONS, and SAVEPOINTS columns, but these don't go nearly far enough.

We need a table that lets engines expose exactly what capabilities they feature.

TABLE ENGINE_CAPABILITIES
ENGINE VARCHAR(64)
…