Advertisement
Guest User

Untitled

a guest
Aug 15th, 2016
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.74 KB | None | 0 0
  1. +----+---------------------+---------------------+------+------------+------------------------------+
  2. | id | LastStart | LastFinish | Log | ExitStatus | TaskName |
  3. +----+---------------------+---------------------+------+------------+------------------------------+
  4. | 1 | 2012-06-26 10:41:17 | 2012-06-26 10:47:42 | NULL | NULL | LouPrMgt004.Backup |
  5. | 2 | NULL | NULL | NULL | NULL | LouPrMgt004.LoadPrtgDataToDb |
  6. +----+---------------------+---------------------+------+------------+------------------------------+
  7.  
  8. 2012/06/26 08:35:53 [6952] building file list
  9. 2012/06/26 08:35:53 [6952] .d...p..... ./
  10. 2012/06/26 08:35:53 [6952] <f..t...... LouPrMgt004-backup-www.tar.gz
  11. 2012/06/26 08:35:53 [6952] <f..t...... MySQL_ServerInfo.sql
  12. 2012/06/26 08:35:53 [6952] <f..t...... MySQL_nmap_scan.sql
  13. 2012/06/26 08:35:53 [6952] <f..t...... packagelist.log
  14. 2012/06/26 08:35:53 [6952] <f.st...... root.tar.gz
  15. 2012/06/26 08:35:53 [6952] sent 60.14K bytes received 30.44K bytes 13.94K bytes/sec
  16. 2012/06/26 08:35:53 [6952] total size is 19.26M speedup is 212.63
  17. 2012/06/26 10:41:31 [8159] building file list
  18. 2012/06/26 10:41:31 [8159] .d...p..... ./
  19. 2012/06/26 10:41:31 [8159] <f.st...... LouPrMgt004-backup-www.tar.gz
  20. 2012/06/26 10:41:31 [8159] <f.st...... MySQL_ServerInfo.sql
  21. 2012/06/26 10:41:31 [8159] <f.st...... MySQL_nmap_scan.sql
  22. 2012/06/26 10:41:31 [8159] <f..t...... packagelist.log
  23. 2012/06/26 10:41:31 [8159] <f.st...... root.tar.gz
  24. 2012/06/26 10:41:32 [8159] sent 7.85M bytes received 30.44K bytes 630.61K bytes/sec
  25. 2012/06/26 10:41:32 [8159] total size is 19.27M speedup is 2.44
  26.  
  27. UPDATE jobs SET Log = LOAD_FILE('/root/copy.log')
  28. WHERE TaskName = 'LouPrMgt004.Backup';
  29.  
  30. SET @mycnf = LOAD_FILE('/etc/my.cnf');
  31. SELECT @mycnf;
  32.  
  33. mysql> SET @mycnf = LOAD_FILE('/etc/my.cnf');
  34. Query OK, 0 rows affected (0.00 sec)
  35.  
  36. mysql> select @mycnfG
  37. *************************** 1. row ***************************
  38. @mycnf: [mysqld]
  39. datadir=/var/lib/mysql
  40. socket=/var/lib/mysql/mysql.sock
  41. # Default to using old password format for compatibility with mysql 3.x
  42. # clients (those using the mysqlclient10 compatibility package).
  43. old_password=1
  44.  
  45. key_buffer_size=1G
  46. max_allowed_packet=128M
  47.  
  48. # These two values must be the same
  49. tmp_table_size=16M
  50. max_heap_table_size=16M
  51.  
  52. # Sort_buffer is too large, so try default to see if it helps
  53. sort_buffer_size = 2M
  54.  
  55. read_buffer_size=1M
  56. read_rnd_buffer_size=2M
  57. myisam_sort_buffer_size=16M
  58. max_length_for_sort_data=2048
  59. max_sort_length=2048
  60. long-query-time=5
  61. skip-name-resolve
  62. table_cache = 6144
  63. open_files_limit = 32768
  64. interactive_timeout=3600
  65. wait_timeout=3600
  66. thread_cache = 100
  67. max_connections=1000
  68. query_cache_size = 0
  69. # Try number of CPU's*2 for thread_concurrency
  70. thread_concurrency = 8
  71. ft_min_word_len=2
  72. group_concat_max_len=5000000
  73. query_cache_size=8M
  74. query_cache_limit=32M
  75.  
  76. #log-output=TABLE
  77. #slow-query-log
  78. #slow-query-log_file=slow-query.log
  79. #expire-logs-days=7
  80.  
  81. server-id=180
  82. #log-bin=mysql-bin
  83. #log-slave-updates
  84. #relay-log=relay-bin
  85.  
  86. innodb_file_per_table
  87. innodb_log_file_size=128M
  88. innodb_buffer_pool_size=512M
  89. innodb_log_buffer_size=8M
  90. innodb_flush_method=O_DIRECT
  91.  
  92. innodb_read_io_threads=16
  93. innodb_write_io_threads=16
  94. innodb_io_capacity=5000
  95. innodb_thread_concurrency=0
  96.  
  97. #
  98. # XtraDB Cluster Options
  99. #
  100.  
  101. user=mysql
  102. binlog_format=ROW
  103. wsrep_provider=/usr/lib64/libgalera_smm.so
  104. wsrep_cluster_address=gcomm://
  105. wsrep_slave_threads=2
  106. innodb_locks_unsafe_for_binlog=1
  107. innodb_autoinc_lock_mode=2
  108.  
  109. wsrep_sst_method=xtrabackup
  110. wsrep_cluster_name=oxygen_xtradb_cluster_test
  111. wsrep_node_name=oxygen_xtradb_cluster_test_node180
  112.  
  113. [mysql.server]
  114. user=mysql
  115. #basedir=/var/lib
  116.  
  117. [mysqld_safe]
  118. log-error=/var/log/mysqld.log
  119. pid-file=/var/run/mysqld/mysqld.pid
  120.  
  121.  
  122. 1 row in set (0.00 sec)
  123.  
  124. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement