Re: SELECT locking tables.... in other databases

Hi David, can you please let me know what is the select query and the update query along with the explain plan of the same. can you please let me know if you are using innodb storage engine? Regards, Chandru www.mafiree.com On Thu, Nov 27, 2008 at 4:45 PM, David Scott <[EMAIL PROTECTED]>wrot

RE: How to delete all rows....

Hi, I prefer using TRUNCATE statement. syntax: TRUNCATE [TABLE] tbl_name This takes lesser time when compared to the delete from table. It takes hardly few seconds. take a backup before executing this if required. Regards, N.Pradeep Chandru. -Original Message- From: Peter Lauri [mai

Re: Need help in recreating .MYD files

hi, Just to add up i have read some where ( i assume in the mailing list only) that OS recognizes the file based on few codes added at the starting / ending of a file. So there are ways to create a MYD file through vi editor as well (this is not from the angle of restoring the data in that

Re: How to repair a table,

Hi, I think the syntax is to be verified. myisamchk * * -u root -p * ///*.* mysql will accept only if the passwords is next to "-p" option **: some frequently used options are mentioned below -r, --recover -o, --safe-recover -e, --extend-check -q, --quick -S, --sort-index -f, --force ( to b

ndbd --initial startup issues in mysql cluster

onnect from any host) id=5 (not connected, accepting connect from any host) As you can find here even the first data node is not connected. i have installed cluster from "mysql-max-5.0.20-linux-i686-glibc23.tar.gz" Can any one help me in solving this issue? Thanks in advance. -pradeep

increased disk ops after alter table

f so, what should i do to fix it? Your responses would be greatly appriciated. thanks, -pradeep PS: The InnoDB buffer pool size was also increased to 800MB after the alter table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

Rollup Query?

TIMESTAMP2 302ok2 TIMESTAMP4 how do I do that? Should I use with rollup if so on what columns.? Regards Pradeep Kumar _ Easiest Money Transfer to India. Send Money To 6000

Re: get one for each row

Try this Table : col1 : col2 1. Hotel 1 $col2 } ?> Pradeep Naharonline.com - Original Message - From: "savaidis" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 1:37 PM Subject: get one for each row > &

Starting problem with safe_mysqld

:51 mysqld ended Can anybody please put some light over this and guide me where i am going wrong. Thanks in advance Pradeep~ - Before posting, please check

Search Engine Query

Hi List, Can anyone tell me how do i create a search engine query.? I am new to Mysql and know how to use a simple select * from "" where "" = ""; but what about if I need to create a query for a search engine that looks for Every word. Thanks in Advance Prad

Downloading MySql

Dear sir , I was browsing the whole site to down load the windows NT version of mysql but i could not get any proper guidence or the proper downloading page.. could u please guid me in downloading mysql.. Thanking you. Pradeep Rangdal Cybage Software Ltd Pune