Re: Space is filling up

1 mysqlmysql 3 Nov 21 2003 webrt.pid Thanks for all the help Jack -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 2:07 PM To: gerald_clark Cc: [EMAIL PROTECTED] Subject: Re: Space is filling up gerald_clark wrote

Space is filling up

innodb_lock_wait_timeout = 50 Any help to clean the dir would be greatly appreciated Thanks -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Space is filling up

gerald_clark wrote: What about getting a bigger drive? I guess that would be my only option eh? Asif Iqbal wrote: Hi All My mysql data dir is filled up to 95% and only 345M left. Here is the dir looks like 1.9Gibdata1 3.1Gibdata2 3.0Kib_arch_log_02 3.0K

Re: data file too big

On Fri, 23 Jan 2004, Mikhail Entaltsev wrote: Date: Fri, 23 Jan 2004 09:34:52 +0100 From: Mikhail Entaltsev [EMAIL PROTECTED] To: Gregory Newby [EMAIL PROTECTED], Asif Iqbal [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: data file too big I believe that this will flush those logs

data file too big

rt3 12K test 67K webrt.err 1.0Kwebrt.pid Is there anyway I can remove some of them so I can get some space back ? I am using mysql -4.0.13 on Solaris 8 -- Asif Iqbal PGP Key: 0xE62693C5 KeyServer: pgp.mit.edu There's no place like 127.0.0.1 -- MySQL General Mailing List

apostrophe error

msg.pgp Description: PGP message

Re: apostrophe error

msg.pgp Description: PGP message

Re: link in your book (was Re: apostrophe error)

msg.pgp Description: PGP message

Re: Newbie: need form to input records View report

] -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 pgp0.pgp Description: PGP signature

SQL syntax error

|| | mesg | text | YES | | NULL|| +---+--+--+-+-++ Is there anyway I can modify the host,prog and mesg field types to accept apostrophe as part of the record ? Thanks for all the help (Happy New Year !!) -- Asif

Re: problem

) 9904-0117 *** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

I was wondering if anyone can give a direction on this sub-query issue. Do I must upgrade it to MySQL 4.1 alpha or is there an alternative on MySQL 4.0.13 as a workaround to sub-query Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

suggestions -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.1 .vs. MySQL 4.0.13

. [/snip] Now My question is if there any possible way I can stick to the current installation MySQL 4.0.13 and have the user do his job with some workaround ? Thanks for your suggestions -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

tables. [/snip] Now My question is if there any possible way I can stick to the current installation MySQL 4.0.13 and have the user do his job with some workaround ? Thanks for your suggestions -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like

Re: InnoDB Error ib_logfile0 of different size

Type tables and Row formats were Dynamic Thanks again -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Replication with multiple servers in Mysql ?

if you or anyone else could suggest any place for improvement. Thanks a lot -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

MySQL Performance

Sorry for reposting , wrong subject in the prebious one -- Forwarded message -- Date: Wed, 27 Aug 2003 11:17:36 -0400 (EDT) From: Asif Iqbal [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Replication with multiple servers in Mysql ? Hi Jeremy Zawodny (and all) I am using

InnoDB Error ib_logfile0 of different size

104857600 bytes! 030826 1:42:15 Can't init databases 030826 1:42:15 Aborting So as a workaround I commented the innodb_log_file_size. But I really don't like this solution. Is there a better solution ? Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's

Re: InnoDB Error ib_logfile0 of different size

On Tue, 26 Aug 2003, Victoria Reznichenko wrote: Asif Iqbal [EMAIL PROTECTED] wrote: I already have mysql 4.0.13 running with all InnoDB tables. I am trying to use my-huge.cnf since I have 4 gig RAM with 4 x 450 Mhz processes In my MySQL data directory I have two ib_logfile files -rw

split database

the database to database.sql 2. Remove all the entries older than one year and save it as database_new.sql 3. Drop the database 4. Source database_new.sql 5. Not sure what I need to do with the innodb data/log Please help/suggest -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch

Re: innodb doc in mysql.com

On Sun, 24 Aug 2003, Heikki Tuuri wrote: Asif, - Original Message - From: Asif Iqbal [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Saturday, August 23, 2003 10:09 PM Subject: innodb doc in mysql.com In mysql.com site on section 7.5.4.1 it says and I qoute

innodb doc in mysql.com

also the corresponding `.frm' files for these tables from the MySQL database directories. Then you can try the InnoDB database creation again. If I do this, will it break my database ? I am still new with InnoDB concept Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch

ibdata1 is close to disk size

= 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout Please help Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

mysqldump w/o password

this in cron so I don't like the option of showing the filename Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

InnoDB data file is growing

together to fix the crash. So now I am not sure how I can prevent the growth of InnoDB. I looked through the InnoDB website but I don't see it addressing InnoDB crash issue Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1

Re: Mysqld is keep crashing

Is there a pdf format of this ibman page ? OR is there a good book on Mysql+innodb out there ? Thanks On Fri, 1 Aug 2003, Heikki Tuuri wrote: Asif, - Original Message - From: Asif Iqbal [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, July 31, 2003 10:41 PM

Mysqld is keep crashing

and this may fail. key_buffer_size=402653184 read_buffer_size=2093056 030731 15:39:59 mysqld ended Anyone would know how I can fix it I am using my-huge.cnf . I have 4 450Mhz with 4 gig ram -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1

RE: Books advice

-- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Books advice

ISBN 0-7357-1212-3 On Fri, 1 Aug 2003, Lucas Fonzalida - Soporte Tecnico wrote: Asif, can you paste here the ISBN? Thanks!! Lucas -Mensaje original- De: Asif Iqbal Enviado el: Jueves, 31 de Julio de 2003 22:05 Para: Ralph Guzman CC: 'Fawad Siddiqui'; [EMAIL PROTECTED] Asunto

Re: Impossible mysqldump - Please HELP!!!

Healthcare - Financial Services 1801 Research Boulevard, Suite 400 Rockville, MD 20850 Tel: 301.315.3274 Fax: 301.315.3265 Email: [EMAIL PROTECTED] -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List

Re: innodb data file of different size

) - Shut down the server - Add the innodb_data_file_path line to your my.cnf file - Start the server - Load the dump file back into the server to recreate your InnoDB tables Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like

Re: innodb data file of different size

00:07:49 -0500 At 22:08 -0400 7/29/03, Asif Iqbal wrote: I just decided to use my.cnf and bumped into this error message 030729 22:04:22 mysqld started InnoDB: Error: data file /usr/local/mysql/data/ibdata1 is of a different size InnoDB: 81024 pages (rounded down to MB) InnoDB: than

Re: What is a good benchmark?

through my DBIx::SeacrhBuilder ? Thanks On Tue, 29 Jul 2003, Dan Nelson wrote: In the last episode (Jul 29), Asif Iqbal said: Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any suggestion on how to improve it ? Run it 4 times simultaneously in separate windows. You got 4 CPUs

Re: What is a good benchmark?

)) | +--+ |0 | +--+ 1 row in set (2.89 sec) Sorry for newbie question On Tue, 29 Jul 2003, Dan Nelson wrote: In the last episode (Jul 29), Asif Iqbal said: Now I am running these processes

innodb data file of different size

:04:23 mysqld ended I am assuming I need to change values in the following line taken from my.cnf file innodb_data_file_path = ibdata1:10M;ibdata2:10M:autoextend Please help Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1

Bottleneck

How do I debug my live mysql query on a specific database to find the query time, memory usage, etc. ? Thanks -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com

RE: What is a good benchmark?

)); +--+ | BENCHMARK(100,ENCODE(hello,goodbye)) | +--+ |0 | +--+ 1 row in set (2.59 sec) Regards, Jake Johnson [EMAIL PROTECTED] -- Asif Iqbal

RE: Access Denied for User: root@127.0.0.1(Using password: NO)

in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list

mysql database dump

Can I dump a database while the database is running in mysql ? -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=getsearch=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

mysql query output get wrapped

mysql select * from Tickets limit 1;

RE: mysql query output get wrapped

statement like below Mysql -u id -ppasswd -E -e show innodb status OR Mysql -u id -ppasswd -e show innodb status \g I am not sure it is little g or capital G. Try both way. -Original Message- From: Asif Iqbal [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 10:27 AM

Re: mysql query output get wrapped

Jun 2003, Paul DuBois wrote: At 11:39 -0400 6/3/03, Asif Iqbal wrote: I want the columns unwrapped to make it easy to read. Sorry if I confused you earlier I still don't know what you mean. What would this output *look like*? Please show an example. On Tue, 3 Jun 2003, Paul DuBois wrote

Re: mysql query output get wrapped

-04-17 18:26:46 0 Still wrapped :-) On Tue, 3 Jun 2003, Thomas Spahni wrote: Asif, try this: prompt echo select * from Tickets limit 1; | mysql mydb result.file You get everything in ONE line. Cheers, Thomas On Tue, 3 Jun 2003, Asif Iqbal wrote: mysql select * from Tickets

Re: mysql query output get wrapped

of a programmer is not the number of lines of code he writes but the number of lines he does not have to write. * - Original Message - From: Asif Iqbal [EMAIL PROTECTED] To: Paul DuBois [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 03, 2003 10:57 AM Subject: Re: mysql query output

Re: mysql query output get wrapped

to the output stream. It is up to the pager how it does this: in the example of less it will paginate and not wrap. Other pagers can be used to achieve different results, processing the stream however you like, based on your needs. Cheers, Chris Asif Iqbal wrote: mysql select * from

Re: mysql query output get wrapped

Asif Iqbal wrote: That works with \G switch , but without the \G switch Istill get it wrapped wish I can remeber the switch On Tue, 3 Jun 2003, Chris Tucker wrote: The pager option can be used to accomplish this (if you don't mind having things running through, e.g., less). When