API tools faq
paste
Guest User

Untitled

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