mysql sql query size limit

Hi List, What is the practical limit on size of the sql query in mysql 4.1.x Anil

RE: Getting SQL errors porting databases between MySQL v4 and v5

Use --allow-keywords option with mysqldump command Anil -Original Message- From: Brian Mansell [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 11:18 PM To: Rob Tanner Cc: mysql@lists.mysql.com Subject: Re: Getting SQL errors porting databases between MySQL v4 and v5 The '

RE: mysqldumpslow output interpretation

Hi List, Any update on this Thanks Anil Hi List, Below is the output of mysqldumpslow. In the output query execution time is showing -ve value how to interpret the below output i.e how to interpret -ve value for query execution time please advice Count: 1 Time=4294967223.00s

Managing big mysqldump files

and remove the dump file. Is there any way to get compressed dump file instead of generating dump file and then compressing it later. Any ideas or suggestions please Thanks Anil

Mysql memory utilization

tes/s, 0.00 deletes/s, 163055.10 reads/s END OF INNODB MONITOR OUTPUT ==== Thanks Anil

RE: connection issue

Than you very much . It is working Anil DBA -Original Message- From: Dobromir Velev [mailto:[EMAIL PROTECTED] Sent: Thursday, October 13, 2005 8:58 PM To: mysql@lists.mysql.com Cc: Anil Subject: Re: connection issue When you connect without specifing the host, the mysql client will

connection issue

Anil DBA

RE: problem with grant

cept connection from any host . please clarify Thanks Anil DBA -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 11:22 PM To: Anil Cc: mysql@lists.mysql.com Subject: Re: problem with grant Anil wrote: > HI, > > I have grante

QUERY CACHE TUNING QUESTION

_ From: Anil [mailto:[EMAIL PROTECTED] Sent: Thursday, September 15, 2005 10:36 PM To: 'mysql@lists.mysql.com' Subject: QUERY CACHE TUNING QUESTION Hi list, We are using mysql 4.0.24 on RHEL 3.0 on dell 2650 machine with 2 gb RAM. We tried to fine tune query cach

QUERY CACHE TUNING QUESTION

down drastically. We didn't understand the reason behind hit . Is there any recommended procedure to fine tune query cache . awaiting early reply from list. Thanks in advance Anil DBA

problem with grant

rver where database was hosted mysql -u -p -h127.0.0.1 I am unable to connect to the database. Please anybody explain what was the problem Thanks Anil DBA

Mysql crash due to page corruptions

on. After restarting the mysql it is working fine. But we want to identify the process which is causing page corruption ,Any clues will be helpful for us. Thanks Anil DBA

RE: backup/restore

0; check the above you will find drop table command in dumpfile. Thanks Anil -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 9:50 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subje

RE: User can't login to his DB.

Hi, after granting privileges did you executed flush privileges command. if not execute below command and then check mysql> flush privileges; thanks Anil -Original Message- From: sam [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 9:09 AM To: mysql@lists.mysql.com Subj

RE: backup/restore

store it from backup file. Thanks Anil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 03, 2005 12:58 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] Subject: RE: backup/restore Hi, Thank you for your reply. If I

RE: Need more info about currently running queries

may be due to corrupted indexes it is taking long time. just re-org the table.if your table is InnoDB type then use below command to re-org it. mysql> alter table <> type=InnoDB; based on size of the table it may execute for long time . for us it has solved performance issue. Th

RE: myql command-line no warning

after executing command. use the below command to know the warnings it is throwing mysql> show warnings; Thanks Anil -Original Message- From: Qunfeng [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 10:45 AM To: Paul DuBois; mysql@lists.mysql.com Subject: Re: myql comm

RE: mysqldump and innodb - set foreign_key_checks=0

just write the below lines of code to a file in the location where your mysqldump file exists SET FOREIGN_KEY_CHECKS = 0; SOURCE <>; SET FOREIGN_KEY_CHECKS = 1; then execute the following command mysql < <> Thanks Anil DBA -Original Message- From: Heikki Tuuri

RE: Restore help! been going 2 weeks

ours is InnoDB. we are not getting any performance problems with the settings. it is working fine since last 1 Year. to my knowledge due to myisam type you are getting performance issue. Thanks Anil -Original Message- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: Wednesday, December

RE: Regarding User creation and loading data

use root user of mysql. u wont get any privilege restrictions with root user. other wise the user you are using should have file privilege to load data from file or to write to a file Thanks Anil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday

RE: Restore help! been going 2 weeks

plication Added by Anil For Replication server-id = 1 log-bin=/usr/local/mysql/data/extended/neptune-bin.1 set-variable=max_binlog_size=500M # required unique id between 1 and 2^32 - 1 # defaults to 1 if master-host is not set # but will not function as a master if omitted

Monitoring replication in mysql

in in replication setup. Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Restore help! been going 2 weeks

please check the my.cnf parameters with recommended values given in my_huge.cnf file in support files. to my knowledge For 2 GB RAM values you set are very high. I think system is going for heavy swapping that might be the reason it is going very slowly. Anil -Original Message- From

RE: Restore help! been going 2 weeks

is going on then check your my.cnf parameters. Anil -Original Message- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 6:15 PM To: [EMAIL PROTECTED] Subject: Re: Restore help! been going 2 weeks The restore is still running is this normal? How do you all d

RE: mysql_install_db problem!!

check the privileges on directories. that error you generally get when user dont have sufficient privileges on directories. please go through the installation steps given in mysql documentation Anil -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Thursday

RE: Are these variables "healthy"?

hi you can find mysql recommendations of my.cnf parameters based on on RAM size in /usr/local/mysql/support-files with file name my-huge.cnf go through those files and set parameters accordingly for most of databases it will work fine. Anil -Original Message- From: Fagyal Csongor

creating mysqldump log file

Hi, Is there any way to create a log file for mysqldump just like oracle export log file i.e what tables exported no of rows exported like that Thanks in advance Anil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

RE: Deleting redundant rows

create a unique key on city,cc columns with ignore option of alter table it will keep the first row and deletes redundant rows. check the below link for alter table syntax http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html Anil -Original Message- From: Walter Pucko [mailto:[EMAIL

RE: Restore help! been going 2 weeks

check your .myd file size. if table type is myisam and it it is more than 4 GB then convert it to InnoDB. --Anil -Original Message- From: matt_lists [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 8:36 PM Cc: [EMAIL PROTECTED] Subject: Re: Restore help! been going 2 weeks

RE: Increasing the InnoDB log file size

if mysql shutdowns cleanly. then there is no chance of loosing data. for safe side take compleate database backup. -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:39 PM To: Anil Doppalapudi; [EMAIL PROTECTED] Subject: Re: Increasing the

RE: Increasing the InnoDB log file size

Hi, First shutdown the mysql cleanly. #mysqladmin shutdown then drop log files in data directory. restart mysql. it will create new log files. Thanks Anil NOC -Original Message- From: Ronan Lucio [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 11:08 PM To: [EMAIL PROTECTED

How to rebuild indexes in InnoDB

and recreating indexes taking lot of time. any alternative Thanks in advance. Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: max allowed packet error

cket Anil DBA -Original Message- From: Philippe Poelvoorde [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 02, 2004 8:13 PM To: Ferino Mardo; [EMAIL PROTECTED] Subject: Re: max allowed packet error HI, > I have copied the mysql-medium.cnf to /etc/my.cnf and have noticed that >

my.cnf parameter settings for 4 GB RAM

please provide me listof my.cnf parameter values for 4 GB RAM . from support files i can list out only upto 2 GB RAM my database is mysql 4.0.20 binary installation on linux and along with database apache, tomcat and one more application is running on the server. Thanks in advance Anil

Incremental backups in Mysql

Is it possible to take incremental backups in mysql.if yes please provide me links or info on it Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysqldump very slow

Hi Stefan, Sorry for not giving complete details it a very small database around 12 Gb data. But on my other servers which are low in configuration i am getting dump very fast for me it is taking nearly 5 Hrs to compleate dump Thanks Anil DBA -Original Message- From: Stefan Kuhn

Mysqldump very slow

mysqldump running very slow. what might be the reason Server details === Dell RAM : 4 GB Innodb_buffer_pool_size : 1000MB i am using --quick option in mysqldump Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: MySql Configuraton on Redhat

use the command below mysqladmin -u root -p supply the passwd when prompted Anil DBA -Original Message- From: Kamal Ahmed [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 8:35 PM To: Kamal Ahmed; [EMAIL PROTECTED] Subject: MySql Configuraton on Redhat Hi, This is the

RE: Table creation Time stamp

i see the time stamp only for Myisam table type and not for InnoDB table type. where can we find for Innodb Table type Thanks Anil DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 13, 2004 8:18 PM To: Anil Doppalapudi Cc: [EMAIL PROTECTED

Table creation Time stamp

Hi, where can we find the time stamp of table creation i.e when that table was created Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to flush process which are in sleep state

Hi, when i issue show processlist command it gives very long list of process most of them are sleep state . is there a way to clear those processs with out killing them Thanks in advace ANil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

RE: Read-Only DB User

First connect to mysql as root user and issue the following command grant select on .* to @ identified by ''; flush privileges; it will grant only select privilege to the newly created user on database and he can only connect from the ipaddress specified in command Anil DBA ---

RE: Create Table Error 1071

` ) ) COMMENT = 'Listing of all pages the administration module' just change the data length of columns from 255 to 250 for both the columns. I tried it on my local server. is is ok Anil DBA -Original Message- From: GH [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 1

RE: How to extract Particular Tables from a Dump file taken with mysqldump

The actual problem is we maintain regular all-databases mysqldump.it is a automated script and after taking complete backup we purged data later we identified that some required data is missed in a particular table. so we require restore of only that particular table. we tried extracting only that

Reg : eliminating duplicate entries

ptions mysql --force < Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Restoring few tables from all-databases dump file

from all-databases backup Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

mysql installation problem

MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! -- As i am new bie to mysql ..please tell how can i make mysql work. Thanks and Regards Anil. p.s.(Can i get precomplied package (.tgz) to which i can d

RE: oracle.

thanks, that helped anil :) -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:51 PM To: Anil Garg Subject: Re: oracle. Anil, I do not remember correct but you need to look at the user_tables. 'desc user_tables' One of the fi

oracle.

hi, m a frequent user of mysql. i was trying to use "show tables" on oracle(sql>), but it dint work :( How do list tables in oracle? Thanks anil. p.s. sorry for the out of list question. - Before posting, please c

RE: date query.

Thanks..that helped. anil :) -Original Message- From: Roger Baklund [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 10:52 AM To: [EMAIL PROTECTED] Cc: Anil Garg Subject: Re: date query. * Anil Garg > The date field in my database table looks as below: > 07th of March 2003

date query.

Hi, The date field in my database table looks as below: 07th of March 2003 10:14:29 PM I need to write a query which gets me all the rows which are entered in last to weeks. Any ideas!! Thanks and Regards Anil. - Before

RE: command line exectution of query(newbie)

thanks, that helped :) -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 1:49 PM To: Anil Garg; [EMAIL PROTECTED] Subject: RE: command line exectution of query(newbie) Database name goes after options. It is showing you the help page

RE: command line exectution of query(newbie)

Sorry, # ./mysql -e "delete from where id > 5;" The above command too doesn't work, it shows the mysql man page.:( any more ideas? thanks and regards anil. -Original Message- From: Jocelyn Fournier [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:3

command line exectution of query(newbie)

Hi, What am i doing wrong: # ./mysql -e "delete * from where id > 5;" I get the mysql help page on exectuting the above command. The mysql verison i am using is : 3.23.52. Thanks and regards anil. - Before po

mysqldump

_four false_info > test" , where awf_four is database name and false_info is a table). I want to do it from command prompt as i want to make a shell script which does all this.(and then put and entry for this script in crontab). help!! Thanks and Regards Anil p.s. please tell if more info is n

RE: database query.

hi, I appreciate the time you spared for my problem. Thanks, that helped :) Regards Anil -Original Message- From: Bruce Feist [mailto:[EMAIL PROTECTED] Sent: Friday, February 28, 2003 2:47 PM To: Anil Garg Subject: Re: database query. There really isn't enough information for

database query.

y to do that OR any ideas on what lines shall i think to modify my database(if needed). Thanks and Regards Anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

users who can access a database

hi, Is there some place where i can define the users who can access the database. If yes..plz help thanx and regards anil sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

cant connect to mysql

uld reaaly appreciate any pointers regarding this. thanx and regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thre

which version to use?

hi What version combinations of mysql and php should be used? regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: Supplied argument is not a valid MySQL result resource!!

can u plz tell me how can i check that? regards anil - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: "SteveH" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002

Re: Supplied argument is not a valid MySQL result resource!!

yes..it echos $edit_id fine. i am also feeling strange why its not working! regards anil - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, August 15, 2002 5:4

Re: Supplied argument is not a valid MySQL result resource!!

hi, m sorry i dint mention that its just a part of code. i am able to delete entries from the database .so i think mysql_connect is not the reason. please tell if u have some more ideas regards anil - Original Message - From: "SteveH" <[EMAIL PROTECTED]> To: <[EMA

Supplied argument is not a valid MySQL result resource!!

ksun/admin/add_doc.php on line 107 element type: What is it happening so!! regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Re: Lost root password

message: Enter full pathname of shell or RETURN for /bin/sh: 3.. JUST HIT ENTER AND CONTINUE 4.. Type: mount -u / 5.. Type: mount /usr 6.. Type: passwd 7.. New Password: 8.. Retype Password: 9.. Type: Reboot regards anil - Original Message - From: "mi

mysql upgrade

ne tell me what needs to be done for the upgarde?and What backups do i need to take? thanx and regards, anil. mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

mysql upgrade

ne tell me what needs to be done for the upgarde?and What backups do i need to take? thanx and regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: UPDATE command..

update set id = replace(id, '1', '2'); hope this helps anil - Original Message - From: "Patrick J Okui" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 16, 2002 9:47 AM Subject: UPDATE command.. > > >

' giving problem while inserting in table.

; (e.g. \')solves my problem...but when i open the same quesion to edit it, again i have to put backslashes where ever i find " ' " in the quesion or answer. Can anyone please suggest a solution to this. thanx and regards anil [please ask if i havent explained the pro

replace query

but being a newbie to mysql i couldnt find the right syntax. Can someone help. thanx and regards anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

Re: changing coulmn

thanx for ur mail, m sorry in dint mention that infact its a big table... Is there a way i can do it in all the columns using only one query ?? thanx anil - Original Message - From: "nellA hciR" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: &

changing coulmn

in my table a column has enties my_1 my_4 my_5 i wnat to change it to my_file_1 my_file_4 my_file_5 can someone please tell me the query for that. thanx anil - Before posting, please check: http://www.mysql.com

Re: Lost Connection to mysql server during query

Hi, Thanx for your mail You are rightin my case the mysqld is getting restarted. But, whey is mysqld getting restarted and giving the Lost Connection error. How can i avoid that?? Thanx anil - Original Message - From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: &qu

Lost Connection to mysql server during query

error: Error 2013 at line 235: Lost connection to MySQL server during query If i decrease the lenght of time stamp in the INSERT query INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122); it works fine. Can a

query: restartmysql daemon

Hi, the sql process(on doing ps) shows the following process: /usr/local/bin/safe_mysqld --user=mysql when i kill this process and try to restart it with command: safe_mysqld --user=mysql it says "a mysql process already exists". can anyone tell me how to restart mysql daemon.

long table scroll down

Hi, for viewing long tables. in my sql query when i say SELECT * FROM abc i miss the upper entries of the table as they scroll down. is there something by which i can view a table page by page(as | more in unix) thanx anil

Re: not able to edit table:((

The persmissions seems to be ok. ne other ideas!! - Original Message - From: "Kiss Dániel" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 11, 2002 12:59 PM Subject: Re: not able to edit table:(( >

not able to edit table:((

ext mydb.documentsrepair error"the 'documents' is read only Can someone help me thanx anil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: help with empty set

- Original Message - From: "Chris Hohimer" <[EMAIL PROTECTED]> To: "Anil Garg" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 2:26 PM Subject: Re: help with empty set > yeah that kinda works... > > what i have

Re: help with empty set

have u tried with \0 ?? - Original Message - From: "Chris Hohimer" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 05, 2002 1:54 PM Subject: help with empty set > using PHP what is the value for a returned result from MySQL of "empty > set" > ex: > > if($result != NULL)

changing column name

Hi Can anyone plz give me the query for chaning the column name of an existing table(which does not affect the elements of that column). I hope there is a way to do that. Any help appreciated Thanx Anil - Before posting

errno: 145

hi when i try to read a table using query > select * from it shows following error: cant open file:'anil.MYD'.(errno: 145) y such an error can come!! earlier it was fine. thanx for help anil - Before po

Re: STRING TO NUMBER

i think u dont need to it will automatically deal with it. - Original Message - From: "Marcel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 16, 2002 3:26 PM Subject: STRING TO NUMBER > Hi, > In Oracle i use TO_NUMBER to convert a String to a Number what Function Do i

Re: MySQL, PHP, Apache: /usr/libexec/ld.so: httpd: libmysqlclient.so.6.0: No such file or directory

, I think. Update your ports tree and reinstall the ports from source, and everything will work fine. -- Anil Madhavapeddy, <[EMAIL PROTECTED]> - Before posting, please check: http://www.mysql.com/manual.php (the manua

A newbie question

database name "test". I tried to run the command like this "mysql -u root test" and when i tried to add a user i ghot Error Table db.user does not exist. I am unable to understand the meaning of above Error. Please help me to understan

error in .frm file

OS is Linux latest version web server apache servlets apache jserv databse server MySql problem : when machine starts and all server starts any databse having more than 6 tables creates problem problem is column cln1, cln2 not found in aa.frm table when i shut down and start mysql se