Transations? (was: Re: login issue..pls help)

2009-10-03 Thread Martijn Tonies
Hi, (better change the message subject if you change, well, the subject) user will create more number of tickets per day. so INSERT, UPDATE, SELECT will use highly. in document says' Myisam will not support transaction but it has self backup and restoration method. but in InnoDB good for

GRANT USAGE (was: Re: login issue..pls help)

2009-10-03 Thread Martijn Tonies
what is the purpose of 'Grant usage ' command http://search.mysql.com/search?site=refman-50q=grant+usagelr=lang_en Check the documentation, if you have more questions after that, get back to us. With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database

RE: login issue..pls help

2009-10-02 Thread LIU YAN
-transactions.html best regards liuyann From: sac.fai...@gmail.com Date: Thu, 1 Oct 2009 15:06:54 +0530 Subject: Re: login issue..pls help To: aim.prab...@gmail.com CC: mysql@lists.mysql.com user will create more number of tickets per day. so INSERT, UPDATE, SELECT will use highly

Re: login issue..pls help

2009-10-02 Thread Michael Dykman
This particular reference is little too vague to be of much use. MyISAM may outperform innodb in signle process situations but in contentious mixed read/write traffic (suchas a typical webapp), innodb is much faster for a variety of reasons. 13.1. Comparing Transaction and Nontransaction

Re: login issue..pls help

2009-10-01 Thread F.A.I.Z.A.L
thanks kumar.. now its working i have another doubt i created an user with limited privilege on particular schema. schema name: test *mysql create user 'test'@'%' identified by 'test'; mysql grant select,insert,update,delete,create,drop on test.* to 'test'@ '%';* after that i login with

Re: login issue..pls help

2009-10-01 Thread prabhat kumar
a. INFORMATION_SCHEMA is the information database ie metadata, the place that stores information about all the other databases that the MySQL server maintains. Inside INFORMATION_SCHEMA there are several read-only tables. They are actually views, not base tables, so there are no files associated

Re: login issue..pls help

2009-10-01 Thread F.A.I.Z.A.L
hi Kumar thanks for your info.. another doubt.. which storage engine is best for transaction.. in my server. the default engine is myisam. now i changed one of my schema to innoDB. is that correct. now i want to create another schema in different location. how to create that? because current

Re: login issue..pls help

2009-10-01 Thread prabhat kumar
A. For transaction *innoDB* is best. B. *ALTER TABLE table_name ENGINE = InnoDB; * but* *if you tons of tables so better export all tables in file and replace all occurs of *myisam* with *InnoDB *the import it. and enable InnoDB engine. http://www.linux.com/archive/articles/46370 C. 1. Stop

Re: login issue..pls help

2009-10-01 Thread F.A.I.Z.A.L
thanks kumar. Storage in datadir contain only one location.is it possible to have multiple location to store datafiles.if yes, how? what is the different between storage engine and tablespace in mysql? account creation *create user 'test'@'%' identified by 'test'; grant usage on test.* to

Re: login issue..pls help

2009-10-01 Thread F.A.I.Z.A.L
1 doubt the front end application is lab ticketing system. so user will create many ticket. iam expecting per day 200k ticket user will create. so which storage engine is best to use. innodb or myisam..? Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Thu, Oct 1,

Re: login issue..pls help

2009-10-01 Thread prabhat kumar
a. at Linux level you can make soft link to database dir to particular database ie schema. I don't is it possible at mysql level? b. There is no relation between storage engine and table space. Yes, Innodb uses tablespace you can read more on both. c.

Re: login issue..pls help

2009-10-01 Thread prabhat kumar
innodb. Since, If there are many modifications of the data, it's said that InnoDB works faster because it uses row locking instead of table locking, like MyISAM. However, if there are mainly SELECT statements, a MyISAM table might be faster. On Thu, Oct 1, 2009 at 2:33 PM, F.A.I.Z.A.L

Re: login issue..pls help

2009-10-01 Thread F.A.I.Z.A.L
user will create more number of tickets per day. so INSERT, UPDATE, SELECT will use highly. in document says' Myisam will not support transaction but it has self backup and restoration method. but in InnoDB good for transaction but no self managed backup and restoration.. now how can i choose

Re: login issue..pls help

2009-10-01 Thread F.A.I.Z.A.L
hi kumar what is the purpose of 'Grant usage ' command Best Regards Faizal S GSM : 9840118673 Blog: http://oradbapro.blogspot.com On Thu, Oct 1, 2009 at 3:06 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote: user will create more number of tickets per day. so INSERT, UPDATE, SELECT will use

login issue..pls help

2009-09-30 Thread F.A.I.Z.A.L
Hi iam getting the following error while login into mysql server. andd141# mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) Can someone please help me understand why I am not able to login from root? Best Regards Faizal S GSM : 9840118673 Blog:

Re: login issue..pls help

2009-09-30 Thread prabhat kumar
Use : mysql -u root -p (it will prompt for password) and if its not a local host also add -h ipaddress On Thu, Oct 1, 2009 at 11:01 AM, F.A.I.Z.A.L sac.fai...@gmail.com wrote: Hi iam getting the following error while login into mysql server. andd141# mysql -u root ERROR 1045 (28000):