Re: Innodb assertion failure after binary backup-restore
Thanks for your replies.
Now I have three ways to go
1. replication
2. innodb hot backup tool
3. Make sure that no one is writing in to the database and start backup when
modified db pages in "BUFFER POOL AND MEMORY" becomes zero
#FLUSH TABLES WITH READ LOCK
still_to_flush=1
while [ $still_to_flush != 0 ]
do
still_to_flush=`/usr/local/mysql/bin/mysql -e "SHOW INNODB STATUS\G" | grep
"Modified db pages" | awk '{print $4}'`
sleep 1
done
#UNLOCK TABLES
Do you think #3 will work?
Regards,
Sp.Raja
> Original Message
> From: "Heikki Tuuri" <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Date: Tue, Jul-27-2004 6:24 PM
> Subject: Re: Innodb assertion failure after binary backup-restore
>
> Hi!
>
> sync will not help.
>
> You can run SHOW INNODB STATUS\G to monitor when InnoDB has flushed its
> buffer pool.
>
> Best regards,
>
> Heikki
> Innobase Oy
> InnoDB - transactions, row level locking, and foreign keys for MySQL
> InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up
> MyISAM
> tables
> http://www.innodb.com/order.php
>
> Order MySQL support from http://www.mysql.com/support/index.html
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb assertion failure after binary backup-restore
Hi, I was able to solve this by calling sync command, as my previous mail say. Do you mean to say this will not work regardless of the whether we sync or not?? which implies binary backup/restore for innodb is impossible?? We actually started with mysqldump for backup, but that was slow when we had huge amount of data, so we decided to switch in to binary mode. If innodb takes long time to flush contents to files, are there any command available to make this happen which would block until things are flushed ?? Thanks for your reply. Thanks, Sp.Raja > Original Message > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Date: Tue, Jul-27-2004 1:05 PM > Subject: Re: Innodb assertion failure after binary backup-restore > > Hi! > > That method will not work. InnoDB must be quiet long enough so that it > has > time to flush all the contents of the buffer pool to the data files. > > Best regards, > > Heikki Tuuri > Innobase Oy > Foreign keys, transactions, and row level locking for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up > MyISAM > tables > http://www.innodb.com/order.php > > Order MySQL technical support from https://order.mysql.com/ > > > - Original Message - > From: ""Sp.Raja"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Friday, July 23, 2004 4:43 PM > Subject: Innodb assertion failure after binary backup-restore > > > > Hi List, > > > > We are using 4.0.15a MySQL. We need to backup database at times and > we > empl= > > oy the following method > > > > FLUSH TABLES WITH READ LOCK > > tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1 > > UNLOCK TABLES > > > > and restore is reverse. We cannot overwrite all databases, some of > them > nee= > > ds to be unchanged across backup and restores called persistent > databases > (= > > just 1% of full data) so we employ the following > > > > mysqldump on persistent databases > > stop mysql > > cd /usr/local/mysql/data > > tar -zxf backup.tar.gz > > start mysql > > destroy persistent databases > > run mysqldump sql files to get database back to shape > > > > This method works fine expect for the case where backup is taken > immediatel= > > y after table creation and population. > > When we start the mysql after restore of this backup. It comes up, > but > mysq= > > l connections to it asking for persistent database destroy hangs. > When I > do= > > a processlist I get > > > ++--+---++-+--+-+--= > > + > > | Id | User | Host | db | Command | Time | State | > Info > = > > | > > > ++--+---++-+--+-+--= > > + > > | 1 | root | localhost || Query | 55 | Waiting on cond | > drop > data= > > base persistent1| > > | 4 | root | localhost || Query | 0| | > show > proc= > > esslist | > > > ++--+---++-+--+-+--= > > + > > > > When I open up another mysql client and query some of the tables, > they > also= > > hang and processlist at that time shows > > > ++--+---+-+-+--+-+-= > > + > > | Id | User | Host | db | Command | Time | State > | > Info= > > | > > > ++--+---+-+-+--+-+-= > > + > > | 1 | root | localhost | | Query | 171 | Waiting on cond > | > drop= > > database persistent1 | > > | 6 | root | localhost | data | Query | 59 | Opening tables > | > sele= > > ct * from my_data | > > | 11 | root | localhost | | Query | 0| > | > show= > > processlist| > > > ++--+---+-+-+--+-+-= > > + > > > > After some time mysql.err reports > > 040721 14:43:49 InnoDB: Assertion failure in thread 88 in file > fsp0fsp.c > l= > > ine 2950 > > InnoDB: We intentionally generate a memory trap. > > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > > InnoDB: Thread 88 stopped in file fsp0fsp.c line 2950 > > In
Re: Innodb assertion failure after binary backup-restore
Hi List, I figured out the fix for it. I need to do a "sync" and wait for the sync to get over and take a backup. Thanks, Sp.Raja > Original Message---- > From: "Sp.Raja" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Date: Fri, Jul-23-2004 8:03 PM > Subject: Re: Innodb assertion failure after binary backup-restore > > In some cases mysql crashes while restore is trying to destroy > persistent databases and mysql.err says > > 000121 21:02:23 InnoDB: Database was not shut down normally. > InnoDB: Starting recovery from log files... > InnoDB: Starting log scan based on checkpoint at > InnoDB: log sequence number 0 867418 > InnoDB: Doing recovery: scanned up to log sequence number 0 867418 > InnoDB: Page directory corruption: supremum not pointed to > 000121 21:02:23 InnoDB: Page dump in ascii and hex (16384 bytes): > len 16384; hex (all zeros and dots in ascii) > ;InnoDB: End of page dump > 000121 21:02:23 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form > checksum 1371122432 > InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 > InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 > InnoDB: Page directory corruption: supremum not pointed to > 000121 21:02:23 InnoDB: Page dump in ascii and hex (16384 bytes): > len 16384; hex ...(all zeros and dots in ascii) > ;InnoDB: End of page dump > 000121 21:02:23 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form > checksum 1371122432 > InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 > InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 > InnoDB: Error: trying to access a stray pointer a1027ff8 > InnoDB: buf pool start is at 2084, number of pages 512 > 000121 21:02:23 InnoDB: Assertion failure in thread 43 in file > include/buf0buf.ic line 284 > InnoDB: Failing assertion: 0 > InnoDB: We intentionally generate a memory trap. > InnoDB: Send a detailed bug report to [EMAIL PROTECTED] > mysqld got signal 11; > This could be because you hit a bug. It is also possible that this > binary > or one of the libraries it was linked against is corrupt, improperly > built, > or misconfigured. This error can also be caused by malfunctioning > hardware. > We will try our best to scrape up some info that will hopefully help > diagnose > the problem, but since we have already crashed, something is definitely > wrong > and this may fail. > > key_buffer_size=16777216 > read_buffer_size=131072 > max_used_connections=0 > max_connections=20 > threads_connected=0 > It is possible that mysqld could use up to > key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections > = 29183 K > bytes of memory > Hope that's ok; if not, decrease some variables in the equation. > > Writing a core file > 000121 21:02:24 mysqld ended > > Thanks, > Sp.Raja > > > Original Message > > From: "Sp.Raja" <[EMAIL PROTECTED]> > > To: "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > > Date: Fri, Jul-23-2004 7:13 PM > > Subject: Innodb assertion failure after binary backup-restore > > > > Hi List, > > > > We are using 4.0.15a MySQL. We need to backup database at times and > we > > employ the following method > > > > FLUSH TABLES WITH READ LOCK > > tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1 > > UNLOCK TABLES > > > > and restore is reverse. We cannot overwrite all databases, some of > them > > needs to be unchanged across backup and restores called persistent > > databases (just 1% of full data) so we employ the following > > > > mysqldump on persistent databases > > stop mysql > > cd /usr/local/mysql/data > > tar -zxf backup.tar.gz > > start mysql > > destroy persistent databases > > run mysqldump sql files to get database back to shape > > > > This method works fine expect for the case where backup is taken > > immediately after table creation and population. > > When we start the mysql after restore of this backup. It comes up, > but > > mysql connections to it asking for persistent database destroy hangs. > > > When I do a processlist I get > > > ++--+---++-+--+-+--+ > > | Id | User | Host | db | Command | Time | State | > Info > >| > > > ++--+---++-+--+-+--+ > > | 1 | root | localhost || Query | 55 | Waiting on cond | > drop > > data
Re: Innodb assertion failure after binary backup-restore
In some cases mysql crashes while restore is trying to destroy persistent databases and mysql.err says 000121 21:02:23 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 867418 InnoDB: Doing recovery: scanned up to log sequence number 0 867418 InnoDB: Page directory corruption: supremum not pointed to 000121 21:02:23 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex (all zeros and dots in ascii) ;InnoDB: End of page dump 000121 21:02:23 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Page directory corruption: supremum not pointed to 000121 21:02:23 InnoDB: Page dump in ascii and hex (16384 bytes): len 16384; hex ...(all zeros and dots in ascii) ;InnoDB: End of page dump 000121 21:02:23 InnoDB: Page checksum 1575996416, prior-to-4.0.14-form checksum 1371122432 InnoDB: stored checksum 0, prior-to-4.0.14-form stored checksum 0 InnoDB: Page lsn 0 0, low 4 bytes of lsn at page end 0 InnoDB: Error: trying to access a stray pointer a1027ff8 InnoDB: buf pool start is at 2084, number of pages 512 000121 21:02:23 InnoDB: Assertion failure in thread 43 in file include/buf0buf.ic line 284 InnoDB: Failing assertion: 0 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16777216 read_buffer_size=131072 max_used_connections=0 max_connections=20 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 29183 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. Writing a core file 000121 21:02:24 mysqld ended Thanks, Sp.Raja > Original Message > From: "Sp.Raja" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED] '" <[EMAIL PROTECTED]> > Date: Fri, Jul-23-2004 7:13 PM > Subject: Innodb assertion failure after binary backup-restore > > Hi List, > > We are using 4.0.15a MySQL. We need to backup database at times and we > employ the following method > > FLUSH TABLES WITH READ LOCK > tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1 > UNLOCK TABLES > > and restore is reverse. We cannot overwrite all databases, some of them > needs to be unchanged across backup and restores called persistent > databases (just 1% of full data) so we employ the following > > mysqldump on persistent databases > stop mysql > cd /usr/local/mysql/data > tar -zxf backup.tar.gz > start mysql > destroy persistent databases > run mysqldump sql files to get database back to shape > > This method works fine expect for the case where backup is taken > immediately after table creation and population. > When we start the mysql after restore of this backup. It comes up, but > mysql connections to it asking for persistent database destroy hangs. > When I do a processlist I get > ++--+---++-+--+-+--+ > | Id | User | Host | db | Command | Time | State | Info >| > ++--+---++-+--+-+--+ > | 1 | root | localhost || Query | 55 | Waiting on cond | drop > database persistent1| > | 4 | root | localhost || Query | 0| | show > processlist | > ++--+---++-+--+-+--+ > > When I open up another mysql client and query some of the tables, they > also hang and processlist at that time shows > ++--+---+-+-+--+-+-+ > | Id | User | Host | db | Command | Time | State | > Info| > ++--+---+-+-+--+-+-+ > | 1 | root | localhost | | Query | 171 | Waiting on cond | > drop database persistent1 | > | 6 | root | localhost | data | Query | 59 | Opening tables | > select * from my_data | > | 11 | root | localhost |
Innodb assertion failure after binary backup-restore
Hi List, We are using 4.0.15a MySQL. We need to backup database at times and we employ the following method FLUSH TABLES WITH READ LOCK tar -zcf backup.tar.gz ibdata1 ib_logfile0 ib_logfile1 UNLOCK TABLES and restore is reverse. We cannot overwrite all databases, some of them needs to be unchanged across backup and restores called persistent databases (just 1% of full data) so we employ the following mysqldump on persistent databases stop mysql cd /usr/local/mysql/data tar -zxf backup.tar.gz start mysql destroy persistent databases run mysqldump sql files to get database back to shape This method works fine expect for the case where backup is taken immediately after table creation and population. When we start the mysql after restore of this backup. It comes up, but mysql connections to it asking for persistent database destroy hangs. When I do a processlist I get ++--+---++-+--+-+--+ | Id | User | Host | db | Command | Time | State | Info | ++--+---++-+--+-+--+ | 1 | root | localhost || Query | 55 | Waiting on cond | drop database persistent1| | 4 | root | localhost || Query | 0| | show processlist | ++--+---++-+--+-+--+ When I open up another mysql client and query some of the tables, they also hang and processlist at that time shows ++--+---+-+-+--+-+-+ | Id | User | Host | db | Command | Time | State | Info | ++--+---+-+-+--+-+-+ | 1 | root | localhost | | Query | 171 | Waiting on cond | drop database persistent1 | | 6 | root | localhost | data | Query | 59 | Opening tables | select * from my_data | | 11 | root | localhost | | Query | 0| | show processlist| ++--+---+-+-+--+-+-+ After some time mysql.err reports 040721 14:43:49 InnoDB: Assertion failure in thread 88 in file fsp0fsp.c line 2950 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] InnoDB: Thread 88 stopped in file fsp0fsp.c line 2950 InnoDB: Thread 30 stopped in file os0sync.c line 509 InnoDB: Thread 96 stopped in file sync0sync.ic line 109 InnoDB: Thread 29 stopped in file sync0arr.c line 126 Please help me in resolving the issue by giving directions on how to proceed. your help is much appreciated. Thanks for your time, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does MySQL Daemonize?
Our software environment requires mysqld to be daemonized. (running in nohup cannot help) Does mysqld support it? Or do we need to change the source code to do it? Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Changing ibdata files on the fly
Hi List, Is it possible to change data and log files (ibdata and iblogfiles copied for backup purpose) on the fly? Will something like this work?? 1. Close all client connections 2. Flush and disable further client connections. 3. Copy ibdata and iblogfiles from backup dir 4. SIGHUP mysqld. What does mysqld does when it receives SIGHUP ? Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb running out of disk space for relatively low number of rows!
Thanks for the response. Closed long running transactions, Did the test again and got in to same situation. Innodb and table status at that time were: = 700101 0:16:20 INNODB MONITOR OUTPUT = Per second averages calculated from the last 56 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 60, signal count 60 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 66, OS waits 33; RW-excl spins 28, OS waits 27 TRANSACTIONS Trx id counter 0 26585 Purge done for trx's n:o < 0 25827 undo n:o < 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 97 MySQL thread id 34, query id 27420 localhost root show innodb status ---TRANSACTION 0 26584, not started, OS thread id 101 MySQL thread id 33, query id 27419 localhost root FILE I/O I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 398 OS file reads, 6813 OS file writes, 6724 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 6.02 writes/s, 5.59 fsyncs/s - INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 97, node heap has 1 buffer(s) 4.43 hash searches/s, 4.96 non-hash searches/s --- LOG --- Log sequence number 0 10811761 Log flushed up to 0 10811761 Last checkpoint at 0 10810302 0 pending log writes, 0 pending chkp writes 6558 log i/o's done, 3.45 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated 20791608; in additional pool allocated 1048576 Buffer pool size 512 Free buffers 0 Database pages 511 Modified db pages 4 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 340, created 291, written 411 0.00 reads/s, 0.04 creates/s, 0.87 writes/s Buffer pool hit rate 1000 / 1000 -- ROW OPERATIONS -- 0 queries inside InnoDB, 0 queries in queue Main thread id 49, state: sleeping Number of rows inserted 6355, updated 12, deleted 8, read 700 0.91 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s END OF INNODB MONITOR OUTPUT | Tbl8577_114_2_2| InnoDB | Dynamic| 5675 | 1024 | 5816320 |NULL |0 | 0 | NULL | NULL| NULL| NULL || InnoDB free: 3072 kB | Thanks, Sp.Raja > Original Message > From: Jochem van Dieten <[EMAIL PROTECTED]> > To: "Sp.Raja" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Date: Tue, Apr-27-2004 5:03 PM > Subject: Re: Innodb running out of disk space for relatively low number of rows! > > Sp.Raja wrote: > > = > > 700101 20:31:59 INNODB MONITOR OUTPUT > > = > > Per second averages calculated from the last 39 seconds > > -- > > SEMAPHORES > > -- > > OS WAIT ARRAY INFO: reservation count 139, signal count 139 > > Mutex spin waits 0, rounds 0, OS waits 0 > > RW-shared spins 186, OS waits 86; RW-excl spins 66, OS waits 53 > > > > TRANSACTIONS > > > > Trx id counter 0 9909 > > Purge done for trx's n:o < 0 9332 undo n:o < 0 0 > > Total number of lock structs in row lock hash table 0 > > LIST OF TRANSACTIONS FOR EACH SESSION: > > ---TRANSACTION 0 0, not started, OS thread id 107 > > MySQL thread id 38, query id 31381 localhost root > > show innodb status > > ---TRANSACTION 0 3238, not started, OS thread id 83 > > MySQL thread id 31, query id 5043 localhost root > > ---TRANSACTION 0 3141, not started, OS thread id 66 > > MySQL thread id 33, query id 4804 localhost root > > ---TRANSACTION 0 9908, not started, OS thread id 88 > > MySQL thread id 28, query id 31373 localhost root > > ---TRANSACTION 0 2853, not started, OS thread id 44 > > MySQL thread id 23, query id 4048 localhost root > > ---TRANSACTION 0 3241, not started, OS thread id 56 > > MySQL thread id 27, query id 5049 localhost root > > ---TRANSACTION 0 3240, ACTIVE 1786 sec, OS thread id 114 > > MySQL thread id 22, query id 5052 localhost root > > ---TRANSACTION 0
Innodb running out of disk space for relatively low number of rows!
Hi list, I have 5 Databases, out of which 2 have only one table and remaining 3 have 270 tables. My data partition in disk has 50MB space. When I start inserting rows to a particular table (which has 114 attributes), MySQL/Innodb runs out of space when 6438th row is added. Is this an expected behavior? I have 50Mb space and MySQL runs out of space for just 6XXX rows, do I have to tweak some configurations ? Please help. Trace reports the following: 700101 20:03:52 InnoDB: Error: Write to file ./ibdata1 failed at offset 0 31457280. InnoDB: 1048576 bytes should have been written, only 1003520 were written. InnoDB: Operating system error number 0. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 0 means 'Error number not set'. InnoDB: See also section 13.2 at http://www.innodb.com/ibman.html InnoDB: about operating system error numbers. When I run show table status on it, I got the following before my insert | Tbl8577_114_2_2| InnoDB | Dynamic| 6073 |957 | 5816320 |NULL |0 | 0 | NULL | NULL| NULL| NULL || InnoDB free: 5120 kB | after disk space over flow I got | Tbl8577_114_2_2| InnoDB | Dynamic| 6073 |957 | 5816320 |NULL |0 | 0 | NULL | NULL| NULL| NULL || InnoDB free: 3072 kB | and show innodb status yeilded = 700101 20:31:59 INNODB MONITOR OUTPUT = Per second averages calculated from the last 39 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 139, signal count 139 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 186, OS waits 86; RW-excl spins 66, OS waits 53 TRANSACTIONS Trx id counter 0 9909 Purge done for trx's n:o < 0 9332 undo n:o < 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, OS thread id 107 MySQL thread id 38, query id 31381 localhost root show innodb status ---TRANSACTION 0 3238, not started, OS thread id 83 MySQL thread id 31, query id 5043 localhost root ---TRANSACTION 0 3141, not started, OS thread id 66 MySQL thread id 33, query id 4804 localhost root ---TRANSACTION 0 9908, not started, OS thread id 88 MySQL thread id 28, query id 31373 localhost root ---TRANSACTION 0 2853, not started, OS thread id 44 MySQL thread id 23, query id 4048 localhost root ---TRANSACTION 0 3241, not started, OS thread id 56 MySQL thread id 27, query id 5049 localhost root ---TRANSACTION 0 3240, ACTIVE 1786 sec, OS thread id 114 MySQL thread id 22, query id 5052 localhost root ---TRANSACTION 0 3142, ACTIVE 1788 sec, OS thread id 81 MySQL thread id 32, query id 4819 localhost root FILE I/O I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 977 OS file reads, 8736 OS file writes, 8539 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s - INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 1, node heap has 1 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 0 5952720 Log flushed up to 0 5952720 Last checkpoint at 0 5952720 0 pending log writes, 0 pending chkp writes 8089 log i/o's done, 0.00 log i/o's/second -- BUFFER POOL AND MEMORY -- Total memory allocated 22969544; in additional pool allocated 1048576 Buffer pool size 512 Free buffers 0 Database pages 511 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 1244, created 1353, written 1660 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout -- ROW OPERATIONS -- 0 queries inside InnoDB, 0 queries in queue Main thread id 77, state: waiting for server activity Number of rows inserted 6719, updated 8, deleted 4, read 25856 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s END OF INNODB MONITOR OUTPUT ==== Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Backup/Restore Procedures
Hi List, I use 3 databases Current, Persistent-1 and Persistent-2. I would like to take backups of Current as when and required and restore them as desired without affecting Persistent-1 and Persistent-2. Initially thought of using mysqldump for this, but was worried about the performance (I use huge DBs). So have come up with the following procedure, When using single tablespace (4.0.15a) Backup process is use innobackup/ibbackup or bring mysqld down and copy all data dir files Restore process is Take mysqldump of Persistent-1 and Persistent-2 Do Restore following either of the two approach For each table discard old tablespace, copy the backup file, import new tablespace or bring down MySQL and copy files Destroy Persistent-1 and Persistent-2 Run sql files of Persistent-1 and Persistent-2 When using per table tablespace (4.1.1 alpha) Backup process is use innobackup/ibbackup or bring mysqld down and copy all files in data/Current Restore process is Do Restore following either of the two approach For each table discard old tablespace, copy the backup file, import new tablespace or bring down MySQL and copy files Do you expect any issues in the above method? Are there any other efficient, minimum downtime (zero is desirable) method to do the same? Please mail me your view, to help me out. Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Innodb table space getting filled up without any increase in actual rows!!
Thanks for your valuable suggestions. I'm committing transactions, but not all. Only the transactions which do insert/delete, commit and not all. So I think the better solution for me is to switch to "Read Committed" isolation mode, since I don't require "Repeatable Read" Isolation for my application. Do you think this will address my issue (tables don't get filled up until they have rows) ? Thanks, Sp.Raja > Original Message > From: "Sp.Raja" <[EMAIL PROTECTED]> > To: "K Perinbam" <[EMAIL PROTECTED]> > Cc: "R Narayanan" <[EMAIL PROTECTED]> > Date: Fri, Mar-5-2004 9:14 AM > Subject: Re: Innodb table space getting filled up without any increase in actual > rows!! - Looks like can be fixed. > > FYI. > > > Sp. Raja, > > you have 3 dangling transactions that have been active for almost 2 hours. > They prevent purge from removing those delete-marked rows. > > ---TRANSACTION 0 832338, ACTIVE 6027 sec, OS thread id 65 > MySQL thread id 41, query id 1036449 localhost root > Trx read view will not see trx with id >= 0 832339, sees < 0 832214 > ---TRANSACTION 0 832337, ACTIVE 6027 sec, OS thread id 57 > MySQL thread id 42, query id 1036436 localhost root > Trx read view will not see trx with id >= 0 832338, sees < 0 832214 > ---TRANSACTION 0 832214, ACTIVE 6055 sec, OS thread id 110 > MySQL thread id 51, query id 1036076 localhost root > Trx read view will not see trx with id >= 0 832215, sees < 0 832215 > > You should commit these transactions. > > Best regards, > > Heikki > Innobase Oy > http://www.innodb.com > InnoDB - transactions, row level locking, and foreign keys for MySQL > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM > tables > > Register now for the 2004 MySQL Users Conference! > http://www.mysql.com/events/uc2004/index.html > > > - Alkuper??inen viesti - > L??hett??j??: "Sp.Raja" <[EMAIL PROTECTED]> > Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > L??hetetty: Thursday, March 04, 2004 4:38 PM > Aihe: Re: Innodb table space getting filled up without any increase in > actual rows!! > > > Heikki, > > Thanks for your reply. > As you said I have attached trace collected for SHOW INNODB STATUS. > Please point me the things which are going wrong. > > Do you mean I have to use auto-commit transactions? > What changes should I do (or) take care when using MySQL through ODBC to > avoid old transactions ? > > To be more specific my client does a lot of inserts/deletes using a ODBC > connection maintaining number of rows to be between 60 and 70. > > Thanks, > Sp.Raja > > > Original Message > > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Date: Thu, Mar-4-2004 1:30 AM > > Subject: Re: Innodb table space getting filled up without any increase in > actual rows!! > > > > Sp. Raja, > > > > please check with > > > > SHOW INNODB STATUS\G > > > > if purge is still running and removing delete-marked rows. Also check that > > you do not have old, dangling transactions, which can prevent purge from > > running, as those old transactions could still see the delete-marked rows. > > > > Best regards, > > > > Heikki > > Innobase Oy > > http://www.innodb.com > > InnoDB - transactions, row level locking, and foreign keys for MySQL > > InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up > MyISAM > > tables > > > > Register now for the 2004 MySQL Users Conference! > > http://www.mysql.com/events/uc2004/index.html > > > Preferably, you should test the problem using the latest stable or development > > version of > > MySQL Server before postin1> > > > > List:MySQL General Discussion Previous MessageNext Message > > From:Sp.RajaDate:March 3 2004 8:48am > > Subject:Fw: Innodb table space getting filled up without any increase in > > actual rows!! > > > > I missed attaching the trace file! > > Sorry !! > > > > Regards, > > Sp.Raja > > > > > Original Message > > > From: "Sp.Raja" <[EMAIL PROTECTED]> > > > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > > > Date: Wed, Mar-3-2004 1:13 PM > > > Subject: Innodb table space getting filled up without any increase in > > actual rows!! > > > > > > Hi Li
Re: Innodb table space getting filled up without any increase in actual rows!!
Heikki, Thanks for your reply. As you said I have attached trace collected for SHOW INNODB STATUS. Please point me the things which are going wrong. Do you mean I have to use auto-commit transactions? What changes should I do (or) take care when using MySQL through ODBC to avoid old transactions ? To be more specific my client does a lot of inserts/deletes using a ODBC connection maintaining number of rows to be between 60 and 70. Thanks, Sp.Raja > > > Original Message > > From: "Heikki Tuuri" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Date: Thu, Mar-4-2004 1:30 AM > > Subject: Re: Innodb table space getting filled up without any increase in actual > > rows!! > > > > Sp. Raja, > > > > please check with > > > > SHOW INNODB STATUS\G > > > > if purge is still running and removing delete-marked rows. Also check that > > you do not have old, dangling transactions, which can prevent purge from > > running, as those old transactions could still see the delete-marked rows. > > > > Best regards, > > > > Heikki Regards, Sp.Raja mysql> show table status ; +--+++--++-+-- ---+--+---++-+ -+++--+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | M ax_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_ time | Check_time | Create_options | Comment | +--+++--++-+-- ---+--+---++-+ -+++--+ | axactivealarmtbl | InnoDB | Dynamic| 503 |195 | 98304 | NULL |98304 | 0 | NULL | NULL| NULL | NULL || InnoDB free: 9216 kB | +--+++--++-+-- ---+--+---++-+ -+++--+ 1 row in set (0.05 sec) mysql> SHOW INNODB STATUS\G *** 1. row *** Status: = 700102 21:22:53 INNODB MONITOR OUTPUT = Per second averages calculated from the last 18 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 13573, signal count 13569 Mutex spin waits 0, rounds 0, OS waits 0 RW-shared spins 10445, OS waits 5172; RW-excl spins 8575, OS waits 8401 TRANSACTIONS Trx id counter 0 835529 Purge done for trx's n:o < 0 832240 undo n:o < 0 0 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 832247, not started, OS thread id 94 MySQL thread id 47, query id 1036187 localhost root ---TRANSACTION 0 832339, not started, OS thread id 114 MySQL thread id 46, query id 1036443 localhost root ---TRANSACTION 0 735412, not started, OS thread id 133 MySQL thread id 38, query id 1041882 localhost root SHOW INNODB STATUS ---TRANSACTION 0 835528, ACTIVE 0 sec, OS thread id 137 1 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 52, query id 1041881 localhost root ---TRANSACTION 0 832338, ACTIVE 297 sec, OS thread id 65 MySQL thread id 41, query id 1036449 localhost root Trx read view will not see trx with id >= 0 832339, sees < 0 832214 ---TRANSACTION 0 832337, ACTIVE 297 sec, OS thread id 57 MySQL thread id 42, query id 1036436 localhost root Trx read view will not see trx with id >= 0 832338, sees < 0 832214 ---TRANSACTION 0 832214, ACTIVE 325 sec, OS thread id 110 MySQL thread id 51, query id 1036076 localhost root Trx read view will not see trx with id >= 0 832215, sees < 0 832215 FILE I/O I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1048 OS file reads, 314001 OS file writes, 241185 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 6.00 writes/s, 4.94 fsyncs/s - INSERT BUFFER AND ADAPTIVE HASH INDEX - Ibuf for space 0: size 1, free list len 0, seg size 2, 0 inserts, 0 merged recs, 0 merges Hash table size 34679, used cells 524, node heap has 2 buffer(s) 1233.49 hash searches/s
Fw: Innodb table space getting filled up without any increase in actual rows!!
I missed attaching the trace file! Sorry !! Regards, Sp.Raja > Original Message > From: "Sp.Raja" <[EMAIL PROTECTED]> > To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> > Date: Wed, Mar-3-2004 1:13 PM > Subject: Innodb table space getting filled up without any increase in actual rows!! > > Hi List, > > My tablespace is getting filled up so quick when no. of transactions increase > without number of rows increasing considerably. > I have a test client which adds and deletes row dynamically maintaining number of > rows at any instant between 20 and 60. > > When I run this test client, after some time the client emits the following error: > > "[MySQL][ODBC 3.51 Driver][mysqld-4.0.15a-debug]The table 'axactivealarmtbl' is > full." > > I was confused on seeing this. So ran the test again but this time monitoring table > status. I noticed that Rows, Data_length and Index_length column increased > monotonically and InnoDB free decreased. I was not able to reason why ? > > But when I used select count(*) from it consistently gave me numbers > between 20 and 60 > > I have attached output of "show table status"(trace.txt) as I observed taken at > increasing time. > > Any Pointers/Ideas on this to help me resolve this issue?? > > Thanks, > Sp.Raja > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > +--+++--++-+-+--+---++-+-+++--+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +--+++--++-+-+--+---++-+-+++--+ | axactivealarmtbl | InnoDB | Dynamic| 467 |210 | 98304 | NULL |98304 | 0 | NULL | NULL| NULL| NULL || InnoDB free: 9216 kB | +--+++--++-+-+--+---++-+-+++--+ +--+++--++-+-+--+---++-+-+++--+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +--+++--++-+-+--+---++-+-+++--+ | axactivealarmtbl | InnoDB | Dynamic| 4946 |321 | 1589248 | NULL | 622592 | 0 | NULL | NULL| NULL| NULL || InnoDB free: 6144 kB | +--+++--++-+-+--+---++-+-+++--+ +--+++--++-+-+--+---++-+-+++--+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +--+++--++-+-+--+---++-+-+++--+ | axactivealarmtbl | InnoDB | D
Innodb table space getting filled up without any increase in actual rows!!
Hi List, My tablespace is getting filled up so quick when no. of transactions increase without number of rows increasing considerably. I have a test client which adds and deletes row dynamically maintaining number of rows at any instant between 20 and 60. When I run this test client, after some time the client emits the following error: "[MySQL][ODBC 3.51 Driver][mysqld-4.0.15a-debug]The table 'axactivealarmtbl' is full." I was confused on seeing this. So ran the test again but this time monitoring table status. I noticed that Rows, Data_length and Index_length column increased monotonically and InnoDB free decreased. I was not able to reason why ? But when I used select count(*) from it consistently gave me numbers between 20 and 60 I have attached output of "show table status"(trace.txt) as I observed taken at increasing time. Any Pointers/Ideas on this to help me resolve this issue?? Thanks, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Patches for 4.0.15a
Hi List, I'm using mysql-4.0.15a. But we need some specific features present in 4.1.X such as 1. INSERT ... ON DUPLICATE KEY UPDATE query support 2. Innodb multi-table space (one ibdata file per table) Could someone point me to patches for them for 4.0.15a release. so that I can back merge them specifically. We don't want to use 4.1.X since it is not production/stable version, but have decided to back merge some specific feature which are required. Regards, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Memory
Thanks for your lightening response. Even I thought of this idea - Isolate pairs like - my_malloc and my_free - Innodb pair: ut_malloc and ut_free But if pointers are passed between InnoDB and MySQL or MySQL and clients, then the memory consumer should free it using my wrapper and not system defined free. Is there such communication or all pointers allocated by one modules stays with in it and gets freed by the module. Thanks, Sp.Raja > Original Message > From: Sasha Pachev <[EMAIL PROTECTED]> > To: Chris Nolan <[EMAIL PROTECTED]> > Cc: "Sp.Raja" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Date: Tue, Feb-17-2004 6:55 PM > Subject: Re: MySQL Memory > > Chris Nolan wrote: > > Hi! > > > > You'll want to look through the MySQL C API docs. There are specific > > calls for allocating certain structures that MySQL client software > > should use (and routines for deallocating it as well). > > > > Regards, > > > > Chris > > > > Sp.Raja wrote: > > > >> Hi List, > >> > >> I want to use some other memory allocator routine other than malloc in > >> MySQL/InnoDB 4.0.15a. > >> Does MySQL call malloc directly? or thru wrappers? If it is through > >> wrappers then my job will be much simpler, If so please give me the > >> list of wrappers. > > You can force MySQL client to allocate using your own routines if you get the > client source,replace my_malloc() and my_free() (see mysys/my_alloc.c), and link > your code against your modified version. In fact, you could even do it for the > server. > > > -- > Sasha Pachev > Create online surveys at http://www.surveyz.com/ > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Re: MySQL Memory
Missed ccing it to list! Yes In mysqld. system provided malloc has access to a samller space of entire main memory, and we APIs to access the rest, I'm trying to change mysqlds malloc calls to our extended malloc which make use of the entire main memory. Regards, Sp.Raja > > Original Message > > From: Chris Nolan <[EMAIL PROTECTED]> > > To: "Sp.Raja" <[EMAIL PROTECTED]> > > Cc: [EMAIL PROTECTED] > > Date: Tue, Feb-17-2004 6:53 PM > > Subject: Re: MySQL Memory > > > > Server end? As in, writing code that will integrate with the MySQL > > Server process? Or are you building UDFs? > > > > Regards, > > > > Chris > > > > Sp.Raja wrote: > > > > >Thanks for your input. I'm trying to do is at the server end(mysqld), could you > > >get some pointers? > > > > > >Regards, > > >Sp.Raja > > > > > > > > > > > >>Original Message > > >>From: Chris Nolan <[EMAIL PROTECTED]> > > >>To: "Sp.Raja" <[EMAIL PROTECTED]> > > >>Cc: [EMAIL PROTECTED] > > >>Date: Tue, Feb-17-2004 6:29 PM > > >>Subject: Re: MySQL Memory > > >> > > >>Hi! > > >> > > >>You'll want to look through the MySQL C API docs. There are specific > > >>calls for allocating certain structures that MySQL client software > > >>should use (and routines for deallocating it as well). > > >> > > >>Regards, > > >> > > >>Chris > > >> > > >>Sp.Raja wrote: > > >> > > >> > > >> > > >>>Hi List, > > >>> > > >>>I want to use some other memory allocator routine other than malloc in > > >>>MySQL/InnoDB 4.0.15a. > > >>>Does MySQL call malloc directly? or thru wrappers? If it is through wrappers > > >>>then my job will be much simpler, If so please give me the list of wrappers. > > >>> > > >>>Any Advice welcome > > >>> > > >>>Regards, > > >>>Sp.Raja > > >>> > > >>> > > >>> > > >>>-- > > >>>MySQL General Mailing List > > >>>For list archives: http://lists.mysql.com/mysql > > >>>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > >>> > > >>> > > >>> > > >>> > > >>> > > >> > > >>-- > > >>MySQL General Mailing List > > >>For list archives: http://lists.mysql.com/mysql > > >>To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > >> > > >> > > >> > > > > > > > > > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Memory
Thanks for your input. I'm trying to do is at the server end(mysqld), could you get some pointers? Regards, Sp.Raja > Original Message > From: Chris Nolan <[EMAIL PROTECTED]> > To: "Sp.Raja" <[EMAIL PROTECTED]> > Cc: [EMAIL PROTECTED] > Date: Tue, Feb-17-2004 6:29 PM > Subject: Re: MySQL Memory > > Hi! > > You'll want to look through the MySQL C API docs. There are specific > calls for allocating certain structures that MySQL client software > should use (and routines for deallocating it as well). > > Regards, > > Chris > > Sp.Raja wrote: > > >Hi List, > > > >I want to use some other memory allocator routine other than malloc in MySQL/InnoDB > >4.0.15a. > >Does MySQL call malloc directly? or thru wrappers? If it is through wrappers then > >my job will be much simpler, If so please give me the list of wrappers. > > > >Any Advice welcome > > > >Regards, > >Sp.Raja > > > > > > > >-- > >MySQL General Mailing List > >For list archives: http://lists.mysql.com/mysql > >To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Memory
Hi List, I want to use some other memory allocator routine other than malloc in MySQL/InnoDB 4.0.15a. Does MySQL call malloc directly? or thru wrappers? If it is through wrappers then my job will be much simpler, If so please give me the list of wrappers. Any Advice welcome Regards, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Innodb Tablespace Management
Hi, I need to manage Innodb Tablespace very effectively from my application. To do that I require clear picture of Innodb tablespace file and its organization. My application needs to do the following 1. backup/restore of databases While doing so should calculate the size of source database, and check it against free space available in data directory. How do I calculate this figure for InnoDB databases 2. Free-Disk Space controlled inserts My application uses two databases normal and faults. I have to restrict faults database in disk size. At present if I have huge number of faults, fault database eats away the disk space(ibdata) and normal is not able to insert. I want to restrict disk space occupied by fault database(say, it can take max 5MB), how do I do it? 3. Innodb reaches table full soon. My system has only 50 MB Flash partition, where I have to store data. Innodb logs occupy 10MB and other files (.frm) occupies 10MB more, which leaves 30MB for ibdata file. Transactions return back table full when about 6000 rows are inserted to them. but show table status reports 3072KB free against the table name. Why is this contradiction? SHOW TABLE STATUS FROM Agora LIKE 'objects' | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | | objects | InnoDB | Dynamic| 6054 |955 | 5783552 | NULL |0 | 0 | NULL | NULL| NULL | NULL || InnoDB free: 3072 kB | Any Help will be greatly appreciated. Thanks a lot, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Bug:: Running mysql in lynxos-powerpc
raries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=16384 read_buffer_size=131072 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 19215 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. free: pid[91] : Double free of 0x215b8e68 allocated at 0x10374c44:0x10374a90:0x10378d98 == I tried stopping the server, but in vain == Decimus:/users/spraja/usr/local/mysql# ./share/mysql/mysql.server stop Killing mysqld with pid 108 Wait for mysqld to exit\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c .\c gave up waiting! == Thanks in advance, Regards, Sp.Raja -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL installation and starting problems on LynxOS
Hello, I tried installing MySQL on LynxOS, and it went fine. After installation I started mysqld and but was not able to communicate with it. When I ran mysqladmin it reported the following arjuna# /usr/local/mysql/bin/mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Lost connection to MySQL server during query' arjuna# /usr/local/mysql/bin/mysqladmin version /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Lost connection to MySQL server during query' Then I tried telnet to 3306 port on which mysqld was listening arjuna# telnet arjuna 3306 Trying 192.168.0.21 ... Connected to arjuna. Escape character is '^]'. , 4.0.15a-log>*VQtulA, Bad handshakeConnection closed by foreign host. arjuna# telnet arjuna 3306 Trying 192.168.0.21 ... Connected to arjuna. Escape character is '^]'. , 4.0.15a-logOVB&8%N=, Bad handshakeConnection closed by foreign host. Server side log at time were arjuna# tail -f arjuna.err Version: '4.0.15a-log' socket: '/tmp/mysql.sock' port: 3306 Number of processes running now: 0 030930 12:47:06 mysqld restarted /usr/local/mysql/libexec/mysqld: File or directory doesn't exist 030930 12:47:06 mysqld ended 030930 12:47:37 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.0.15a-log' socket: '/tmp/mysql.sock' port: 3306 030930 12:55:28 Error on new connection socket: Socket operation on non-socket 030930 12:55:33 Error on new connection socket: Socket operation on non-socket Could some one help me to resolve this?? Regards Sp.Raja
