Re: Very strange issue while trying to login remotely

Sorry, The user had multiple passwords set up in mysql.user table. Clearing the "other" passwords solved the issue. Sorry for the inconvenience. Thanks and Regards, Ajay On Mon, May 25, 2015 at 8:54 PM, Ajay Garg wrote: > Hi All. > > I have two servers, 1.2.3.4 and 5.6.7.

Very strange issue while trying to login remotely

Hi All. I have two servers, 1.2.3.4 and 5.6.7.8 I wish to login remotely FROM 1.2.3.4 onto 5.6.7.8. a) On 5.6.7.8, mysql> show grants for 'root'@'%'; +-+ | Grants for root@% | +

Re: Query on some MySQL-internals

Hi Martin. Thanks for the reply. As I had mentioned, we are running both the instances since last 6 years or so, and the records are inserted/deleted on both the instances. So, we did a "show table status like 'XX' \G;" on both the instances, and following are the outputs (here "XX" is

Strange observation in "OPTIMIZE TABLE" command in InnoDB

Sorry, forgot to specify the engine. The table runs on InnoDB backend. Also, changed the subject to be more specific. On Sat, Sep 6, 2014 at 2:26 PM, Ajay Garg wrote: > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same

Query on some MySQL-internals

Hi all. We are facing a very strange scenario. We have two mysql-instances running on the same machine, and they had been running functionally fine since about 6 years or so (catering to millions of records per day). However, since last few days, we were experiencing some elongated slowness on

Re: Query regarding implementation of parallel-replication

> > If you're not comfortable to do that, just share the SHOW SLAVE STATUS > output with us. > > Let us know how's it going, cheers!! > > > > > -- > Wagner Bianchi, MySQL Database Specialist > Mobile: +55.31.8654.9510 > E-mail: m...@wagne

Re: Query regarding implementation of parallel-replication

o how we may get the mysql+replication up and running (even with the plain old non-multi-threaded mode)? On Tue, Sep 2, 2014 at 12:57 PM, Ajay Garg wrote: > Thanks Akshay for the reply. > > On Tue, Sep 2, 2014 at 12:25 PM, Akshay Suryavanshi > wrote: >> Hello Ajay, >> &

Re: Query regarding implementation of parallel-replication

r sql worker thread. > > This is a good feature added in mysql, however still needs to go through lot > of testing. Please share your observation and findings in case it differs > from the above. > > Cheers!!! > Akshay > > > On Mon, Sep 1, 2014 at 8:27 AM, Ajay Garg w

Re: Query regarding implementation of parallel-replication

Ping !! :) On Mon, Sep 1, 2014 at 8:27 AM, Ajay Garg wrote: > Hi all. > > > We have replication set-up, where we cater to HUUGEE amounts of data. > Since quite some time, we have been facing issues wherein the slave > lags behind master quite a lot. > > > So, yest

Query regarding implementation of parallel-replication

Hi all. We have replication set-up, where we cater to HUUGEE amounts of data. Since quite some time, we have been facing issues wherein the slave lags behind master quite a lot. So, yesterday we were able to setup parallel replication, by incorporating the following changes :: a) To begin with

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

On Thu, Apr 17, 2014 at 3:03 PM, Manuel Arostegui wrote: > > > > 2014-04-17 11:11 GMT+02:00 Ajay Garg : > > On Thu, Apr 17, 2014 at 2:28 PM, Reindl Harald > >wrote: >> >> > >> > >> > Am 17.04.2014 10:55, schrieb Ajay Garg: &

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

On Thu, Apr 17, 2014 at 2:28 PM, Reindl Harald wrote: > > > Am 17.04.2014 10:55, schrieb Ajay Garg: > > I do understand the meaning of Unix "sync" function. > > > > So, you mean to say that "flushing" and "syncing" are same, in the > c

Re: Difference between log-buffer "flushing" and "log-buffer" syncing?

Reindl, I do understand the meaning of Unix "sync" function. So, you mean to say that "flushing" and "syncing" are same, in the context of MySQL? On Thu, Apr 17, 2014 at 2:15 PM, Reindl Harald wrote: > > Am 17.04.2014 10:37, schrieb Ajay Garg: > > I

Difference between log-buffer "flushing" and "log-buffer" syncing?

Hi all. I am a newbie to MySQL, and have been going through several online resources. I usually come across the terms - "flushing" and "syncing" the log-buffer. In particular, these two terms hold great significance while selecting the value of "innodb_flush_log_at_trx_commit