Not the answer you need?
Register and ask your own question!

lower_case_file_system variable is not found

adliazaddinadliazaddin EntrantCurrent User Role Novice
Hi,

im trying to enable lower_case_file_system variable in my.cnf, however i received this error in the error log

unknown variable 'lower_case_file_system=ON'.

anyone can help me on this?

Comments

  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    Could you share the my.cnf please?
    What exact version of Percona Server for MySQL are you using?
    Thanks!
  • adliazaddinadliazaddin Entrant Current User Role Novice
    Hi Lorraine

    im using percona-server-server-8.0.16-7.1.el7.x86_64, ive read somewhere that it is not possible to turn it on on linux

    btw below is somepart of my my.cnf

    lower_case_table_names=1
    lower_case_file_system=ON
  • lorraine.pocklingtonlorraine.pocklington Percona Community Manager Legacy User Role Patron
    HI there, one of the team here looked into it for you and confirmed that Percona Server is in step with upstream MySQL i.e. you get the same error there. It seems that the parameter exists to help with maintaining compatibility when needing to switch between Windows, OSX and Linux, so as you've rightly observed, it's not possible to turn it on in Linux.

    That it's labelled as a variable on Linux is probably a bit of a misnomer in this circumstance. Although we can see where it might be used, it's been observed to me that some senior folk have never had cause to use it, as the compatibility issues are taken care of at the file system level anyhow.

    Hope this helps?
  • Federico RazzoliFederico Razzoli Contributor Current User Role Patron
    https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_file_system

    "This variable is read only because it reflects a file system attribute and setting it would have no effect on the file system."

    So, this behaviour seems to be expected.
  • adliazaddinadliazaddin Entrant Current User Role Novice
    Hi, thanks for the clarification.. sorry for the late reply
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.