CentOS, Nginx, CMS Битрикс
Постоянно таймауты во время бэкапа двух сайтов (файлы + база, на cron'e запущено), из-за этого таймауты API к сайту (на битриксе оба сайта).
Проверил NGINX вроде конфа норма (если надо выложу)
Top
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1139 nginx 20 0 1161m 196m 157m S 8.9 0.6 1:36.58 php-fpm
15514 nginx 20 0 94552 49m 2632 S 8.9 0.2 45:00.45 nginx
7870 mysql 20 0 12.8g 7.5g 13m S 1.3 24.0 3891:39 mysqld
32286 nginx 20 0 1162m 203m 172m S 1.0 0.6 1:45.06 php-fpm
Вот результат запроса в phpmyadmin:
SHOW GLOBAL STATUSVariable_name
Value
Aborted_clients
3528
Aborted_connects
316548
Binlog_cache_disk_use
0
Binlog_cache_use
0
Bytes_received
743570754143
Bytes_sent
4921171436283
Com_admin_commands
0
Com_assign_to_keycache
0
Com_alter_db
4
Com_alter_db_upgrade
0
Com_alter_event
0
Com_alter_function
0
Com_alter_procedure
0
Com_alter_server
0
Com_alter_table
273
Com_alter_tablespace
0
Com_analyze
2452
Com_backup_table
0
Com_begin
6278
Com_binlog
0
Com_call_procedure
0
Com_change_db
21569947
Com_change_master
0
Com_check
2961
Com_checksum
0
Com_commit
5477
Com_create_db
2
Com_create_event
0
Com_create_function
0
Com_create_index
380
Com_create_procedure
0
Com_create_server
0
Com_create_table
18690
Com_create_trigger
0
Com_create_udf
0
Com_create_user
0
Com_create_view
0
Com_dealloc_sql
0
Com_delete
22657804
Com_delete_multi
486
Com_do
8400913
Com_drop_db
0
Com_drop_event
0
Com_drop_function
0
Com_drop_index
0
Com_drop_procedure
0
Com_drop_server
0
Com_drop_table
34352
Com_drop_trigger
0
Com_drop_user
0
Com_drop_view
0
Com_empty_query
3
Com_execute_sql
0
Com_flush
0
Com_grant
1
Com_ha_close
0
Com_ha_open
0
Com_ha_read
0
Com_help
0
Com_insert
27679778
Com_insert_select
12763961
Com_install_plugin
0
Com_kill
0
Com_load
0
Com_load_master_data
0
Com_load_master_table
0
Com_lock_tables
142
Com_optimize
2535
Com_preload_keys
0
Com_prepare_sql
0
Com_purge
0
Com_purge_before_date
0
Com_release_savepoint
0
Com_rename_table
0
Com_rename_user
0
Com_repair
4
Com_replace
16230
Com_replace_select
0
Com_reset
0
Com_restore_table
0
Com_revoke
2
Com_revoke_all
0
Com_rollback
62
Com_rollback_to_savepoint
0
Com_savepoint
0
Com_select
121138705
Com_set_option
34815804
Com_show_authors
0
Com_show_binlog_events
0
Com_show_binlogs
67
Com_show_charsets
8900
Com_show_collations
64
Com_show_column_types
0
Com_show_contributors
0
Com_show_create_db
1
Com_show_create_event
0
Com_show_create_func
0
Com_show_create_proc
0
Com_show_create_table
234403
Com_show_create_trigger
0
Variable_name
Value
Com_show_databases
3588
Com_show_engine_logs
0
Com_show_engine_mutex
0
Com_show_engine_status
0
Com_show_events
53
Com_show_errors
0
Com_show_fields
4768558
Com_show_function_status
478
Com_show_grants
14
Com_show_keys
45561
Com_show_master_status
101
Com_show_new_master
0
Com_show_open_tables
0
Com_show_plugins
2
Com_show_privileges
0
Com_show_procedure_status
478
Com_show_processlist
0
Com_show_profile
0
Com_show_profiles
0
Com_show_slave_hosts
0
Com_show_slave_status
101
Com_show_status
12
Com_show_storage_engines
2
Com_show_table_status
206514
Com_show_tables
847658
Com_show_triggers
203738
Com_show_variables
6054
Com_show_warnings
1
Com_slave_start
0
Com_slave_stop
0
Com_stmt_close
0
Com_stmt_execute
0
Com_stmt_fetch
0
Com_stmt_prepare
0
Com_stmt_reprepare
0
Com_stmt_reset
0
Com_stmt_send_long_data
0
Com_truncate
205
Com_uninstall_plugin
0
Com_unlock_tables
169
Com_update
66155397
Com_update_multi
16610
Com_xa_commit
0
Com_xa_end
0
Com_xa_prepare
0
Com_xa_recover
0
Com_xa_rollback
0
Com_xa_start
0
Compression
OFF
Connections
17209698
Created_tmp_disk_tables
12177717
Created_tmp_files
87505
Created_tmp_tables
19621245
Delayed_errors
0
Delayed_insert_threads
0
Delayed_writes
0
Flush_commands
1
Handler_commit
240938453
Handler_delete
28067775
Handler_discover
0
Handler_prepare
0
Handler_read_first
16552231
Handler_read_key
111646312521
Handler_read_next
21364311642
Handler_read_prev
263575649
Handler_read_rnd
1205365504
Handler_read_rnd_next
72666398848
Handler_rollback
5563
Handler_savepoint
0
Handler_savepoint_rollback
0
Handler_update
141245889
Handler_write
1308204356
Innodb_buffer_pool_pages_data
255889
Innodb_buffer_pool_pages_dirty
201
Innodb_buffer_pool_pages_flushed
55949892
Innodb_buffer_pool_pages_free
60
Innodb_buffer_pool_pages_misc
6195
Innodb_buffer_pool_pages_total
262144
Innodb_buffer_pool_read_ahead_rnd
26
Innodb_buffer_pool_read_ahead_seq
1158
Innodb_buffer_pool_read_requests
352299524470
Innodb_buffer_pool_reads
86403
Innodb_buffer_pool_wait_free
0
Innodb_buffer_pool_write_requests
934987418
Innodb_data_fsyncs
15221212
Innodb_data_pending_fsyncs
0
Innodb_data_pending_reads
0
Innodb_data_pending_writes
0
Innodb_data_read
2463698944
Innodb_data_reads
112154
Innodb_data_writes
145529490
Innodb_data_written
1129839431168
Innodb_dblwr_pages_written
0
Innodb_dblwr_writes
0
Innodb_log_waits
0
Innodb_log_write_requests
359312161
Innodb_log_writes
104958358
Innodb_os_log_fsyncs
5333328
Innodb_os_log_pending_fsyncs
0
Innodb_os_log_pending_writes
0
Variable_name
Value
Innodb_os_log_written
212743475200
Innodb_page_size
16384
Innodb_pages_created
384107
Innodb_pages_read
150239
Innodb_pages_written
55949892
Innodb_row_lock_current_waits
0
Innodb_row_lock_time
413249
Innodb_row_lock_time_avg
14
Innodb_row_lock_time_max
50811
Innodb_row_lock_waits
27915
Innodb_rows_deleted
27930971
Innodb_rows_inserted
46286944
Innodb_rows_read
202494005481
Innodb_rows_updated
64076740
Key_blocks_not_flushed
0
Key_blocks_unused
1714736
Key_blocks_used
7404
Key_read_requests
1590583468
Key_reads
542188
Key_write_requests
406952453
Key_writes
697161
Last_query_cost
0.000000
Max_used_connections
152
Not_flushed_delayed_rows
0
Open_files
1432
Open_streams
0
Open_table_definitions
4096
Open_tables
4096
Opened_files
70473387
Opened_table_definitions
16505726
Opened_tables
17874877
Prepared_stmt_count
0
Qcache_free_blocks
1810
Qcache_free_memory
5774912
Qcache_hits
1051104716
Qcache_inserts
75978100
Qcache_lowmem_prunes
20369508
Qcache_not_cached
44986474
Qcache_queries_in_cache
3578
Qcache_total_blocks
9427
Queries
1389614181
Questions
1389614181
Rpl_status
NULL
Select_full_join
2222096
Select_full_range_join
1024222
Select_range
9244653
Select_range_check
0
Select_scan
15457204
Slave_open_temp_tables
0
Slave_retried_transactions
0
Slave_running
OFF
Slow_launch_threads
0
Slow_queries
20132
Sort_merge_passes
43750
Sort_range
7200282
Sort_rows
1162558587
Sort_scan
17843614
Ssl_accept_renegotiates
0
Ssl_accepts
0
Ssl_callback_cache_hits
0
Ssl_cipher
Ssl_cipher_list
Ssl_client_connects
0
Ssl_connect_renegotiates
0
Ssl_ctx_verify_depth
0
Ssl_ctx_verify_mode
0
Ssl_default_timeout
0
Ssl_finished_accepts
0
Ssl_finished_connects
0
Ssl_session_cache_hits
0
Ssl_session_cache_misses
0
Ssl_session_cache_mode
NONE
Ssl_session_cache_overflows
0
Ssl_session_cache_size
0
Ssl_session_cache_timeouts
0
Ssl_sessions_reused
0
Ssl_used_session_cache_entries
0
Ssl_verify_depth
0
Ssl_verify_mode
0
Ssl_version
Table_locks_immediate
487146379
Table_locks_waited
875
Tc_log_max_pages_used
0
Tc_log_page_size
0
Tc_log_page_waits
0
Threads_cached
63
Threads_connected
1
Threads_created
2640
Threads_running
1
Uptime
6738397
Uptime_since_flush_status
6738397
Простой
