l_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,
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 Mess
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
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
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
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]
--
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,
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]
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
le 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" <[EMA
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: &
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: Inn
nters/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]
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 unsubscrib
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 PROTECTE
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
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 PROT
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
| 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
--
MyS
qld 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]
7; 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
22 matches
Mail list logo
