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
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
-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
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
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
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
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
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
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
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,
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.
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
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
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
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:
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):
16 matches
Mail list logo