Re: Refresh slave state

p=19297:4:105567988301604::NO:4:P4_ID:4541>, MySQL Certified Professional Percona MySQL Forum <http://www.percona.com/forums/> Community V.I.P. Email: m...@wagnerbianchi.com Skype: wbianchijr 2015-06-25 2:48 GMT-03:00 Ben RUBSON : > 2015-06-22 13:45 GMT+02:00 Ben RUBSON : > > > 2

Re: MySQL Variable size usage in shell prompt

Director <https://apex.oracle.com/pls/otn/f?p=19297:4:105567988301604::NO:4:P4_ID:4541>, MySQL Certified Professional Percona MySQL Forum <http://www.percona.com/forums/> Community V.I.P. Email: m...@wagnerbianchi.com Skype: wbianchijr 2015-06-16 10:28 GMT-03:00 Manivannan S : > Hi,

Re: MySQL 5.7 Innodb performans issue

default, IMHO, innodb_thread_concurrency=0, is better... -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE Director <https://apex.oracle.com/pls/otn/f?p=19297:4:105567988301604::NO:4:P4_ID:4541>, MySQL Certified Professional Percona MySQL Forum <http://www.percona.com/forums/> Community V.I.P. Email: m..

Re: MySQL 5.7 Innodb performans issue

.P. Email: m...@wagnerbianchi.com Skype: wbianchijr 2015-05-20 15:07 GMT-03:00 Jørn Dahl-Stamnes : > Hello > > (again I must say). > > Over a year ago I experienced a severe drop in the MySQL Innodb > performance after ugrading to MySQL > 5.6. I did not found any solution to th

Re: MySQL 5.7 Innodb performans issue

Additionally, take a look on this http://wagnerbianchi.com/blog/?p=982 as you're running mysql on SSD -- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE Director <https://apex.oracle.com/pls/otn/f?p=19297:4:105567988301604::NO:4:P4_ID:4541>, MySQL Certified Professional Percona MySQL

Re: deleting big tables

The problem was here: ---TRANSACTION 154B1E00, ACTIVE 265942 sec rollback mysql tables in use 1, locked 1 ROLLING BACK 297751 lock struct(s), heap size 35387832, 74438247 row lock(s), undo log entries 66688203 MySQL thread id 37, OS thread handle 0x7f11bc4b9700, query id 110 localhost pau query en

Re: Starting mysql 5.7.7

E Director <https://apex.oracle.com/pls/otn/f?p=19297:4:105567988301604::NO:4:P4_ID:4541>, MySQL Certified Professional Percona MySQL Forum <http://www.percona.com/forums/> Community V.I.P. Email: m...@wagnerbianchi.com Skype: wbianchijr 2015-05-15 4:57 GMT-03:00 Jørn Dahl-Stamnes :

Re: update and control flow

You can do that, but, perhaps the only chance to have it updating a row based on a condition is developing a Stored Procedure or even having a BEFORE Trigger associated with the main table. Those ways, you can test the sent value and decide on what UPDATE you will execute afterwards. Consider that

Re: mysql strangeness...

Very good share Reindl. -- *Wagner Bianchi, MySQL Database Specialist* Mobile: +55.31.8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014-12-08 12:05 GMT-02:00 Reindl Harald : > > Am 08.12.2014 um 14:56 schrieb Chris Knipe: > >> They have been dealt with.

Re: Query regarding implementation of parallel-replication

It's good to know. Keep up with good work, cheers!! -- *Wagner Bianchi, MySQL Database Specialist* Mobile: +55.31.8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014-09-06 3:01 GMT-03:00 Ajay Garg : > Hi Wagner. > > That is what I did as the last resor

Re: Strange observation in "OPTIMIZE TABLE" command in InnoDB

Are both instances running the same MySQL version and release? Are they MASTER and SLAVE, actively replicating? Are the InnoDB configurations currently running on both servers the same? -- *WB* 2014-09-06 6:00 GMT-03:00 Ajay Garg : > Sorry, forgot to specify the engine. > The table runs on InnoD

Re: Getting error while launching mysqld

Have you changed the default mysqld port? Could you share with us the below command output? $ my_print_defaults mysqld -- *Wagner Bianchi, MySQL Database Specialist* Mobile: +55.31.8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014-09-04 4:33 GMT-03:00 Banerjee

Re: 1045 Error accessing mysql db

ges; > > Try Login~~ > > Second.. Recreate user.. > > root#] mysql -u root -p > mysql > drop user foo; > mysql > create user 'foo'@'%' IDENTIFIED by ''; > mysql > grant all privileges on *.* to foo@"%" identified by &

Re: Query regarding implementation of parallel-replication

8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014-09-04 7:24 GMT-03:00 Ajay Garg : > Hi all. > > Unfortunately, I have run into the logs, as described at > http://bugs.mysql.com/bug.php?id=71495 > > Unfortunately, the issue does not go away, even after reverting b

Re: 1045 Error accessing mysql db

currently must be checked as well...could you let us now if you can log to MySQL using the mysql client? Something like: $ mysql -u foo -p Let us know, cheers!! -- *Wagner Bianchi, MySQL Database Specialist* Mobile: +55.31.8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014

Re: Replication problem

Based on the SHOW SLAVE STATUS output you've sent us, I'd suggest that you check what the application is doing, understand *why* the application is violating the PK of the table information_server.audit, repair the possible application problem and the, reconfigure the replication. It seems that th

Re: Replication problem

Hello guys, some points to check here: 1-) Is the master server configured with sync_binlog=1 ? 2-) About the SHOW SLAVE STATUS output, when slave seems to be just reading events from master, is the Exec_Master_Log_Pos incrementing or not? 3-) Why are you reconfiguring all the replication just bec

Re: How to get all known bugs on specified mysql version?

Why do not use GTID? Just curious...WB 2014-07-07 3:18 GMT-03:00 louis liu : > don't use GTID is my suggestion :) > > > > 2014-07-07 7:42 GMT+08:00 娄帅 : > > > Hi, all, > > > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > > on this version. Now i check the "bugfix"