'MySQL' Tag

• 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

• 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

• 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

• MySQL Table Caching

  February 25, 2010

  Too much of a good thing… I have had a lot of people asking me about MySQL lately so I thought is was time to share something I learned.  Too much caching space in MySQL can be a bad thing. You would thing the more you can stuff your entire database into memory the better […]

  posted in Commentary by mark