'MySQL' Tag

• MySQL Network Connections

  May 7, 2010

  If your MySQL server has hundreds of clients (applications) and tens of thousands of queries per second,  MySQL default network settings may NOT be for you.  Network performance is not often a significant factor in the performance of MySQL.  That said, there are things to consider. If you are building new applications make these changes [...]

  posted in Tunning by mark

• Install MariaDB on RedHat 5.4

  May 4, 2010

  Is MariaDB really a drop in replacement for MySQL?   I’m running CentOS 5.4.  What happens if… Use “mysqldump –all-databases > FullBackup.sql” to make a full backup. (Better safe then sorry) Go to http://askmonty.org/wiki/MariaDB:Download and download the CentOS 5 packages. Stop msql “service mysqld stop” Pull MySQL out by the roots with “rpm -e mysql-server mysql [...]

  posted in Commentary by mark

• mg_hot_replace_table.pl

  May 1, 2010

  Do you have MyISAM tables you reload with new data? Do your queries, using that table, get blocked because the table is locked? Do the waiting queries create idle connections slowing down the table load? Do you wish you could just replace the table? Years ago I was told you can replace CSV tables by [...]

  posted in Code by admin

• MySQL master/slave support merged into Linux-HA

  April 21, 2010

  (Re-posted from Florian’s blog.) MySQL replication support for the Pacemaker cluster manager (the stuff that we explained in this webinar) has made it into the Linux-HA resource agents default branch. If you are interested in testing — and you should! — please read the extended announcement. Feedback is extremely welcome on the linux-ha-dev mailing list. [...]

  posted in Commentary by mark

• New AutoMySQLBackup Script

  April 19, 2010

  (2010/11/04) NEWS: Life has been restored in the source forge project after four years!  A new version 2.5.1-01 has been released.  I am working on merging my modifications with the new code and contacting the developers in the project with the new code. MySQL Backup Script has been around for a long time.  I have [...]

  posted in Code, Tips & Tricks by mark

• Developer Tips using MySQL

  April 19, 2010

  I get ask, by application developers,  “how do you optimize MySQL”.  I do lots of things that don’t really relate to a developer. I analyze the percent of queries are being pulled from cache for instance.  What a developer can do to optimize the SQL they develop is a different questions.   So here is a [...]

  posted in Tips & Tricks by mark

• MySQL Conference 2010

  April 19, 2010

  The big questions was “Where is Oracle taking MySQL.” Edward Screven spoke to insure everyone Oracle will continue to grow the Open Source side of the company and gave several examples of the way MySQL has already been improved over the last year. Oracle has integrating the MySQL and InnoDB teams resulting in increases of [...]

  posted in Commentary by mark

• Is your Replications in Sync?

  April 12, 2010

  Here is a quick way to see if your replicated tables are in sync. I found this on http://www.mysqldbahelp.com/2010/04/pager-md5sum-quick-way-to-compare.html I haven’t tested this yet. I’ll update it when I do. I set the pager output to md5sum. Here is an example: Slave: mysql> pager md5sum – PAGER set to ‘md5sum -’ mysql> select * from [...]

  posted in Commentary by mark

• REVIEW – MySQL Admin Cookbook

  April 2, 2010

  MySQL Admin Cookbook 99 great recipes for mastering MySQL configurations and administration by Daniel Schneller,  Udo Schwedt Published by PACKT Publishing This book is a great first attempt at a book that has been needed for a long time.   It covers the everyday practical parts of managing a MySQL server. I have been hungry for [...]

  posted in Commentary by mark

• The OpenArk Kit

  March 25, 2010

  Shlomi Noach is DBA,  authorized MySQL instructor software developer and Winner of the MySQL Community Member of the Year, 2009. He has published his own collections of MySQL scripts and you might find them useful.  Shlomi calls them the “openark kit“. The available tools are: oak-apply-ri: apply referential integrity on two columns with parent-child relationship. [...]

  posted in Tips & Tricks by mark