http://planetmysql.ru Блог о самой популярной СУБД MySQL Wed, 10 Mar 2010 03:04:06 +0000 http://backend.userland.com/rss092 en Imagine you tried to use the slow query log to debug a performance problem. Does the current format have enough details? # Time: 100309 18:48:23 # User@Host: root[root] @ localhost [] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 I have added Thread_id, Errno, Start and End. Thread_id can be ... http://www.facebook.com/note.php?note_id=355839540932&utm_source=rss&utm_medium=rss&utm_campaign=do-you-need-more-data-in-the-slow-query-log Video fragments of my session posted at the end — read on. I arrived at Omni Mandalay Hotel on Sunday evening with Dan Norris. I was flying through Chicago and it turned out that Dan was on the same flight and only few rows behind me. Small world. Preparations for the conference ... http://www.pythian.com/news/9219/hotsos-symposium-2010-battle-against-any-guess-is-won/?utm_source=rss&utm_medium=rss&utm_campaign=hotsos-symposium-2010-%25e2%2580%2594-battle-against-any-guess-is-won As part of my upcoming FREE my.cnf check advice I first need to ask people to provide the current MySQL configuration file commonly found as a file named my.cnf If only that question was easy to answer! Use of configuration files MySQL will by default use at least one configuration file from ... http://ronaldbradford.com/blog/how-do-i-identify-the-mysql-my-cnf-file-2010-03-09/?utm_source=rss&utm_medium=rss&utm_campaign=how-do-i-identify-the-mysql-my-cnf-file Data comparison is a difficult and resource-intensive process. For convenience, this process can be divided into several steps. First, you should compare tables from one database on one server with the database on the other server. You should choose columns for data comparison, and also choose a column that will be ... http://www.devart.com/blogs/dbforge/?p=1056&utm_source=rss&utm_medium=rss&utm_campaign=data-comparison-methods-overview   Few weeks ago I was at FOSDEM.  It was really amazing experience. I meet many interesting people, learned quite some thing and I returned full of enthusiasm. Open Source events are really great. But all the fun wasn't over even after the FOSDEM. I spent few more days in Bruxelles attending ... http://michal.hrusecky.net/index.php/blog/show/MySQL-Version-Updates.html?utm_source=rss&utm_medium=rss&utm_campaign=mysql-version-updates Changes (as compared to 8.22) include: Features: * Added an option to define a ‘color code’ for a connection. The color will be used as background color in the Object Browser. * A Query Builder session can now be saved and resumed. * In Query Builder a table alias can be defined ... http://www.webyog.com/blog/2010/03/09/sqlyog-mysql-gui-8-3-has-been-released/?utm_source=rss&utm_medium=rss&utm_campaign=sqlyog-mysql-gui-8-3-has-been-released I’ve submitted a Birds of a Feather session for Maatkit at the upcoming MySQL conference. It’s not on the public schedule yet, but it has been accepted and scheduled for 19:00 on 13 Apr 2010. See you there! Related posts:Presentation uploaded for Maatkit talk at MySQL Conference The slidesI’ll ... http://www.xaprb.com/blog/2010/03/09/maatkit-bof-session-at-the-mysql-conference/?utm_source=rss&utm_medium=rss&utm_campaign=maatkit-bof-session-at-the-mysql-conference TRUNCATE is usually a fast operation (much faster than DELETE FROM). But sometimes it just hangs; I’ve has several such uncheerful events with InnoDB (Plugin) tables which were extensively written to. The TRUNCATE hanged; nothing else would work; minutes pass. TRUNCATE on tables with no FOREIGN KEYs should act fast: it ... http://code.openark.org/blog/mysql/tip-faster-than-truncate?utm_source=rss&utm_medium=rss&utm_campaign=tip-faster-than-truncate I'm happy to announce that my talk "Making MySQL administration a breeze - a look into a MySQL DBA's toolchest" has been accepted for this year's edition of the MySQL Conference & Expo in Santa Clara, which will take place on April 12-15, 2010. The session is currently scheduled for ... http://www.lenzg.net/archives/293-Speaking-at-the-OReilly-MySQL-Conference-Expo-A-look-into-a-MySQL-DBAs-toolchest.html?utm_source=rss&utm_medium=rss&utm_campaign=speaking-at-the-oreilly-mysql-conference-expo-a-look-into-a-mysql-dbas-toolchest At the 2010 O’Reilly MySQL Conference and Expo there will be a Drizzle BoF! It’s currently scheduled for 7pm on April 13th. Come along, it will be awesome.PlanetMySQL Voting: Vote UP / Vote DOWN http://www.flamingspork.com/blog/2010/03/09/drizzle-bof-at-the-mysql-conference-and-expo/?utm_source=rss&utm_medium=rss&utm_campaign=drizzle-bof-at-the-mysql-conference-and-expo