Solved

How can I improve the performance of MYSQL and APACHE under High Loads?

Posted on 2014-07-24
19
607 Views
Last Modified: 2015-02-27
Hello to everyone I would like to know how to improve the performance of my Apache and MySQL server under high loads aprox a concurrency of 1000 users. I am using linux OS deployed in a Virtual Machine using Hyper-V (Windows 2012R2 Datacenter)

My hardware:
Proliant ML370G6 2 CPU XEON  E5410 @ 2.33GHz, 4 cores each with 52GB RAM

APACHE
Version: 2.2.15 (64bits)

My Configuration:

<IfModule prefork.c>
        StartServers         25
        MinSpareServers      25
        MaxSpareServers      50
        ServerLimit          300
        MaxClients           250
        MaxRequestsPerChild  1000
</IfModule>
<IfModule worker.c>
        StartServers         3
        MinSpareThreads     25
        MaxSpareThreads     75
        ThreadLimit         64
        MaxClients         150
        ThreadsPerChild     25
        MaxRequestsPerChild  100
</IfModule>
KeepAlive On
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 2

Open in new window



MYSQL
Version: 5.6.12 (64bits)


My Variables:

"Variable_name"	"Value"
"auto_increment_increment"	"1"
"auto_increment_offset"	"1"
"autocommit"	"ON"
"automatic_sp_privileges"	"ON"
"back_log"	"80"
"basedir"	"/usr"
"big_tables"	"OFF"
"bind_address"	"*"
"binlog_cache_size"	"32768"
"binlog_checksum"	"CRC32"
"binlog_direct_non_transactional_updates"	"OFF"
"binlog_format"	"MIXED"
"binlog_max_flush_queue_time"	"0"
"binlog_order_commits"	"ON"
"binlog_row_image"	"FULL"
"binlog_rows_query_log_events"	"OFF"
"binlog_stmt_cache_size"	"32768"
"bulk_insert_buffer_size"	"8388608"
"character_set_client"	"utf8"
"character_set_connection"	"utf8"
"character_set_database"	"utf8"
"character_set_filesystem"	"binary"
"character_set_results"	"utf8"
"character_set_server"	"utf8"
"character_set_system"	"utf8"
"character_sets_dir"	"/usr/share/mysql-community-server/charsets/"
"collation_connection"	"utf8_general_ci"
"collation_database"	"utf8_general_ci"
"collation_server"	"utf8_general_ci"
"completion_type"	"NO_CHAIN"
"concurrent_insert"	"AUTO"
"connect_timeout"	"10"
"core_file"	"OFF"
"datadir"	"/var/lib/mysql/"
"date_format"	"%Y-%m-%d"
"datetime_format"	"%Y-%m-%d %H:%i:%s"
"default_storage_engine"	"InnoDB"
"default_tmp_storage_engine"	"InnoDB"
"default_week_format"	"0"
"delay_key_write"	"ON"
"delayed_insert_limit"	"100"
"delayed_insert_timeout"	"300"
"delayed_queue_size"	"1000"
"disconnect_on_expired_password"	"ON"
"div_precision_increment"	"4"
"end_markers_in_json"	"OFF"
"enforce_gtid_consistency"	"OFF"
"eq_range_index_dive_limit"	"10"
"error_count"	"0"
"event_scheduler"	"OFF"
"expire_logs_days"	"99"
"explicit_defaults_for_timestamp"	"OFF"
"external_user"	""
"flush"	"OFF"
"flush_time"	"0"
"foreign_key_checks"	"ON"
"ft_boolean_syntax"	"+ -><()~*:""""&|"
"ft_max_word_len"	"84"
"ft_min_word_len"	"4"
"ft_query_expansion_limit"	"20"
"ft_stopword_file"	"(built-in)"
"general_log"	"ON"
"general_log_file"	"/var/log/mysql/mysqld.log"
"group_concat_max_len"	"1024"
"gtid_executed"	""
"gtid_mode"	"OFF"
"gtid_next"	"AUTOMATIC"
"gtid_owned"	""
"gtid_purged"	""
"have_compress"	"YES"
"have_crypt"	"YES"
"have_dynamic_loading"	"YES"
"have_geometry"	"YES"
"have_openssl"	"DISABLED"
"have_profiling"	"YES"
"have_query_cache"	"YES"
"have_rtree_keys"	"YES"
"have_ssl"	"DISABLED"
"have_symlink"	"YES"
"host_cache_size"	"279"
"hostname"	"mysql"
"identity"	"0"
"ignore_builtin_innodb"	"OFF"
"ignore_db_dirs"	""
"init_connect"	""
"init_file"	""
"init_slave"	""
"innodb_adaptive_flushing"	"ON"
"innodb_adaptive_flushing_lwm"	"10"
"innodb_adaptive_hash_index"	"ON"
"innodb_adaptive_max_sleep_delay"	"150000"
"innodb_additional_mem_pool_size"	"8388608"
"innodb_api_bk_commit_interval"	"5"
"innodb_api_disable_rowlock"	"OFF"
"innodb_api_enable_binlog"	"OFF"
"innodb_api_enable_mdl"	"OFF"
"innodb_api_trx_level"	"0"
"innodb_autoextend_increment"	"64"
"innodb_autoinc_lock_mode"	"1"
"innodb_buffer_pool_dump_at_shutdown"	"OFF"
"innodb_buffer_pool_dump_now"	"OFF"
"innodb_buffer_pool_filename"	"ib_buffer_pool"
"innodb_buffer_pool_instances"	"32"
"innodb_buffer_pool_load_abort"	"OFF"
"innodb_buffer_pool_load_at_startup"	"OFF"
"innodb_buffer_pool_load_now"	"OFF"
"innodb_buffer_pool_size"	"10737418240"
"innodb_change_buffer_max_size"	"25"
"innodb_change_buffering"	"all"
"innodb_checksum_algorithm"	"innodb"
"innodb_checksums"	"ON"
"innodb_cmp_per_index_enabled"	"OFF"
"innodb_commit_concurrency"	"0"
"innodb_compression_failure_threshold_pct"	"5"
"innodb_compression_level"	"6"
"innodb_compression_pad_pct_max"	"50"
"innodb_concurrency_tickets"	"6000"
"innodb_data_file_path"	"ibdata1:12M:autoextend"
"innodb_data_home_dir"	""
"innodb_disable_sort_file_cache"	"OFF"
"innodb_doublewrite"	"ON"
"innodb_fast_shutdown"	"1"
"innodb_file_format"	"Barracuda"
"innodb_file_format_check"	"ON"
"innodb_file_format_max"	"Barracuda"
"innodb_file_per_table"	"ON"
"innodb_flush_log_at_timeout"	"1"
"innodb_flush_log_at_trx_commit"	"1"
"innodb_flush_method"	""
"innodb_flush_neighbors"	"1"
"innodb_flushing_avg_loops"	"30"
"innodb_force_load_corrupted"	"OFF"
"innodb_force_recovery"	"0"
"innodb_ft_aux_table"	""
"innodb_ft_cache_size"	"8000000"
"innodb_ft_enable_diag_print"	"OFF"
"innodb_ft_enable_stopword"	"ON"
"innodb_ft_max_token_size"	"84"
"innodb_ft_min_token_size"	"3"
"innodb_ft_num_word_optimize"	"2000"
"innodb_ft_server_stopword_table"	""
"innodb_ft_sort_pll_degree"	"2"
"innodb_ft_user_stopword_table"	""
"innodb_io_capacity"	"100"
"innodb_io_capacity_max"	"2000"
"innodb_large_prefix"	"OFF"
"innodb_lock_wait_timeout"	"50"
"innodb_locks_unsafe_for_binlog"	"OFF"
"innodb_log_buffer_size"	"8388608"
"innodb_log_compressed_pages"	"ON"
"innodb_log_file_size"	"50331648"
"innodb_log_files_in_group"	"2"
"innodb_log_group_home_dir"	"./"
"innodb_lru_scan_depth"	"1024"
"innodb_max_dirty_pages_pct"	"75"
"innodb_max_dirty_pages_pct_lwm"	"0"
"innodb_max_purge_lag"	"0"
"innodb_max_purge_lag_delay"	"0"
"innodb_mirrored_log_groups"	"1"
"innodb_monitor_disable"	""
"innodb_monitor_enable"	""
"innodb_monitor_reset"	""
"innodb_monitor_reset_all"	""
"innodb_old_blocks_pct"	"37"
"innodb_old_blocks_time"	"1000"
"innodb_online_alter_log_max_size"	"134217728"
"innodb_open_files"	"2000"
"innodb_optimize_fulltext_only"	"OFF"
"innodb_page_size"	"16384"
"innodb_print_all_deadlocks"	"OFF"
"innodb_purge_batch_size"	"450"
"innodb_purge_threads"	"1"
"innodb_random_read_ahead"	"OFF"
"innodb_read_ahead_threshold"	"56"
"innodb_read_io_threads"	"16"
"innodb_read_only"	"OFF"
"innodb_replication_delay"	"0"
"innodb_rollback_on_timeout"	"OFF"
"innodb_rollback_segments"	"128"
"innodb_sort_buffer_size"	"1048576"
"innodb_spin_wait_delay"	"3"
"innodb_stats_auto_recalc"	"ON"
"innodb_stats_method"	"nulls_equal"
"innodb_stats_on_metadata"	"OFF"
"innodb_stats_persistent"	"ON"
"innodb_stats_persistent_sample_pages"	"20"
"innodb_stats_sample_pages"	"8"
"innodb_stats_transient_sample_pages"	"8"
"innodb_strict_mode"	"OFF"
"innodb_support_xa"	"ON"
"innodb_sync_array_size"	"1"
"innodb_sync_spin_loops"	"30"
"innodb_table_locks"	"ON"
"innodb_thread_concurrency"	"24"
"innodb_thread_sleep_delay"	"150000"
"innodb_undo_directory"	"."
"innodb_undo_logs"	"128"
"innodb_undo_tablespaces"	"0"
"innodb_use_native_aio"	"ON"
"innodb_use_sys_malloc"	"ON"
"innodb_version"	"5.6.12"
"innodb_write_io_threads"	"12"
"insert_id"	"0"
"interactive_timeout"	"28800"
"join_buffer_size"	"262144"
"keep_files_on_create"	"OFF"
"key_buffer_size"	"8388608"
"key_cache_age_threshold"	"300"
"key_cache_block_size"	"1024"
"key_cache_division_limit"	"100"
"large_files_support"	"ON"
"large_page_size"	"0"
"large_pages"	"OFF"
"last_insert_id"	"0"
"lc_messages"	"en_US"
"lc_messages_dir"	"/usr/share/mysql-community-server/"
"lc_time_names"	"en_US"
"license"	"GPL"
"local_infile"	"ON"
"lock_wait_timeout"	"31536000"
"locked_in_memory"	"OFF"
"log_bin"	"ON"
"log_bin_basename"	"/var/lib/mysql/mysql-bin"
"log_bin_index"	"/var/lib/mysql/mysql-bin.index"
"log_bin_trust_function_creators"	"OFF"
"log_bin_use_v1_row_events"	"OFF"
"log_error"	"/var/log/mysql/mysqld.err"
"log_output"	"FILE"
"log_queries_not_using_indexes"	"ON"
"log_slave_updates"	"OFF"
"log_slow_admin_statements"	"OFF"
"log_slow_slave_statements"	"OFF"
"log_throttle_queries_not_using_indexes"	"0"
"log_warnings"	"1"
"long_query_time"	"10.000000"
"low_priority_updates"	"OFF"
"lower_case_file_system"	"OFF"
"lower_case_table_names"	"0"
"master_info_repository"	"FILE"
"master_verify_checksum"	"OFF"
"max_allowed_packet"	"4194304"
"max_binlog_cache_size"	"18446744073709547520"
"max_binlog_size"	"1073741824"
"max_binlog_stmt_cache_size"	"18446744073709547520"
"max_connect_errors"	"100"
"max_connections"	"500"
"max_delayed_threads"	"20"
"max_error_count"	"64"
"max_heap_table_size"	"16777216"
"max_insert_delayed_threads"	"20"
"max_join_size"	"18446744073709551615"
"max_length_for_sort_data"	"1024"
"max_prepared_stmt_count"	"16382"
"max_relay_log_size"	"0"
"max_seeks_for_key"	"18446744073709551615"
"max_sort_length"	"1024"
"max_sp_recursion_depth"	"0"
"max_tmp_tables"	"32"
"max_user_connections"	"0"
"max_write_lock_count"	"18446744073709551615"
"metadata_locks_cache_size"	"1024"
"metadata_locks_hash_instances"	"8"
"min_examined_row_limit"	"0"
"multi_range_count"	"256"
"myisam_data_pointer_size"	"6"
"myisam_max_sort_file_size"	"9223372036853727232"
"myisam_mmap_size"	"18446744073709551615"
"myisam_recover_options"	"OFF"
"myisam_repair_threads"	"1"
"myisam_sort_buffer_size"	"8388608"
"myisam_stats_method"	"nulls_unequal"
"myisam_use_mmap"	"OFF"
"net_buffer_length"	"16384"
"net_read_timeout"	"30"
"net_retry_count"	"10"
"net_write_timeout"	"60"
"new"	"OFF"
"old"	"OFF"
"old_alter_table"	"OFF"
"old_passwords"	"0"
"open_files_limit"	"5000"
"optimizer_prune_level"	"1"
"optimizer_search_depth"	"62"
"optimizer_switch"	"index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on"
"optimizer_trace"	"enabled=off,one_line=off"
"optimizer_trace_features"	"greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on"
"optimizer_trace_limit"	"1"
"optimizer_trace_max_mem_size"	"16384"
"optimizer_trace_offset"	"-1"
"performance_schema"	"ON"
"performance_schema_accounts_size"	"100"
"performance_schema_digests_size"	"10000"
"performance_schema_events_stages_history_long_size"	"10000"
"performance_schema_events_stages_history_size"	"10"
"performance_schema_events_statements_history_long_size"	"10000"
"performance_schema_events_statements_history_size"	"10"
"performance_schema_events_waits_history_long_size"	"10000"
"performance_schema_events_waits_history_size"	"10"
"performance_schema_hosts_size"	"100"
"performance_schema_max_cond_classes"	"80"
"performance_schema_max_cond_instances"	"3504"
"performance_schema_max_file_classes"	"50"
"performance_schema_max_file_handles"	"32768"
"performance_schema_max_file_instances"	"7693"
"performance_schema_max_mutex_classes"	"200"
"performance_schema_max_mutex_instances"	"15906"
"performance_schema_max_rwlock_classes"	"30"
"performance_schema_max_rwlock_instances"	"9102"
"performance_schema_max_socket_classes"	"10"
"performance_schema_max_socket_instances"	"322"
"performance_schema_max_stage_classes"	"150"
"performance_schema_max_statement_classes"	"167"
"performance_schema_max_table_handles"	"4000"
"performance_schema_max_table_instances"	"12500"
"performance_schema_max_thread_classes"	"50"
"performance_schema_max_thread_instances"	"402"
"performance_schema_session_connect_attrs_size"	"512"
"performance_schema_setup_actors_size"	"100"
"performance_schema_setup_objects_size"	"100"
"performance_schema_users_size"	"100"
"pid_file"	"/var/run/mysql/mysqld.pid"
"plugin_dir"	"/usr/lib64/mysql/plugin/"
"port"	"3306"
"preload_buffer_size"	"32768"
"profiling"	"OFF"
"profiling_history_size"	"15"
"protocol_version"	"10"
"proxy_user"	""
"pseudo_slave_mode"	"OFF"
"pseudo_thread_id"	"1818"
"query_alloc_block_size"	"8192"
"query_cache_limit"	"8388608"
"query_cache_min_res_unit"	"4096"
"query_cache_size"	"1048576"
"query_cache_type"	"OFF"
"query_cache_wlock_invalidate"	"OFF"
"query_prealloc_size"	"8192"
"rand_seed1"	"0"
"rand_seed2"	"0"
"range_alloc_block_size"	"4096"
"read_buffer_size"	"131072"
"read_only"	"OFF"
"read_rnd_buffer_size"	"1048576"
"relay_log"	""
"relay_log_basename"	""
"relay_log_index"	""
"relay_log_info_file"	"relay-log.info"
"relay_log_info_repository"	"FILE"
"relay_log_purge"	"ON"
"relay_log_recovery"	"OFF"
"relay_log_space_limit"	"0"
"report_host"	""
"report_password"	""
"report_port"	"3306"
"report_user"	""
"secure_auth"	"ON"
"secure_file_priv"	""
"server_id"	"1"
"server_id_bits"	"32"
"server_uuid"	"9b922bff-12bc-11e4-825f-00155d0a0c00"
"sha256_password_private_key_path"	"private_key.pem"
"sha256_password_public_key_path"	"public_key.pem"
"skip_external_locking"	"ON"
"skip_name_resolve"	"OFF"
"skip_networking"	"OFF"
"skip_show_database"	"OFF"
"slave_allow_batching"	"OFF"
"slave_checkpoint_group"	"512"
"slave_checkpoint_period"	"300"
"slave_compressed_protocol"	"OFF"
"slave_exec_mode"	"STRICT"
"slave_load_tmpdir"	"/var/tmp/mysql.3U0stY"
"slave_max_allowed_packet"	"1073741824"
"slave_net_timeout"	"3600"
"slave_parallel_workers"	"0"
"slave_pending_jobs_size_max"	"16777216"
"slave_rows_search_algorithms"	"TABLE_SCAN,INDEX_SCAN"
"slave_skip_errors"	"OFF"
"slave_sql_verify_checksum"	"ON"
"slave_transaction_retries"	"10"
"slave_type_conversions"	""
"slow_launch_time"	"2"
"slow_query_log"	"ON"
"slow_query_log_file"	"/var/log/mysql/mysqld.slow"
"socket"	"/var/run/mysql/mysql.sock"
"sort_buffer_size"	"1048576"
"sql_auto_is_null"	"OFF"
"sql_big_selects"	"ON"
"sql_buffer_result"	"OFF"
"sql_log_bin"	"ON"
"sql_log_off"	"OFF"
"sql_mode"	"STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
"sql_notes"	"ON"
"sql_quote_show_create"	"ON"
"sql_safe_updates"	"OFF"
"sql_select_limit"	"18446744073709551615"
"sql_slave_skip_counter"	"0"
"sql_warnings"	"OFF"
"ssl_ca"	""
"ssl_capath"	""
"ssl_cert"	""
"ssl_cipher"	""
"ssl_crl"	""
"ssl_crlpath"	""
"ssl_key"	""
"storage_engine"	"InnoDB"
"stored_program_cache"	"256"
"sync_binlog"	"1"
"sync_frm"	"ON"
"sync_master_info"	"10000"
"sync_relay_log"	"10000"
"sync_relay_log_info"	"10000"
"system_time_zone"	"PET"
"table_definition_cache"	"1400"
"table_open_cache"	"2000"
"table_open_cache_instances"	"8"
"thread_cache_size"	"10"
"thread_concurrency"	"10"
"thread_handling"	"one-thread-per-connection"
"thread_stack"	"262144"
"time_format"	"%H:%i:%s"
"time_zone"	"SYSTEM"
"timed_mutexes"	"OFF"
"timestamp"	"1406222097.354680"
"tmp_table_size"	"16777216"
"tmpdir"	"/var/tmp/mysql.3U0stY"
"transaction_alloc_block_size"	"8192"
"transaction_allow_batching"	"OFF"
"transaction_prealloc_size"	"4096"
"tx_isolation"	"REPEATABLE-READ"
"tx_read_only"	"OFF"
"unique_checks"	"ON"
"updatable_views_with_limit"	"YES"
"version"	"5.6.12-log"
"version_comment"	"openSUSE package"
"version_compile_machine"	"x86_64"
"version_compile_os"	"Linux"
"wait_timeout"	"28800"
"warning_count"	"0"

Open in new window


This is my status

"Variable_name"	"Value"
"Aborted_clients"	"0"
"Aborted_connects"	"0"
"Binlog_cache_disk_use"	"0"
"Binlog_cache_use"	"8502"
"Binlog_stmt_cache_disk_use"	"0"
"Binlog_stmt_cache_use"	"0"
"Bytes_received"	"8572"
"Bytes_sent"	"44134669"
"Com_admin_commands"	"0"
"Com_assign_to_keycache"	"0"
"Com_alter_db"	"0"
"Com_alter_db_upgrade"	"0"
"Com_alter_event"	"0"
"Com_alter_function"	"0"
"Com_alter_procedure"	"0"
"Com_alter_server"	"0"
"Com_alter_table"	"0"
"Com_alter_tablespace"	"0"
"Com_alter_user"	"0"
"Com_analyze"	"0"
"Com_begin"	"0"
"Com_binlog"	"0"
"Com_call_procedure"	"0"
"Com_change_db"	"0"
"Com_change_master"	"0"
"Com_check"	"0"
"Com_checksum"	"0"
"Com_commit"	"0"
"Com_create_db"	"0"
"Com_create_event"	"0"
"Com_create_function"	"0"
"Com_create_index"	"0"
"Com_create_procedure"	"0"
"Com_create_server"	"0"
"Com_create_table"	"0"
"Com_create_trigger"	"0"
"Com_create_udf"	"0"
"Com_create_user"	"0"
"Com_create_view"	"0"
"Com_dealloc_sql"	"0"
"Com_delete"	"0"
"Com_delete_multi"	"0"
"Com_do"	"0"
"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"	"0"
"Com_drop_trigger"	"0"
"Com_drop_user"	"0"
"Com_drop_view"	"0"
"Com_empty_query"	"0"
"Com_execute_sql"	"0"
"Com_flush"	"0"
"Com_get_diagnostics"	"0"
"Com_grant"	"0"
"Com_ha_close"	"0"
"Com_ha_open"	"0"
"Com_ha_read"	"0"
"Com_help"	"0"
"Com_insert"	"0"
"Com_insert_select"	"0"
"Com_install_plugin"	"0"
"Com_kill"	"0"
"Com_load"	"0"
"Com_lock_tables"	"0"
"Com_optimize"	"0"
"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"	"0"
"Com_replace"	"0"
"Com_replace_select"	"0"
"Com_reset"	"0"
"Com_resignal"	"0"
"Com_revoke"	"0"
"Com_revoke_all"	"0"
"Com_rollback"	"0"
"Com_rollback_to_savepoint"	"0"
"Com_savepoint"	"0"
"Com_select"	"12"
"Com_set_option"	"16"
"Com_signal"	"0"
"Com_show_binlog_events"	"0"
"Com_show_binlogs"	"0"
"Com_show_charsets"	"0"
"Com_show_collations"	"0"
"Com_show_create_db"	"0"
"Com_show_create_event"	"0"
"Com_show_create_func"	"0"
"Com_show_create_proc"	"0"
"Com_show_create_table"	"0"
"Com_show_create_trigger"	"0"
"Com_show_databases"	"0"
"Com_show_engine_logs"	"0"
"Com_show_engine_mutex"	"0"
"Com_show_engine_status"	"5"
"Com_show_events"	"0"
"Com_show_errors"	"0"
"Com_show_fields"	"0"
"Com_show_function_code"	"0"
"Com_show_function_status"	"0"
"Com_show_grants"	"0"
"Com_show_keys"	"0"
"Com_show_master_status"	"0"
"Com_show_open_tables"	"0"
"Com_show_plugins"	"0"
"Com_show_privileges"	"0"
"Com_show_procedure_code"	"0"
"Com_show_procedure_status"	"0"
"Com_show_processlist"	"1"
"Com_show_profile"	"0"
"Com_show_profiles"	"4"
"Com_show_relaylog_events"	"0"
"Com_show_slave_hosts"	"0"
"Com_show_slave_status"	"0"
"Com_show_status"	"166"
"Com_show_storage_engines"	"0"
"Com_show_table_status"	"0"
"Com_show_tables"	"0"
"Com_show_triggers"	"0"
"Com_show_variables"	"2"
"Com_show_warnings"	"4"
"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"	"0"
"Com_uninstall_plugin"	"0"
"Com_unlock_tables"	"0"
"Com_update"	"0"
"Com_update_multi"	"0"
"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"	"ON"
"Connection_errors_accept"	"0"
"Connection_errors_internal"	"0"
"Connection_errors_max_connections"	"0"
"Connection_errors_peer_address"	"0"
"Connection_errors_select"	"0"
"Connection_errors_tcpwrap"	"0"
"Connections"	"11467"
"Created_tmp_disk_tables"	"0"
"Created_tmp_files"	"4663"
"Created_tmp_tables"	"10"
"Delayed_errors"	"0"
"Delayed_insert_threads"	"0"
"Delayed_writes"	"0"
"Flush_commands"	"1"
"Handler_commit"	"8"
"Handler_delete"	"0"
"Handler_discover"	"0"
"Handler_external_lock"	"16"
"Handler_mrr_init"	"0"
"Handler_prepare"	"0"
"Handler_read_first"	"4"
"Handler_read_key"	"68"
"Handler_read_last"	"0"
"Handler_read_next"	"0"
"Handler_read_prev"	"0"
"Handler_read_rnd"	"64"
"Handler_read_rnd_next"	"27208"
"Handler_rollback"	"0"
"Handler_savepoint"	"0"
"Handler_savepoint_rollback"	"0"
"Handler_update"	"0"
"Handler_write"	"306"
"Innodb_buffer_pool_dump_status"	"not started"
"Innodb_buffer_pool_load_status"	"not started"
"Innodb_buffer_pool_pages_data"	"14133"
"Innodb_buffer_pool_bytes_data"	"163299328"
"Innodb_buffer_pool_pages_dirty"	"192"
"Innodb_buffer_pool_bytes_dirty"	"2777088"
"Innodb_buffer_pool_pages_flushed"	"3999"
"Innodb_buffer_pool_pages_free"	"645368"
"Innodb_buffer_pool_pages_misc"	"18446744073709547475"
"Innodb_buffer_pool_pages_total"	"655360"
"Innodb_buffer_pool_read_ahead_rnd"	"0"
"Innodb_buffer_pool_read_ahead"	"0"
"Innodb_buffer_pool_read_ahead_evicted"	"0"
"Innodb_buffer_pool_read_requests"	"105950624"
"Innodb_buffer_pool_reads"	"14059"
"Innodb_buffer_pool_wait_free"	"0"
"Innodb_buffer_pool_write_requests"	"28180"
"Innodb_data_fsyncs"	"5920"
"Innodb_data_pending_fsyncs"	"0"
"Innodb_data_pending_reads"	"0"
"Innodb_data_pending_writes"	"0"
"Innodb_data_read"	"122294272"
"Innodb_data_reads"	"14222"
"Innodb_data_writes"	"8512"
"Innodb_data_written"	"126252032"
"Innodb_dblwr_pages_written"	"3999"
"Innodb_dblwr_writes"	"1194"
"Innodb_have_atomic_builtins"	"ON"
"Innodb_log_waits"	"0"
"Innodb_log_write_requests"	"28615"
"Innodb_log_writes"	"3241"
"Innodb_os_log_fsyncs"	"3326"
"Innodb_os_log_pending_fsyncs"	"0"
"Innodb_os_log_pending_writes"	"0"
"Innodb_os_log_written"	"14923776"
"Innodb_page_size"	"16384"
"Innodb_pages_created"	"58"
"Innodb_pages_read"	"14075"
"Innodb_pages_written"	"3999"
"Innodb_row_lock_current_waits"	"0"
"Innodb_row_lock_time"	"0"
"Innodb_row_lock_time_avg"	"0"
"Innodb_row_lock_time_max"	"0"
"Innodb_row_lock_waits"	"0"
"Innodb_rows_deleted"	"0"
"Innodb_rows_inserted"	"0"
"Innodb_rows_read"	"52358339"
"Innodb_rows_updated"	"3056"
"Innodb_num_open_files"	"11"
"Innodb_truncated_status_writes"	"0"
"Innodb_available_undo_logs"	"128"
"Key_blocks_not_flushed"	"0"
"Key_blocks_unused"	"6698"
"Key_blocks_used"	"0"
"Key_read_requests"	"0"
"Key_reads"	"0"
"Key_write_requests"	"0"
"Key_writes"	"0"
"Last_query_cost"	"10.499000"
"Last_query_partial_plans"	"1"
"Max_used_connections"	"304"
"Not_flushed_delayed_rows"	"0"
"Open_files"	"47"
"Open_streams"	"0"
"Open_table_definitions"	"73"
"Open_tables"	"577"
"Opened_files"	"4810"
"Opened_table_definitions"	"0"
"Opened_tables"	"2"
"Performance_schema_accounts_lost"	"0"
"Performance_schema_cond_classes_lost"	"0"
"Performance_schema_cond_instances_lost"	"0"
"Performance_schema_digest_lost"	"0"
"Performance_schema_file_classes_lost"	"0"
"Performance_schema_file_handles_lost"	"0"
"Performance_schema_file_instances_lost"	"0"
"Performance_schema_hosts_lost"	"0"
"Performance_schema_locker_lost"	"0"
"Performance_schema_mutex_classes_lost"	"0"
"Performance_schema_mutex_instances_lost"	"0"
"Performance_schema_rwlock_classes_lost"	"0"
"Performance_schema_rwlock_instances_lost"	"0"
"Performance_schema_session_connect_attrs_lost"	"0"
"Performance_schema_socket_classes_lost"	"0"
"Performance_schema_socket_instances_lost"	"0"
"Performance_schema_stage_classes_lost"	"0"
"Performance_schema_statement_classes_lost"	"0"
"Performance_schema_table_handles_lost"	"0"
"Performance_schema_table_instances_lost"	"0"
"Performance_schema_thread_classes_lost"	"0"
"Performance_schema_thread_instances_lost"	"0"
"Performance_schema_users_lost"	"0"
"Prepared_stmt_count"	"0"
"Qcache_free_blocks"	"1"
"Qcache_free_memory"	"1031376"
"Qcache_hits"	"0"
"Qcache_inserts"	"0"
"Qcache_lowmem_prunes"	"0"
"Qcache_not_cached"	"2453"
"Qcache_queries_in_cache"	"0"
"Qcache_total_blocks"	"1"
"Queries"	"33912"
"Questions"	"211"
"Rsa_public_key"	""
"Select_full_join"	"0"
"Select_full_range_join"	"0"
"Select_range"	"0"
"Select_range_check"	"0"
"Select_scan"	"10"
"Slave_heartbeat_period"	"0.000"
"Slave_last_heartbeat"	""
"Slave_open_temp_tables"	"0"
"Slave_received_heartbeats"	"0"
"Slave_retried_transactions"	"0"
"Slave_running"	"OFF"
"Slow_launch_threads"	"0"
"Slow_queries"	"8"
"Sort_merge_passes"	"0"
"Sort_range"	"0"
"Sort_rows"	"64"
"Sort_scan"	"4"
"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_server_not_after"	""
"Ssl_server_not_before"	""
"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"	"27188"
"Table_locks_waited"	"0"
"Table_open_cache_hits"	"6"
"Table_open_cache_misses"	"2"
"Table_open_cache_overflows"	"0"
"Tc_log_max_pages_used"	"0"
"Tc_log_page_size"	"0"
"Tc_log_page_waits"	"0"
"Threads_cached"	"0"
"Threads_connected"	"304"
"Threads_created"	"415"
"Threads_running"	"246"
"Uptime"	"1064"
"Uptime_since_flush_status"	"1064"

Open in new window



This is my INNODB STATUS:

=====================================
2014-07-24 12:13:54 7fdab6baf700 INNODB MONITOR OUTPUT
=====================================
Per SECOND averages calculated FROM the LAST 23 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 934 srv_active, 0 srv_shutdown, 75 srv_idle
srv_master_thread LOG FLUSH AND writes: 1009
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation COUNT 27561
OS WAIT ARRAY INFO: signal COUNT 43208
MUTEX spin waits 27768, rounds 92312, OS waits 2435
RW-shared spins 22358, rounds 544544, OS waits 16235
RW-excl spins 1893, rounds 356376, OS waits 8194
Spin rounds per WAIT: 3.32 MUTEX, 24.36 RW-shared, 188.26 RW-excl
------------
TRANSACTIONS
------------
Trx id counter 2587127
PURGE done FOR trx's n:o < 2586864 undo n:o < 0 state: running but idle
History list length 499
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 2586554, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 11190, OS thread handle 0x7fdab0b89700, query id 33025 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587109, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 10751, OS thread handle 0x7fdab03eb700, query id 33718 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=3725
---TRANSACTION 2586368, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 10566, OS thread handle 0x7fdab0530700, query id 32456 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=14214
---TRANSACTION 2586933, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 10525, OS thread handle 0x7fdab046d700, query id 33634 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2585892, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 10484, OS thread handle 0x7fdab05f3700, query id 31696 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586838, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 10216, OS thread handle 0x7fdab087d700, query id 33320 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=11015
---TRANSACTION 2586938, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 10190, OS thread handle 0x7fdab042c700, query id 33501 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=806
---TRANSACTION 2586404, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 10175, OS thread handle 0x7fdab0cce700, query id 32665 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587066, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 10042, OS thread handle 0x7fdab04ae700, query id 33654 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=494
---TRANSACTION 2587053, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 10002, OS thread handle 0x7fdab0634700, query id 33637 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15914
---TRANSACTION 2585397, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9991, OS thread handle 0x7fdab0738700, query id 30585 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586501, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9992, OS thread handle 0x7fdab0a03700, query id 32733 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10524
---TRANSACTION 2587045, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9974, OS thread handle 0x7fdab08be700, query id 33629 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=4403
---TRANSACTION 2586889, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9910, OS thread handle 0x7fdab11a1700, query id 33526 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586400, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9855, OS thread handle 0x7fdab1327700, query id 32517 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=3583
---TRANSACTION 2586492, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9652, OS thread handle 0x7fdab0779700, query id 32826 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586978, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9625, OS thread handle 0x7fdab04ef700, query id 33553 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15509
---TRANSACTION 2586718, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9391, OS thread handle 0x7fdab0ac6700, query id 33148 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=2153
---TRANSACTION 2587059, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9291, OS thread handle 0x7fdab0a85700, query id 33645 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10214
---TRANSACTION 2586256, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9289, OS thread handle 0x7fdab0d91700, query id 32218 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9308
---TRANSACTION 2586961, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9288, OS thread handle 0x7fdab083c700, query id 33529 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17374
---TRANSACTION 2586344, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9287, OS thread handle 0x7fdab0940700, query id 32549 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586910, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9250, OS thread handle 0x7fdab0a44700, query id 33573 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587089, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9131, OS thread handle 0x7fdab06b6700, query id 33683 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15127
---TRANSACTION 2586596, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9130, OS thread handle 0x7fdab06f7700, query id 33005 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586891, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9123, OS thread handle 0x7fdab13a9700, query id 33421 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=8711
---TRANSACTION 2586680, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 9122, OS thread handle 0x7fdab0c4c700, query id 33169 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587094, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 9015, OS thread handle 0x7fdab0dd2700, query id 33695 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=18450
---TRANSACTION 2587086, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8825, OS thread handle 0x7fdab07ba700, query id 33681 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10726
---TRANSACTION 2586985, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8824, OS thread handle 0x7fdab07fb700, query id 33701 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586674, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8797, OS thread handle 0x7fdab09c2700, query id 33063 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=763
---TRANSACTION 2586623, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8765, OS thread handle 0x7fdab25b0700, query id 32970 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=6500
---TRANSACTION 2586126, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8764, OS thread handle 0x7fdab11e2700, query id 32050 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586810, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8738, OS thread handle 0x7fdab109d700, query id 33285 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1546
---TRANSACTION 2587100, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8708, OS thread handle 0x7fdab0e13700, query id 33705 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=12504
---TRANSACTION 2586874, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8707, OS thread handle 0x7fdab14ee700, query id 33499 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586800, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8685, OS thread handle 0x7fdab12e6700, query id 33280 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=14267
---TRANSACTION 2586979, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8673, OS thread handle 0x7fdab22e5700, query id 33697 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587090, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8674, OS thread handle 0x7fdab0b48700, query id 33685 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17312
---TRANSACTION 2586916, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8664, OS thread handle 0x7fdab0d0f700, query id 33582 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587078, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8661, OS thread handle 0x7fdab0ed6700, query id 33672 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1219
---TRANSACTION 2586878, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8642, OS thread handle 0x7fdab111f700, query id 33506 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587108, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8641, OS thread handle 0x7fdab10de700, query id 33716 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=3664
---TRANSACTION 2586919, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8634, OS thread handle 0x7fdab0bca700, query id 33466 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=3168
---TRANSACTION 2586947, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8633, OS thread handle 0x7fdab0c0b700, query id 33656 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586664, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8624, OS thread handle 0x7fdab0d50700, query id 33130 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586894, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8617, OS thread handle 0x7fdab101b700, query id 33428 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=16659
---TRANSACTION 2586796, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8603, OS thread handle 0x7fdab0e54700, query id 33380 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587081, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8582, OS thread handle 0x7fdab0e95700, query id 33676 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=16652
---TRANSACTION 2586624, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8580, OS thread handle 0x7fdab142b700, query id 33048 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586755, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8579, OS thread handle 0x7fdab0f17700, query id 33306 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586706, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8576, OS thread handle 0x7fdab105c700, query id 33226 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586883, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8578, OS thread handle 0x7fdab17b9700, query id 33409 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13960
---TRANSACTION 2586497, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8577, OS thread handle 0x7fdab1160700, query id 32727 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17297
---TRANSACTION 2586847, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8542, OS thread handle 0x7fdab0f58700, query id 33336 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=309
---TRANSACTION 2586906, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8541, OS thread handle 0x7fdab0fda700, query id 33570 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586673, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8502, OS thread handle 0x7fdab1633700, query id 33160 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586424, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8504, OS thread handle 0x7fdab0f99700, query id 32574 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10429
---TRANSACTION 2586970, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8408, OS thread handle 0x7fdab16f6700, query id 33677 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587107, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8409, OS thread handle 0x7fdab12a5700, query id 33717 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10075
---TRANSACTION 2587067, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8355, OS thread handle 0x7fdab187c700, query id 33652 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=79
---TRANSACTION 2586618, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8346, OS thread handle 0x7fdab1d4f700, query id 33029 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586868, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8336, OS thread handle 0x7fdab183b700, query id 33384 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=4992
---TRANSACTION 2587041, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8335, OS thread handle 0x7fdab1dd1700, query id 33627 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5402
---TRANSACTION 2586232, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8331, OS thread handle 0x7fdab1264700, query id 32314 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586973, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8330, OS thread handle 0x7fdab17fa700, query id 33544 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5342
---TRANSACTION 2586208, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8324, OS thread handle 0x7fdab1368700, query id 32236 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586378, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8320, OS thread handle 0x7fdab18bd700, query id 32465 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1104
---TRANSACTION 2587057, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8316, OS thread handle 0x7fdab1bc9700, query id 33642 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17110
---TRANSACTION 2586899, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8315, OS thread handle 0x7fdab1674700, query id 33548 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586566, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8307, OS thread handle 0x7fdab13ea700, query id 32967 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587060, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8301, OS thread handle 0x7fdab14ad700, query id 33647 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=2904
---TRANSACTION 2586187, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8284, OS thread handle 0x7fdab15b1700, query id 32077 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15137
---TRANSACTION 2586257, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8267, OS thread handle 0x7fdab152f700, query id 32220 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13617
---TRANSACTION 2586931, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8266, OS thread handle 0x7fdab1570700, query id 33624 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587084, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8264, OS thread handle 0x7fdab15f2700, query id 33678 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=8726
---TRANSACTION 2586317, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8263, OS thread handle 0x7fdab16b5700, query id 32486 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586980, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8166, OS thread handle 0x7fdab1737700, query id 33563 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=3049
---TRANSACTION 2587098, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8168, OS thread handle 0x7fdab1d90700, query id 33704 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=18399
---TRANSACTION 2587106, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8163, OS thread handle 0x7fdab1a43700, query id 33715 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5788
---TRANSACTION 2586695, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8150, OS thread handle 0x7fdab1e53700, query id 33199 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586792, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8120, OS thread handle 0x7fdab19c1700, query id 33269 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=2664
---TRANSACTION 2586895, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8119, OS thread handle 0x7fdab1a02700, query id 33542 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586091, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8097, OS thread handle 0x7fdab1b47700, query id 32016 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587119, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8096, OS thread handle 0x7fdab1ac5700, query id 33723 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=12579
---TRANSACTION 2587099, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8091, OS thread handle 0x7fdab1ccd700, query id 33703 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9665
---TRANSACTION 2586617, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8089, OS thread handle 0x7fdab193f700, query id 32953 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=16072
---TRANSACTION 2586854, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 8088, OS thread handle 0x7fdab1980700, query id 33454 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586751, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 8035, OS thread handle 0x7fdab1a84700, query id 33191 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=16454
---TRANSACTION 2587051, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 7915, OS thread handle 0x7fdab1f98700, query id 33635 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=971
---TRANSACTION 2586951, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7916, OS thread handle 0x7fdab1b06700, query id 33625 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586736, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7782, OS thread handle 0x7fdab1c4b700, query id 33274 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586925, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7765, OS thread handle 0x7fdab1f57700, query id 33609 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586975, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7766, OS thread handle 0x7fdab1f16700, query id 33688 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2585962, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7767, OS thread handle 0x7fdab1c8c700, query id 31746 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586852, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7769, OS thread handle 0x7fdab1c0a700, query id 33448 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586336, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 7584, OS thread handle 0x7fdab201a700, query id 32540 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587019, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 7585, OS thread handle 0x7fdab20dd700, query id 33603 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1505
---TRANSACTION 2586825, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 7381, OS thread handle 0x7fdab205b700, query id 33301 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10932
---TRANSACTION 2586956, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 6730, OS thread handle 0x7fdab1ed5700, query id 33523 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17526
---TRANSACTION 2587068, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 6576, OS thread handle 0x7fdab242a700, query id 33653 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=3439
---TRANSACTION 2587118, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 6288, OS thread handle 0x7fdab1e12700, query id 33727 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=4122
---TRANSACTION 2586481, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 6287, OS thread handle 0x7fdab2263700, query id 32774 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587062, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 6103, OS thread handle 0x7fdab1e94700, query id 33649 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5113
---TRANSACTION 2586804, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 6102, OS thread handle 0x7fdab211e700, query id 33391 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586871, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5985, OS thread handle 0x7fdab209c700, query id 33387 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17383
---TRANSACTION 2586686, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5984, OS thread handle 0x7fdab2673700, query id 33181 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586579, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5897, OS thread handle 0x7fdab1fd9700, query id 32894 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13417
---TRANSACTION 2586460, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5884, OS thread handle 0x7fdab2326700, query id 32740 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587008, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5882, OS thread handle 0x7fdab246b700, query id 33592 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1169
---TRANSACTION 2586897, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5874, OS thread handle 0x7fdab215f700, query id 33518 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2585772, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5867, OS thread handle 0x7fdab24ac700, query id 31225 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=11608
---TRANSACTION 2586875, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5859, OS thread handle 0x7fdab21a0700, query id 33480 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586994, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5857, OS thread handle 0x7fdab252e700, query id 33579 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=7594
---TRANSACTION 2586981, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5845, OS thread handle 0x7fdab23a8700, query id 33711 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586908, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5833, OS thread handle 0x7fdab2367700, query id 33453 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=6773
---TRANSACTION 2586656, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5825, OS thread handle 0x7fdab2736700, query id 33031 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5976
---TRANSACTION 2586435, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5829, OS thread handle 0x7fdab21e1700, query id 32591 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10000
---TRANSACTION 2586580, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5828, OS thread handle 0x7fdab2222700, query id 32989 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587080, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5518, OS thread handle 0x7fdab6105700, query id 33674 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13962
---TRANSACTION 2586565, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5519, OS thread handle 0x7fdab293e700, query id 32958 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586556, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5517, OS thread handle 0x7fdab283a700, query id 32839 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13381
---TRANSACTION 2586969, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 5170, OS thread handle 0x7fdab26b4700, query id 33537 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9335
---TRANSACTION 2586524, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 5155, OS thread handle 0x7fdab2bc8700, query id 32880 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587002, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4679, OS thread handle 0x7fdab27b8700, query id 33587 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=18504
---TRANSACTION 2586653, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4668, OS thread handle 0x7fdab23e9700, query id 33121 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587092, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4663, OS thread handle 0x7fdab24ed700, query id 33689 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17842
---TRANSACTION 2587105, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4641, OS thread handle 0x7fdab28fd700, query id 33714 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15476
---TRANSACTION 2586665, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4632, OS thread handle 0x7fdab2777700, query id 33131 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586584, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4626, OS thread handle 0x7fdab2d4e700, query id 32903 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9258
---TRANSACTION 2586745, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4602, OS thread handle 0x7fdab256f700, query id 33183 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=347
---TRANSACTION 2586944, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4600, OS thread handle 0x7fdab25f1700, query id 33641 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587055, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4597, OS thread handle 0x7fdab26f5700, query id 33646 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=2009
---TRANSACTION 2587015, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4542, OS thread handle 0x7fdab27f9700, query id 33596 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=18358
---TRANSACTION 2586540, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4540, OS thread handle 0x7fdab669b700, query id 32901 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586691, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4350, OS thread handle 0x7fdab2a01700, query id 33172 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586445, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4351, OS thread handle 0x7fdab287b700, query id 32605 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5432
---TRANSACTION 2586299, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 4308, OS thread handle 0x7fdab28bc700, query id 32308 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9646
---TRANSACTION 2586962, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4307, OS thread handle 0x7fdab2a42700, query id 33671 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586930, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3805, OS thread handle 0x7fdab29c0700, query id 33617 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586635, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3806, OS thread handle 0x7fdab297f700, query id 32992 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10341
---TRANSACTION 2586777, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3657, OS thread handle 0x7fdab2b05700, query id 33244 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=11689
---TRANSACTION 2586977, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3656, OS thread handle 0x7fdab2c4a700, query id 33694 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586939, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3499, OS thread handle 0x7fdab2ac4700, query id 33638 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586877, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3500, OS thread handle 0x7fdab2a83700, query id 33395 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17830
---TRANSACTION 2587043, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3448, OS thread handle 0x7fdab2b87700, query id 33630 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=4517
---TRANSACTION 2586011, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3449, OS thread handle 0x7fdab2b46700, query id 31816 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586790, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3439, OS thread handle 0x7fdab624a700, query id 33268 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=8933
---TRANSACTION 2586856, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3431, OS thread handle 0x7fdab634e700, query id 33473 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586747, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3430, OS thread handle 0x7fdab2c8b700, query id 33188 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=6567
---TRANSACTION 2586995, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3423, OS thread handle 0x7fdab2d0d700, query id 33730 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587085, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3416, OS thread handle 0x7fdab2d8f700, query id 33682 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=11515
---TRANSACTION 2587007, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3411, OS thread handle 0x7fdab6146700, query id 33732 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586371, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3407, OS thread handle 0x7fdab6083700, query id 32462 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13613
---TRANSACTION 2586333, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3401, OS thread handle 0x7fdab671d700, query id 32521 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587117, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3392, OS thread handle 0x7fdab6187700, query id 33726 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13793
---TRANSACTION 2586786, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3391, OS thread handle 0x7fdab6515700, query id 33368 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2585332, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3389, OS thread handle 0x7fdab6452700, query id 29979 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5091
---TRANSACTION 2586782, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3342, OS thread handle 0x7fdab6209700, query id 33246 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13191
---TRANSACTION 2585537, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3312, OS thread handle 0x7fdab675e700, query id 30683 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=11643
---TRANSACTION 2586264, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3314, OS thread handle 0x7fdab66dc700, query id 32359 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586472, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 3311, OS thread handle 0x7fdab62cc700, query id 32757 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586912, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 3310, OS thread handle 0x7fdab638f700, query id 33457 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1110
---TRANSACTION 2585172, not started
MySQL thread id 1818, OS thread handle 0x7fdab6baf700, query id 33733 192.168.10.3 ldiehl init
SHOW ENGINE INNODB STATUS
---TRANSACTION 2586898, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2207, OS thread handle 0x7fdab630d700, query id 33431 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9238
---TRANSACTION 2585574, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 2206, OS thread handle 0x7fdab6619700, query id 30945 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586957, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2140, OS thread handle 0x7fdab6c72700, query id 33525 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=14105
---TRANSACTION 2586936, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 2120, OS thread handle 0x7fdab6411700, query id 33633 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587052, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2121, OS thread handle 0x7fdab63d0700, query id 33640 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=6918
---TRANSACTION 2586828, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 2118, OS thread handle 0x7fdab628b700, query id 33386 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586720, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 2116, OS thread handle 0x7fdab6493700, query id 33147 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=11752
---TRANSACTION 2586514, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1925, OS thread handle 0x7fdab67e0700, query id 32777 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=16943
---TRANSACTION 2587054, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1913, OS thread handle 0x7fdab6821700, query id 33639 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=17162
---TRANSACTION 2586773, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1912, OS thread handle 0x7fdab6556700, query id 33345 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2585887, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1910, OS thread handle 0x7fdab65d8700, query id 31419 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5044
---TRANSACTION 2586515, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1900, OS thread handle 0x7fdab6e39700, query id 32870 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586446, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1899, OS thread handle 0x7fdab679f700, query id 32606 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=16561
---TRANSACTION 2587102, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1888, OS thread handle 0x7fdab68a3700, query id 33706 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1699
---TRANSACTION 2586831, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1889, OS thread handle 0x7fdab6862700, query id 33407 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586375, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1886, OS thread handle 0x7fdab6925700, query id 32463 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=1540
---TRANSACTION 2586343, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1885, OS thread handle 0x7fdab6966700, query id 32550 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586888, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1729, OS thread handle 0x7fdab69a7700, query id 33416 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=12933
---TRANSACTION 2586220, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1728, OS thread handle 0x7fdab69e8700, query id 32271 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587022, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1668, OS thread handle 0x7fdab6a6a700, query id 33608 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=18579
---TRANSACTION 2586880, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1664, OS thread handle 0x7fdab6a29700, query id 33483 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2587000, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1658, OS thread handle 0x7fdab6aab700, query id 33588 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=8951
---TRANSACTION 2586313, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1653, OS thread handle 0x7fdab6aec700, query id 32447 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586917, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1650, OS thread handle 0x7fdab6df8700, query id 33465 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=5612
---TRANSACTION 2586958, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1648, OS thread handle 0x7fdab6b2d700, query id 33667 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586559, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1647, OS thread handle 0x7fdab6c31700, query id 32845 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10234
---TRANSACTION 2586666, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1646, OS thread handle 0x7fdab6b6e700, query id 33134 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586229, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1641, OS thread handle 0x7fdab6bf0700, query id 33722 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586754, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1638, OS thread handle 0x7fdab6cf4700, query id 33193 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=4404
---TRANSACTION 2586608, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1630, OS thread handle 0x7fdab6f3d700, query id 32938 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=13897
---TRANSACTION 2587065, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1626, OS thread handle 0x7fdab7000700, query id 33651 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=14430
---TRANSACTION 2586802, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1621, OS thread handle 0x7fdab6d76700, query id 33281 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=14764
---TRANSACTION 2586681, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1620, OS thread handle 0x7fdab6db7700, query id 33175 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586764, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1619, OS thread handle 0x7fdab7082700, query id 33216 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=10973
---TRANSACTION 2587017, not started
MySQL thread id 1616, OS thread handle 0x7fdab6e7a700, query id 32971 172.16.10.4 dbuser cleaning up
---TRANSACTION 2586433, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1612, OS thread handle 0x7fdab6f7e700, query id 32589 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=2224
---TRANSACTION 2587030, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1615, OS thread handle 0x7fdab6ebb700, query id 33614 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=364
---TRANSACTION 2586452, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1614, OS thread handle 0x7fdab6efc700, query id 33560 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586929, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1611, OS thread handle 0x7fdab6fbf700, query id 33615 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2585807, not started
MySQL thread id 1604, OS thread handle 0x7fdab728a700, query id 31224 172.16.10.4 dbuser cleaning up
---TRANSACTION 2586709, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1602, OS thread handle 0x7fdab7145700, query id 33233 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586444, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1599, OS thread handle 0x7fdab70c3700, query id 32604 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=14301
---TRANSACTION 2587116, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1596, OS thread handle 0x7fdab7186700, query id 33725 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15748
---TRANSACTION 2586020, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1595, OS thread handle 0x7fdab7249700, query id 31843 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586999, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1589, OS thread handle 0x7fdab71c7700, query id 33589 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=9610
---TRANSACTION 2586753, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1588, OS thread handle 0x7fdab7208700, query id 33310 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2583893, not started
MySQL thread id 1584, OS thread handle 0x7fdab738e700, query id 19534 172.16.10.4 dbuser cleaning up
---TRANSACTION 2586923, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1585, OS thread handle 0x7fdab72cb700, query id 33476 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=15063
---TRANSACTION 2584201, not started
MySQL thread id 1583, OS thread handle 0x7fdab730c700, query id 21591 172.16.10.4 dbuser cleaning up
---TRANSACTION 2587061, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1582, OS thread handle 0x7fdab734d700, query id 33650 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=7173
---TRANSACTION 2586102, not started sleeping before entering InnoDB
mysql tables in use 1, locked 1
MySQL thread id 1580, OS thread handle 0x7fdab7514700, query id 31895 172.16.10.4 dbuser updating
UPDATE project SET keyword='xxx' WHERE id_proyecto=12307
---TRANSACTION 2586247, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1575, OS thread handle 0x7fdab7410700, query id 32323 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2584483, not started
MySQL thread id 1576, OS thread handle 0x7fdab73cf700, query id 23304 172.16.10.4 dbuser cleaning up
---TRANSACTION 2585081, not started
MySQL thread id 1573, OS thread handle 0x7fdab7451700, query id 27471 172.16.10.4 dbuser cleaning up
---TRANSACTION 2580200, not started
MySQL thread id 1530, OS thread handle 0x7fdab7492700, query id 8212 172.16.10.4 dbuser cleaning up
---TRANSACTION 2580199, not started
MySQL thread id 1529, OS thread handle 0x7fdab74d3700, query id 8211 172.16.10.4 dbuser cleaning up
---TRANSACTION 2580194, not started
MySQL thread id 1527, OS thread handle 0x7fdab7555700, query id 8208 172.16.10.4 dbuser cleaning up
---TRANSACTION 2580188, not started
MySQL thread id 1526, OS thread handle 0x7fdab7618700, query id 8202 172.16.10.4 dbuser cleaning up
---TRANSACTION 2580117, not started
MySQL thread id 1523, OS thread handle 0x7fdab7596700, query id 8135 172.16.10.4 dbuser cleaning up
---TRANSACTION 2580170, not started
MySQL thread id 1522, OS thread handle 0x7fdab75d7700, query id 8185 172.16.10.4 dbuser cleaning up
---TRANSACTION 2579319, not started
MySQL thread id 1480, OS thread handle 0x7fdab78a2700, query id 7466 172.16.10.4 dbuser cleaning up
---TRANSACTION 2579327, not started
MySQL thread id 1479, OS thread handle 0x7fdab7659700, query id 7472 172.16.10.4 dbuser cleaning up
---TRANSACTION 2579313, not started
MySQL thread id 1478, OS thread handle 0x7fdab769a700, query id 7461 172.16.10.4 dbuser cleaning up
---TRANSACTION 2579314, not started
MySQL thread id 1477, OS thread handle 0x7fdab76db700, query id 7462 172.16.10.4 dbuser cleaning up
---TRANSACTION 2579264, not started
MySQL thread id 1475, OS thread handle 0x7fdab771c700, query id 7421 172.16.10.4 dbuser cleaning up
---TRANSACTION 2579258, not started
MySQL thread id 1472, OS thread handle 0x7fdab775d700, query id 7415 172.16.10.4 dbuser cleaning up
---TRANSACTION 2578470, not started
MySQL thread id 1431, OS thread handle 0x7fdab779e700, query id 6739 172.16.10.4 dbuser cleaning up
---TRANSACTION 2578466, not started
MySQL thread id 1430, OS thread handle 0x7fdab77df700, query id 6736 172.16.10.4 dbuser cleaning up
---TRANSACTION 2578463, not started
MySQL thread id 1428, OS thread handle 0x7fdab7820700, query id 6734 172.16.10.4 dbuser cleaning up
---TRANSACTION 2578449, not started
MySQL thread id 1427, OS thread handle 0x7fdab7861700, query id 6721 172.16.10.4 dbuser cleaning up
---TRANSACTION 2578460, not started
MySQL thread id 1425, OS thread handle 0x7fdab7a28700, query id 6730 172.16.10.4 dbuser cleaning up
---TRANSACTION 2578413, not started
MySQL thread id 1422, OS thread handle 0x7fdab7965700, query id 6687 172.16.10.4 dbuser cleaning up
---TRANSACTION 2577608, not started
MySQL thread id 1328, OS thread handle 0x7fdab7aaa700, query id 6014 172.16.10.4 dbuser cleaning up
---TRANSACTION 2577604, not started
MySQL thread id 1327, OS thread handle 0x7fdab7924700, query id 6011 172.16.10.4 dbuser cleaning up
---TRANSACTION 2577593, not started
MySQL thread id 1322, OS thread handle 0x7fdab78e3700, query id 6003 172.16.10.4 dbuser cleaning up
---TRANSACTION 2577582, not started
MySQL thread id 1317, OS thread handle 0x7fdab79e7700, query id 5993 172.16.10.4 dbuser cleaning up
---TRANSACTION 2577592, not started
MySQL thread id 1316, OS thread handle 0x7fdabc382700, query id 6002 172.16.10.4 dbuser cleaning up
---TRANSACTION 2577535, not started
MySQL thread id 1305, OS thread handle 0x7fdab7a69700, query id 5951 172.16.10.4 dbuser cleaning up
---TRANSACTION 2576757, not started
MySQL thread id 1123, OS thread handle 0x7fdab79a6700, query id 5182 172.16.10.4 dbuser cleaning up
---TRANSACTION 2576730, not started
MySQL thread id 1119, OS thread handle 0x7fdab7b2c700, query id 5147 172.16.10.4 dbuser cleaning up
---TRANSACTION 2576756, not started
MySQL thread id 1111, OS thread handle 0x7fdab7b6d700, query id 5181 172.16.10.4 dbuser cleaning up
---TRANSACTION 2576721, not started
MySQL thread id 1110, OS thread handle 0x7fdab7aeb700, query id 5138 172.16.10.4 dbuser cleaning up
---TRANSACTION 2576724, not started
MySQL thread id 1108, OS thread handle 0x7fdab7cf3700, query id 5141 172.16.10.4 dbuser cleaning up
---TRANSACTION 2576672, not started
MySQL thread id 1098, OS thread handle 0x7fdab7cb2700, query id 5077 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575885, not started
MySQL thread id 907, OS thread handle 0x7fdab7bef700, query id 4135 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575878, not started
MySQL thread id 905, OS thread handle 0x7fdab7c71700, query id 4122 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575856, not started
MySQL thread id 897, OS thread handle 0x7fdab7bae700, query id 4094 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575859, not started
MySQL thread id 891, OS thread handle 0x7fdab7efb700, query id 4097 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575850, not started
MySQL thread id 890, OS thread handle 0x7fdab7c30700, query id 4085 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575817, not started
MySQL thread id 882, OS thread handle 0x7fdab7d75700, query id 4039 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575047, not started
MySQL thread id 651, OS thread handle 0x7fdab7df7700, query id 3046 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575015, not started
MySQL thread id 650, OS thread handle 0x7fdabc1fc700, query id 3011 172.16.10.4 dbuser cleaning up
---TRANSACTION 2575052, not started
MySQL thread id 649, OS thread handle 0x7fdab7d34700, query id 3052 172.16.10.4 dbuser cleaning up
---TRANSACTION 2574995, not started
MySQL thread id 638, OS thread handle 0x7fdabc341700, query id 2983 172.16.10.4 dbuser cleaning up
---TRANSACTION 2574998, not started
MySQL thread id 629, OS thread handle 0x7fdabc0b6700, query id 2989 172.16.10.4 dbuser cleaning up
---TRANSACTION 2574973, not started
MySQL thread id 626, OS thread handle 0x7fdab7db6700, query id 2956 172.16.10.4 dbuser cleaning up
---TRANSACTION 2585759, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 381, OS thread handle 0x7fdab7e38700, query id 31299 192.168.10.5 dbuser Sending data
select * from project a join proposal b using(id_proposal) join type c on a.id_type=c.id_type LIMIT 1
---TRANSACTION 2586711, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 75, OS thread handle 0x7fdab7e79700, query id 33234 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586869, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 73, OS thread handle 0x7fdabc2bf700, query id 33493 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2574186, not started
MySQL thread id 23, OS thread handle 0x7fdabc1bb700, query id 1885 172.16.10.4 dbuser cleaning up
---TRANSACTION 2586839, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 17, OS thread handle 0x7fdab7f7d700, query id 33420 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586392, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 20, OS thread handle 0x7fdab7eba700, query id 32615 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586620, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 1, OS thread handle 0x7fdabc3c3700, query id 33038 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2574166, not started
MySQL thread id 10, OS thread handle 0x7fdabc17a700, query id 1856 172.16.10.4 dbuser cleaning up
---TRANSACTION 2574185, not started
MySQL thread id 16, OS thread handle 0x7fdab7fbe700, query id 1884 172.16.10.4 dbuser cleaning up
---TRANSACTION 2586507, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 6, OS thread handle 0x7fdabc27e700, query id 32859 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2586246, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 12, OS thread handle 0x7fdabc0f7700, query id 32301 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2574191, not started
MySQL thread id 14, OS thread handle 0x7fdabc075700, query id 1896 172.16.10.4 dbuser cleaning up
---TRANSACTION 2585997, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 11, OS thread handle 0x7fdabc138700, query id 31780 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2574145, not started
MySQL thread id 18, OS thread handle 0x7fdab7f3c700, query id 1825 172.16.10.4 dbuser cleaning up
---TRANSACTION 2586816, not started sleeping before entering InnoDB
mysql tables in use 3, locked 0
MySQL thread id 4, OS thread handle 0x7fdabc300700, query id 33397 172.16.10.4 dbuser Creating sort index
SELECT * FROM project a JOIN type b 
                ON a.id_type=b.id_type JOIN proposal c USING(id_proposal) ORDER BY a.title
---TRANSACTION 2574142, not started
MySQL thread id 7, OS thread handle 0x7fdabc23d700, query id 1822 172.16.10.4 dbuser cleaning up
--------
FILE I/O
--------
I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
I/O thread 1 state: waiting for completed aio requests (log thread)
I/O thread 2 state: waiting for completed aio requests (read thread)
I/O thread 3 state: waiting for completed aio requests (read thread)
I/O thread 4 state: waiting for completed aio requests (read thread)
I/O thread 5 state: waiting for completed aio requests (read thread)
I/O thread 6 state: waiting for completed aio requests (read thread)
I/O thread 7 state: waiting for completed aio requests (read thread)
I/O thread 8 state: waiting for completed aio requests (read thread)
I/O thread 9 state: waiting for completed aio requests (read thread)
I/O thread 10 state: waiting for completed aio requests (read thread)
I/O thread 11 state: waiting for completed aio requests (read thread)
I/O thread 12 state: waiting for completed aio requests (read thread)
I/O thread 13 state: waiting for completed aio requests (read thread)
I/O thread 14 state: waiting for completed aio requests (read thread)
I/O thread 15 state: waiting for completed aio requests (read thread)
I/O thread 16 state: waiting for completed aio requests (read thread)
I/O thread 17 state: waiting for completed aio requests (read thread)
I/O thread 18 state: waiting for completed aio requests (write thread)
I/O thread 19 state: waiting for completed aio requests (write thread)
I/O thread 20 state: waiting for completed aio requests (write thread)
I/O thread 21 state: waiting for completed aio requests (write thread)
I/O thread 22 state: waiting for completed aio requests (write thread)
I/O thread 23 state: waiting for completed aio requests (write thread)
I/O thread 24 state: waiting for completed aio requests (write thread)
I/O thread 25 state: waiting for completed aio requests (write thread)
I/O thread 26 state: waiting for completed aio requests (write thread)
I/O thread 27 state: waiting for completed aio requests (write thread)
I/O thread 28 state: waiting for completed aio requests (write thread)
I/O thread 29 state: waiting for completed aio requests (write thread)
Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
 ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
Pending flushes (fsync) log: 0; buffer pool: 0
14222 OS file reads, 8370 OS file writes, 5836 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 11.09 writes/s, 6.96 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2, 0 merges
merged operations:
 insert 0, delete mark 0, delete 0
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 21249871, node heap has 18 buffer(s)
33325.25 hash searches/s, 1507.72 non-hash searches/s
---
LOG
---
Log sequence number 3710468151
Log flushed up to   3710468151
Pages flushed up to 3709897392
Last checkpoint at  3709897392
0 pending log writes, 0 pending chkp writes
3301 log i/o's done, 2.43 LOG i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 10989076480; in additional pool allocated 0
Dictionary memory allocated 121665
Buffer pool size   655360
Free buffers       645368
Database pages     14133
Old database pages 214
Modified db pages  212
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 14075, created 58, written 3906
0.00 reads/s, 0.00 creates/s, 6.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 14133, unzip_LRU len: 2655
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   20480
Free buffers       20205
Database pages     426
Old database pages 0
Modified db pages  14
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 426, created 0, written 242
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 426, unzip_LRU len: 45
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   20480
Free buffers       20208
Database pages     388
Old database pages 0
Modified db pages  1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 388, created 0, written 62
0.00 reads/s, 0.00 creates/s, 0.09 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 388, unzip_LRU len: 77
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   20480
Free buffers       20201
Database pages     381
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 381, created 0, written 86
0.00 reads/s, 0.00 creates/s, 0.13 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 381, unzip_LRU len: 87
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   20480
Free buffers       20130
Database pages     446
Old database pages 0
Modified db pages  47
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 446, created 0, written 352
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 446, unzip_LRU len: 93
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   20480
Free buffers       20134
Database pages     439
Old database pages 0
Modified db pages  28
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 439, created 0, written 293
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 439, unzip_LRU len: 95
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   20480
Free buffers       20086
Database pages     451
Old database pages 0
Modified db pages  22
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 430, created 21, written 294
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 451, unzip_LRU len: 135
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   20480
Free buffers       20068
Database pages     454
Old database pages 0
Modified db pages  41
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 454, created 0, written 342
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 454, unzip_LRU len: 149
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   20480
Free buffers       20081
Database pages     418
Old database pages 0
Modified db pages  6
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 418, created 0, written 270
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 418, unzip_LRU len: 156
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 8
Buffer pool size   20480
Free buffers       20120
Database pages     500
Old database pages 0
Modified db pages  38
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 463, created 37, written 296
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 500, unzip_LRU len: 79
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 9
Buffer pool size   20480
Free buffers       20130
Database pages     485
Old database pages 0
Modified db pages  3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 485, created 0, written 230
0.00 reads/s, 0.00 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 485, unzip_LRU len: 74
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 10
Buffer pool size   20480
Free buffers       20114
Database pages     490
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 490, created 0, written 84
0.00 reads/s, 0.00 creates/s, 0.09 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 490, unzip_LRU len: 120
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 11
Buffer pool size   20480
Free buffers       20125
Database pages     493
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 493, created 0, written 76
0.00 reads/s, 0.00 creates/s, 0.17 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 493, unzip_LRU len: 107
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 12
Buffer pool size   20480
Free buffers       20135
Database pages     474
Old database pages 0
Modified db pages  2
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 474, created 0, written 114
0.00 reads/s, 0.00 creates/s, 0.26 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 474, unzip_LRU len: 107
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 13
Buffer pool size   20480
Free buffers       20139
Database pages     474
Old database pages 0
Modified db pages  1
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 474, created 0, written 58
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 474, unzip_LRU len: 102
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 14
Buffer pool size   20480
Free buffers       20159
Database pages     420
Old database pages 0
Modified db pages  3
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 420, created 0, written 258
0.00 reads/s, 0.00 creates/s, 0.52 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 420, unzip_LRU len: 110
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 15
Buffer pool size   20480
Free buffers       20123
Database pages     526
Old database pages 214
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 526, created 0, written 38
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 526, unzip_LRU len: 93
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 16
Buffer pool size   20480
Free buffers       20156
Database pages     464
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 464, created 0, written 39
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 464, unzip_LRU len: 91
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 17
Buffer pool size   20480
Free buffers       20123
Database pages     509
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 509, created 0, written 53
0.00 reads/s, 0.00 creates/s, 0.13 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 509, unzip_LRU len: 101
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 18
Buffer pool size   20480
Free buffers       20142
Database pages     500
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 500, created 0, written 49
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 500, unzip_LRU len: 88
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 19
Buffer pool size   20480
Free buffers       20129
Database pages     510
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 510, created 0, written 43
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 510, unzip_LRU len: 96
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 20
Buffer pool size   20480
Free buffers       20160
Database pages     462
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 462, created 0, written 40
0.00 reads/s, 0.00 creates/s, 0.04 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 462, unzip_LRU len: 89
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 21
Buffer pool size   20480
Free buffers       20186
Database pages     468
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 468, created 0, written 45
0.00 reads/s, 0.00 creates/s, 0.09 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 468, unzip_LRU len: 60
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 22
Buffer pool size   20480
Free buffers       20214
Database pages     431
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 431, created 0, written 58
0.00 reads/s, 0.00 creates/s, 0.04 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 431, unzip_LRU len: 49
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 23
Buffer pool size   20480
Free buffers       20195
Database pages     411
Old database pages 0
Modified db pages  6
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 411, created 0, written 219
0.00 reads/s, 0.00 creates/s, 0.43 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 411, unzip_LRU len: 79
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 24
Buffer pool size   20480
Free buffers       20233
Database pages     398
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 398, created 0, written 30
0.00 reads/s, 0.00 creates/s, 0.13 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 398, unzip_LRU len: 47
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 25
Buffer pool size   20480
Free buffers       20233
Database pages     402
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 402, created 0, written 26
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 402, unzip_LRU len: 45
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 26
Buffer pool size   20480
Free buffers       20250
Database pages     368
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 368, created 0, written 31
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 368, unzip_LRU len: 46
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 27
Buffer pool size   20480
Free buffers       20236
Database pages     389
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 389, created 0, written 25
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 389, unzip_LRU len: 49
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 28
Buffer pool size   20480
Free buffers       20219
Database pages     404
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 404, created 0, written 62
0.00 reads/s, 0.00 creates/s, 0.04 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 404, unzip_LRU len: 58
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 29
Buffer pool size   20480
Free buffers       20235
Database pages     400
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 400, created 0, written 28
0.00 reads/s, 0.00 creates/s, 0.13 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 400, unzip_LRU len: 44
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 30
Buffer pool size   20480
Free buffers       20251
Database pages     377
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 377, created 0, written 29
0.00 reads/s, 0.00 creates/s, 0.09 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 377, unzip_LRU len: 40
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
---BUFFER POOL 31
Buffer pool size   20480
Free buffers       20248
Database pages     375
Old database pages 0
Modified db pages  0
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 375, created 0, written 34
0.00 reads/s, 0.00 creates/s, 0.04 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 375, unzip_LRU len: 44
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
24 queries inside InnoDB, 223 queries in queue
26 read views open inside InnoDB
Main thread process no. 37252, id 140577488500480, state: sleeping
Number of rows inserted 0, updated 3040, deleted 0, read 51444671
0.00 inserts/s, 2.09 updates/s, 0.00 deletes/s, 49729.71 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

Open in new window

0
Comment
Question by:Ludwig Diehl
  • 8
  • 7
  • 2
  • +2
19 Comments
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40217847
That's a lot of data to wade through, so I'll start with some general questions and tips:

* Is the virtual drive getting full?
* Is the host drive getting full?
* How many CPU cores are on the host, and how many are assigned to the VM?
* How much RAM is on the host, and how much is assigned to the VM?
* How many disks are on the host? For better performance, the VM disk file should be on a different drive than the host OS.
* One cheap way to gain performance is to install an SSD on the host, and move the virtual drive to the SSD.
* How much swap space is configured on the host? How much is it being used by the host OS?
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40217955
1. No
2. No
3. I mentioned it on the post
Proliant ML370G6 2 CPU XEON  E5410 @ 2.33GHz, 4 cores each with 52GB RAM
. It has all cores assigned.
4. It has to RAID 5 arrays. Each with 15K rpm disks SAS.
5. Not an option
6. Can you give further details on this?

Thx for answering
0
 
LVL 14

Expert Comment

by:ThomasMcA2
ID: 40218007
"each with 52GB RAM" doesn't say how much is allocated to the VM.

Assigning all cores to the VM is very bad for performance. The host needs a core for itself.
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40218054
I said
It has all cores assigned
. I measured the CPU usage it shows an avg of 18%
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40218061
What gets slow is the service, neither the host nor the VM.
0
 
LVL 27

Expert Comment

by:BigRat
ID: 40219217
If the CPU usage is below 20% then it is either I/O bound or network bound.

To be on the safe side, I'd run performance monitors on these two. But with RAID 5 it shouldn't be I/O bound.

So it must be network bound and with 1000 concurrent users that might be the case.

Are you using mod_gzip to reduce the amount of data being sent down the wire?
0
 
LVL 108

Expert Comment

by:Ray Paseur
ID: 40219559
0
 
LVL 61

Expert Comment

by:gheist
ID: 40223168
Simple question - are you running prefork or worker mpm (later needs 10x less memory for same "high load")
How apache interfaces mysql? By default it can use it as authentication source but not much more?

Do you use some particular distribution (like centos v4 or Ubuntu LTS) or some home-mashed frankenstein?
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40229616
1. prefork
2. I didn't understand the question very well. It uses the db as a repository for data coming from complex forms built in PHP. They have lots of ajax requests.
2. Opensuse 13.1 64bits minimal installation.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 61

Expert Comment

by:gheist
ID: 40229659
1 - OK - lets switch to 10x more efficent worker mpm
2- php was not mentioned in initial post - you know there is python, perl, java and ruby all willing to drive websites from database
2- cool lets do it. Let me get home to my opensuse... Can I assume you are familiar with zypper and all software on your system is from there?
0
 
LVL 61

Expert Comment

by:gheist
ID: 40229786
Lets see
# zypper se worker fcgi fastcgi
Can you help me guess which three packages I will suggest you to install?
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40230379
1. I have read about worker module and it says it has some issues with mod_php
2. Yes, I know I didn't mentioned it before, however php must be kept as the server-side programming language.
3. Yeah, zypper and all opensuse stuff :-)
0
 
LVL 61

Accepted Solution

by:
gheist earned 500 total points
ID: 40230555
you cannot use mod_php with threaded apache because php is not threadsafe (maybe core is, but no extensions are)
So prepare to forget everything you assumed before and lets get to work

I will try to make your configuration easily switchable between prefork and worker (probably with minor edits left to you)
Also you can try event mpm but that is hit and miss with virtualisation, especially the hostile kind.

1) install 3 zypper packages
apache2-mod_fcgid
apache2-worker
php5-fastcgi
(so far no change at all - restart apache if you want, it loads with same configuration)

2) lets neuter threaded mod_php
in /etc/apache2/conf.d/php5.conf:
 You see section IfModule <mod_php5.c>

Wrap section around with IfMofule <prefork.c>

and same in ...he2/sysconfig.d/loadmodule.conf

apache2ctl is broken so you have to check configuration with httpd (you can report bug to suse if you like)
/usr/sbin/httpd2 -t
/usr/sbin/httpd2-worker -t (this will not load php as of now)

3) enable mod_fcgid php
go to ...e2/conf.d/mod_fcgid.conf
at the end of file there is commented out section:
FilesMatch PHP...
uncomment it
(both httpd -t)
4) activate fcgid for threaded apache:
in loadmodule.conf
make another section with IfModule <worker.c>
that contains LoadModule mod_fcgid.so
and
parameters (otherwise PHP backend exits every 500 requests and apache drops line in error log)
FcgidMaxRequestsPerProcess 500
FcgidMaxRequestInMem XXX
FcgidMaxRequestLen XXX
where XXX is maximum request size from php.ini

(again both httpd -t's)


5) edit /etc/sysconfig/apache2 and "service apache2 restart"
check head of  error log and process list that there are 3+ httpd2-worker processes, one with php-cgi children
0
 
LVL 61

Expert Comment

by:gheist
ID: 40230563
now like 1 in 10 requests gets to php instead of PHP taking memory to serve pictures. Also each 10-20mb apache proxess serves way more connections than before.
0
 
LVL 61

Expert Comment

by:gheist
ID: 40233912
i will go on a vacation to sunny places and most likely will not be able to assist in coming weeks - can you try my suggestions on alternate VM at least so i see you can manage public system alone?
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40235507
Hey thanks, sorry I've been and will be very busy these days, I will try to set it up  at weekend.
0
 
LVL 6

Author Comment

by:Ludwig Diehl
ID: 40635931
gheist
Thank you very much for your detailed explanation. It tried it and it works great. However I still need to improve Mysql performance . Any suggestion?
0
 
LVL 61

Expert Comment

by:gheist
ID: 40636107
Mysql tuner scripts are quite good once your system has warmed up working for one work cycle (day/week/month/year)
Since apache overhaul I doubt initial question still stands as mysql gets 20x less connections.
Please open a new request in mysql areas as this long after nobody will pay attention.
0
 
LVL 61

Expert Comment

by:gheist
ID: 40636349
And dont upgrade to 13.2 as what you have is for couple more years:
https://news.opensuse.org/2013/08/26/upcoming-opensuse-13-1-will-be-kept-evergreen/
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
MYSQL/PHP inserting 1969-12-31 instead of NULL 12 43
Parse DNS log 3 33
sql statement to select and drop 13 32
linux ssh 4 32
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now