Postings by Machiel Richards

info on open tables

Hi all

I am hoping this mail finds all well.

I have a question about mysql open tables and open_table_cache which I do not seem to be finding the answer to on the internet.

We are busy investigating an issue on a server where we have erattic behaviour.

During the times when it experiences issues, I found that there is always about 4-5 processes on mysql that gets stuck on "closing table" state and once the software (opensips) is restarted due to a sigfault, then these queries are killed as well.

Based on information found we added grafana graphs and did notic

Optimize fails due to duplicate rows error but no duplicates found

Good day guys,

I am hoping this mail finds you well.

I am at a bit of a loss here...

We are trying to run optimize against a table in order to reclaim disk space from archived data which has been removed.

However, after running for over an hour , the optimize fails stating there is a duplicate entry in the table.

We have now spent 2 days using various methods but we are unable to find any duplicates in the primary key and also nothing on the unique key fields.

Any idea on why optimize would still be failing ?