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
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
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
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
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
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
.
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]
| Tbl8577_114_2_2| InnoDB | Dynamic| 5675 | 1024 |
5816320 |NULL |0 | 0 | NULL | NULL|
NULL| NULL || InnoDB free: 3072 kB |
Thanks,
Sp.Raja
Original
Thanks,
Sp.Raja
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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
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
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]
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
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
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
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
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
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
| 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
.\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
on new connection socket: Socket operation on non-socket
Could some one help me to resolve this??
Regards
Sp.Raja
22 matches
Mail list logo