tutorial de mysql workbecnch

The open source DBA Dashboard for MySQL automates the statistical data collection, reporting and monitoring of the internals of your MySQL Servers. Information such as server health, schema information, database size, and usage statistics are aggregated on a periodic basis to give you insight into your MySQL databases. This JasperReports application answers questions such as: How many queries per day? Which user has the most resource usage? What tables are growing the fastest?(2005-08-05)

I’ve been working on various different MySQL related issues and maintenance procedures some of which have not gone according to plan. Here is a recipe that may help you avoid wasting a lot of time, especially if your database is large.

Beginners to MySQL often start monitoring their systems manually but quickly realize the need to automate. When the new MySQL DBA is also new to shell scripting, the task of automating becomes even more daunting. This presentation introduces the Bash shell, illustrates how it can communicate with MySQL and with the outside world, and gives practical examples of these scripts.

Launching MySQL databases in "The Cloud" can make a DBA's dreams come true. While it is relatively easy to set up special-purpose replicas or scale out on demand -- it is not as easy as it looks! RightScale, the leader in cloud computing management,has already launched thousands of MySQL clusters in the cloud and can help attendees understand the tradeoffs and tricks it takes to do it right.

You don't have to read source code -- understanding how MySQL works can be achieved through the system data. Learn a wide range of topics in this 3-hour tutorial, and leave armed with tons of knowledge about how MySQL 5.0, 5.1 and 6.0 work. You will take home a healthy understanding of performance tuning, storage engines, replication and many tips and tricks to help you be a better DBA.

On the front cover of MySQL Administrator’s Bible is a sentence that reads: “The book you need to succeed!” I must say, I do agree.