Re: 5.0.37 hangs on startup

rting? Cheers, James James Green wrote: > Hi, > > I've upgraded from 5.0.26 to 5.0.37, both compiled from same source > options, and the newer release crashes on startup. > > 5.0.26 Appears fine on all counts. > 5.0.37 Appears to start without innodb switched on, but mys

5.0.37 hangs on startup

Hi, I've upgraded from 5.0.26 to 5.0.37, both compiled from same source options, and the newer release crashes on startup. 5.0.26 Appears fine on all counts. 5.0.37 Appears to start without innodb switched on, but mysql clients just hang, and you cannot stop it without several "killall -9 mysqld"

Binary Logs not updating

s are being written to the logs except the relay-log. Can someone please advise? Using InnoDB's hotbackup.pl file to perform the backups. Cheers, -- James Green -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

InnoDB: Space issues

Hi, One of our servers has a 30GB+ ibdata1 file. We just switched on per table tablespaces and have begun moving tables out into their own files. But I still need to reduce the 30GB+ down to a more reasonable level to free up disk space. This is essential. The only references I can find for

Re: Innodb: Alter table progress

Heikki, See inline. Heikki Tuuri wrote: James, - Original Message - From: "James Green" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, April 04, 2005 1:28 PM Subject: Innodb: Alter table progress Hi, Is there any way of checking the progress of

Innodb: Alter table progress

Hi, Is there any way of checking the progress of an "ALTER TABLE" query on an InnoDB table? "show innodb status" isn't clear. Thanks, -- James Green Systems Administrator, StealthNET Ltd, www.stealthnet.co.uk Tel: 0870 800 1777 Intl: +44 1493 660066 Fax: 0870 135 1069

Re: Merging / Moving InnoDB Databases

ables http://www.innodb.com/order.php Order MySQL Network from http://www.mysql.com/network/ - Original Message ----- From: "James Green" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, February 21, 2005 1:16 PM Subject: Merging / Moving InnoDB Databases

Merging / Moving InnoDB Databases

nnodb data files and frm data 2. Taken down Servers A & B 3. Put on Servers A & B the data files from Server C, but under different InnoDB names (ibdata3 for example) 4. Start Servers A & B and watch all the databases fly happily? Is this the correct procedure? Thanks, -- James Green

InnoDB: Problem with innobackup

Hi, On running the hot backup tool we receive: ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1 ibbackup: Re-reading page at offset 0 366297088 in /var/lib/mysql/data/ibdata1 050218 15:18:01 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex eeaefd1a0

InnoDB problem, yet performance increased!?

mands took roughly 45 minutes to finish - it did something, we just don't know what! Any help duly appreciated. -- James Green Systems Administrator, StealthNET Ltd, www.stealthnet.co.uk Tel: 0870 800 1777 Intl: +44 1493 660066 Fax: 0870 135 1069 -- MySQL General Mailing List For list

hotcopy - segfault

ib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) open("/root/.my.cnf", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) --- SIGSEGV (Segmentation fault) --- +++ killed by SIGSEGV +++ I'm no expert - can anyone identify the fault? Running as