[racktables-users] Re: Racktables Search crashes with Out of Memory Error Message
- From: Denis Ovsienko <infrastation@xxxxxxxxx>
- To: "racktables-users@xxxxxxxxxxxxx" <racktables-users@xxxxxxxxxxxxx>
- Date: Thu, 20 Mar 2014 19:44:27 +0400
07.03.2014, 17:41, "J Lee" <juleedev@xxxxxxxxx>:
> Hi again. Just FYI. The key parameter fixed the issue was setting
> join_buffer_size. I've set it to 3M and it seems to be happy again. There
> were a few other variables that I tweaked including the table cache, and
> query cache. But the one that actually fixed the issue was the
> join_buffer_size.
>
MySQL can perform very well but often comes in a default configuration that
doesn't let it perform. In most cases it makes sense to start with the
"my-innodb-heavy-4G.cnf" sample configuration that normally belongs to the same
package as the MySQL server.
--
Denis Ovsienko
Other related posts:
