provide the output of the below query.
Select user, host, password from mysql.user;
Thanks
Vikas Shukla
Mail Sent from my Windows Phone From: Reindl Harald
Sent: =E2=80=8E14-=E2=80=8E01-=E2=80=8E2014 01:38
To: mysql@lists.mysql.com
Subject: Re: Access denied for user 'root'@'localhost' (using
Hi Russ,
Please share with us the exact details of the table data as well as the
o/p.
Regards,
ViXiD
Vikas Shukla
Mail Sent from my Windows Phone From: Russ Lavoie
Sent: 27-12-2013 23:32
To: mysql@lists.mysql.com
Subject: MySQL Descending ORDER issue
Hello,
I am currently upgrading from mysql
Hi,
No, it does not represents the time from request to response not does
it includes the time that is spent in waiting for the locks to be
released.
The slow query log consists of SQL statements that took more than
long_query_time seconds to EXECUTE. The default value of
long_query_time is 10.
Hi claudio,
The best value for innodb buffer pool size is considered to be 60 to 70 percent
of ram.
So in your case, this must be around 4 gb.
That would work better.
Regards.
Vikas
-Original Message-
From: Claudio Nanni claudio.na...@gmail.com
Sent: 16-05-2013 14:12
To: Rafał
16.05.2013 11:01, schrieb Vikas Shukla:
The best value for innodb buffer pool size is considered to be 60 to 70
percent of ram.
So in your case, this must be around 4 gb.
That would work better.
hwo would a innodb_buffer_pool larger than the whole database
make anything better? the best value
.
Regards
Vikas shukla
-Original Message-
From: Rick James rja...@yahoo-inc.com
Sent: 10-05-2013 07:24
To: Bruce Ferrell bferr...@baywinds.org; mysql@lists.mysql.com
mysql@lists.mysql.com
Subject: RE: Slow Response -- What Does This Sound Like to You?
1. MyISAM locks _tables_. That can
Hi ,,
It would be helpful if you could share the error messages.
Do any of these:
1) Add these lines to my.cnf file:
expire_logs_days = 7
2) Or Try this
log-bin=OFF
or simply u can comment the lines related to the log-bin.
3) Other than this,
if you are using
Hi,
Use LIMIT 1 to limit the number of output to single record.
Regards,
Vikas Shukla
On Wed, Aug 1, 2012 at 3:56 AM, Paul Halliday paul.halli...@gmail.comwrote:
On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete halukkaram...@gmail.com
wrote:
I've got a text field called source_recid
