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

> -Original Message- > From: Vikas Shukla [mailto:myfriendvi...@gmail.com] > Sent: Thursday, May 30, 2013 7:19 PM > To: Robinson, Eric; mysql@lists.mysql.com > Subject: RE: Are There Slow Queries that Don't Show in the > Slow Query Logs? > > Hi, > >

RE: [>Suspected Spam<][Characteristics] Re: NET START MYSQL QUESTION?

> why not answer the question another user made hours ago? > under which account do you try to start mysqld? > Agreed. Chances are good that if he goes into the Windows Services control panel and gets the properties of the mysql service, he will find that it is configured to start under a Windo

RE: [>Suspected Spam<][Characteristics] RE: Slow Response -- What Does This Sound Like to You?

> > 1. MyISAM locks _tables_. That can cause other connections > to be blocked. Solution: switch to InnoDB. Caution: There > are a few caveats when switching; see > https://kb.askmonty.org/en/converting-tables-from-myisam-to-innodb/ > > 2. As mentioned by Shawn, the Query Cache can be more

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

> -Original Message- > From: Wm Mussatto [mailto:mussa...@csz.com] > Sent: Thursday, May 09, 2013 3:50 PM > To: Robinson, Eric > Cc: Rick James; mysql@lists.mysql.com > Subject: RE: Slow Response -- What Does This Sound Like to You? > > On Thu, May 9, 2013 15:

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

> > > -Original Message- > > From: Robinson, Eric [mailto:eric.robin...@psmnv.com] > > Sent: Thursday, May 09, 2013 1:58 PM > > To: mysql@lists.mysql.com > > Subject: Slow Response -- What Does This Sound Like to You? > > > > We have a s

Managing ODBC on Linux? What Happened to myodbc3i?

We usually manage ODBC data sources on Linux using the myodbc3i utility that came with mysql-connector-odbc-3.51.30-1.rhel5.i386.rpm. When we upgraded to mysql-connector-odbc-5.1.10-1.rhel5.i386.rpm, it removed the myodbc3i utility. What GUI tool is now recommended to managing ODBC connections o

RE: InnoDB and rsync

> * flush atbles > * rsync while mysqld is running > * stop mysqld > * second rsync > Unless we can verify 100% that there is a safe way to do it without shutting down MySQL, then I'm sure the approach you described above is the one we will end up with. Thanks for your input. -- Eric Robinson

RE: InnoDB and rsync

> And you will build your business on a hotcopy with external > tools beause you do not trust replication? laughable! > > Do what you want, but dont come back and cry if all goes down > You were told in which way you can use rsync with minimum > downtime or that replication can be used to stop

RE: InnoDB and rsync

> In one extreme instance, having a few terabytes of data > across several instances (on distinct hosts), I was required > to do a full-refactoring data migration with an absolute > limitation on allowable downtime. > Among the technique which I used (and I can't take credit for this > one) was

RE: InnoDB and rsync

> You need to quiesce the InnoDb background threads. One > technique is mentioned here: > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablesp aces.html Just refreshing this topic a bit. Can anyone confirm that FLUSH TABLES WITH READ LOCK is sufficient to quiesce the InnoBD background

RE: InnoDB and rsync

> > You need to quiesce the InnoDb background threads. One technique is > > mentioned here: > > http://dev.mysql.com/doc/refman/5.5/en/innodb-multiple-tablesp > aces.html > > > > Loo

RE: InnoDB and rsync

're talkin. I'll check it out. > > I read that section but it is not at all clear (1) how one quiesces the InnoDB background threads, or (2) if there is a way to keep them quiesced while the backup is in progress. Disclaimer - January 25, 2011 This email and any files transmitted

RE: InnoDB and rsync

> > I'm starting to worry that you may be right. I know FLUSH > TABLES WITH > > READ LOCK does not work as expected with InnoDB, but is > there really > > no way to put InnoDB into a state where all changes have > been flushed > > to disk and it is safe to rsync the directory? Is stopping >

RE: InnoDB and rsync

> On 1/25/2011 10:45, Robinson, Eric wrote: > >>> There is a very good reason: it is the phenomenon of row > drift. The > >>> master and slave can appear to be in good sync, but often > it is not > >>> actually the case. > >> > >&g

RE: InnoDB and rsync

> 240 mysql-instances on 3 physical hosts? > what crazy setup is this please? Processors average 90% idle, peaks are low, iowait is low, the system is not swapping, response time is good, and our users are happy all around the country. What is crazy about that? > The whole world can work with

RE: InnoDB and rsync

> 240 mysql-servers? > why there is no consolidation? I said 240+ mysql *instances*, not servers. It's actually just 3 physical servers (not counting standby cluster nodes). > > just need a way to make the same thing work with InnoDB. > > this is simply impossible That is very unfortunate. Di

RE: InnoDB and rsync

> nobody cares if they are binary replica as long > as the data is consistent and ident Like I said, I'm no expert on this, but my approach seems like the only way to 100% absolutely sure that the data on the slave is in fact consistent and identical to the data on tha master. > so start another

RE: InnoDB and rsync

> > There is a very good reason: it is the phenomenon of row drift. The > > master and slave can appear to be in good sync, but often it is not > > actually the case. > > ... sounds interesting; have you got any document explaining > this phenomenon? AFAIK, the things that (silently) break > r

RE: InnoDB and rsync

> Why don't you use a Maatkit solution like mk-checksum to > ensure that your slaves have identical data with the master? I looked at Maatkit a year or so ago. It looked pretty interesting, but then I started reading the disclaimers carefully and they scared the bejeepers out of me. Warnings abou

RE: InnoDB and rsync

> your whole solution is crippled because why in the world are > you killing your salves and reinit them without any reason daily? There is a very good reason: it is the phenomenon of row drift. The master and slave can appear to be in good sync, but often it is not actually the case. For this re

InnoDB and rsync

Is there a way to safely backup an InnoDB database using rsync? Right now we have a very efficient and reliable way to backup 240+ separate instances of MySQL with MyISAM tables. The databases range in size from .5GB to 16GB. During this time, users can still access the system, so our customers c

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

Hi Baron, > I'm the primary author of Maatkit. Awkward... :-) > What can I say -- you could go buy a commercial off-the-shelf tool > and believe the song and dance they feed you about the tool > being perfect. There's not a single commercial software solution in our toolbox. We're big fan

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

>> I would never have any confidence that the replication >> is solid enough to use the slave server for backup purposes. > I agree completely there. That's the other reason I like filesystem > snapshots is that it allows you to take a backup from > the master relatively painlessly. I've thou

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

> I would say that it's very important to know why data > is getting out of sync between your master and slave. Ultimately, I agree. But since it's a canned application, getting to that point might be hard, and once it is resolved, new issues might arise. I would never have any confidence that t

RE: Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

> (1) innodb? It's an off-the-shelf application that uses MyISAM tables. It is possible to convert to innodb, but I have not been sold on innodb in terms of its performance characteristics for this particular application. Maybe I've been reading the wrong stuff. Do you have general thoughts on t

Here's an Idea for Re-Syncing Master and Slave During Production Hours without Interrupting Users (Much)

Let's face it, sometimes the master and slave get out of sync, even when 'show slave status' and 'show master status' indicate that all is well. And sometimes it is not feasible to wait until after production hours to resync them. We've been working on a method to do an emergency hot-resync durin

RE: Rename Database - Why Would This Not Work?

>RENAME TABLE > olddb.table1 TO newdb.table1, > olddb.table2 TO newdb.table2 >put the whole list in here, the whole statement will be applied to the system atomically The database has 1200+ tables, so your approach seems like more work to me. As it is, all I'm doing is: service mysql stop m

RE: Rename Database - Why Would This Not Work?

> DB engines that have their own data dictionary (Innodb, etc) in addition to > what is in the .frm could easily be messed up. Like I said, there are only MyISAM tables in the database, so would there be any risks associated with my simple approach? (Also there are no stored procedures because

Rename Database - Why Would This Not Work?

I used a simple procedure to rename my MySQL 4.1.22 database, which has only My-ISAM tables: 1. Stopped MySQL 2. Renamed the database directory from olddbname to newdbname 3. Started mysql At this point, I grepped for 'olddbname' and found that many of the old .MYI files still had references to

mysqld-nt 100% CPU Utilization?

Our MySQL-based medical application has been running fine for 3 years. Last week, mysqld-nt started jumping up to 100% CPU and staying there until someone restarts the service. mysqlcheck found no errors in the database. I dumped it to disk and read it back in to create a fresh copy of the database

RE: MySQL Performance Question

inson -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 6:35 AM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question One reason you might be seeing a higher number of writes than reads is if MySQL is able to answer queries fro

RE: Server Load Question

ided to do is create one instance of MySQL per version of the application. All clients running the same version of the application would use the same instance of MySQL. -Original Message- From: Dan Buettner [mailto:[EMAIL PROTECTED] Sent: Monday, June 19, 2006 12:55 PM To: Robinson, Eric

Server Load Question

I asked this question previously but didn't get much response so I'll try again. Our server will be home to 100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. Each client has 3 databases. Database-1: 500 tables. 13 t

RE: MySQL Performance Question

ersions of the application.) --Eric -Original Message- From: Atle Veka [mailto:[EMAIL PROTECTED] Sent: Saturday, June 17, 2006 12:14 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: MySQL Performance Question So, you're looking at 150-300 databases and ~31-62k table

MySQL Performance Question

Our server will be home to 50-100 separate clients. Each client will have their own set of databases that will be accessed by 10-60 users at each client's site. In terms of performance, is it better to have 1 instance of MySQL servicing multiple databases, or multiple instances of MySQL each serv

RE: mysql4.0

Does mysqlcheck sometimes repair problems that it does not report? I've seen a few instances where running mysqlcheck -r -f fixed application problems even though it reported all tables "OK." --Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

mysqlcheck

Does mysqlcheck sometimes repair problems that it does not report? I've seen a few instances where running mysqlcheck -r -f fixed application problems even though it reported all tables "OK." --Eric -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:h

RE: Fixing Databases When Replication Is Enabled?

[mailto:[EMAIL PROTECTED] Sent: Tuesday, May 02, 2006 8:23 AM To: Marciano Cc: Robinson, Eric; mysql@lists.mysql.com Subject: Re: Fixing Databases When Replication Is Enabled? My Sincere apologies, I intented to mean mysqlcheck but somehow came out as myisamchk :) Kishore Jalleda On 5/2/06

RE: Fixing Databases When Replication Is Enabled?

I ran mysqlcheck, not myisamchk or REPAIR. Is what you said still true? -Original Message- From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Monday, May 01, 2006 1:56 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: Fixing Databases When Replication Is Enabled? On 5/1/06

Fixing Databases When Replication Is Enabled?

I ran mysqlcheck against a replication master database and it reported a problem with a table, which it corrected. Is the slave now out of sync? If so, how do I correct the problem without copying the whole database over a slow WAN link? --Eric -- MySQL General Mailing List For list archives: htt

RE: Quick Replication Question

: Friday, April 28, 2006 9:05 AM To: Robinson, Eric; mysql@lists.mysql.com Subject: Re: Quick Replication Question no. - Original Message - From: "Robinson, Eric" <[EMAIL PROTECTED]> To: Sent: Friday, April 28, 2006 8:51 AM Subject: Quick Replication Question When you h

Quick Replication Question

When you have master-slave replication enabled, and something goes wrong with one of the tables on the master, and you have to run mysqlcheck -r to fix it, does the fix get written to the binlog and replicated to the slave? --Eric -- MySQL General Mailing List For list archives: http://lists.my

RE: How to Verify Replication Status?

All excellent information. I have much to ponder. -Original Message- From: Eric Braswell [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 11:20 AM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: How to Verify Replication Status? You'll need to checksum them at the

RE: How to Verify Replication Status?

, LLC 775.720.2082 -Original Message- From: Eric Braswell [mailto:[EMAIL PROTECTED] Sent: Thursday, April 20, 2006 1:49 AM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: How to Verify Replication Status? There are only a very limited set of circumstances where slaves could get

RE: How to Verify Replication Status?

ailto:[EMAIL PROTECTED] Sent: Wednesday, April 19, 2006 5:31 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: How to Verify Replication Status? Never used it, but this might help: http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html James Harvard At 5:00 pm -0700 19/4/06, Robinson,

How to Verify Replication Status?

I have master-slave replication working fine. However, I worry about the possibility of the master and slave accidentally getting out of synchronization. Are there circumstances (other than a direct INSERT to the slave) that could cause the master and slave to be out of sync? Is there a way to peri

RE: SHOW TABLE STATUS: Update_Time Is Wrong?

lto:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 6:23 PM To: Robinson, Eric Cc: Mikael Fridh; mysql@lists.mysql.com Subject: RE: SHOW TABLE STATUS: Update_Time Is Wrong? Eric, I'm glad that last answer worked, but I'm wondering what exactly you did to resolve the problem? I see the

RE: SHOW TABLE STATUS: Update_Time Is Wrong?

That looks like a direct hit. Thanks! -- Eric Robinson -Original Message- From: Mikael Fridh [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 29, 2004 1:06 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: SHOW TABLE STATUS: Update_Time Is Wrong? Robinson, Eric wrote

RE: SHOW TABLE STATUS: Update_Time Is Wrong?

esday, December 28, 2004 8:15 PM To: Robinson, Eric Cc: mysql@lists.mysql.com Subject: Re: SHOW TABLE STATUS: Update_Time Is Wrong? Robinson, Eric wrote: > When I execute SHOW TABLE STATUS on my master replication server, it > shows an Update_Time for some tables that is more than 2 hours ear

SHOW TABLE STATUS: Update_Time Is Wrong?

When I execute SHOW TABLE STATUS on my master replication server, it shows an Update_Time for some tables that is more than 2 hours earlier than the Update_Time for the same tables on the slave server. However the bin log names, positions, and number or records are correct. What's with that? --

RE: Newbie: Using SELECT to Get Table Status?

great day. -- Eric Robinson -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 28, 2004 12:22 AM To: mysql@lists.mysql.com Subject: Re: Newbie: Using SELECT to Get Table Status? Hello. You may use count(*) for counting rows. "Robinson, Eric&quo

Newbie: Using SELECT to Get Table Status?

The mysql>SHOW TABLE STATUS command returns such things as the number or rows and time of the last update. Is it possible to get the same information using a SELECT statement? FYI, I am writing a script to monitor replication status by comparing this information between the master and slave serv

Auto-Increment Starting Point? (Multimaster Replication Question)

When you set a field to auto-increment, can you tell it where to start? I'm trying to set up multimaster replication, but I'm worried about auto-increment collisions. Q: If server A starts auto-incrementing at 0, and server B starts auto-incrementing at some point higher than the maximum n

How to Enable Full Query Logging?

Hi, I included the following statement in my.ini: log=c:\log.txt I then executed some queries. The file log.txt only shows the following: MySql, Version: 4.0.13-nt-log, started with: TCP Port: 3306, Named Pipe: MySQL Time Id CommandArgument 040527 9:31:57 1 C

RE: 1-Way or 2-Way Replication?

Shawn, your answer is excellent, and I now understand why replication is a touchy issue. But now I am worried that I will not be able to accomplish what I had hoped. I want to have a server at my corporate office and a server at my branch office. Most of the time, all users at both locations would

RE: 1-Way or 2-Way Replication?

That is my question exactly. -Original Message- From: Ditto kolankanny [mailto:[EMAIL PROTECTED] Sent: Monday, May 17, 2004 8:40 AM To: Robinson, Eric; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: 1-Way or 2-Way Replication? Hi all, In this A->B->C->A setup A is mas

RE: 1-Way or 2-Way Replication?

It is there. Look for "two-way" :-) >I don't think they do... A search of the documentation for >"2-way" yields nothing. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: 1-Way or 2-Way Replication?

>Circular replication is possible... A->B->C->A Thanks, but that still does not answer the question... why do they call it 2-way replication? That implies two machines, not several. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists

RE: 1-Way or 2-Way Replication?

>there is no mechanism for propagating slave changes >from the slave back up to the master... synchronization >occurs *only* from master to slave >(hence the terminology). Then why do they call it 2-way replication? Is there such a thing as master-to-master? -- MySQL General Mailing List F

1-Way or 2-Way Replication?

Hi, Our healthcare organization has 2 geographical locations which I will call corporate_office and satellite_office. Currently, we run a medical application from a MySQL server at the corporate_office. Users at the satellite_office use the same server. Speed across the WAN is acceptable.