API tools faq
paste
Guest User

Untitled

a guest
Dec 13th, 2012
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.17 KB | None | 0 0
raw download clone embed print report
  1. ============================================================================================
  2. SUNUCU DEĞİŞKENLERİ
  3. ============================================================================================
  4. auto_increment_increment 1
  5. auto_increment_offset 1
  6. autocommit ON
  7. automatic_sp_privileges ON
  8. back_log 50
  9. basedir F:\xampplite\mysql\
  10. big_tables OFF
  11. binlog_cache_size 32768
  12. binlog_format STATEMENT
  13. bulk_insert_buffer_size 8388608
  14. character_set_client latin1
  15. character_set_connection latin1
  16. character_set_database latin1
  17. character_set_filesystem binary
  18. character_set_results latin1
  19. character_set_server latin1
  20. character_set_system utf8
  21. character_sets_dir F:\xampplite\mysql\share\charsets\
  22. collation_connection latin1_swedish_ci
  23. collation_database latin1_swedish_ci
  24. collation_server latin1_swedish_ci
  25. completion_type 0
  26. concurrent_insert 1
  27. connect_timeout 10
  28. datadir F:\xampplite\mysql\data\
  29. date_format %Y-%m-%d
  30. datetime_format %Y-%m-%d %H:%i:%s
  31. default_week_format 0
  32. delay_key_write ON
  33. delayed_insert_limit 100
  34. delayed_insert_timeout 300
  35. delayed_queue_size 1000
  36. div_precision_increment 4
  37. engine_condition_pushdown ON
  38. error_count 0
  39. event_scheduler OFF
  40. expire_logs_days 0
  41. flush OFF
  42. flush_time 1800
  43. foreign_key_checks ON
  44. ft_boolean_syntax + -><()~*:""&|
  45. ft_max_word_len 84
  46. ft_min_word_len 4
  47. ft_query_expansion_limit 20
  48. ft_stopword_file (built-in)
  49. general_log OFF
  50. general_log_file F:\xampplite\mysql\data\pc1.log
  51. group_concat_max_len 1024
  52. have_community_features YES
  53. have_compress YES
  54. have_crypt NO
  55. have_csv YES
  56. have_dynamic_loading YES
  57. have_geometry YES
  58. have_innodb YES
  59. have_ndbcluster NO
  60. have_openssl DISABLED
  61. have_partitioning YES
  62. have_query_cache YES
  63. have_rtree_keys YES
  64. have_ssl DISABLED
  65. have_symlink YES
  66. hostname pc1
  67. identity 0
  68. ignore_builtin_innodb OFF
  69. init_connect
  70. init_file
  71. init_slave
  72. innodb_adaptive_hash_index ON
  73. innodb_additional_mem_pool_size 2097152
  74. innodb_autoextend_increment 8
  75. innodb_autoinc_lock_mode 1
  76. innodb_buffer_pool_size 16777216
  77. innodb_checksums ON
  78. innodb_commit_concurrency 0
  79. innodb_concurrency_tickets 500
  80. innodb_data_file_path ibdata1:10M:autoextend
  81. innodb_data_home_dir F:\xampplite\mysql\data\
  82. innodb_doublewrite ON
  83. innodb_fast_shutdown 1
  84. innodb_file_io_threads 4
  85. innodb_file_per_table OFF
  86. innodb_flush_log_at_trx_commit 1
  87. innodb_flush_method
  88. innodb_force_recovery 0
  89. innodb_lock_wait_timeout 50
  90. innodb_locks_unsafe_for_binlog OFF
  91. innodb_log_buffer_size 8388608
  92. innodb_log_file_size 5242880
  93. innodb_log_files_in_group 2
  94. innodb_log_group_home_dir F:\xampplite\mysql\data
  95. innodb_max_dirty_pages_pct 90
  96. innodb_max_purge_lag 0
  97. innodb_mirrored_log_groups 1
  98. innodb_open_files 300
  99. innodb_rollback_on_timeout OFF
  100. innodb_stats_on_metadata ON
  101. innodb_support_xa ON
  102. innodb_sync_spin_loops 20
  103. innodb_table_locks ON
  104. innodb_thread_concurrency 8
  105. innodb_thread_sleep_delay 10000
  106. insert_id 0
  107. interactive_timeout 28800
  108. join_buffer_size 131072
  109. keep_files_on_create OFF
  110. key_buffer_size 16777216
  111. key_cache_age_threshold 300
  112. key_cache_block_size 1024
  113. key_cache_division_limit 100
  114. language F:\xampplite\mysql\share\english\
  115. large_files_support ON
  116. large_page_size 0
  117. large_pages OFF
  118. last_insert_id 0
  119. lc_time_names en_US
  120. license GPL
  121. local_infile ON
  122. log OFF
  123. log_bin OFF
  124. log_bin_trust_function_creators OFF
  125. log_bin_trust_routine_creators OFF
  126. log_error .\mysql_error.log
  127. log_output FILE
  128. log_queries_not_using_indexes OFF
  129. log_slave_updates OFF
  130. log_slow_queries OFF
  131. log_warnings 1
  132. long_query_time 10.000000
  133. low_priority_updates OFF
  134. lower_case_file_system ON
  135. lower_case_table_names 1
  136. max_allowed_packet 1048576
  137. max_binlog_cache_size 4294963200
  138. max_binlog_size 1073741824
  139. max_connect_errors 10
  140. max_connections 151
  141. max_delayed_threads 20
  142. max_error_count 64
  143. max_heap_table_size 16777216
  144. max_insert_delayed_threads 20
  145. max_join_size 18446744073709551615
  146. max_length_for_sort_data 1024
  147. max_prepared_stmt_count 16382
  148. max_relay_log_size 0
  149. max_seeks_for_key 4294967295
  150. max_sort_length 1024
  151. max_sp_recursion_depth 0
  152. max_tmp_tables 32
  153. max_user_connections 0
  154. max_write_lock_count 4294967295
  155. min_examined_row_limit 0
  156. multi_range_count 256
  157. myisam_data_pointer_size 6
  158. myisam_max_sort_file_size 2146435072
  159. myisam_recover_options OFF
  160. myisam_repair_threads 1
  161. myisam_sort_buffer_size 8388608
  162. myisam_stats_method nulls_unequal
  163. myisam_use_mmap OFF
  164. named_pipe OFF
  165. net_buffer_length 8192
  166. net_read_timeout 30
  167. net_retry_count 10
  168. net_write_timeout 60
  169. new OFF
  170. old OFF
  171. old_alter_table OFF
  172. old_passwords OFF
  173. open_files_limit 755
  174. optimizer_prune_level 1
  175. optimizer_search_depth 62
  176. pid_file F:\xampplite\mysql\data\pc1.pid
  177. plugin_dir F:\xampplite\mysql\lib/plugin
  178. port 3306
  179. preload_buffer_size 32768
  180. profiling OFF
  181. profiling_history_size 15
  182. protocol_version 10
  183. pseudo_thread_id 0
  184. query_alloc_block_size 8192
  185. query_cache_limit 1048576
  186. query_cache_min_res_unit 4096
  187. query_cache_size 0
  188. query_cache_type ON
  189. query_cache_wlock_invalidate OFF
  190. query_prealloc_size 8192
  191. rand_seed1
  192. rand_seed2
  193. range_alloc_block_size 4096
  194. read_buffer_size 262144
  195. read_only OFF
  196. read_rnd_buffer_size 524288
  197. relay_log
  198. relay_log_index
  199. relay_log_info_file relay-log.info
  200. relay_log_purge ON
  201. relay_log_space_limit 0
  202. report_host
  203. report_password
  204. report_port 3306
  205. report_user
  206. rpl_recovery_rank 0
  207. secure_auth OFF
  208. secure_file_priv
  209. server_id 1
  210. shared_memory OFF
  211. shared_memory_base_name MYSQL
  212. skip_external_locking ON
  213. skip_networking OFF
  214. skip_show_database OFF
  215. slave_compressed_protocol OFF
  216. slave_exec_mode STRICT
  217. slave_load_tmpdir F:\xampplite\tmp
  218. slave_net_timeout 3600
  219. slave_skip_errors
  220. slave_transaction_retries 10
  221. slow_launch_time 2
  222. slow_query_log OFF
  223. slow_query_log_file F:\xampplite\mysql\data\pc1-slow.log
  224. sort_buffer_size 524288
  225. sql_auto_is_null ON
  226. sql_big_selects ON
  227. sql_big_tables OFF
  228. sql_buffer_result OFF
  229. sql_log_bin ON
  230. sql_log_off OFF
  231. sql_log_update ON
  232. sql_low_priority_updates OFF
  233. sql_max_join_size 18446744073709551615
  234. sql_mode
  235. sql_notes ON
  236. sql_quote_show_create ON
  237. sql_safe_updates OFF
  238. sql_select_limit 18446744073709551615
  239. sql_slave_skip_counter
  240. sql_warnings OFF
  241. ssl_ca
  242. ssl_capath
  243. ssl_cert
  244. ssl_cipher
  245. ssl_key
  246. storage_engine MyISAM
  247. sync_binlog 0
  248. sync_frm ON
  249. system_time_zone GTB Standart Saati
  250. table_definition_cache 256
  251. table_lock_wait_timeout 50
  252. table_open_cache 64
  253. table_type MyISAM
  254. thread_cache_size 0
  255. thread_handling one-thread-per-connection
  256. thread_stack 196608
  257. time_format %H:%i:%s
  258. time_zone SYSTEM
  259. timed_mutexes OFF
  260. timestamp 1355425775
  261. tmp_table_size 16777216
  262. tmpdir F:/xampplite/tmp
  263. transaction_alloc_block_size 8192
  264. transaction_prealloc_size 4096
  265. tx_isolation REPEATABLE-READ
  266. unique_checks ON
  267. updatable_views_with_limit YES
  268. version 5.1.33-community
  269. version_comment MySQL Community Server (GPL)
  270. version_compile_machine ia32
  271. version_compile_os Win32
  272. wait_timeout 28800
  273. warning_count 0
  274.  
  275. ============================================================================================
  276. SUNUCU STATUS DEĞERLERİ
  277. ============================================================================================
  278.  
  279. Aborted_clients 0
  280. Aborted_connects 0
  281. Binlog_cache_disk_use 0
  282. Binlog_cache_use 0
  283. Bytes_received 11601528
  284. Bytes_sent 8173453
  285. Com_admin_commands 0
  286. Com_alter_db 0
  287. Com_alter_db_upgrade 0
  288. Com_alter_event 0
  289. Com_alter_function 0
  290. Com_alter_procedure 0
  291. Com_alter_server 0
  292. Com_alter_table 1
  293. Com_alter_tablespace 0
  294. Com_analyze 0
  295. Com_assign_to_keycache 0
  296. Com_backup_table 0
  297. Com_begin 0
  298. Com_binlog 0
  299. Com_call_procedure 0
  300. Com_change_db 52
  301. Com_change_master 0
  302. Com_check 0
  303. Com_checksum 0
  304. Com_commit 0
  305. Com_create_db 0
  306. Com_create_event 0
  307. Com_create_function 0
  308. Com_create_index 0
  309. Com_create_procedure 0
  310. Com_create_server 0
  311. Com_create_table 7
  312. Com_create_trigger 0
  313. Com_create_udf 0
  314. Com_create_user 0
  315. Com_create_view 0
  316. Com_dealloc_sql 0
  317. Com_delete 29
  318. Com_delete_multi 0
  319. Com_do 0
  320. Com_drop_db 0
  321. Com_drop_event 0
  322. Com_drop_function 0
  323. Com_drop_index 0
  324. Com_drop_procedure 0
  325. Com_drop_server 0
  326. Com_drop_table 12
  327. Com_drop_trigger 0
  328. Com_drop_user 0
  329. Com_drop_view 0
  330. Com_empty_query 0
  331. Com_execute_sql 0
  332. Com_flush 0
  333. Com_grant 0
  334. Com_ha_close 0
  335. Com_ha_open 0
  336. Com_ha_read 0
  337. Com_help 0
  338. Com_insert 65820
  339. Com_insert_select 1
  340. Com_install_plugin 0
  341. Com_kill 0
  342. Com_load 0
  343. Com_load_master_data 0
  344. Com_load_master_table 0
  345. Com_lock_tables 0
  346. Com_optimize 0
  347. Com_preload_keys 0
  348. Com_prepare_sql 0
  349. Com_purge 0
  350. Com_purge_before_date 0
  351. Com_release_savepoint 0
  352. Com_rename_table 0
  353. Com_rename_user 0
  354. Com_repair 0
  355. Com_replace 0
  356. Com_replace_select 0
  357. Com_reset 0
  358. Com_restore_table 0
  359. Com_revoke 0
  360. Com_revoke_all 0
  361. Com_rollback 0
  362. Com_rollback_to_savepoint 0
  363. Com_savepoint 0
  364. Com_select 94
  365. Com_set_option 95
  366. Com_show_authors 0
  367. Com_show_binlog_events 0
  368. Com_show_binlogs 0
  369. Com_show_charsets 1
  370. Com_show_collations 1
  371. Com_show_column_types 0
  372. Com_show_contributors 0
  373. Com_show_create_db 0
  374. Com_show_create_event 0
  375. Com_show_create_func 0
  376. Com_show_create_proc 0
  377. Com_show_create_table 36
  378. Com_show_create_trigger 0
  379. Com_show_databases 6
  380. Com_show_engine_logs 0
  381. Com_show_engine_mutex 0
  382. Com_show_engine_status 0
  383. Com_show_errors 0
  384. Com_show_events 0
  385. Com_show_fields 11
  386. Com_show_function_status 1
  387. Com_show_grants 0
  388. Com_show_keys 9
  389. Com_show_master_status 0
  390. Com_show_new_master 0
  391. Com_show_open_tables 0
  392. Com_show_plugins 0
  393. Com_show_privileges 0
  394. Com_show_procedure_status 1
  395. Com_show_processlist 0
  396. Com_show_profile 0
  397. Com_show_profiles 0
  398. Com_show_slave_hosts 0
  399. Com_show_slave_status 0
  400. Com_show_status 1
  401. Com_show_storage_engines 1
  402. Com_show_table_status 12
  403. Com_show_tables 11
  404. Com_show_triggers 0
  405. Com_show_variables 10
  406. Com_show_warnings 0
  407. Com_slave_start 0
  408. Com_slave_stop 0
  409. Com_stmt_close 0
  410. Com_stmt_execute 0
  411. Com_stmt_fetch 0
  412. Com_stmt_prepare 0
  413. Com_stmt_reprepare 0
  414. Com_stmt_reset 0
  415. Com_stmt_send_long_data 0
  416. Com_truncate 0
  417. Com_uninstall_plugin 0
  418. Com_unlock_tables 0
  419. Com_update 0
  420. Com_update_multi 0
  421. Com_xa_commit 0
  422. Com_xa_end 0
  423. Com_xa_prepare 0
  424. Com_xa_recover 0
  425. Com_xa_rollback 0
  426. Com_xa_start 0
  427. Compression OFF
  428. Connections 62
  429. Created_tmp_disk_tables 42
  430. Created_tmp_files 5
  431. Created_tmp_tables 106
  432. Delayed_errors 0
  433. Delayed_insert_threads 0
  434. Delayed_writes 0
  435. Flush_commands 1
  436. Handler_commit 0
  437. Handler_delete 29
  438. Handler_discover 0
  439. Handler_prepare 0
  440. Handler_read_first 50
  441. Handler_read_key 9990
  442. Handler_read_next 653
  443. Handler_read_prev 0
  444. Handler_read_rnd 2864
  445. Handler_read_rnd_next 73193
  446. Handler_rollback 0
  447. Handler_savepoint 0
  448. Handler_savepoint_rollback 0
  449. Handler_update 0
  450. Handler_write 71697
  451. Innodb_buffer_pool_pages_data 48
  452. Innodb_buffer_pool_pages_dirty 0
  453. Innodb_buffer_pool_pages_flushed 0
  454. Innodb_buffer_pool_pages_free 976
  455. Innodb_buffer_pool_pages_misc 0
  456. Innodb_buffer_pool_pages_total 1024
  457. Innodb_buffer_pool_read_ahead_rnd 1
  458. Innodb_buffer_pool_read_ahead_seq 0
  459. Innodb_buffer_pool_read_requests 846
  460. Innodb_buffer_pool_reads 25
  461. Innodb_buffer_pool_wait_free 0
  462. Innodb_buffer_pool_write_requests 0
  463. Innodb_data_fsyncs 3
  464. Innodb_data_pending_fsyncs 0
  465. Innodb_data_pending_reads 0
  466. Innodb_data_pending_writes 0
  467. Innodb_data_read 2969600
  468. Innodb_data_reads 58
  469. Innodb_data_writes 3
  470. Innodb_data_written 1536
  471. Innodb_dblwr_pages_written 0
  472. Innodb_dblwr_writes 0
  473. Innodb_log_waits 0
  474. Innodb_log_write_requests 0
  475. Innodb_log_writes 1
  476. Innodb_os_log_fsyncs 3
  477. Innodb_os_log_pending_fsyncs 0
  478. Innodb_os_log_pending_writes 0
  479. Innodb_os_log_written 512
  480. Innodb_page_size 16384
  481. Innodb_pages_created 0
  482. Innodb_pages_read 48
  483. Innodb_pages_written 0
  484. Innodb_row_lock_current_waits 0
  485. Innodb_row_lock_time 0
  486. Innodb_row_lock_time_avg 0
  487. Innodb_row_lock_time_max 0
  488. Innodb_row_lock_waits 0
  489. Innodb_rows_deleted 0
  490. Innodb_rows_inserted 0
  491. Innodb_rows_read 0
  492. Innodb_rows_updated 0
  493. Key_blocks_not_flushed 0
  494. Key_blocks_unused 14333
  495. Key_blocks_used 3932
  496. Key_read_requests 774418
  497. Key_reads 72
  498. Key_write_requests 293055
  499. Key_writes 292123
  500. Last_query_cost 0.000000
  501. Max_used_connections 5
  502. Not_flushed_delayed_rows 0
  503. Open_files 14
  504. Open_streams 0
  505. Open_table_definitions 23
  506. Open_tables 7
  507. Opened_files 448
  508. Opened_table_definitions 39
  509. Opened_tables 54
  510. Prepared_stmt_count 0
  511. Qcache_free_blocks 0
  512. Qcache_free_memory 0
  513. Qcache_hits 0
  514. Qcache_inserts 0
  515. Qcache_lowmem_prunes 0
  516. Qcache_not_cached 0
  517. Qcache_queries_in_cache 0
  518. Qcache_total_blocks 0
  519. Queries 66308
  520. Questions 66308
  521. Rpl_status NULL
  522. Select_full_join 0
  523. Select_full_range_join 0
  524. Select_range 42
  525. Select_range_check 0
  526. Select_scan 107
  527. Slave_open_temp_tables 0
  528. Slave_retried_transactions 0
  529. Slave_running OFF
  530. Slow_launch_threads 0
  531. Slow_queries 0
  532. Sort_merge_passes 0
  533. Sort_range 0
  534. Sort_rows 2864
  535. Sort_scan 23
  536. Ssl_accept_renegotiates 0
  537. Ssl_accepts 0
  538. Ssl_callback_cache_hits 0
  539. Ssl_cipher
  540. Ssl_cipher_list
  541. Ssl_client_connects 0
  542. Ssl_connect_renegotiates 0
  543. Ssl_ctx_verify_depth 0
  544. Ssl_ctx_verify_mode 0
  545. Ssl_default_timeout 0
  546. Ssl_finished_accepts 0
  547. Ssl_finished_connects 0
  548. Ssl_session_cache_hits 0
  549. Ssl_session_cache_misses 0
  550. Ssl_session_cache_mode NONE
  551. Ssl_session_cache_overflows 0
  552. Ssl_session_cache_size 0
  553. Ssl_session_cache_timeouts 0
  554. Ssl_sessions_reused 0
  555. Ssl_used_session_cache_entries 0
  556. Ssl_verify_depth 0
  557. Ssl_verify_mode 0
  558. Ssl_version
  559. Table_locks_immediate 65934
  560. Table_locks_waited 0
  561. Tc_log_max_pages_used 0
  562. Tc_log_page_size 0
  563. Tc_log_page_waits 0
  564. Threads_cached 0
  565. Threads_connected 4
  566. Threads_created 61
  567. Threads_running 1
  568. Uptime 2667
  569. Uptime_since_flush_status 2667
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!