RE: Access denied for user 'root'@'localhost' (using password:

2014-01-13 Thread Vikas Shukla
fer-Encoding: quoted-printable Please 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 den

RE: MySQL Descending ORDER issue

2013-12-27 Thread Vikas Shukla
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

RE: Are There Slow Queries that Don't Show in the Slow Query Logs?

2013-05-30 Thread Vikas Shukla
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. Th

RE: Innodb innodb_buffer_pool_size?

2013-05-16 Thread Vikas Shukla
Sorry I failed to specify ghatna is only applicable when the database is quiet large. Vikas -Original Message- From: "Reindl Harald" Sent: ‎16-‎05-‎2013 14:43 To: "mysql@lists.mysql.com" Subject: Re: Innodb innodb_buffer_pool_size? Am 16.05.2013 11:01, schrieb

RE: Innodb innodb_buffer_pool_size?

2013-05-16 Thread Vikas Shukla
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" Sent: ‎16-‎05-‎2013 14:12 To: "Rafał Radecki" Cc: "mysql@lis

RE: Slow Response -- What Does This Sound Like to You?

2013-05-09 Thread Vikas Shukla
. Regards Vikas shukla -Original Message- From: "Rick James" Sent: ‎10-‎05-‎2013 07:24 To: "Bruce Ferrell" ; "mysql@lists.mysql.com" Subject: RE: Slow Response -- What Does This Sound Like to You? 1. MyISAM locks _tables_. That can cause other connect

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Vikas Shukla
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 se

Re: query help

2012-08-01 Thread Vikas Shukla
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 wrote: > On Tue, Jul 31, 2012 at 7:02 PM, Haluk Karamete > wrote: > > I've got a text field called source_recid. It stores half string hal