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?
Subject
Views
Written By
Posted
1627
November 14, 2014 08:24PM
854
November 15, 2014 08:46PM
783
November 16, 2014 06:25PM
Re: Which server hardware would you pick?
759
November 17, 2014 03:42PM
961
November 18, 2014 09:08AM
733
November 19, 2014 05:02PM
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.