'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 […]

  • 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. […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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. […]

  • 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 […]

 



Powered by Wordpress and MySQL. Theme by Shlomi Noach, openark.org
Creative Commons License
MySQL Fan Boy by Mark Grennan is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License.
HOME