英文:
laravel website freeze after 15-30 refreshes
问题
Here is the translated content:
我有一个使用Laravel制作的网站，它不太庞大，使用了一个mysql数据库。
服务器信息：
微型服务器（SBC）
CPU：Intel® Celeron® N5105 4核4线程
内存：LPDDR4 8GB
存储：500GB NVMe
操作系统：Ubuntu 22.04.2 LTS
Web服务器：Apache 2.4.52
PHP版本：8.1
当我使用网站时，如果操作较慢，服务器的第一个响应大约需要200-300毫秒。但是当我快速刷新页面20-30次时，页面会冻结，下一次需要等待5秒钟才能收到服务器的第一个响应。有时在刷新10次后，有时甚至在30次后会发生，这不是一个固定的值。但一旦发生这种情况，其他用户在此时无法加载页面，他们必须等待5秒或更长时间。大约20-30秒后，网站会再次运行快速。
示例良好的结果：
20-30次刷新后：
无论是通过域名还是通过IP请求，都不会有影响。这是在网站冻结期间快速刷新时的服务器统计信息：
我尝试过：
- 将Apache2更改为使用php-fpm（https://www.digitalocean.com/community/tutorials/how-to-configure-apache-http-with-mpm-event-and-php-fpm-on-ubuntu-18-04）
- 重新安装整个Ubuntu并使用Nginx进行配置
不幸的是，问题仍然存在。我在想问题是出在服务器本身还是配置上。在我设置了Google云平台上最小可能的VM - 这是e2-micro（0.25-2 vCPU 1GB MEM） - 安装我的网站后，问题不再出现：O 我可以刷新50次甚至100次。有人能告诉我为什么我的服务器上效果这么差吗？这至少比Google云平台上的性能好4倍。
这是“SHOW VARIABLES;”的输出。
英文:
I have a website which is made in Laravel. it is not too extensive, it uses a mysql database
machine:
microserver (SBC)
CPU: Intel® Celeron® N5105 4c/4t
MEM: LPDDR4 8GB
Storage: 500GB NVMe
System: Ubuntu 22.04.2 LTS
Web: Apache 2.4.52
PHP: 8.1
when I am using the site relatively slowly, the first server response is after about 200-300ms.
but when i refresh the page 20-30 times fast. the page freezes and you have to wait 5 seconds for the first response from the server next time. sometimes the page slows down after 10 and sometimes even after 30 refreshes it is not a constant value. but once this happens, no other user can load the page at that time and they have to wait 5 or more seconds. after about 20-30 seconds, the website works fast again
Example good result:
after 20-30 refreshes:
it doesn't matter if it performs a request via a domain or to a local server via ip. this is server stats during rapid refreshing while website is frozen:
i tried:
changing apache2 to use php-fpm (https://www.digitalocean.com/community/tutorials/how-to-configure-apache-http-with-mpm-event-and-php-fpm-on-ubuntu-18-04)
reinstalled whole ubuntu and configured with nginx
unfortunately the problem still exists I'm wondering if the problem is with the server itself or with the configuration. it seems to me that the server is quite strong for these needs and should easily withstand this load - it's like 20-30 people browsing my site at the same time.
I also set up the smallest possible VM on GCP - this is e2-micro (0.25-2 vCPU 1GB MEM) - installed my website there THE PROBLEM DOESN'T OCCUR :O I can refresh it 50 or 100 times. Can someone tell me why on my server this is working so badly. it's at least 4 times better than the one on gcp
SHOW VARIABLES;
activate_all_roles_on_login OFFadmin_addressadmin_port *****admin_ssl_caadmin_ssl_capathadmin_ssl_certadmin_ssl_cipheradmin_ssl_crladmin_ssl_crlpathadmin_ssl_keyadmin_tls_ciphersuitesadmin_tls_version TLSv1.2,TLSv1.3authentication_policy *,,auto_generate_certs ONauto_increment_increment 1auto_increment_offset 1autocommit ONautomatic_sp_privileges ONavoid_temporal_upgrade OFFback_log 151basedir /usr/big_tables OFFbind_address 127.0.0.1binlog_cache_size 32768binlog_checksum CRC32binlog_direct_non_transactional_updates OFFbinlog_encryption OFFbinlog_error_action ABORT_SERVERbinlog_expire_logs_auto_purge ONbinlog_expire_logs_seconds 2592000binlog_format ROWbinlog_group_commit_sync_delay 0binlog_group_commit_sync_no_delay_count 0binlog_gtid_simple_recovery ONbinlog_max_flush_queue_time 0binlog_order_commits ONbinlog_rotate_encryption_master_key_at_startup OFFbinlog_row_event_max_size 8192binlog_row_image FULLbinlog_row_metadata MINIMALbinlog_row_value_optionsbinlog_rows_query_log_events OFFbinlog_stmt_cache_size 32768binlog_transaction_compression OFFbinlog_transaction_compression_level_zstd 3binlog_transaction_dependency_history_size 25000binlog_transaction_dependency_tracking COMMIT_ORDERblock_encryption_mode aes-128-ecbbuild_id 03172b8eeae9ab733eff94a4fc191f6acced9b6dbulk_insert_buffer_size 8388608caching_sha2_password_auto_generate_rsa_keys ONcaching_sha2_password_digest_rounds 5000caching_sha2_password_private_key_path private_key.pemcaching_sha2_password_public_key_path public_key.pemcharacter_set_client utf8mb4character_set_connection utf8mb4character_set_database utf8mb4character_set_filesystem binarycharacter_set_results utf8mb4character_set_server utf8mb4character_set_system utf8mb3character_sets_dir /usr/share/mysql/charsets/check_proxy_users OFFcollation_connection utf8mb4_unicode_cicollation_database utf8mb4_0900_ai_cicollation_server utf8mb4_0900_ai_cicompletion_type NO_CHAINconcurrent_insert AUTOconnect_timeout 10connection_memory_chunk_size 8912connection_memory_limit 18446744073709551615core_file OFFcreate_admin_listener_thread OFFcte_max_recursion_depth 1000datadir /var/lib/mysql/default_authentication_plugin caching_sha2_passworddefault_collation_for_utf8mb4 utf8mb4_0900_ai_cidefault_password_lifetime 0default_storage_engine InnoDBdefault_table_encryption OFFdefault_tmp_storage_engine InnoDBdefault_week_format 0delay_key_write ONdelayed_insert_limit 100delayed_insert_timeout 300delayed_queue_size 1000disabled_storage_enginesdisconnect_on_expired_password ONdiv_precision_increment 4end_markers_in_json OFFenforce_gtid_consistency OFFeq_range_index_dive_limit 200error_count 0event_scheduler ONexpire_logs_days 0explain_format TRADITIONALexplicit_defaults_for_timestamp ONexternal_userflush OFFflush_time 0foreign_key_checks ONft_boolean_syntax + -><()~*:""&|ft_max_word_len 84ft_min_word_len 4ft_query_expansion_limit 20ft_stopword_file (built-in)general_log OFFgeneral_log_file /var/lib/mysql/lattepanda.loggenerated_random_password_length 20global_connection_memory_limit 18446744073709551615global_connection_memory_tracking OFFgroup_concat_max_len 1024group_replication_consistency EVENTUALgtid_executedgtid_executed_compression_period 0gtid_mode OFFgtid_next AUTOMATICgtid_ownedgtid_purgedhave_compress YEShave_dynamic_loading YEShave_geometry YEShave_openssl YEShave_profiling YEShave_query_cache NOhave_rtree_keys YEShave_ssl YEShave_statement_timeout YEShave_symlink DISABLEDhistogram_generation_max_mem_size 20000000host_cache_size 279hostname lattepandaidentity 0immediate_server_version 999999information_schema_stats_expiry 86400init_connectinit_fileinit_replicainit_slaveinnodb_adaptive_flushing ONinnodb_adaptive_flushing_lwm 10innodb_adaptive_hash_index ONinnodb_adaptive_hash_index_parts 8innodb_adaptive_max_sleep_delay 150000innodb_api_bk_commit_interval 5innodb_api_disable_rowlock OFFinnodb_api_enable_binlog OFFinnodb_api_enable_mdl OFFinnodb_api_trx_level 0innodb_autoextend_increment 64innodb_autoinc_lock_mode 2innodb_buffer_pool_chunk_size 134217728innodb_buffer_pool_dump_at_shutdown ONinnodb_buffer_pool_dump_now OFFinnodb_buffer_pool_dump_pct 25innodb_buffer_pool_filename ib_buffer_poolinnodb_buffer_pool_in_core_file ONinnodb_buffer_pool_instances 1innodb_buffer_pool_load_abort OFFinnodb_buffer_pool_load_at_startup ONinnodb_buffer_pool_load_now OFFinnodb_buffer_pool_size 134217728innodb_change_buffer_max_size 25innodb_change_buffering allinnodb_checksum_algorithm crc32innodb_cmp_per_index_enabled OFFinnodb_commit_concurrency 0innodb_compression_failure_threshold_pct 5innodb_compression_level 6innodb_compression_pad_pct_max 50innodb_concurrency_tickets 5000innodb_data_file_path ibdata1:12M:autoextendinnodb_data_home_dirinnodb_ddl_buffer_size 1048576innodb_ddl_threads 4innodb_deadlock_detect ONinnodb_dedicated_server OFFinnodb_default_row_format dynamicinnodb_directoriesinnodb_disable_sort_file_cache OFFinnodb_doublewrite ONinnodb_doublewrite_batch_size 0innodb_doublewrite_dirinnodb_doublewrite_files 2innodb_doublewrite_pages 4innodb_extend_and_initialize ONinnodb_fast_shutdown 1innodb_file_per_table ONinnodb_fill_factor 100innodb_flush_log_at_timeout 1innodb_flush_log_at_trx_commit 1innodb_flush_method fsyncinnodb_flush_neighbors 0innodb_flush_sync ONinnodb_flushing_avg_loops 30innodb_force_load_corrupted OFFinnodb_force_recovery 0innodb_fsync_threshold 0innodb_ft_aux_tableinnodb_ft_cache_size 8000000innodb_ft_enable_diag_print OFFinnodb_ft_enable_stopword ONinnodb_ft_max_token_size 84innodb_ft_min_token_size 3innodb_ft_num_word_optimize 2000innodb_ft_result_cache_limit 2000000000innodb_ft_server_stopword_tableinnodb_ft_sort_pll_degree 2innodb_ft_total_cache_size 640000000innodb_ft_user_stopword_tableinnodb_idle_flush_pct 100innodb_io_capacity 200innodb_io_capacity_max 2000innodb_lock_wait_timeout 50innodb_log_buffer_size 16777216innodb_log_checksums ONinnodb_log_compressed_pages ONinnodb_log_file_size 50331648innodb_log_files_in_group 2innodb_log_group_home_dir ./innodb_log_spin_cpu_abs_lwm 80innodb_log_spin_cpu_pct_hwm 50innodb_log_wait_for_flush_spin_hwm 400innodb_log_write_ahead_size 8192innodb_log_writer_threads ONinnodb_lru_scan_depth 1024innodb_max_dirty_pages_pct 90.000000innodb_max_dirty_pages_pct_lwm 10.000000innodb_max_purge_lag 0innodb_max_purge_lag_delay 0innodb_max_undo_log_size 1073741824innodb_monitor_disableinnodb_monitor_enableinnodb_monitor_resetinnodb_monitor_reset_allinnodb_numa_interleave OFFinnodb_old_blocks_pct 37innodb_old_blocks_time 1000innodb_online_alter_log_max_size 134217728innodb_open_files 4000innodb_optimize_fulltext_only OFFinnodb_page_cleaners 1innodb_page_size 16384innodb_parallel_read_threads 4innodb_print_all_deadlocks OFFinnodb_print_ddl_logs OFFinnodb_purge_batch_size 300innodb_purge_rseg_truncate_frequency 128innodb_purge_threads 4innodb_random_read_ahead OFFinnodb_read_ahead_threshold 56innodb_read_io_threads 4innodb_read_only OFFinnodb_redo_log_archive_dirsinnodb_redo_log_capacity 104857600innodb_redo_log_encrypt OFFinnodb_replication_delay 0innodb_rollback_on_timeout OFFinnodb_rollback_segments 128innodb_segment_reserve_factor 12.500000innodb_sort_buffer_size 1048576innodb_spin_wait_delay 6innodb_spin_wait_pause_multiplier 50innodb_stats_auto_recalc ONinnodb_stats_include_delete_marked OFFinnodb_stats_method nulls_equalinnodb_stats_on_metadata OFFinnodb_stats_persistent ONinnodb_stats_persistent_sample_pages 20innodb_stats_transient_sample_pages 8innodb_status_output OFFinnodb_status_output_locks OFFinnodb_strict_mode ONinnodb_sync_array_size 1innodb_sync_spin_loops 30innodb_table_locks ONinnodb_temp_data_file_path ibtmp1:12M:autoextendinnodb_temp_tablespaces_dir ./#innodb_temp/innodb_thread_concurrency 0innodb_thread_sleep_delay 10000innodb_tmpdirinnodb_undo_directory ./innodb_undo_log_encrypt OFFinnodb_undo_log_truncate ONinnodb_undo_tablespaces 2innodb_use_fdatasync OFFinnodb_use_native_aio ONinnodb_validate_tablespace_paths ONinnodb_version 8.0.33innodb_write_io_threads 4insert_id 0interactive_timeout 28800internal_tmp_mem_storage_engine TempTablejoin_buffer_size 262144keep_files_on_create OFFkey_buffer_size 16777216key_cache_age_threshold 300key_cache_block_size 1024key_cache_division_limit 100keyring_operations ONlarge_files_support ONlarge_page_size 0large_pages OFFlast_insert_id 0lc_messages en_USlc_messages_dir /usr/share/mysql/lc_time_names en_USlicense GPLlocal_infile OFFlock_wait_timeout 31536000locked_in_memory OFFlog_bin ONlog_bin_basename /var/lib/mysql/binloglog_bin_index /var/lib/mysql/binlog.indexlog_bin_trust_function_creators OFFlog_bin_use_v1_row_events OFFlog_error /var/log/mysql/error.loglog_error_services log_filter_internal; log_sink_internallog_error_suppression_listlog_error_verbosity 2log_output FILElog_queries_not_using_indexes OFFlog_raw OFFlog_replica_updates ONlog_slave_updates ONlog_slow_admin_statements OFFlog_slow_extra OFFlog_slow_replica_statements OFFlog_slow_slave_statements OFFlog_statements_unsafe_for_binlog ONlog_throttle_queries_not_using_indexes 0log_timestamps UTClong_query_time 10.000000low_priority_updates OFFlower_case_file_system OFFlower_case_table_names 0mandatory_rolesmaster_info_repository TABLEmaster_verify_checksum OFFmax_allowed_packet 67108864max_binlog_cache_size 18446744073709547520max_binlog_size 104857600max_binlog_stmt_cache_size 18446744073709547520max_connect_errors 100max_connections 151max_delayed_threads 20max_digest_length 1024max_error_count 1024max_execution_time 0max_heap_table_size 16777216max_insert_delayed_threads 20max_join_size 18446744073709551615max_length_for_sort_data 4096max_points_in_geometry 65536max_prepared_stmt_count 16382max_relay_log_size 0max_seeks_for_key 18446744073709551615max_sort_length 1024max_sp_recursion_depth 0max_user_connections 0max_write_lock_count 18446744073709551615min_examined_row_limit 0myisam_data_pointer_size 6myisam_max_sort_file_size 9223372036853727232myisam_mmap_size 18446744073709551615myisam_recover_options BACKUPmyisam_sort_buffer_size 8388608myisam_stats_method nulls_unequalmyisam_use_mmap OFFmysql_native_password_proxy_users OFFmysqlx_bind_address 127.0.0.1mysqlx_compression_algorithms DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAMmysqlx_connect_timeout 30mysqlx_deflate_default_compression_level 3mysqlx_deflate_max_client_compression_level 5mysqlx_document_id_unique_prefix 0mysqlx_enable_hello_notice ONmysqlx_idle_worker_thread_timeout 60mysqlx_interactive_timeout 28800mysqlx_lz4_default_compression_level 2mysqlx_lz4_max_client_compression_level 8mysqlx_max_allowed_packet 67108864mysqlx_max_connections 100mysqlx_min_worker_threads 2mysqlx_port 33060mysqlx_port_open_timeout 0mysqlx_read_timeout 30mysqlx_socket /var/run/mysqld/mysqlx.sockmysqlx_ssl_camysqlx_ssl_capathmysqlx_ssl_certmysqlx_ssl_ciphermysqlx_ssl_crlmysqlx_ssl_crlpathmysqlx_ssl_keymysqlx_wait_timeout 28800mysqlx_write_timeout 60mysqlx_zstd_default_compression_level 3mysqlx_zstd_max_client_compression_level 11net_buffer_length 16384net_read_timeout 30net_retry_count 10net_write_timeout 60new OFFngram_token_size 2offline_mode OFFold OFFold_alter_table OFFopen_files_limit 10000optimizer_max_subgraph_pairs 100000optimizer_prune_level 1optimizer_search_depth 62optimizer_switch index_merge=on,index_merge_union=on,index_merge_so...optimizer_trace enabled=off,one_line=offoptimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=...optimizer_trace_limit 1optimizer_trace_max_mem_size 1048576optimizer_trace_offset -1original_commit_timestamp 36028797018963968original_server_version 999999parser_max_mem_size 18446744073709551615partial_revokes OFFpassword_history 0password_require_current OFFpassword_reuse_interval 0performance_schema ONperformance_schema_accounts_size -1performance_schema_digests_size 10000performance_schema_error_size 5288performance_schema_events_stages_history_long_size 10000performance_schema_events_stages_history_size 10performance_schema_events_statements_history_long_... 10000performance_schema_events_statements_history_size 10performance_schema_events_transactions_history_lon... 10000performance_schema_events_transactions_history_siz... 10performance_schema_events_waits_history_long_size 10000performance_schema_events_waits_history_size 10performance_schema_hosts_size -1performance_schema_max_cond_classes 150performance_schema_max_cond_instances -1performance_schema_max_digest_length 1024performance_schema_max_digest_sample_age 60performance_schema_max_file_classes 80performance_schema_max_file_handles 32768performance_schema_max_file_instances -1performance_schema_max_index_stat -1performance_schema_max_memory_classes 450performance_schema_max_metadata_locks -1performance_schema_max_mutex_classes 350performance_schema_max_mutex_instances -1performance_schema_max_prepared_statements_instanc... -1performance_schema_max_program_instances -1performance_schema_max_rwlock_classes 60performance_schema_max_rwlock_instances -1performance_schema_max_socket_classes 10performance_schema_max_socket_instances -1performance_schema_max_sql_text_length 1024performance_schema_max_stage_classes 175performance_schema_max_statement_classes 219performance_schema_max_statement_stack 10performance_schema_max_table_handles -1performance_schema_max_table_instances -1performance_schema_max_table_lock_stat -1performance_schema_max_thread_classes 100performance_schema_max_thread_instances -1performance_schema_session_connect_attrs_size 512performance_schema_setup_actors_size -1performance_schema_setup_objects_size -1performance_schema_show_processlist OFFperformance_schema_users_size -1persist_only_admin_x509_subjectpersist_sensitive_variables_in_plaintext ONpersisted_globals_load ONpid_file /var/lib/mysql/lattepanda.pidplugin_dir /usr/lib/mysql/plugin/port 3306preload_buffer_size 32768print_identified_with_as_hex OFFprofiling OFFprofiling_history_size 15protocol_compression_algorithms zlib,zstd,uncompressedprotocol_version 10proxy_userpseudo_replica_mode OFFpseudo_slave_mode OFFpseudo_thread_id 7911query_alloc_block_size 8192query_prealloc_size 8192rand_seed1 0rand_seed2 0range_alloc_block_size 4096range_optimizer_max_mem_size 8388608rbr_exec_mode STRICTread_buffer_size 131072read_only OFFread_rnd_buffer_size 262144regexp_stack_limit 8000000regexp_time_limit 32relay_log lattepanda-relay-binrelay_log_basename /var/lib/mysql/lattepanda-relay-binrelay_log_index /var/lib/mysql/lattepanda-relay-bin.indexrelay_log_info_file relay-log.inforelay_log_info_repository TABLErelay_log_purge ONrelay_log_recovery OFFrelay_log_space_limit 0replica_allow_batching ONreplica_checkpoint_group 512replica_checkpoint_period 300replica_compressed_protocol OFFreplica_exec_mode STRICTreplica_load_tmpdir /tmpreplica_max_allowed_packet 1073741824replica_net_timeout 60replica_parallel_type LOGICAL_CLOCKreplica_parallel_workers 4replica_pending_jobs_size_max 134217728replica_preserve_commit_order ONreplica_skip_errors OFFreplica_sql_verify_checksum ONreplica_transaction_retries 10replica_type_conversionsreplication_optimize_for_static_plugin_config OFFreplication_sender_observe_commit_only OFFreport_hostreport_passwordreport_port 3306report_userrequire_row_format OFFrequire_secure_transport OFFresultset_metadata FULLrpl_read_size 8192rpl_stop_replica_timeout 31536000rpl_stop_slave_timeout 31536000schema_definition_cache 256secondary_engine_cost_threshold 100000.000000secure_file_priv /var/lib/mysql-files/select_into_buffer_size 131072select_into_disk_sync OFFselect_into_disk_sync_delay 0server_id 1server_id_bits 32server_uuid 13ae3759-1efd-11ed-9b66-00e04c0ba112session_track_gtids OFFsession_track_schema ONsession_track_state_change OFFsession_track_system_variables time_zone,autocommit,character_set_client,characte...session_track_transaction_info OFFsha256_password_auto_generate_rsa_keys ONsha256_password_private_key_path private_key.pemsha256_password_proxy_users OFFsha256_password_public_key_path public_key.pemshow_create_table_skip_secondary_engine OFFshow_create_table_verbosity OFFshow_gipk_in_create_table_and_information_schema ONshow_old_temporals OFFskip_external_locking ONskip_name_resolve OFFskip_networking OFFskip_replica_start OFFskip_show_database OFFskip_slave_start OFFslave_allow_batching ONslave_checkpoint_group 512slave_checkpoint_period 300slave_compressed_protocol OFFslave_exec_mode STRICTslave_load_tmpdir /tmpslave_max_allowed_packet 1073741824slave_net_timeout 60slave_parallel_type LOGICAL_CLOCKslave_parallel_workers 4slave_pending_jobs_size_max 134217728slave_preserve_commit_order ONslave_rows_search_algorithms INDEX_SCAN,HASH_SCANslave_skip_errors OFFslave_sql_verify_checksum ONslave_transaction_retries 10slave_type_conversionsslow_launch_time 2slow_query_log OFFslow_query_log_file /var/lib/mysql/lattepanda-slow.logsocket /var/run/mysqld/mysqld.socksort_buffer_size 262144source_verify_checksum OFFsql_auto_is_null OFFsql_big_selects ONsql_buffer_result OFFsql_generate_invisible_primary_key OFFsql_log_bin ONsql_log_off OFFsql_mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_...sql_notes ONsql_quote_show_create ONsql_replica_skip_counter 0sql_require_primary_key OFFsql_safe_updates OFFsql_select_limit 18446744073709551615sql_slave_skip_counter 0sql_warnings OFFssl_ca ca.pemssl_capathssl_cert server-cert.pemssl_cipherssl_crlssl_crlpathssl_fips_mode OFFssl_key server-key.pemssl_session_cache_mode ONssl_session_cache_timeout 300statement_id 1151955stored_program_cache 256stored_program_definition_cache 256super_read_only OFFsync_binlog 1sync_master_info 10000sync_relay_log 10000sync_relay_log_info 10000sync_source_info 10000system_time_zone CESTtable_definition_cache 2000table_encryption_privilege_check OFFtable_open_cache 4000table_open_cache_instances 16tablespace_definition_cache 256temptable_max_mmap 1073741824temptable_max_ram 1073741824temptable_use_mmap ONterminology_use_previous NONEthread_cache_size 9thread_handling one-thread-per-connectionthread_stack 1048576time_zone SYSTEMtimestamp 1688073784.830778tls_ciphersuitestls_version TLSv1.2,TLSv1.3tmp_table_size 16777216tmpdir /tmptransaction_alloc_block_size 8192transaction_allow_batching OFFtransaction_isolation REPEATABLE-READtransaction_prealloc_size 4096transaction_read_only OFFtransaction_write_set_extraction XXHASH64unique_checks ONupdatable_views_with_limit YESuse_secondary_engine ONversion 8.0.33-0ubuntu0.22.04.2version_comment (Ubuntu)version_compile_machine x86_64version_compile_os Linuxversion_compile_zlib 1.2.13wait_timeout 28800warning_count 0windowing_use_high_precision ONxa_detach_on_prepare ON
答案1
得分: 0
经过几天的努力解决这个问题，我成功找到了原因。我的服务器和域名是通过CloudFlare隧道配置的，以确保在任何端口，甚至80端口上都不会暴露IP地址。更多信息请参考这里：
https://developers.cloudflare.com/cloudflare-one/connections/connect-apps/
原来，通过这样的隧道传输的流量在某种程度上受到限制，可能是速率限制。一旦我重新配置了DNS并在A记录中指定了服务器的直接IP地址，服务器就可以处理数千个请求而没有任何问题。
如果将来有人遇到类似问题并且同时使用这样的隧道，记得要注意这个限制。
英文:
After a few days of struggling with this problem, I managed to find the cause. My server and domain was configured through the CloudFlare tunnel so as not to expose the IP address in any way on any port, even 80. more information available here:
https://developers.cloudflare.com/cloudflare-one/connections/connect-apps/
it turns out that the traffic that goes through such a tunnel is somehow limited - maybe it's a rate limit. as soon as I reconfigured the dns and indicated the direct IP address of the server in the A record. The server handles thousands of requests without any problem.
If someone in the future would have a problem with this and uses such a tunnel at the same time, it is worth remembering about this limitation
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论