Post Profile






Using the loose_ option prefix in my.cnf

In this blog post, I’ll look at how to use the loose_ option prefix in my.cnf in MySQL. mysqld throws errors at startup – and refuses to start up – if a non-existent options are defined in the my.cnf file. For example: [crayon-57fd5f3b81f77105487558/] The MySQL manual has a solution: use the loose_ prefix option in my.cnf file. In the prior example, if we specify loose_bogus_option=1 [
read more

share

Related Posts


[ERROR] mysqld: Sort aborted: Server shutdown in progress

Programming / Database Development : MySQL Performance Blog

Recently, one of our support customers faced this: “[ERROR] mysqld: Sort aborted: Server shutdown in progress.” At first it would appear this occurred because of a mysql restart (i.e. the MySQL server restarted and the query got kil...

QA: Advanced Option Combinatorics (Pairwise Testing): Combinatorial mysqld Option Test Case Generation

Programming / Database Development : MySQL Performance Blog

How do we ensure that, when we have 35+ testable option combinations for mysqld, we test each and every combination of them? For example: will a different innodb_log_file_size combined with more innodb_log_files_in_group and a modif...

MySQL and predictive option handling – beware

Programming / Database Development : MySQL Performance Blog

MySQL command line utilities have an interesting property – if you only use the prefix of the option or command it will go over the list of available command and if there is only one command with matching prefix it will execute it w...

Get MySQL Passwords in Plain Text from .mylogin.cnf

Programming / Database Development : MySQL Performance Blog

This post will tell you how to get MySQL passwords in plain text using the.mylogin.cnf file. Since MySQL 5.6.6, it became possible to store MySQL credentials in an encrypted login path file named.mylogin.cnf, using the mysql_config_...

ulimit, taskset for mysqld

Programming / Database Development : Open Query Blog

my.cnf can take the open_files_limit=N option in the [mysqld_safe] block. This doesn't do anything to mysqld directly, instead the mysqld_safe script calls ulimit -n These days, we might want to limit mysqld to use a maximum of 4 co...

Comments


Copyright © 2016 Regator, LLC