Re: Space is filling up

ebrt.err -rw-rw1 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 PROTEC

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 > &g

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/[

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 >

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 Lis

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

msg.pgp Description: PGP message

Re: apostrophe error

msg.pgp Description: PGP message

apostrophe error

msg.pgp Description: PGP message

Re: Newbie: need form to input records & View report

manage and excellent tool > > > -- > 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=get&search=0x8B686E08 There's no place like 127.0.0.1 pgp0.pgp Description: PGP signature

SQL syntax error

L|| | prog | varchar(255) | YES | | NULL|| | mesg | text | YES | | NULL|| +---+--+--+-+-++ Is there anyway I can modify the host,prog and mesg field types to accept apostrophe as part

Re: problem

UNCISAL > --> Fone: (0xx82) 9904-0117 > > *** > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

nd ? Thanks for your suggestions -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=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 (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=get&search=0x8B686E08 There's no p

MySQL 4.1 .vs. MySQL 4.0.13 (fwd)

licate temporary 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=get&search=0x8B686E08 T

MySQL 4.1 .vs. MySQL 4.0.13

licate temporary 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=get&search=0x8B686E08 T

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)

Re: Replication with multiple servers in Mysql ?

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

Re: InnoDB Error ib_logfile0 of different size

timeout I am doing any replication. I have just one server. I am using MyISAM and InnoDB Type tables and Row formats were Dynamic Thanks again -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mai

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 dat

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=get&search=0x8B

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 > > > > I

split database

p 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=get&a

innodb doc in mysql.com

elete 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/looku

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=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com

mysqldump w/o password

put 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=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

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 >

InnoDB data file is growing

e all 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=get&search=0x8B686E08 There's no p

Re: Impossible mysqldump - Please HELP!!!

; > Is there something that I am doing wrong please point me in the right > direction. > > Thank you all very much > > Ola A. Ogunneye > Senior Accountant > > Adventist Healthcare - Financial Services > 1801 Research Boulevard, Suite 400 > Rockville, MD 20850 > T

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

RE: Books advice

hens, Ronald R. Plew > > 6.The Practical SQL Handbook: Using SQL Variants >by Judith S. Bowman, et al > > > Many thanks in advance for all your help. > > > Fawad > > > > -- Asif Iqbal http://pgpkeys.mit.edu:11371/pks/lookup?op=get&searc

Mysqld is keep crashing

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=get&search=0x8B686E08 There's no place like

Re: innodb data file of different size

fferent size > From: Paul DuBois > Date: Wed, 30 Jul 2003 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

Re: innodb data file of different size

be the files that begin with "ib" in your data directory) > - 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 > > > > >Tha

innodb data file of different size

29 22: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=get&search=0x8B686E08 There's no place

Re: What is a good benchmark?

ENCODE("hello","goodbye")) | +--+ |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

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 separat

RE: What is a good benchmark?

> >| BENCHMARK(100,ENCODE("hello","goodbye")) | > >+--+ > >|0 | > >+--+ > >1 row in set (2.59 sec) > >

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=get&search=0x8B686E08 There's no place like 127.0.0.1 -- MySQL General Mailing List For list archi

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

ght direction, this is my first try and > it has been quite a serious learning experience. > > Thank you in advance. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >

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=get&search=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.

Re: mysql query output get wrapped

ou'll need to do some > post-processing of your own. > > Chris > > 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

Re: mysql query output get wrapped

t on the input stream and write its output out 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. >

Re: mysql query output get wrapped

ience > * The measure 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 PRO

Re: mysql query output get wrapped

4-17 18:38:02 1 2001-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. >

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. &g

RE: mysql query output get wrapped

; in end of your sql statement like below > > Mysql -u -p -E -e "show innodb status" > > OR > > Mysql -u -p -e "show innodb status \g" > > I am not sure it is little "g" or capital "G". Try both way. > > -Original Message

Re: mysql query output get wrapped

I want the columns unwrapped to make it easy to read. Sorry if I confused you earlier On Tue, 3 Jun 2003, Paul DuBois wrote: > At 11:27 -0400 6/3/03, Asif Iqbal wrote: > >mysql> select * from Tic

mysql query output get wrapped

mysql> select * from Tickets limit 1; ++-+---++++---+---+-+---+--+--++--+-++-+-+--+---