MySQL Forums
Forum List  »  Newbie

Re: MYSQL Server is getting restarted multiple times every 2-3 days
Posted by: Peter Brawley
Date: October 05, 2017 11:52AM

As Phillip suggests, address space above 4GB on a 32-bit OS spills into the swap file. That's deadly for performance. Your system looks way too busy for 32 bits. What's the output from running free -m? If you have a path to 64 bits, consider getting onto it as fast as you can.

There are way too many query table scans---240k table scan row seeks/sec, yikes! Many of these queries are on MyISAM tables. It's hard to think of a reason they shouldn't be InnoDB unless they're getting frequent big bulk inserts. Find the offending queries by turning on the slow query log for a week. On each, move the table to InnoDB then run Explain Extended, and add indexes till table scans aren't required.

Until you're on 64 bits, you might get a small performance boost by bumping innodb_buffer_pool_size to 3GB.



Edited 1 time(s). Last edit at 10/05/2017 11:53AM by Peter Brawley.

Options: ReplyQuote




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.