List:General Discussion« Previous MessageNext Message »
From:Miguel Date:March 9 2009 10:00pm
Subject:Re: mysql behaviour
View as plain text  
On Mon, 2009-03-09 at 22:37 +0100, Miguel wrote:

> as you say, it is not a fact. I m trying to find the problem but I
> have no experiences with ddbb performance.
> 
> I have also found file descriptors really big like this one (lsof
> info):
> 
> 
> 
> > mysqld    17638       mysql   71u      REG        8,4   15925532      83013
> /usr/var/lib/mysql/django_session.MYD
> > 
> > I dont know if this could be a problem.
> 
> 
> Another clue I have is that I have duplicated the framework in my pc
> (in both systems bbdd and framework are in the same machine) and the
> bbdd goes faster that the production one.
> 
> maybe, should I restart mysql?
> 
> (Thanks Claudio for your help)
> 
> 
> here are the status results (this one: Aborted_clients doesnt seem
> really nice):
> 
> 
> 
> > +-----------------------------------+-------------+
> > | Variable_name                     | Value       |
> > +-----------------------------------+-------------+
> > | Aborted_clients                   | 25046       | 
> > | Aborted_connects                  | 44          | 
> > | Binlog_cache_disk_use             | 0           | 
> > | Binlog_cache_use                  | 1           | 
> > | Bytes_received                    | 122         | 
> > | Bytes_sent                        | 180         | 
> > | Com_admin_commands                | 0           | 
> > | Com_alter_db                      | 0           | 
> > | Com_alter_table                   | 0           | 
> > | Com_analyze                       | 0           | 
> > | Com_backup_table                  | 0           | 
> > | Com_begin                         | 0           | 
> > | Com_change_db                     | 0           | 
> > | Com_change_master                 | 0           | 
> > | Com_check                         | 0           | 
> > | Com_checksum                      | 0           | 
> > | Com_commit                        | 0           | 
> > | Com_create_db                     | 0           | 
> > | Com_create_function               | 0           | 
> > | Com_create_index                  | 0           | 
> > | Com_create_table                  | 0           | 
> > | Com_create_user                   | 0           | 
> > | Com_dealloc_sql                   | 0           | 
> > | Com_delete                        | 0           | 
> > | Com_delete_multi                  | 0           | 
> > | Com_do                            | 0           | 
> > | Com_drop_db                       | 0           | 
> > | Com_drop_function                 | 0           | 
> > | Com_drop_index                    | 0           | 
> > | Com_drop_table                    | 0           | 
> > | Com_drop_user                     | 0           | 
> > | Com_execute_sql                   | 0           | 
> > | Com_flush                         | 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_kill                          | 0           | 
> > | Com_load                          | 0           | 
> > | Com_load_master_data              | 0           | 
> > | Com_load_master_table             | 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_rename_table                  | 0           | 
> > | Com_repair                        | 0           | 
> > | Com_replace                       | 0           | 
> > | Com_replace_select                | 0           | 
> > | Com_reset                         | 0           | 
> > | Com_restore_table                 | 0           | 
> > | Com_revoke                        | 0           | 
> > | Com_revoke_all                    | 0           | 
> > | Com_rollback                      | 0           | 
> > | Com_savepoint                     | 0           | 
> > | Com_select                        | 1           | 
> > | Com_set_option                    | 0           | 
> > | Com_show_binlog_events            | 0           | 
> > | Com_show_binlogs                  | 0           | 
> > | Com_show_charsets                 | 0           | 
> > | Com_show_collations               | 0           | 
> > | Com_show_column_types             | 0           | 
> > | Com_show_create_db                | 0           | 
> > | Com_show_create_table             | 0           | 
> > | Com_show_databases                | 0           | 
> > | Com_show_errors                   | 0           | 
> > | Com_show_fields                   | 0           | 
> > | Com_show_grants                   | 0           | 
> > | Com_show_innodb_status            | 0           | 
> > | Com_show_keys                     | 0           | 
> > | Com_show_logs                     | 0           | 
> > | Com_show_master_status            | 0           | 
> > | Com_show_ndb_status               | 0           | 
> > | Com_show_new_master               | 0           | 
> > | Com_show_open_tables              | 0           | 
> > | Com_show_privileges               | 0           | 
> > | Com_show_processlist              | 0           | 
> > | Com_show_slave_hosts              | 0           | 
> > | Com_show_slave_status             | 0           | 
> > | Com_show_status                   | 1           | 
> > | Com_show_storage_engines          | 0           | 
> > | Com_show_tables                   | 0           | 
> > | Com_show_triggers                 | 0           | 
> > | Com_show_variables                | 0           | 
> > | Com_show_warnings                 | 0           | 
> > | 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_reset                    | 0           | 
> > | Com_stmt_send_long_data           | 0           | 
> > | Com_truncate                      | 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                       | OFF         | 
> > | Connections                       | 616340      | 
> > | Created_tmp_disk_tables           | 0           | 
> > | Created_tmp_files                 | 31          | 
> > | Created_tmp_tables                | 1           | 
> > | Delayed_errors                    | 0           | 
> > | Delayed_insert_threads            | 0           | 
> > | Delayed_writes                    | 0           | 
> > | Flush_commands                    | 1           | 
> > | Handler_commit                    | 0           | 
> > | Handler_delete                    | 0           | 
> > | Handler_discover                  | 0           | 
> > | Handler_prepare                   | 0           | 
> > | Handler_read_first                | 0           | 
> > | Handler_read_key                  | 0           | 
> > | Handler_read_next                 | 0           | 
> > | Handler_read_prev                 | 0           | 
> > | Handler_read_rnd                  | 0           | 
> > | Handler_read_rnd_next             | 0           | 
> > | Handler_rollback                  | 0           | 
> > | Handler_savepoint                 | 0           | 
> > | Handler_savepoint_rollback        | 0           | 
> > | Handler_update                    | 0           | 
> > | Handler_write                     | 131         | 
> > | Innodb_buffer_pool_pages_data     | 19          | 
> > | Innodb_buffer_pool_pages_dirty    | 0           | 
> > | Innodb_buffer_pool_pages_flushed  | 1           | 
> > | Innodb_buffer_pool_pages_free     | 493         | 
> > | Innodb_buffer_pool_pages_latched  | 0           | 
> > | Innodb_buffer_pool_pages_misc     | 0           | 
> > | Innodb_buffer_pool_pages_total    | 512         | 
> > | Innodb_buffer_pool_read_ahead_rnd | 1           | 
> > | Innodb_buffer_pool_read_ahead_seq | 0           | 
> > | Innodb_buffer_pool_read_requests  | 169         | 
> > | Innodb_buffer_pool_reads          | 12          | 
> > | Innodb_buffer_pool_wait_free      | 0           | 
> > | Innodb_buffer_pool_write_requests | 1           | 
> > | Innodb_data_fsyncs                | 7           | 
> > | Innodb_data_pending_fsyncs        | 0           | 
> > | Innodb_data_pending_reads         | 0           | 
> > | Innodb_data_pending_writes        | 0           | 
> > | Innodb_data_read                  | 2494464     | 
> > | Innodb_data_reads                 | 25          | 
> > | Innodb_data_writes                | 7           | 
> > | Innodb_data_written               | 35328       | 
> > | Innodb_dblwr_pages_written        | 1           | 
> > | Innodb_dblwr_writes               | 1           | 
> > | Innodb_log_waits                  | 0           | 
> > | Innodb_log_write_requests         | 0           | 
> > | Innodb_log_writes                 | 2           | 
> > | Innodb_os_log_fsyncs              | 5           | 
> > | Innodb_os_log_pending_fsyncs      | 0           | 
> > | Innodb_os_log_pending_writes      | 0           | 
> > | Innodb_os_log_written             | 1024        | 
> > | Innodb_page_size                  | 16384       | 
> > | Innodb_pages_created              | 0           | 
> > | Innodb_pages_read                 | 19          | 
> > | Innodb_pages_written              | 1           | 
> > | 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                  | 0           | 
> > | Innodb_rows_updated               | 0           | 
> > | Key_blocks_not_flushed            | 0           | 
> > | Key_blocks_unused                 | 9438        | 
> > | Key_blocks_used                   | 14497       | 
> > | Key_read_requests                 | 39761741149 | 
> > | Key_reads                         | 3592665     | 
> > | Key_write_requests                | 350460068   | 
> > | Key_writes                        | 350307528   | 
> > | Last_query_cost                   | 0.000000    | 
> > | Max_used_connections              | 30          | 
> > | Ndb_cluster_node_id               | 0           | 
> > | Ndb_config_from_host              |             | 
> > | Ndb_config_from_port              | 0           | 
> > | Ndb_number_of_data_nodes          | 0           | 
> > | Not_flushed_delayed_rows          | 0           | 
> > | Open_files                        | 129         | 
> > | Open_streams                      | 0           | 
> > | Open_tables                       | 64          | 
> > | Opened_tables                     | 0           | 
> > | Prepared_stmt_count               | 0           | 
> > | Qcache_free_blocks                | 1093        | 
> > | Qcache_free_memory                | 3048576     | 
> > | Qcache_hits                       | 447421329   | 
> > | Qcache_inserts                    | 13377148    | 
> > | Qcache_lowmem_prunes              | 4819545     | 
> > | Qcache_not_cached                 | 64236       | 
> > | Qcache_queries_in_cache           | 3617        | 
> > | Qcache_total_blocks               | 8471        | 
> > | Questions                         | 777237127   | 
> > | Rpl_status                        | NULL        | 
> > | Select_full_join                  | 0           | 
> > | Select_full_range_join            | 0           | 
> > | Select_range                      | 0           | 
> > | Select_range_check                | 0           | 
> > | Select_scan                       | 1           | 
> > | Slave_open_temp_tables            | 0           | 
> > | Slave_retried_transactions        | 0           | 
> > | Slave_running                     | OFF         | 
> > | Slow_launch_threads               | 0           | 
> > | Slow_queries                      | 0           | 
> > | Sort_merge_passes                 | 0           | 
> > | Sort_range                        | 0           | 
> > | Sort_rows                         | 0           | 
> > | Sort_scan                         | 0           | 
> > | Ssl_accept_renegotiates           | 0           | 
> > | Ssl_accepts                       | 0           | 
> > | Ssl_callback_cache_hits           | 0           | 
> > | Ssl_cipher                        |             | 
> > | Ssl_cipher_list                   |             | 
> > | Ssl_client_connects               | 0           | 
> > | Ssl_connect_renegotiates          | 0           | 
> > | Ssl_ctx_verify_depth              | 0           | 
> > | Ssl_ctx_verify_mode               | 0           | 
> > | Ssl_default_timeout               | 0           | 
> > | Ssl_finished_accepts              | 0           | 
> > | Ssl_finished_connects             | 0           | 
> > | Ssl_session_cache_hits            | 0           | 
> > | Ssl_session_cache_misses          | 0           | 
> > | Ssl_session_cache_mode            | NONE        | 
> > | Ssl_session_cache_overflows       | 0           | 
> > | Ssl_session_cache_size            | 0           | 
> > | Ssl_session_cache_timeouts        | 0           | 
> > | Ssl_sessions_reused               | 0           | 
> > | Ssl_used_session_cache_entries    | 0           | 
> > | Ssl_verify_depth                  | 0           | 
> > | Ssl_verify_mode                   | 0           | 
> > | Ssl_version                       |             | 
> > | Table_locks_immediate             | 175862068   | 
> > | Table_locks_waited                | 12103       | 
> > | Tc_log_max_pages_used             | 0           | 
> > | Tc_log_page_size                  | 0           | 
> > | Tc_log_page_waits                 | 0           | 
> > | Threads_cached                    | 5           | 
> > | Threads_connected                 | 5           | 
> > | Threads_created                   | 581         | 
> > | Threads_running                   | 1           | 
> > | Uptime                            | 7100847     | 
> > +-----------------------------------+-------------+
> > 251 rows in set (0.13 sec)
> > 



Thread
mysql behaviourMiguel8 Mar
  • Re: mysql behaviourClaudio Nanni9 Mar
    • Re: mysql behaviourMiguel9 Mar
      • Re: mysql behaviourClaudio Nanni9 Mar
        • Re: mysql behaviourMiguel9 Mar
          • Re: mysql behaviourClaudio Nanni9 Mar
Re: mysql behaviourMiguel9 Mar
  • Re: mysql behaviourClaudio Nanni9 Mar
    • Re: mysql behaviourMiguel9 Mar
      • Re: mysql behaviourClaudio Nanni10 Mar
        • Re: mysql behaviourMiguel10 Mar
          • Re: mysql behaviourClaudio Nanni10 Mar