MySQL Forums
Forum List  »  Performance

Re: Which server hardware would you pick?
Posted by: Rick James
Date: November 17, 2014 03:42PM

I'm curious to get to the bottom of this. Some guesses as to how to solve the puzzle...

Do SHOW VARIABLES on each server, then diff the outputs. Report the diffs; we can discuss them. innodb_flush_log_at_trx_commit, if different, may be the cause.

> I have a couple of Innodb tables with a couple million records, which I purge after 7 days.

Do you delete all 2M rows?

> script runs and purges 500 records

One row at a time? Or a single DELETE? Please show us the DELETE statement and the SHOW CREATE TABLE for the two tables. Also SHOW TABLE STATUS for them. There may be some subtle difference that is causing the significant timing difference.

> Disk 1: Intel SSD 330 Series 120GB (for OS)

Are you sure the database tables, logs, or tmpdir is not there? SHOW VARIABLES LIKE '%dir%';

SHOW VARIABLES LIKE 'binlog_format'; -- this will lead into the next question:
Which machine are you doing the 'pruge' on? I assume the other machine is receiving the deletes via replication?

Are your 70 connections 'evenly' split between the two Masters?

Options: ReplyQuote


Subject
Views
Written By
Posted
1627
November 14, 2014 08:24PM
Re: Which server hardware would you pick?
759
November 17, 2014 03:42PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.