Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.48 KB | None | 0 0
  1. sudo find / -name my.cnf
  2. /etc/mysql/my.cnf
  3.  
  4. 27652 root 20 0 4096 424 420 S 0 0.0 0:00.01 mysqld_safe
  5. 27769 mysql 20 0 392m 57m 7236 S 0 1.5 119116,08 mysqld
  6.  
  7. mysqld --print-defaults
  8. mysqld would have been started with the following arguments:
  9. --user=mysql --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --myisam-recover=BACKUP --query_cache_limit=1M --query_cache_size=16M --log_error=/var/log/mysql/error.log --expire_logs_days=9 --max_binlog_size=100M --innodb_file_per_table=1 --innodb_buffer_pool_size=500M --innodb_buffer_pool_size=500M --user=mysql --socket=/var/run/mysqld/mysqld.sock --port=3306 --basedir=/usr --datadir=/var/lib/mysql --tmpdir=/tmp --skip-external-locking --bind-address=127.0.0.1 --key_buffer=16M --max_allowed_packet=16M --thread_stack=192K --thread_cache_size=8 --myisam-recover=BACKUP --query_cache_limit=1M --query_cache_size=16M --log_error=/var/log/mysql/error.log --expire_logs_days=9 --max_binlog_size=100M --innodb_file_per_table=1 --innodb_buffer_pool_size=500M --innodb_buffer_pool_size=500M
  10.  
  11. [client]
  12. port = 3306
  13. socket = /var/run/mysqld/mysqld.sock
  14.  
  15. [mysqld_safe]
  16. socket = /var/run/mysqld/mysqld.sock
  17. nice = 0
  18.  
  19. [mysqld]
  20. user = mysql
  21. socket = /var/run/mysqld/mysqld.sock
  22. port = 3306
  23. basedir = /usr
  24. datadir = /var/lib/mysql
  25. tmpdir = /tmp
  26. skip-external-locking
  27. bind-address = 127.0.0.1
  28. key_buffer = 16M
  29. max_allowed_packet = 16M
  30. thread_stack = 192K
  31. thread_cache_size = 8
  32. myisam-recover = BACKUP
  33. query_cache_limit = 1M
  34. query_cache_size = 16M
  35. log_error = /var/log/mysql/error.log
  36. expire_logs_days = 10
  37. max_binlog_size = 100M
  38. innodb_file_per_table = 1
  39.  
  40. [mysqldump]
  41. quick
  42. quote-names
  43. max_allowed_packet = 16M
  44.  
  45. [mysql]
  46.  
  47. [isamchk]
  48. key_buffer = 16M
  49.  
  50. !includedir /etc/mysql/conf.d/
  51.  
  52. [mysqld]
  53. innodb_buffer_pool_size = 500M
  54.  
  55. strace -e trace=open mysqld
  56.  
  57. open("/etc/ld.so.cache", O_RDONLY) = 3
  58. open("/lib64/libpthread.so.0", O_RDONLY) = 3
  59. open("/lib64/libaio.so.1", O_RDONLY) = 3
  60. open("/lib64/libm.so.6", O_RDONLY) = 3
  61. open("/lib64/librt.so.1", O_RDONLY) = 3
  62. open("/lib64/libcrypt.so.1", O_RDONLY) = 3
  63. open("/lib64/libdl.so.2", O_RDONLY) = 3
  64. open("/usr/lib64/libssl.so.10", O_RDONLY) = 3
  65. open("/lib64/libcrypto.so.10", O_RDONLY) = 3
  66. open("/lib64/libc.so.6", O_RDONLY) = 3
  67. open("/usr/lib64/libfreebl3.so", O_RDONLY) = 3
  68. open("/lib64/libgssapi_krb5.so.2", O_RDONLY) = 3
  69. open("/lib64/libkrb5.so.3", O_RDONLY) = 3
  70. open("/lib64/libcom_err.so.2", O_RDONLY) = 3
  71. open("/lib64/libk5crypto.so.3", O_RDONLY) = 3
  72. open("/lib64/libz.so.1", O_RDONLY) = 3
  73. open("/lib64/libkrb5support.so.0", O_RDONLY) = 3
  74. open("/lib64/libkeyutils.so.1", O_RDONLY) = 3
  75. open("/lib64/libresolv.so.2", O_RDONLY) = 3
  76. open("/usr/lib64/libselinux.so.1", O_RDONLY) = 3
  77. open("/proc/filesystems", O_RDONLY) = 3
  78. open("/sys/devices/system/cpu/online", O_RDONLY|O_CLOEXEC) = 3
  79. open("/sys/devices/system/cpu", O_RDONLY|O_NONBLOCK|O_DIRECTORY|O_CLOEXEC) = 3
  80. open("/etc/my.cnf", O_RDONLY) = 3
  81. open("/etc/localtime", O_RDONLY) = 3
  82. open("/dev/urandom", O_RDONLY|O_NOCTTY|O_NONBLOCK) = 3
  83. open("/proc/sys/crypto/fips_enabled", O_RDONLY) = 3
  84.  
  85. /etc/init.d/mysql start --query_cache_size=0
  86.  
  87. mysql.server start
  88.  
  89. Starting MySQL. SUCCESS!
  90.  
  91. sudo chmod 644 my.cnf
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement