Forum |  HardWare.fr | News | Articles | PC | S'identifier | S'inscrire | Shop Recherche
2348 connectés 

  FORUM HardWare.fr
  Windows & Software
  Logiciels

  Mysql trés lent à se connecter

 
 


 Mot :   Pseudo :  
 
Bas de page
Auteur Sujet :

Mysql trés lent à se connecter

n°3082524
snike
Posté le 28-03-2013 à 11:54:56  profilanswer
 

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 :??:
mood
Publicité
Posté le 28-03-2013 à 11:54:56  profilanswer
 


Aller à :
Ajouter une réponse
  FORUM HardWare.fr
  Windows & Software
  Logiciels

  Mysql trés lent à se connecter

 

Sujets relatifs
Problème démarrage Windows 7 très longMon pc est infecté et devient super lent, des pub non désirées
Visionneuse de photo windows 7 très lente à l'affichageProbleme clic droit "lent"
[RESOLU] Ordinateur (Poste de travail) et explorateur innacessible[ Résolu] Chenillard lent XP
[resolu] clic droit (menu contextuel) lent - Win 8Réseau local très lent... PC-NeufBox 4-Synology DS212j
Memoire Utiliser très élevé "lsass.exe" 
Plus de sujets relatifs à : Mysql trés lent à se connecter

Forum MesDiscussions.Net, Version 2010.2
(c) 2000-2011 Doctissimo
Page générée en 0.088 secondes

Copyright © 1997-2022 Hardware.fr SARL (Signaler un contenu illicite / Données personnelles) / Groupe LDLC / Shop HFR