API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 23rd, 2017
56
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 37.31 KB | None | 0 0
raw download clone embed print report
  1. ## SAT1 ##
  2. # Issue: Can't do more than 30 req/ sec (only selects)
  3.  
  4. ## Show variables ##
  5. Variable_name Value
  6. --------------------------------------- -----------------------------------------------------------------------------------------
  7. auto_increment_increment 1
  8. auto_increment_offset 1
  9. autocommit ON
  10. automatic_sp_privileges ON
  11. back_log 50
  12. basedir /usr/
  13. big_tables OFF
  14. binlog_cache_size 32768
  15. binlog_direct_non_transactional_updates OFF
  16. binlog_format STATEMENT
  17. bulk_insert_buffer_size 8388608
  18. character_set_client utf8
  19. character_set_connection utf8
  20. character_set_database latin1
  21. character_set_filesystem binary
  22. character_set_results utf8
  23. character_set_server latin1
  24. character_set_system utf8
  25. character_sets_dir /usr/share/mysql/charsets/
  26. collation_connection utf8_general_ci
  27. collation_database latin1_swedish_ci
  28. collation_server latin1_swedish_ci
  29. completion_type 0
  30. concurrent_insert 1
  31. connect_timeout 10
  32. datadir /var/lib/mysql/
  33. date_format %Y-%m-%d
  34. datetime_format %Y-%m-%d %H:%i:%s
  35. default_week_format 0
  36. delay_key_write ON
  37. delayed_insert_limit 100
  38. delayed_insert_timeout 300
  39. delayed_queue_size 1000
  40. div_precision_increment 4
  41. engine_condition_pushdown ON
  42. error_count 0
  43. event_scheduler OFF
  44. expire_logs_days 0
  45. flush OFF
  46. flush_time 0
  47. foreign_key_checks ON
  48. ft_boolean_syntax + -><()~*:""&|
  49. ft_max_word_len 84
  50. ft_min_word_len 4
  51. ft_query_expansion_limit 20
  52. ft_stopword_file (built-in)
  53. general_log OFF
  54. general_log_file /var/run/mysqld/mysqld.log
  55. group_concat_max_len 1024
  56. have_community_features YES
  57. have_compress YES
  58. have_crypt YES
  59. have_csv YES
  60. have_dynamic_loading YES
  61. have_geometry YES
  62. have_innodb YES
  63. have_ndbcluster NO
  64. have_openssl DISABLED
  65. have_partitioning YES
  66. have_query_cache YES
  67. have_rtree_keys YES
  68. have_ssl DISABLED
  69. have_symlink YES
  70. hostname vte1
  71. identity 0
  72. ignore_builtin_innodb OFF
  73. init_connect
  74. init_file
  75. init_slave
  76. innodb_adaptive_hash_index ON
  77. innodb_additional_mem_pool_size 1048576
  78. innodb_autoextend_increment 8
  79. innodb_autoinc_lock_mode 1
  80. innodb_buffer_pool_size 1073741824
  81. innodb_checksums ON
  82. innodb_commit_concurrency 0
  83. innodb_concurrency_tickets 500
  84. innodb_data_file_path ibdata1:10M:autoextend
  85. innodb_data_home_dir
  86. innodb_doublewrite ON
  87. innodb_fast_shutdown 1
  88. innodb_file_io_threads 4
  89. innodb_file_per_table OFF
  90. innodb_flush_log_at_trx_commit 1
  91. innodb_flush_method
  92. innodb_force_recovery 0
  93. innodb_lock_wait_timeout 50
  94. innodb_locks_unsafe_for_binlog OFF
  95. innodb_log_buffer_size 1048576
  96. innodb_log_file_size 5242880
  97. innodb_log_files_in_group 2
  98. innodb_log_group_home_dir ./
  99. innodb_max_dirty_pages_pct 90
  100. innodb_max_purge_lag 0
  101. innodb_mirrored_log_groups 1
  102. innodb_open_files 300
  103. innodb_rollback_on_timeout OFF
  104. innodb_stats_on_metadata ON
  105. innodb_support_xa ON
  106. innodb_sync_spin_loops 20
  107. innodb_table_locks ON
  108. innodb_thread_concurrency 8
  109. innodb_thread_sleep_delay 10000
  110. innodb_use_legacy_cardinality_algorithm ON
  111. insert_id 0
  112. interactive_timeout 28800
  113. join_buffer_size 131072
  114. keep_files_on_create OFF
  115. key_buffer_size 402653184
  116. key_cache_age_threshold 300
  117. key_cache_block_size 1024
  118. key_cache_division_limit 100
  119. language /usr/share/mysql/english/
  120. large_files_support ON
  121. large_page_size 0
  122. large_pages OFF
  123. last_insert_id 0
  124. lc_time_names en_US
  125. license GPL
  126. local_infile ON
  127. locked_in_memory OFF
  128. log OFF
  129. log_bin ON
  130. log_bin_trust_function_creators OFF
  131. log_bin_trust_routine_creators OFF
  132. log_error /var/lib/mysql/vte1.err
  133. log_output FILE
  134. log_queries_not_using_indexes OFF
  135. log_slave_updates OFF
  136. log_slow_queries OFF
  137. log_warnings 1
  138. long_query_time 10.000000
  139. low_priority_updates OFF
  140. lower_case_file_system OFF
  141. lower_case_table_names 0
  142. max_allowed_packet 1048576
  143. max_binlog_cache_size 18446744073709547520
  144. max_binlog_size 1073741824
  145. max_connect_errors 10
  146. max_connections 151
  147. max_delayed_threads 20
  148. max_error_count 64
  149. max_heap_table_size 16777216
  150. max_insert_delayed_threads 20
  151. max_join_size 18446744073709551615
  152. max_length_for_sort_data 1024
  153. max_prepared_stmt_count 16382
  154. max_relay_log_size 0
  155. max_seeks_for_key 18446744073709551615
  156. max_sort_length 1024
  157. max_sp_recursion_depth 0
  158. max_tmp_tables 32
  159. max_user_connections 0
  160. max_write_lock_count 18446744073709551615
  161. min_examined_row_limit 0
  162. multi_range_count 256
  163. myisam_data_pointer_size 6
  164. myisam_max_sort_file_size 9223372036853727232
  165. myisam_mmap_size 18446744073709551615
  166. myisam_recover_options OFF
  167. myisam_repair_threads 1
  168. myisam_sort_buffer_size 67108864
  169. myisam_stats_method nulls_unequal
  170. myisam_use_mmap OFF
  171. net_buffer_length 16384
  172. net_read_timeout 30
  173. net_retry_count 10
  174. net_write_timeout 60
  175. new OFF
  176. old OFF
  177. old_alter_table OFF
  178. old_passwords OFF
  179. open_files_limit 1185
  180. optimizer_prune_level 1
  181. optimizer_search_depth 62
  182. optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on
  183. pid_file /var/run/mysqld/mysqld.pid
  184. plugin_dir /usr/lib64/mysql/plugin
  185. port 3306
  186. preload_buffer_size 32768
  187. profiling OFF
  188. profiling_history_size 15
  189. protocol_version 10
  190. pseudo_thread_id 3
  191. query_alloc_block_size 8192
  192. query_cache_limit 1048576
  193. query_cache_min_res_unit 4096
  194. query_cache_size 33554432
  195. query_cache_type ON
  196. query_cache_wlock_invalidate OFF
  197. query_prealloc_size 8192
  198. rand_seed1
  199. rand_seed2
  200. range_alloc_block_size 4096
  201. read_buffer_size 2097152
  202. read_only OFF
  203. read_rnd_buffer_size 8388608
  204. relay_log
  205. relay_log_index
  206. relay_log_info_file relay-log.info
  207. relay_log_purge ON
  208. relay_log_space_limit 0
  209. report_host
  210. report_password
  211. report_port 3306
  212. report_user
  213. rpl_recovery_rank 0
  214. secure_auth OFF
  215. secure_file_priv
  216. server_id 1
  217. skip_external_locking ON
  218. skip_name_resolve OFF
  219. skip_networking OFF
  220. skip_show_database OFF
  221. slave_compressed_protocol OFF
  222. slave_exec_mode STRICT
  223. slave_load_tmpdir /tmp
  224. slave_net_timeout 3600
  225. slave_skip_errors OFF
  226. slave_transaction_retries 10
  227. slow_launch_time 2
  228. slow_query_log OFF
  229. slow_query_log_file /var/run/mysqld/mysqld-slow.log
  230. socket /var/lib/mysql/mysql.sock
  231. sort_buffer_size 2097152
  232. sql_auto_is_null ON
  233. sql_big_selects ON
  234. sql_big_tables OFF
  235. sql_buffer_result OFF
  236. sql_log_bin ON
  237. sql_log_off OFF
  238. sql_log_update ON
  239. sql_low_priority_updates OFF
  240. sql_max_join_size 18446744073709551615
  241. sql_mode
  242. sql_notes ON
  243. sql_quote_show_create ON
  244. sql_safe_updates OFF
  245. sql_select_limit 18446744073709551615
  246. sql_slave_skip_counter
  247. sql_warnings OFF
  248. ssl_ca
  249. ssl_capath
  250. ssl_cert
  251. ssl_cipher
  252. ssl_key
  253. storage_engine MyISAM
  254. sync_binlog 0
  255. sync_frm ON
  256. system_time_zone CEST
  257. table_definition_cache 256
  258. table_lock_wait_timeout 50
  259. table_open_cache 512
  260. table_type MyISAM
  261. thread_cache_size 8
  262. thread_handling one-thread-per-connection
  263. thread_stack 262144
  264. time_format %H:%i:%s
  265. time_zone SYSTEM
  266. timed_mutexes OFF
  267. timestamp 1288023714
  268. tmp_table_size 16777216
  269. tmpdir /tmp
  270. transaction_alloc_block_size 8192
  271. transaction_prealloc_size 4096
  272. tx_isolation REPEATABLE-READ
  273. unique_checks ON
  274. updatable_views_with_limit YES
  275. version 5.1.51-log
  276. version_comment MySQL Community Server (GPL) by Remi
  277. version_compile_machine x86_64
  278. version_compile_os redhat-linux-gnu
  279. wait_timeout 28800
  280. warning_count 0
  281.  
  282.  
  283. #MONO ERROR when i reach 30 req/sec#
  284.  
  285.  
  286. Error: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown.
  287. at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
  288. --- End of inner exception stack trace ---
  289. at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
  290. at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0
  291. at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in <filename unknown>:0
  292. at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in <filename unknown>:0
  293. at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in <filename unknown>:0
  294. Error: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts. ---> System.Exception: Exception of type 'System.Exception' was thrown.
  295. at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
  296. --- End of inner exception stack trace ---
  297. at MySql.Data.MySqlClient.NativeDriver.Open () [0x00000] in <filename unknown>:0
  298. at MySql.Data.MySqlClient.Driver.Create (MySql.Data.MySqlClient.MySqlConnectionStringBuilder settings) [0x00000] in <filename unknown>:0
  299. at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection () [0x00000] in <filename unknown>:0
  300. at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection () [0x00000] in <filename unknown>:0
  301. at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver () [0x00000] in <filename unknown>:0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!