From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1NhGt7-0004nS-Oi for garchives@archives.gentoo.org; Tue, 16 Feb 2010 06:26:26 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id 270CAE0884; Tue, 16 Feb 2010 06:26:23 +0000 (UTC) Received: from smtp.gentoo.org (smtp.gentoo.org [140.211.166.183]) by pigeon.gentoo.org (Postfix) with ESMTP id 71DB1E06D9 for ; Tue, 16 Feb 2010 06:26:09 +0000 (UTC) Received: from mail.isohunt.com (b01.ext.isohunt.com [208.71.112.51]) by smtp.gentoo.org (Postfix) with ESMTP id CA1AF1B401F for ; Tue, 16 Feb 2010 06:26:08 +0000 (UTC) Received: (qmail 31997 invoked from network); 16 Feb 2010 06:26:04 -0000 Received: from tsi-static.orbis-terrarum.net (HELO grubbs.orbis-terrarum.net) (76.10.188.108) by mail.isohunt.com (qpsmtpd/0.33-dev on beta01) with (CAMELLIA256-SHA encrypted) ESMTPS; Tue, 16 Feb 2010 06:26:04 +0000 Received: (qmail 8192 invoked by uid 10000); 16 Feb 2010 06:26:03 -0000 Date: Tue, 16 Feb 2010 06:26:03 +0000 From: "Robin H. Johnson" To: gentoo-dev@lists.gentoo.org Subject: Re: [gentoo-dev] Re: News item: MySQL 5.1 bump Message-ID: References: <20100216001408.GA346@orbis-terrarum.net> Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-dev@lists.gentoo.org Reply-to: gentoo-dev@lists.gentoo.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.20 (2009-06-14) X-Archives-Salt: 36c04411-faca-4950-93b7-b8ed8c0c1af3 X-Archives-Hash: 10d4a2a7cc9cd531f09c4612fc62f2a7 On Tue, Feb 16, 2010 at 06:11:13AM +0000, Duncan wrote: > > - If you actually ran mysqld as your own user (Akonadi w/ internal MySQL > > instance), use the mysql_upgrade with suitable parameters to connect > > to the database (as to what those are, you're the one running it, not > > me). > It's automagic from here. I just run kde. What it does, I don't know. I > just don't want it to break! (And upgrade implications will get worse > with kde 4.5 in August, as kmail will be depending on it then, and users > tend to get rather cross when their mail store gets hosed! With 4.4, it's > mainly the address book.) All of that is under the Akonadi side of KDE. I really don't think storing mail inside MySQL is going to be a good idea. > >> Perhaps a note for kde users telling them where their databases are > >> located so they /can/ back them up, etc.) > > I've got no idea where they are located, I just focus on MySQL itself. I > > wasn't even aware of Akonadi's usage until a couple of weeks ago. > What I was suggesting, between the lines, is to coordinate with the kde > project. They may want to create their own upgrade document, which might > be listed in the news release or in a separate one (testing for both mysql > and kde). Hopefully they reply to this thread with whatever their > concerns there might be. I announced it 2 weeks ago, on February 1st, Message-Id: robbat2-20100201T012126-637073772Z@orbis-terrarum.net I just hadn't gotten to actually doing it yet due to travel and getting sick on my way home (and Delta doing everything in their power to screw things up, I still haven't got one of my pieces of luggage back yet). As soon as the 72 hours on this news announcement are done, I'm going to be unmasking it. I do expect most of the breakage to come from the client libraries, and NOT any actual data storage issues. If MySQL detects that it's not safe to access a table, it does give you a suitable error to repair the table. mysql_upgrade is actually really just running 'CHECK TABLE ... FOR UPGRADE;' && 'REPAIR TABLE ...' on tables with something that needs to change. Doing a 'REPAIR TABLE ...' globally will cover you if you don't have any other way to issue the check statements manually. That is of course me assuming that you have a way to issue 'REPAIR TABLE ...', because that's a critical MySQL command for the DBA/user to know in managing their data. -- Robin Hugh Johnson Gentoo Linux: Developer, Trustee & Infrastructure Lead E-Mail : robbat2@gentoo.org GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85