Re: Configuration for a Medium Database with low number of Connections.
Posted by: Rick James
Date: January 01, 2016 12:20AM

> "large systems with 1-2GB of ram"

That is tiny by today's standards.

See http://mysql.rjweb.org/doc.php/memory for info on basic tuning.

ONE connection will use at most ONE CPU core.

> 5 queries per minute

Even 5 queries per _second_ is not stressing MySQL.

If you have queries that are taking "too long", show us the query, plus `SHOW CREATE TABLE` for any tables used in the query. We can probably recommend ways to speed it up. (That rarely involves tuning.)

Options: ReplyQuote


Subject
Written By
Posted
Re: Configuration for a Medium Database with low number of Connections.
January 01, 2016 12:20AM


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.