On Tue, Apr 13, 2010 at 2:21 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
hi all
what is the difference between
OPTIMIZE TABLE tablename;
and
ANALYZE TABLE tablename;
thank you
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
--
Thanks
Suresh Kuna
MySQL DBA
hi all
what is the difference between
OPTIMIZE TABLE tablename;
and
ANALYZE TABLE tablename;
thank you
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
;
This action only analyze table and stores the key distribution for a table.
2010-04-13
--
River wubx
Gtalk: wubin...@gmail.com
http://www.mysqlsupport.cn
China
--
*发件人:* F.A.I.Z.A.L
*发送时间:* 2010-04-13 16:52:28
*收件人:* mysql; mysql-help
Hi *
mysqld process consuming more 100% of cpu usage and execution time also very
high.
1. how to reduce CPU?
2. why mysqld process consuming high cpu utilization?
3. Wether need to fine tune sql application. then how to use plan table in
mysql?
4. which storage engine is better for transaction?
Hi All
please help me to reduce mysqld cpu load.
mysql 4.1 running on solaris 10 with 4gb ram. front end apps is php (apache
server). everyday mysql reach about 100% cpu load. can one help to fix this
issue...
thank you.
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
...
thanks again..
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Jan 14, 2010 at 4:13 PM, Joerg Bruehe joerg.bru...@sun.com wrote:
Hi Faizal, all!
F.A.I.Z.A.L wrote:
hi
anyone can help. its urgent. iam trying to start mysql server but it is
not
starting
hi
can anybody help me to check this query is written in good way
select ATX_Status.Server as `Server`, ATX_Status.Load as
`Load`,ATX_Status.System as `System`,
atx.ATX_Status.Timestamp as `TimeStamp`, `Coverage`,
atx.ATX_Summary.Testware as `View`, `Traffic`,
ATX_Status.Status as `Status`,
hi
anyone can help. its urgent. iam trying to start mysql server but it is not
starting.
bash-2.03# ./mysqld_safe
[2] 3422
bash-2.03# Starting mysqld daemon with databases from /usr/local/mysql/var
STOPPING server from pid file /usr/local/mysql/var/andd141.pid
100114 11:31:22 mysqld ended
log
Kumar anan...@gmail.com wrote:
what is your my.cnf setting.
Also did u check slowquery.log for any sql's not using index or not using
the right index.
On Mon, Jan 11, 2010 at 1:21 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
Hi
mysqld process taking high cpu utilization (100%), how
= /var/lib/slowqueries.log.
Or execute
SHOW ENGINE STATUS\G;
You will get to know what all activities are going on ur db and check if
there is any IO contention happening
On Mon, Jan 11, 2010 at 2:47 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
Hi Kumar,
thanks for your reply.. here
Hi
mysqld process taking high cpu utilization (100%), how to reduce the cup
utilization
it is running under solaris 8 with 16GB ram and 1 multicore cpu (2 core)
anyone help please?
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
on the queries that your application
hits the database.
On Thu, Jan 7, 2010 at 12:20 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
hi Suresh
thanks. max_connection=100(default). so, it won't allow user more than
100?
and one more clarification. i am facing performance issue in mysqld. some
hi
i can see many 'updates' is going every min. so is it good to increase this
query_cache_size ?..
what are the other action i can take to improve the performance of mysql
server
environment
version : 5.0.22
platform : redhat 5
Cheers
Faizal S
GSM : 9840118673
Blog:
Dear all
I can see max_connection and max_user_connection set to default value. but
daily i can see 40 to 70 users connection to the database. how? when
max_user_connections=0. what is the different between these two parameters..
max_connection=100
max_user_connections=0
thanks in advance.
sureshkumar...@gmail.comwrote:
Hi Faizal,
Max_connections are the connections for the overall MySQLD server.
Max_user_connections are the connections for the particular user ( i.e for
an account ) of the MySQLD server.
Suresh Kuna
MySQL DBA
On Thu, Jan 7, 2010 at 11:00 AM, F.A.I.Z.A.L sac.fai
hi All
how we can allocate memory for mysql database. since we have different
storage. each having its own buffer for running the query.
in oracle we have some calculation for allocating sga size,like this any
method is exist for mysql.
i am seeing mysql is using default 8m for all (myisam and
HI experts
I am facing performance issue for last couple of months. it taking more time
to execute query..
developers created tables on myIsam and Innodb. i have a doubts whether we
can use both storage same time..
i have 2 thinks in my minds to check this performance.
1. to check innodb and
://oradbapro.blogspot.com
On Wed, Nov 18, 2009 at 11:50 AM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
HI experts
I am facing performance issue for last couple of months. it taking more
time to execute query..
developers created tables on myIsam and Innodb. i have a doubts whether we
can use
hi iam trying to start mysql services but it showing error. while i start it
automatically goes to shutdown..
what is errmsg.sys? its looking this file but it was not there.. please help
to fix this..
..
any idea
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
2009/11/11 Benedikt Schackenberg schackenb...@termindoc.de
Check that your my.ini or my.cnf has the correct entry for the Basedir
option.
F.A.I.Z.A.L schrieb:
hi iam trying to start mysql services
://oradbapro.blogspot.com
2009/11/11 Benedikt Schackenberg schackenb...@termindoc.de
hi,
exists this folder on your System?
/var/LRM-INSTALL/ams/software/lrm_2.0.0.0_9.0.0.0-76641/server/mysql/mysql-5.1.34-solaris10-sparc-64bit
F.A.I.Z.A.L schrieb:
hi
thanks for your reply,,
i can see
Prajapati
prajapat...@gmail.com wrote:
Hi faizal,
Check your mysql error log file.
Thanks,
Krishna
On Wed, Nov 11, 2009 at 4:17 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
hi iam trying to start mysql services but it showing error. while i start
it
automatically goes to shutdown..
what
hi experts
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
iam facing the above error while connecting the mysql database. i am also
checked the mysql.sock socket file is not in /tmp.
could you please help me to fix this problem. what i have to do
Hi
thanks for your reply.
i found the problem, the problem was due to maintenance activity IT team
rebooted the machine but they didn't start the mysql server after reboot.
i executed mysqld with root credit. i got the below output but still the
cursor not return to prompt
bash-2.03#
Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Thu, Oct 1, 2009 at 11:09 AM, prabhat kumar aim.prab...@gmail.comwrote:
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
DML
query or also want DDL operations.
http://dev.mysql.com/doc/refman/5.1/en/privileges-provided.html
On Thu, Oct 1, 2009 at 12:08 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
thanks kumar..
now its working
i have another doubt
i created an user with limited privilege on particular
location in /etc/my.cnf file ,
datadir variable.
4. Start MySQL.
note: *datadir=/path/to/datadir/mysq*l
http://docdb.fnal.gov/doc/my.cnf.html
On Thu, Oct 1, 2009 at 12:53 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
hi Kumar
thanks for your info..
another doubt.. which storage
, 2009 at 2:10 PM, F.A.I.Z.A.L sac.fai...@gmail.com wrote:
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
, 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 sac.fai...@gmail.com
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
hello experts
I am new to mysql. in my server mysql application is installed just like
that. there is no proper driectory strutured maintained.
now my question is. how can i find the datafiles, archive files, backup
location.
i don't have root authentication. is it possible to login to the
451238
Email j...@butterflysystems.co.uk
Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer
---
Sent from HP IPAQ mobile device.
-Original Message-
From: F.A.I.Z.A.L sac.fai...@gmail.com
Sent: Wednesday, September
hi tonies
no, i don't see this portal before. for my quick view, can u please answer
my question in previous email..
thanks for ur link..
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Sep 30, 2009 at 3:46 PM, Martijn Tonies m.ton...@upscene.comwrote:
Hi,
hi tonies..
you mistaken me. I am exploring many forums and discussion. these questions
are only my doubts. iam started to explore mysql.com. but i need some quick
inputs to complete my task. if u or anyone experienced in mysql can answer
this because iam sitting in urgent task.
anyways thanks
hi Daisley
thanks for your answers
Best Regards
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Wed, Sep 30, 2009 at 4:20 PM, John Daisley
j...@butterflysystems.co.ukwrote:
Basic answers under each of your questions below
-Original Message-
From: 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:
36 matches
Mail list logo