Como monitorar o InnoDB Change Buffer

por I/O em I/O-Bound workloads. Abraço!! -- *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

Re: Como monitorar o InnoDB Change Buffer

Please, ignore last message, wrong list :) -- *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

Re: After long semaphore waits MySQL becomes unresponsive.

Just to confirm, is that MySQL 5.5.11? -- Wagner Bianchi Mobile: +55.31.8654.9510 > Em 11/03/2015, às 19:56, Michael Walker - Rotech escreveu: > > Same problem here... happens about once a month, since recent MySQL version > update > > http://qnalist.com/questions/4209635/af

Re: mysql strangeness...

-- *Wagner Bianchi, +55.31.8654.9510* Oracle ACE <https://apex.oracle.com/pls/otn/f?p=19297:4:331870797705::NO:4:P4_ID:4541>, MySQL Certified Professional Email: m...@wagnerbianchi.com Skype: wbianchijr 2014-12-08 11:56 GMT-02:00 Chris Knipe : > On Mon, Dec 8, 2014 at 3:02 PM, Wagn

Re: mysql strangeness...

In some past experiences, firewall can add a small overhead in connection establishment. If you're using iptables, you can try disable it for a second, test the connection establishment to check if the overhead is being added by the firewall and enable that afterwards. Let us know how's it goin

Re: mysql strangeness...

Hello Chris, Can pls you share the below command output... > SHOW STATUS LIKE 'Threads%'; > SELECT @@thread_cache_size, @@net_buffer_length, @@max_allowed_packet; What about the limits.conf config on operating system level? -- WB, MySQL Oracle ACE > Em 07/12/2014, às 20:03, "Chris Knipe" escr

Re: Indexes issue importing tablespaces

Did you check if an ANALYZE TABLE is enough in this case? -- Wagner Bianchi Mobile: +55.31.8654.9510 > Em 10/10/2014, às 09:06, Ruben Cardenal escreveu: > > > > Hi, > > I have this problem among several different instaces of 5.6.20. I take > all the s

Re: Proxy / connected failover question

I like HAProxy as well as it simplifies many of the things you seem to be looking for. -- Wagner Bianchi Mobile: +55.31.8654.9510 > Em 09/07/2014, às 07:48, "Heck, Walter" escreveu: > > Johan, > > I don't think there's any need for the heavyness (and ug

Re: Optimizing InnoDB tables

Hi Antonio, como esta? What's the mysql version you're running? Have you tried to ALTER TABLE x ENGINE=InnoDB? -- WB, MySQL Oracle ACE > Em 24/06/2014, às 08:03, Antonio Fernández Pérez > escreveu: > > ​Hi list, > > I was trying to optimize the InnoDB tables. I have executed the next query

Re: This just seems to slow

Multiple line insert is the better choice...it will be organized in transaction blocks of many lines and it will speed up data insertion. [bian...@mysql.com]# mysqldump -u root -p --all-databases -e > file.dump -e: extended-inserts Best regards. -- Wagner Bianchi 2011/1/3 Daevid Vinc

Re: MySQL raw files to .SQL

Did a tried MaatKit? MaatKit let you control over the number of threads dedicated to extract a MySQL backup. Best regards. -- Wagner Bianchi 2010/12/31 Lydia Rowe > In order to get a database into A .SQL file, I usually import the raw > files, .MYI and such, into a database and th

Re: my.cnf file

Please, forget my last note, I answered in a wrong thread! Sorry. Best regards. -- Wagner Bianchi 2010/12/31 Wagner Bianchi > Are you show about the non-outage operation with this command? > > Best regards. > -- > Wagner Bianchi > > > 2010/12/31 Sharl.Jimh.Tsin

Re: my.cnf file

Are you show about the non-outage operation with this command? Best regards. -- Wagner Bianchi 2010/12/31 Sharl.Jimh.Tsin > rpm -qpi mysql*.rpm | grep my.cnf > > Best regards, > Sharl.Jimh.Tsin (From China **Obviously Taiwan INCLUDED**) > > > > 2010/12/30 Lydia Rowe :

Re: /etc/init.d/mysql start WITHOUT integrity check?

atabases' integrity? => Yeah, there is! Open the debian script and comment all rows. Best regards. -- Wagner Bianchi 2010/12/30 Shawn Green > On 12/30/2010 5:00 PM, Daevid Vincent wrote: > >> Comment WHAT lines? >> >> I looked through /etc/init.d/mysql and don'

Re: my.cnf file

f, my-medium.cnf ...), use linux command line "cp" to copy it to /etc or /etc/mysql and restart mysqld. Could you check it? Best regards. -- Wagner Bianchi 2010/12/30 > Adam, > > you should look upon this as an opportunity to write a my.cnf that suits > your application and

Re: /etc/init.d/mysql start WITHOUT integrity check?

s check of was comment the lines inside the file script with # character. Please, let us know if it is the operation do you want to avoid when restart mysqld. Best regards. -- Wagner Bianchi 2010/12/30 > Daevid, > > I'm not quite sure I understand why you want to restart your

Re: Back-up Plan for Large Database

*You have no guarantee the data on the slave matches the master 100%.* * * Try it with *semi-synchronous* replication. Best regards. -- Wagner Bianchi 2010/12/27 Johnny Withers > Might want to check out LVM snapshots: > > > http://www.mysqlperformanceblog.com/2006/08/21/using-l

Re: Back-up Plan for Large Database

in case of MASTER fails and things like that. In advance to have ZMANDA as you backup tool, do you have server replicating data on you environment? Best regards. -- Wagner Bianchi 2010/12/27 Adarsh Sharma > Dear all, > > Back-up is the most important thing that need special attention.

Re: Table cache not being updated

Best regards. -- Wagner Bianchi 2010/12/22 杨涛涛 > How did you adjust this variable? Stay it in my.cnf or just set it? > David Yeung, In China, Beijing. > My First Blog:http://yueliangdao0608.cublog.cn > My Second Blog:http://yueliangdao0608.blog.51cto.com > My Msn: yueliangdao0...@gmail

Re: Trigger?

I think if you built a trigger to update value of foo's column after, this trigger will not be compiled cause it will execute two transactions on the same one. Try it... Best regards. -- Wagner Bianchi 2010/12/21 Jerry Schwartz > Aha! That was the clue I needed. Thank you so much. &g

Re: Discontinued AUTO_INCREMENT problem....

Too curious...could you share a SHOW CREATE TABLE from this table as requested before? Best regards. -- Wagner Bianchi 2010/12/21 杨涛涛 > Hi. > You can show us your show create table statement as well. > > > 杨涛 > 我博客1:http://yueliangdao0608.cublog.cn > My 我博客2:http:/

Re: Trigger?

t into testtrigger set id =100, foo =null; ERROR 1048 (23000): Column 'foo' cannot be null Did you get? Best regards. -- Wagner Bianchi 2010/12/20 Jerry Schwartz > I've never used a trigger before, and I want to make one that sounds like > it > should be simple. > &g

Re: INSERT DELAYED and logging

Yes, I'm to lazy to do it myself, what did you think :-p > > > On Tue, Nov 30, 2010 at 4:01 PM, Wagner Bianchi > wrote: > >> Friends, I did a benchmark regarding to this subject. >> Please, I am considering your comments. >> => http://wbianchi.wordpre

Re: INSERT DELAYED and logging

Friends, I did a benchmark regarding to this subject. Please, I am considering your comments. => http://wbianchi.wordpress.com/2010/11/30/insert-x-insert-delayed/ Best regards. -- WB 2010/11/30 Wagner Bianchi > Maybe, the table in use must be a table that is inside cache now - SHOW

Re: Log Mysql slow query into table

Have a look on it: mysql> show variables like '%slow%'; +-+--+ | Variable_name | Value| +-+--+ | log_slow_queries| OFF | | slow_launch_time

Re: INSERT DELAYED and logging

into a single table, so there's >> only >> > going to be a single delay thread for it anyway. >> > >> > Archive tables are a good idea, agreed, but I suspect that inserts into >> > that are going to be slower than into regular MyISAM because of the >

Re: INSERT DELAYED and logging

Well, analyze if you need to create an excessive overhead into the MySQL Server because a simple INSERT. What you must have a look is it: - How much data this connection is delivering to MySQL's handlers? - A word DELAYED in this case is making MySQL surfer? Perhaps, you are sophisticating

Re: [PHP] mySQL query assistance...

This is the general list. If your problem is with MySQL and queries, let us know. Best regards. -- WB 2010/11/29 Daniel P. Brown > On Mon, Nov 29, 2010 at 14:35, Don Wieland > wrote: > > Hi all, > > > > Is there a list/form to get some help on compiling mySQL queries? I am > > executing them

Re: From Maurizio Ponti, Switzerland

Hi Michael, I am not sure whether your UPDATE statement will affect all "root" users password or only which one that will access from a localhost. Best regards. -- WB 2010/11/29 Michael Dykman > as root, stop your mysql server in the normal way > ie :$ service mysqld stop > > run mysql explici

Re: From Maurizio Ponti, Switzerland

Start mysqld with --skip-grant-tables option, give an update on the root password, mentioning the new password the you want to put for your access with root user and be happy. Well, make some like this: shell> mysqld --skip-grant-tables Open another tty, terminal or prompt: shell> mysql mysql>

Re: How do I get a list of all defined UDF's known to the system?

---+ 1 row in set (0,00 sec) Wagner Bianchi 2010/2/8 Robert Gilland > Hi, > > > > Trying this SQL (SELECT * FROM INFORMATON_SCHEMA.ROUTINES) > > On MySQL 7.0 (C:\Program Files\MySQL\MySQL Server 7.0\bin) > > > > I get the following error: > > >

MySQL Proxy

-backend-addresses=localhost:3306 --proxy-lua-script=mc.lua" and made all tests again with port 4042. Once my tests fail. Anybody here use this and MySQL-Proxy function? Anybody can give some explanation how does it works? Thanks in advanced. Wagner Bianchi

MySQL Proxy

-backend-addresses=localhost:3306 --proxy-lua-script=mc.lua" and made all tests again with port 4042. Once my tests fail. Anybody here use this and MySQL-Proxy function? Anybody can give some explanation how does it works? Thanks in advanced. Wagner Bianchi

Re: Is table_open_cache a private cache of a session?

Sorry, *open_files_limit... 2010/2/1 Wagner Bianchi > Is FD_SETSIZE regards to an open_file_limit? > > WB > > 2010/2/1 Cui Shijun > > Got your idea. >> Thank you very much. Now I know how table cache works :-) >> >> For the bug, yes, it's

Re: Is table_open_cache a private cache of a session?

Is FD_SETSIZE regards to an open_file_limit? WB 2010/2/1 Cui Shijun > Got your idea. > Thank you very much. Now I know how table cache works :-) > > For the bug, yes, it's related to the value of FD_SETSIZE, which is > limited to 1024 at my RedHat box. > Maybe I should update it to a suitabl

Re: How to force Warning: #1048 Column cannot be null to Error

mysql> SET sql_mode = TRADITIONAL; Query OK, 0 rows affected (0.02 sec) Then the insert query will fail and the row will not be added to the table...see you. Wagner Bianchi 2010/1/30 Claudio Nanni > Take a look at SQL_MODE ;) > > Claudio > > On Jan 30, 2010 5:05 PM, &

Re: I would like to post on lists.mysql.com

Hi, if you did your subscription in any lists, you will automatically added to send and receive e-mails from professionals that are connected in it. See lists here: http://lists.mysql.com/ Wagner Bianchi 2010/1/30 Daniel Brown > On Sat, Jan 30, 2010 at 01:49, Vikram A wrote: > > D

Re: WAMP vs LAMP

Unix only* PIPE Named-pipe connection to local or remote server Windows only MEMORY Shared-memory connection to local server Windows only *Source*: http://dev.mysql.com/doc/refman/5.0/en/connecting.html -- Wagner Bianchi 2010/1/29 Jerry Schwartz >*From:* Wagner Bianchi [mailto:wagner

Fwd: how to switch between users

On other SGBDs you can issue: sqlplus> conn other_user; But, using MySQL you can't do it...start new connection. -- Wagner Bianchi - Web System Developer and Database Administrator Phone: (31) 8654-9510 / 3272-0226 E-mail: wagnerbianch...@gmail.com Lattes: http://lattes.cnpq.br/20410677

Re: how to dump database or tables

a value big enough and don't worry, start restore and be happy. *See it on manual:* http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html -- Wagner Bianchi - Web System Developer and Database Administrator Phone: (31) 8654-9510 / 3272-0226 E-mail: wagnerbianch...@gmail.com Lattes

Re: Event feature already working in Server 5.1.37

Hi friends, This isn't rarelly to see...its common on these days. Get this: http://dev.mysql.com/tech-resources/articles/mysql_on_windows.html WB 2010/1/27 Shawn Green > Daevid Vincent wrote: > >> -Original Message- >>> From: Dan Nelson [mailto:dnel...@allantgroup.com] Sent: Monday, Ja

Fwd: auto_increment without primary key in innodb?

Yeah, Paul... This is so clear...the auto_increment column may be indexed like: - KEY(); - UNIQUE(); - PRIMARY KEY() ...when you create or alter a table. -- Wagner Bianchi 2010/1/25 Paul DuBois The requirement is that it be indexed. The index need not be a primary key. > >

Re: Problems with slave_skip_errors on replication

l skip the your error as the error number is 1062 and all will > skip all the errors. > > You have to mention specific error numbers to skip the same. > > > -- > Thanks > Suresh Kuna > MySQL DBA > > > > On Mon, Jan 25, 2010 at 6:06 PM, Wagner Bianchi > wrote:

Problems with slave_skip_errors on replication

835E341D18011D25Z', now(), 'x', 'x.sp', null)' 1 row in set (0.00 sec) Have other thing to do, or this problem is made by the mix of versions? Best regards! -- Wagner Bianchi - Web System Developer and Dat

Res: MySQL purge logs

mysql> reset master; Wagner Bianchi Diretor de Tecnologia - INFODBA C&T [EMAIL PROTECTED] - (31) 3272 - 0226 / 9114 - 7695 - Mensagem original De: Kaushal Shriyan <[EMAIL PROTECTED]> Para: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Enviadas: Domingo, 11 de Maio de

Res: Table Locking (Was: Best CPU config for a busy DB server)

Locking will ocours with MyISAM tables when INSERT, UPDATE, DELETE or REPLACE statemats arrive that tables, lock at the table level. In INNODB engine, a lock ocours at the row-level. BDB have lock at the page-level. Wagner Bianchi Diretor de Tecnologia - INFODBA C&T [EMAIL PROTECTED] -

Res: German collation for UTF8 missing

Hi Friend, Try this: CHARACTER SET: latin1 COLLATION: latin1_german2_ci Cya! Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & Consulting [EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803 - Mensagem original De: Yves Goergen <[EMAIL PROTECTED]> Para: Mart

Res: german datetime format?

You can treat it with DATE_FORMAT() and TIME_FORMAT(), change the format of MySQL variable, don't have way. You have to make a explicity convertion. ;-) Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & Consulting [EMAIL PROTECTED] - (31) 3272 - 0226 / 84

--shared-memory, ??

Hi friends, I'm read somethings about the MySQL works with the option --shared-memory on Windows and about this I have some doubts. Anybody here know explain what are the chages compered without the parameter? Thk`s... Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & C

DOCUMENTATION ABOUT SHOW PROFILE

Hi friends, Somebody here in this list have or knows where i get or read about the PROFILE of MySQL (SHOW PROFILE) ? I see this article of Schummi, but is most superficial. (http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html) Can u help me? Thk's 4 all. W

Res: MySQL only listens on localhost

After check the my.cnf, how said by friend Patricio, give the GRANT ALL ON *.* TO root@'%'; for thet user do the remote connections. For some doubts, keep on list! Bye! Wagner Bianchi Diretor de Tecnologia - INFODBA Technologies & Consulting [EMAIL PROTECTED] - +55 (31) 3272

CONCEPTS ABOUT PRIVILEGES!

new user, that don't have the global privileges!" Maybe, I think is not correctly, cause that new user have a USAGE privileges ok, and have the possibles privileges revoked in this moment. In resuming, the user have all global privileges, but, revoked! What you think about that