MySQL Forums
Forum List  »  Performance

Re: Need Perfomance / Tuning Help
Posted by: Marco Schierhorn
Date: November 23, 2005 07:19AM

Thanks a lot for your help !!!
I really appreciate this...

You´re totally right. It´s a community-based site.
If changed some start parameters.
Below you find the new output of show status.
Hope things are a little better now...

If you would like, i would love to invite you to our small community www.decayenne.com
May I trouble you for e-mail address. You can send it to -> marco.schierhorn@gmail.com
Then i can send you my msn messenger or icq id as well.



+----------------------------+-----------+
| Variable_name | Value |
+----------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 5917327 |
| Bytes_sent | 22883804 |
| 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 | 15389 |
| 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_dealloc_sql | 0 |
| Com_delete | 4864 |
| 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 | 13 |
| 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 | 15388 |
| Com_set_option | 6958 |
| 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 | 436 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_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 | 437 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_send_long_data | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_close | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2737 |
| Com_update_multi | 0 |
| Connections | 3258 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 3 |
| Created_tmp_tables | 268 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 4 |
| Handler_discover | 0 |
| Handler_read_first | 2769 |
| Handler_read_key | 61343 |
| Handler_read_next | 128488 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 19444 |
| Handler_read_rnd_next | 935828 |
| Handler_rollback | 0 |
| Handler_update | 1134 |
| Handler_write | 18961 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 463581 |
| Key_blocks_used | 339 |
| Key_read_requests | 192122 |
| Key_reads | 346 |
| Key_write_requests | 1721 |
| Key_writes | 908 |
| Max_used_connections | 12 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 57 |
| Open_streams | 0 |
| Open_tables | 32 |
| Opened_tables | 43 |
| Qcache_free_blocks | 67 |
| Qcache_free_memory | 535363592 |
| Qcache_hits | 24869 |
| Qcache_inserts | 15139 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 51 |
| Qcache_queries_in_cache | 1046 |
| Qcache_total_blocks | 2185 |
| Questions | 74421 |
| Rpl_status | NULL |
| Select_full_join | 132 |
| Select_full_range_join | 0 |
| Select_range | 90 |
| Select_range_check | 0 |
| Select_scan | 538 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slave_retried_transactions | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 20 |
| Sort_rows | 19891 |
| Sort_scan | 309 |
| Table_locks_immediate | 32007 |
| Table_locks_waited | 237 |
| Threads_cached | 0 |
| Threads_connected | 3 |
| Threads_created | 3257 |
| Threads_running | 1 |
| Uptime | 501 |
+----------------------------+-----------+

Options: ReplyQuote


Subject
Views
Written By
Posted
2449
November 21, 2005 05:38AM
1767
November 21, 2005 06:31AM
1693
November 21, 2005 07:26AM
3163
November 22, 2005 08:21PM
Re: Need Perfomance / Tuning Help
1790
November 23, 2005 07:19AM
1714
November 23, 2005 08:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.