binary preference path to mysqld or mysqld_safe?

[Carmen Sarlo]

What is the preferred binary for the prm config, path to mysqld or mysqld_safe? I was using the path to mysqld but could not update open_file_limit without adding a startup flag.

 

[Yves Trudeau]

Hi Carmen,
    Have you tried adding open-files-limit to the mysqld section of the my.cnf file?  I just tested and that works just fine provided the system ulimits are set correctly.

Regards,

Yves

Le 2015-10-14 14:31, "Carmen Sarlo" <carmen...@voxmedia.com> a écrit :

What is the preferred binary for the prm config, path to mysqld or mysqld_safe? I was using the path to mysqld but could not update open_file_limit without adding a startup flag.

 

--
You received this message because you are subscribed to the Google Groups "PRM-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to prm-discuss...@googlegroups.com.
To post to this group, send email to prm-d...@googlegroups.com.
Visit this group at http://groups.google.com/group/prm-discuss.
For more options, visit https://groups.google.com/d/optout.

[Carmen Sarlo]

Hi Yves,

Yes, in my.cnf

open-files-limit = 32768

I looked at the variables 

show variables like 'open%';

+------------------+-------+

| Variable_name    | Value |

+------------------+-------+

| open_files_limit | 65535 |

+------------------+-------+

I am using percona5.5 server.

[Yves Trudeau]

Just to be sure,  in the [mysqld] section?   I just tested with PS 5.6.  I couldn't set it lower than around 4000 though.

-- Yves