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 'group

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

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

connection issue

Anil DBA

problem with grant

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

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

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 cache . please

RE: problem with grant

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 granted all privileges to a user

Mysql crash due to page corruptions

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

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 have

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 Subject

RE: backup/restore

=1000; 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

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

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: 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 dumpfile name; SET FOREIGN_KEY_CHECKS = 1; then execute the following command mysql filename Thanks Anil DBA -Original Message- From: Heikki Tuuri

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 command

RE: Need more info about currently running queries

Anil -Original Message- From: Greg Fortune [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 22, 2004 1:34 AM To: mysql@lists.mysql.com Subject: Re: Need more info about currently running queries Yep, mysqladmin can give the same info. As noted in my original message, I need much

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

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 #server-id = 1

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: 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: 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 deal

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

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

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

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

RE: max allowed packet error

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 the max

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]

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

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

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]

RE: MySql Configuraton on Redhat

use the command below mysqladmin -u root -p options 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

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 12:16 AM

RE: Read-Only DB User

in command Anil DBA -Original Message- From: Lee Zelyck [mailto:[EMAIL PROTECTED] Sent: Monday, October 11, 2004 7:30 AM To: [EMAIL PROTECTED] Subject: Read-Only DB User Hi All, I'm sorry to access such a basic question, but I couldn't find a specific answer to it in the mysql manual

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]

Reg : eliminating duplicate entries

file with the following options mysql databasename --force dumpfilename Thanks Anil DBA -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

mysql installation problem

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 directly pkg_add?). -- MySQL General Mailing

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 check: http

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 fields mught

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: 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 10:14:29

mysqldump

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 needed from me

command line exectution of query(newbie)

Hi, What am i doing wrong: # ./mysql database name -e delete * from table name 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

RE: command line exectution of query(newbie)

Sorry, # ./mysql database name -e delete from table name 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:38 PM

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

database query.

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/ (the list archive

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 me

cant connect to mysql

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 thread, e-mail

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

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

Supplied argument is not a valid MySQL result resource!!

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

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: [EMAIL PROTECTED] Sent: Thursday

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:40 PM Subject: Re: Supplied argument is not a valid

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 5:41 PM Subject: Re: Supplied argument is not a valid MySQL result

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: michael

mysql upgrade

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/ (the list

mysql upgrade

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.com

Re: UPDATE command..

update table name 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.. I have two collumns in my mysql database like

' giving problem while inserting in table.

suggest a solution to this. thanx and regards anil [please ask if i havent explained the problem fully] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

replace query

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 archive) To request this thread, e

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: 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: [EMAIL PROTECTED] Sent: Tuesday, July 02

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: Anil Garg [EMAIL

Lost Connection to mysql server during query

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 anyone help me by telling wots going wrong here!! thanx anil

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

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. thanx anil

not able to edit table:((

mydb.documentsrepair errorthe '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/ (the list

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:(( Greetings, Stop the MySQL server and check

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){ do this

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 is $result = mysql($database select x, y, z from $table

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 table name 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 posting

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 have

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

the ports from source, and everything will work fine. -- Anil Madhavapeddy, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

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