Mysql trés lent à se connecter

Mysql trés lent à se connecter - Logiciels - Windows & Software

Marsh Posté le 28-03-2013 à 11:54:56    

Bonjour,
 
  J'utilise EsayPHP, mon Intranet se connectait instantanément (qq millisecondes) sur l'ancien serveur, mais depuis le nouveau serveur il met 1s (500x moins rapide).
  Comment trouver la source de ce problème ?
  Voici les variables et le status, voyez-vous quelque chose d'anormal qui pourrait expliquer cette lenteur ?
 
 

Code :
  1. auto_increment_increment 1
  2. auto_increment_offset 1
  3. autocommit ON
  4. automatic_sp_privileges ON
  5. back_log 50
  6. basedir D:/EASYPH~1.1/mysql/
  7. big_tables OFF
  8. binlog_cache_size 32768
  9. binlog_direct_non_transactional_updates OFF
  10. binlog_format MIXED
  11. binlog_stmt_cache_size 32768
  12. bulk_insert_buffer_size 8388608
  13. character_set_client utf8
  14. character_set_connection utf8
  15. character_set_database latin1
  16. character_set_filesystem binary
  17. character_set_results utf8
  18. character_set_server latin1
  19. character_set_system utf8
  20. character_sets_dir D:\EASYPH~1.1\mysql\share\charsets\
  21. collation_connection utf8_general_ci
  22. collation_database latin1_swedish_ci
  23. collation_server latin1_swedish_ci
  24. completion_type NO_CHAIN
  25. concurrent_insert AUTO
  26. connect_timeout 10
  27. datadir D:\EASYPH~1.1\mysql\data\
  28. date_format %Y-%m-%d
  29. datetime_format %Y-%m-%d %H:%i:%s
  30. default_storage_engine InnoDB
  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. external_user
  42. flush OFF
  43. flush_time 1800
  44. foreign_key_checks ON
  45. ft_boolean_syntax + -><()~*:""&|
  46. ft_max_word_len 84
  47. ft_min_word_len 4
  48. ft_query_expansion_limit 20
  49. ft_stopword_file (built-in)
  50. general_log OFF
  51. general_log_file D:\EASYPH~1.1\mysql\data\CCS-FSDB12.log
  52. group_concat_max_len 1024
  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_profiling YES
  63. have_query_cache YES
  64. have_rtree_keys YES
  65. have_ssl DISABLED
  66. have_symlink YES
  67. hostname CCS-FSDB12
  68. identity 0
  69. ignore_builtin_innodb OFF
  70. init_connect
  71. init_file
  72. init_slave
  73. innodb_adaptive_flushing ON
  74. innodb_adaptive_hash_index ON
  75. innodb_additional_mem_pool_size 2097152
  76. innodb_autoextend_increment 8
  77. innodb_autoinc_lock_mode 1
  78. innodb_buffer_pool_instances 1
  79. innodb_buffer_pool_size 16777216
  80. innodb_change_buffering all
  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_format Antelope
  89. innodb_file_format_check ON
  90. innodb_file_format_max Antelope
  91. innodb_file_per_table OFF
  92. innodb_flush_log_at_trx_commit 1
  93. innodb_flush_method
  94. innodb_force_load_corrupted OFF
  95. innodb_force_recovery 0
  96. innodb_io_capacity 200
  97. innodb_large_prefix OFF
  98. innodb_lock_wait_timeout 50
  99. innodb_locks_unsafe_for_binlog OFF
  100. innodb_log_buffer_size 1048576
  101. innodb_log_file_size 5242880
  102. innodb_log_files_in_group 2
  103. innodb_log_group_home_dir .\
  104. innodb_max_dirty_pages_pct 75
  105. innodb_max_purge_lag 0
  106. innodb_mirrored_log_groups 1
  107. innodb_old_blocks_pct 37
  108. innodb_old_blocks_time 0
  109. innodb_open_files 300
  110. innodb_purge_batch_size 20
  111. innodb_purge_threads 0
  112. innodb_random_read_ahead OFF
  113. innodb_read_ahead_threshold 56
  114. innodb_read_io_threads 4
  115. innodb_replication_delay 0
  116. innodb_rollback_on_timeout OFF
  117. innodb_rollback_segments 128
  118. innodb_spin_wait_delay 6
  119. innodb_stats_method nulls_equal
  120. innodb_stats_on_metadata ON
  121. innodb_stats_sample_pages 8
  122. innodb_strict_mode OFF
  123. innodb_support_xa ON
  124. innodb_sync_spin_loops 30
  125. innodb_table_locks ON
  126. innodb_thread_concurrency 0
  127. innodb_thread_sleep_delay 10000
  128. innodb_use_native_aio ON
  129. innodb_use_sys_malloc ON
  130. innodb_version 1.1.8
  131. innodb_write_io_threads 4
  132. insert_id 0
  133. interactive_timeout 28800
  134. join_buffer_size 131072
  135. keep_files_on_create OFF
  136. key_buffer_size 16777216
  137. key_cache_age_threshold 300
  138. key_cache_block_size 1024
  139. key_cache_division_limit 100
  140. large_files_support ON
  141. large_page_size 0
  142. large_pages OFF
  143. last_insert_id 0
  144. lc_messages en_US
  145. lc_messages_dir D:\EASYPH~1.1\mysql\share\
  146. lc_time_names en_US
  147. license GPL
  148. local_infile ON
  149. lock_wait_timeout 31536000
  150. log OFF
  151. log_bin ON
  152. log_bin_trust_function_creators OFF
  153. log_error D:\EASYPH~1.1\mysql\data\CCS-FSDB12.err
  154. log_output FILE
  155. log_queries_not_using_indexes OFF
  156. log_slave_updates OFF
  157. log_slow_queries OFF
  158. log_warnings 1
  159. long_query_time 10.000000
  160. low_priority_updates OFF
  161. lower_case_file_system ON
  162. lower_case_table_names 1
  163. max_allowed_packet 1048576
  164. max_binlog_cache_size 18446744073709547520
  165. max_binlog_size 1073741824
  166. max_binlog_stmt_cache_size 18446744073709547520
  167. max_connect_errors 10
  168. max_connections 151
  169. max_delayed_threads 20
  170. max_error_count 64
  171. max_heap_table_size 16777216
  172. max_insert_delayed_threads 20
  173. max_join_size 18446744073709551615
  174. max_length_for_sort_data 1024
  175. max_long_data_size 1048576
  176. max_prepared_stmt_count 16382
  177. max_relay_log_size 0
  178. max_seeks_for_key 4294967295
  179. max_sort_length 1024
  180. max_sp_recursion_depth 0
  181. max_tmp_tables 32
  182. max_user_connections 0
  183. max_write_lock_count 4294967295
  184. metadata_locks_cache_size 1024
  185. min_examined_row_limit 0
  186. multi_range_count 256
  187. myisam_data_pointer_size 6
  188. myisam_max_sort_file_size 2146435072
  189. myisam_mmap_size 4294967295
  190. myisam_recover_options OFF
  191. myisam_repair_threads 1
  192. myisam_sort_buffer_size 8388608
  193. myisam_stats_method nulls_unequal
  194. myisam_use_mmap OFF
  195. named_pipe OFF
  196. net_buffer_length 8192
  197. net_read_timeout 30
  198. net_retry_count 10
  199. net_write_timeout 60
  200. new OFF
  201. old OFF
  202. old_alter_table OFF
  203. old_passwords OFF
  204. open_files_limit 2803
  205. optimizer_prune_level 1
  206. optimizer_search_depth 62
  207. optimizer_switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on
  208. performance_schema OFF
  209. performance_schema_events_waits_history_long_size 10000
  210. performance_schema_events_waits_history_size 10
  211. performance_schema_max_cond_classes 80
  212. performance_schema_max_cond_instances 1000
  213. performance_schema_max_file_classes 50
  214. performance_schema_max_file_handles 32768
  215. performance_schema_max_file_instances 10000
  216. performance_schema_max_mutex_classes 200
  217. performance_schema_max_mutex_instances 1000000
  218. performance_schema_max_rwlock_classes 30
  219. performance_schema_max_rwlock_instances 1000000
  220. performance_schema_max_table_handles 100000
  221. performance_schema_max_table_instances 50000
  222. performance_schema_max_thread_classes 50
  223. performance_schema_max_thread_instances 1000
  224. pid_file D:\EASYPH~1.1\mysql\data\CCS-FSDB12.pid
  225. plugin_dir D:\EASYPH~1.1\mysql\lib\plugin\
  226. port 3306
  227. preload_buffer_size 32768
  228. profiling OFF
  229. profiling_history_size 15
  230. protocol_version 10
  231. proxy_user
  232. pseudo_thread_id 5531
  233. query_alloc_block_size 8192
  234. query_cache_limit 1048576
  235. query_cache_min_res_unit 4096
  236. query_cache_size 0
  237. query_cache_type ON
  238. query_cache_wlock_invalidate OFF
  239. query_prealloc_size 8192
  240. rand_seed1 0
  241. rand_seed2 0
  242. range_alloc_block_size 4096
  243. read_buffer_size 262144
  244. read_only OFF
  245. read_rnd_buffer_size 524288
  246. relay_log
  247. relay_log_index
  248. relay_log_info_file relay-log.info
  249. relay_log_purge ON
  250. relay_log_recovery OFF
  251. relay_log_space_limit 0
  252. report_host
  253. report_password
  254. report_port 3306
  255. report_user
  256. rpl_recovery_rank 0
  257. secure_auth OFF
  258. secure_file_priv
  259. server_id 1
  260. shared_memory OFF
  261. shared_memory_base_name MYSQL
  262. skip_external_locking ON
  263. skip_name_resolve OFF
  264. skip_networking OFF
  265. skip_show_database OFF
  266. slave_compressed_protocol OFF
  267. slave_exec_mode STRICT
  268. slave_load_tmpdir C:\Windows\TEMP
  269. slave_max_allowed_packet 1073741824
  270. slave_net_timeout 3600
  271. slave_skip_errors OFF
  272. slave_transaction_retries 10
  273. slave_type_conversions
  274. slow_launch_time 2
  275. slow_query_log OFF
  276. slow_query_log_file D:\EASYPH~1.1\mysql\data\CCS-FSDB12-slow.log
  277. socket D:/EASYPH~1.1/mysql/mysql.sock
  278. sort_buffer_size 524288
  279. sql_auto_is_null OFF
  280. sql_big_selects ON
  281. sql_big_tables OFF
  282. sql_buffer_result OFF
  283. sql_log_bin ON
  284. sql_log_off OFF
  285. sql_low_priority_updates OFF
  286. sql_max_join_size 18446744073709551615
  287. sql_mode
  288. sql_notes ON
  289. sql_quote_show_create ON
  290. sql_safe_updates OFF
  291. sql_select_limit 18446744073709551615
  292. sql_slave_skip_counter 0
  293. sql_warnings OFF
  294. ssl_ca
  295. ssl_capath
  296. ssl_cert
  297. ssl_cipher
  298. ssl_key
  299. storage_engine InnoDB
  300. stored_program_cache 256
  301. sync_binlog 0
  302. sync_frm ON
  303. sync_master_info 0
  304. sync_relay_log 0
  305. sync_relay_log_info 0
  306. system_time_zone Paris, Madrid
  307. table_definition_cache 400
  308. table_open_cache 64
  309. thread_cache_size 0
  310. thread_concurrency 10
  311. thread_handling one-thread-per-connection
  312. thread_stack 196608
  313. time_format %H:%i:%s
  314. time_zone SYSTEM
  315. timed_mutexes OFF
  316. timestamp 1364467491
  317. tmp_table_size 16777216
  318. tmpdir C:\Windows\TEMP
  319. transaction_alloc_block_size 8192
  320. transaction_prealloc_size 4096
  321. tx_isolation REPEATABLE-READ
  322. unique_checks ON
  323. updatable_views_with_limit YES
  324. version 5.5.27-log
  325. version_comment MySQL Community Server (GPL)
  326. version_compile_machine x86
  327. version_compile_os Win32
  328. wait_timeout 28800
  329. warning_count 0


 
Status (uniquement les valeurs >0)

Code :
  1. Binlog_cache_disk_use 3
  2. Binlog_cache_use 10
  3. Binlog_stmt_cache_use 1125
  4. Bytes_received 150
  5. Bytes_sent 115
  6. Com_set_option 2
  7. Com_show_status 1
  8. Compression OFF
  9. Connections 5498
  10. Created_tmp_files 366
  11. Flush_commands 1
  12. Innodb_buffer_pool_pages_data 1022
  13. Innodb_buffer_pool_pages_flushed 874
  14. Innodb_buffer_pool_pages_free 1
  15. Innodb_buffer_pool_pages_misc 1
  16. Innodb_buffer_pool_pages_total 1024
  17. Innodb_buffer_pool_read_ahead 83816
  18. Innodb_buffer_pool_read_ahead_evicted 2057
  19. Innodb_buffer_pool_read_requests 10256049
  20. Innodb_buffer_pool_reads 8185
  21. Innodb_buffer_pool_write_requests 30824
  22. Innodb_data_fsyncs 330
  23. Innodb_data_read 1509527552
  24. Innodb_data_reads 92011
  25. Innodb_data_writes 1165
  26. Innodb_data_written 31732224
  27. Innodb_dblwr_pages_written 874
  28. Innodb_dblwr_writes 40
  29. Innodb_have_atomic_builtins ON
  30. Innodb_log_write_requests 6406
  31. Innodb_log_writes 227
  32. Innodb_os_log_fsyncs 250
  33. Innodb_os_log_written 3080704
  34. Innodb_page_size 16384
  35. Innodb_pages_created 90
  36. Innodb_pages_read 92000
  37. Innodb_pages_written 874
  38. Innodb_rows_deleted 24
  39. Innodb_rows_inserted 9437
  40. Innodb_rows_read 9836455
  41. Innodb_rows_updated 1
  42. Key_blocks_unused 14287
  43. Key_blocks_used 143
  44. Key_read_requests 356853
  45. Key_reads 2002
  46. Key_write_requests 1703
  47. Key_writes 255
  48. Last_query_cost 0.000000
  49. Max_used_connections 9
  50. Open_files 100
  51. Open_table_definitions 386
  52. Open_tables 52
  53. Opened_files 11430
  54. Queries 86202
  55. Questions 3
  56. Rpl_status AUTH_MASTER
  57. Slave_heartbeat_period 0.000
  58. Slave_running OFF
  59. Ssl_cipher
  60. Ssl_cipher_list
  61. Ssl_session_cache_mode NONE
  62. Ssl_version
  63. Table_locks_immediate 66013
  64. Threads_connected 1
  65. Threads_created 5497
  66. Threads_running 1
  67. Uptime 547166
  68. Uptime_since_flush_status 547166


 
Merci par avance.


---------------
Le problème avec les idées derrière la tête c'est qu'on ne peut pas les voir :??:
Reply

Marsh Posté le 28-03-2013 à 11:54:56   

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed