Advertisement
Guest User

50-server.cnf

a guest
Oct 30th, 2021
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.57 KB | None | 0 0
  1. #
  2. # These groups are read by MariaDB server.
  3. # Use it for options that only the server (but not clients) should see
  4. #
  5. # See the examples of server my.cnf files in /usr/share/mysql
  6.  
  7. # this is read by the standalone daemon and embedded servers
  8. [server]
  9.  
  10. # this is only for the mysqld standalone daemon
  11. [mysqld]
  12.  
  13. #
  14. # * Basic Settings
  15. #
  16. user                    = mysql
  17. pid-file                = /run/mysqld/mysqld.pid
  18. #socket                  = /run/mysqld/mysqld.sock
  19. socket = /media/pi/DBDRIVE/MariaDB/mysqld.sock
  20. port                   = 3306
  21. basedir                 = /usr
  22. #datadir                 = /var/lib/mysql
  23. datadir =/media/pi/DBDRIVE/MariaDB
  24. tmpdir                  = /tmp
  25. lc-messages-dir         = /usr/share/mysql
  26. #skip-external-locking
  27.  
  28. # Instead of skip-networking the default is now to listen only on
  29. # localhost which is more compatible and is not less secure.
  30. bind-address            = 127.0.0.1
  31.  
  32. #
  33. # * Fine Tuning
  34. #
  35. #key_buffer_size        = 16M
  36. #max_allowed_packet     = 16M
  37. #thread_stack           = 192K
  38. #thread_cache_size      = 8
  39. # This replaces the startup script and checks MyISAM tables if needed
  40. # the first time they are touched
  41. #myisam_recover_options = BACKUP
  42. #max_connections        = 100
  43. #table_cache            = 64
  44. #thread_concurrency     = 10
  45.  
  46. #
  47. # * Query Cache Configuration
  48. #
  49. #query_cache_limit      = 1M
  50. query_cache_size        = 16M
  51.  
  52. #
  53. # * Logging and Replication
  54. #
  55. # Both location gets rotated by the cronjob.
  56. # Be aware that this log type is a performance killer.
  57. # As of 5.1 you can enable the log at runtime!
  58.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement