[Fwd: Re: Your Data Needed]
Ronald Bradford
As per morgan's pickup and my scratching my head with some of my samples
in the past 3 mins, please use GLOBAL appropiately.
Regards
Ronald
Hi Ronald,
> I'm wanting to do some data analysis of raw MySQL Stats. Given I've got
> limited system installations to access, I'm asking for any others that
> would like to contribute data to the benefit of my research. I'm
> looking for the following:
>
> SELECT VERSION();
> SHOW STATUS;
Just to clarify. You probably want SHOW STATUS (mysql 4.1) or SHOW
GLOBAL STATUS (mysql 5.0+).
- Morgan
--
Morgan Tocker, Support Engineer
MySQL AB, Brisbane, Australia, www.mysql.com
Office: +61 402 832 215 (GMT +10)
Are you MySQL certified? www.mysql.com/certification
Markus Popp
I have attached the outputs from my MySQL 5.0 and my MySQL 5.1 servers
on my working machine (running SuSE Linux 10.0).
I have discovered a strange phenomenon on the MySQL 5.0 db4free.net
server - maybe one of you has an idea where this comes from. Sometimes
(not always) I get a long and raising list of unauthenticated users in
my processlist. The server doesn't allow access to any anonymous users
or to users without password or missing host information.
I have searched the web (including the MySQL Forum and Bug System) and
found several people who had the same problem (all on large servers and
nobody could create a repeatable case), but I didn't find anything that
would really explain why this happens and what I could reasonably do
about it (I found the --skip-resolve-name option, but that's not really
an explaination, nor a solution). Has one of you discovered something
similar and know more about it? Could this be a bug? There have been
some bug reports, but they have all been closed with "No Feedback" or
"Cannot repeat".
Another issue I stumbled upon during the weekend was that I haven't
managed to store the uptime of a server in a user defined variable (I
hope I haven't overlooked something very stupid). The SHOW command
doesn't allow me to do that and I also haven't found another way.
Unfortunately, there's no such view in information_schema yet (same as
with variables, replication data, ...). What do you think about it?
Cheers & thanks,
Markus
Ronald Bradford schrieb:
Giuseppe Maxia
Hi,
I have attached the outputs from my MySQL 5.0 and my MySQL 5.1 servers
on my working machine (running SuSE Linux 10.0).
I have discovered a strange phenomenon on the MySQL 5.0 db4free.net
server - maybe one of you has an idea where this comes from. Sometimes
(not always) I get a long and raising list of unauthenticated users in
my processlist. The server doesn't allow access to any anonymous users
or to users without password or missing host information.
I had the same problem a few months ago, so I asked MySQL support about that, and this is what I got:
" This state is shown for sessions which opened TCP/IP connection but did not send authentication packets yet. A slower connection or client could make appearance of these lines more likely."
I have searched the web (including the MySQL Forum and Bug System) and
found several people who had the same problem (all on large servers and
nobody could create a repeatable case), but I didn't find anything that
would really explain why this happens and what I could reasonably do
about it (I found the --skip-resolve-name option, but that's not really
an explaination, nor a solution). Has one of you discovered something
similar and know more about it? Could this be a bug? There have been
some bug reports, but they have all been closed with "No Feedback" or
"Cannot repeat".
Another issue I stumbled upon during the weekend was that I haven't
managed to store the uptime of a server in a user defined variable (I
hope I haven't overlooked something very stupid). The SHOW command
doesn't allow me to do that and I also haven't found another way.
Unfortunately, there's no such view in information_schema yet (same as
with variables, replication data, ...). What do you think about it?
No luck here, until the VARIABLES and STATUS become information schema tables.
The only thing you can do is to store the uptime in a table through a CRON job.
First, create the table
create table test.uptime (last_checked timestamp, current bigint);
insert into test.uptime values (null,0);
Then you can have a cron job updating it as often as you want:
mysql -e "update test.uptime set current='`mysql -e 'show status like "uptime"' -N -B | awk '{ print $2 }'`'"
Cheers & thanks,
Markus
Ciao
Giuseppe
Markus Popp
something ;-).
AFAIK, the status and variable views for information_schema are quite on
top of the to-do list, so they will hopefully be available soon.
To let you know about my plans - I want to turn off db4free's MySQL 5.0
server quite soon (maybe when 5.1.12 is released) and merge the user's
databases together on one MySQL 5.1 server. I plan to extensively use
logging capabilities and events to monitor the server and user activity.
Instead of the second server (which was the MySQL 5.1 server so far) I
might set up a replication slave instead to run regular backups from
there. So this will end up in one of the first production servers with
MySQL 5.1 on a "slightly higher loaded server".
If you have some ideas what else to do to make this maximum beneficial
for MySQL to find bugs and improve the MySQL server, please let me know.
Cheers,
Markus
Giuseppe Maxia schrieb:
> Hi,
>
> On 8/28/06, *Markus Popp* <m.p...@db4free.net
> <mailto:m.p...@db4free.net>> wrote:
>
> Hi,
>
> I have attached the outputs from my MySQL 5.0 and my MySQL 5.1 servers
> on my working machine (running SuSE Linux 10.0).
>
> I have discovered a strange phenomenon on the MySQL 5.0 db4free.net
Beat Vontobel
The "unauthenticated user" problem usually appears due to one of the
two following reasons:
* DNS (reverse) lookups that hang (long time-out, usually something
around 2 minutes, I think), which you seem to have excluded already.
(I encountered this once with a missbehaving name server from one of
our Internet providers.)
* The missing authentication packets from the clients as mentioned by
Giuseppe:
> "This state is shown for sessions which opened TCP/IP connection
> but did not send authentication packets yet. A slower connection or
> client could make appearance of these lines more likely."
The reason could of course be slower connections (as MySQL support
suggests), it could also be a misbehaving client library (but never
encountered this) - but in reality (in my case) for remote
connections I always found the reason to be network problems out in
the wild word of the Internet. If one of the providers along the
route from the client to the server has got a routing problem (e.g.
misconfigured MTU settings or similar things) it could be possible
that smaller packets get through (connection established) but bigger
packets fail (no authentication possible). I got that once for
example when one of the core routers of a Swiss Internet provider
failed and packets got rerouted. As you probably have a lot of
clients accessing your server from all over the world, something like
this could be the reason. It would also explain the intermittent
failure.
Cheers,
Beat
-----
"The major difference between a thing that might go wrong and a thing
that cannot possibly go wrong is that when a thing that cannot
possibly go wrong goes wrong it usually turns out to be impossible to
get at or repair." (Douglas Adams, Mostly Harmless)
MeteoNews AG, Beat Vontobel (IT, Research & Development)
E-Mail: b.von...@meteonews.ch
IT Department: +41 (0)43 288 40 54
Main phone: +41 (0)43 288 40 50
Mobile: +41 (0)79 738 79 70
> > mysql> select version();
> +----------------+
> | version() |
> +----------------+
> | 5.0.24-max-log |
> +----------------+
> 1 row in set (0.00 sec)
>
> mysql> show global variables;
> +---------------------------------
> +---------------------------------------------------------+
> | Variable_name |
> Value |
> +---------------------------------
> +---------------------------------------------------------+
> | auto_increment_increment |
> 1 |
> | auto_increment_offset |
> 1 |
> | automatic_sp_privileges |
> ON |
> | back_log |
> 50 |
> | basedir
> | / |
> | bdb_cache_size |
> 8388600 |
> | bdb_home | /var/lib/
> mysql/ |
> | bdb_log_buffer_size |
> 32768 |
> | bdb_logdir
> | |
> | bdb_max_lock |
> 10000 |
> | bdb_shared_data |
> OFF |
> | bdb_tmpdir | /
> tmp/ |
> | binlog_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/
> charsets/ |
> | collation_connection |
> utf8_general_ci |
> | collation_database |
> utf8_general_ci |
> | collation_server |
> utf8_general_ci |
> | completion_type |
> 0 |
> | concurrent_insert |
> 1 |
> | connect_timeout |
> 5 |
> | datadir | /var/lib/
> mysql/ |
> | date_format | %Y-%m-%
> d |
> | datetime_format | %Y-%m-%d %H:%i:%
> s |
> | default_week_format |
> 0 |
> | delay_key_write |
> ON |
> | delayed_insert_limit |
> 100 |
> | delayed_insert_timeout |
> 300 |
> | delayed_queue_size |
> 1000 |
> | div_precision_increment |
> 4 |
> | engine_condition_pushdown |
> OFF |
> | expire_logs_days |
> 0 |
> | flush |
> OFF |
> | flush_time |
> 0 |
> | ft_boolean_syntax | + -><()
> ~*:""&| |
> | ft_max_word_len |
> 84 |
> | ft_min_word_len |
> 4 |
> | ft_query_expansion_limit |
> 20 |
> | ft_stopword_file | (built-
> in) |
> | group_concat_max_len |
> 1024 |
> | have_archive |
> YES |
> | have_bdb |
> YES |
> | have_blackhole_engine |
> YES |
> | have_compress |
> YES |
> | have_crypt |
> YES |
> | have_csv |
> YES |
> | have_dynamic_loading |
> YES |
> | have_example_engine |
> YES |
> | have_federated_engine |
> YES |
> | have_geometry |
> YES |
> | have_innodb |
> YES |
> | have_isam |
> NO |
> | have_ndbcluster |
> DISABLED |
> | have_merge_engine |
> YES |
> | have_openssl |
> DISABLED |
> | have_query_cache |
> YES |
> | have_raid |
> NO |
> | have_rtree_keys |
> YES |
> | have_symlink |
> YES |
> | init_connect
> | |
> | init_file
> | |
> | init_slave
> | |
> | innodb_additional_mem_pool_size |
> 1048576 |
> | innodb_autoextend_increment |
> 8 |
> | innodb_buffer_pool_awe_mem_mb |
> 0 |
> | innodb_buffer_pool_size |
> 8388608 |
> | innodb_checksums |
> ON |
> | innodb_commit_concurrency |
> 0 |
> | innodb_concurrency_tickets |
> 500 |
> | innodb_data_file_path |
> ibdata1:10M:autoextend |
> | innodb_data_home_dir
> | |
> | innodb_doublewrite |
> ON |
> | innodb_fast_shutdown |
> 1 |
> | innodb_file_io_threads |
> 4 |
> | innodb_file_per_table |
> OFF |
> | innodb_flush_log_at_trx_commit |
> 1 |
> | innodb_flush_method
> | |
> | innodb_force_recovery |
> 0 |
> | innodb_lock_wait_timeout |
> 50 |
> | innodb_locks_unsafe_for_binlog |
> OFF |
> | innodb_log_arch_dir
> | |
> | innodb_log_archive |
> OFF |
> | innodb_log_buffer_size |
> 1048576 |
> | innodb_log_file_size |
> 5242880 |
> | innodb_log_files_in_group |
> 2 |
> | innodb_log_group_home_dir
> | ./ |
> | innodb_max_dirty_pages_pct |
> 90 |
> | innodb_max_purge_lag |
> 0 |
> | innodb_mirrored_log_groups |
> 1 |
> | innodb_open_files |
> 300 |
> | innodb_support_xa |
> ON |
> | innodb_sync_spin_loops |
> 20 |
> | innodb_table_locks |
> ON |
> | innodb_thread_concurrency |
> 8 |
> | innodb_thread_sleep_delay |
> 10000 |
> | interactive_timeout |
> 28800 |
> | join_buffer_size |
> 131072 |
> | key_buffer_size |
> 16777216 |
> | key_cache_age_threshold |
> 300 |
> | key_cache_block_size |
> 1024 |
> | key_cache_division_limit |
> 100 |
> | language | /usr/share/mysql/
> english/ |
> | large_files_support |
> ON |
> | large_page_size |
> 0 |
> | large_pages |
> OFF |
> | license |
> GPL |
> | local_infile |
> ON |
> | locked_in_memory |
> OFF |
> | log |
> OFF |
> | log_bin |
> ON |
> | log_bin_trust_function_creators |
> OFF |
> | log_error
> | |
> | log_queries_not_using_indexes |
> OFF |
> | log_slave_updates |
> OFF |
> | log_slow_queries |
> OFF |
> | log_warnings |
> 1 |
> | long_query_time |
> 10 |
> | low_priority_updates |
> OFF |
> | lower_case_file_system |
> OFF |
> | lower_case_table_names |
> 0 |
> | max_allowed_packet |
> 134216704 |
> | max_binlog_cache_size |
> 18446744073709551615 |
> | max_binlog_size |
> 1073741824 |
> | max_connect_errors |
> 10 |
> | max_connections |
> 100 |
> | 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 |
> | multi_range_count |
> 256 |
> | myisam_data_pointer_size |
> 6 |
> | myisam_max_sort_file_size |
> 9223372036854775807 |
> | myisam_recover_options |
> OFF |
> | myisam_repair_threads |
> 1 |
> | myisam_sort_buffer_size |
> 8388608 |
> | myisam_stats_method |
> nulls_unequal |
> | ndb_autoincrement_prefetch_sz |
> 32 |
> | ndb_force_send |
> ON |
> | ndb_use_exact_count |
> ON |
> | ndb_use_transactions |
> OFF |
> | ndb_cache_check_time |
> 0 |
> | net_buffer_length |
> 8192 |
> | net_read_timeout |
> 30 |
> | net_retry_count |
> 10 |
> | net_write_timeout |
> 60 |
> | new |
> OFF |
> | old_passwords |
> OFF |
> | open_files_limit |
> 1024 |
> | optimizer_prune_level |
> 1 |
> | optimizer_search_depth |
> 62 |
> | pid_file | /var/lib/mysql/
> suse.pid |
> | port |
> 3306 |
> | preload_buffer_size |
> 32768 |
> | prepared_stmt_count |
> 0 |
> | protocol_version |
> 10 |
> | query_alloc_block_size |
> 8192 |
> | query_cache_limit |
> 1048576 |
> | query_cache_min_res_unit |
> 4096 |
> | query_cache_size |
> 0 |
> | query_cache_type |
> ON |
> | query_cache_wlock_invalidate |
> OFF |
> | query_prealloc_size |
> 8192 |
> | range_alloc_block_size |
> 2048 |
> | read_buffer_size |
> 258048 |
> | read_only |
> OFF |
> | read_rnd_buffer_size |
> 520192 |
> | relay_log_purge |
> ON |
> | relay_log_space_limit |
> 0 |
> | rpl_recovery_rank |
> 0 |
> | secure_auth |
> OFF |
> | server_id |
> 1 |
> | skip_external_locking |
> ON |
> | skip_networking |
> OFF |
> | skip_show_database |
> OFF |
> | slave_compressed_protocol |
> OFF |
> | slave_load_tmpdir | /
> tmp/ |
> | slave_net_timeout |
> 3600 |
> | slave_skip_errors |
> OFF |
> | slave_transaction_retries |
> 10 |
> | slow_launch_time |
> 2 |
> | socket | /var/lib/mysql/
> mysql.sock |
> | sort_buffer_size |
> 524280 |
> | sql_big_selects |
> ON |
> | sql_mode
> | |
> | sql_notes |
> ON |
> | sql_warnings |
> OFF |
> | ssl_ca
> | |
> | ssl_capath
> | |
> | ssl_cert
> | |
> | ssl_cipher
> | |
> | ssl_key
> | |
> | storage_engine |
> InnoDB |
> | sync_binlog |
> 0 |
> | sync_frm |
> ON |
> | system_time_zone |
> CEST |
> | table_cache |
> 64 |
> | table_lock_wait_timeout |
> 50 |
> | table_type |
> InnoDB |
> | thread_cache_size |
> 0 |
> | thread_stack |
> 262144 |
> | time_format | %H:%i:%
> s |
> | time_zone |
> SYSTEM |
> | timed_mutexes |
> OFF |
> | tmp_table_size |
> 33554432 |
> | tmpdir | /
> tmp/ |
> | transaction_alloc_block_size |
> 8192 |
> | transaction_prealloc_size |
> 4096 |
> | tx_isolation | REPEATABLE-
> READ |
> | updatable_views_with_limit |
> YES |
> | version | 5.0.24-max-
> log |
> | version_bdb | Sleepycat Software: Berkeley DB
> 4.1.24: (July 27, 2006) |
> | version_comment | MySQL Community Edition -
> Experimental (GPL) |
> | version_compile_machine |
> x86_64 |
> | version_compile_os | unknown-linux-
> gnu |
> | wait_timeout |
> 28800 |
> +---------------------------------
> +---------------------------------------------------------+
> 232 rows in set (0.00 sec)
>
> mysql> show global status;
> +-----------------------------------+----------+
> | Variable_name | Value |
> +-----------------------------------+----------+
> | Aborted_clients | 3 |
> | Aborted_connects | 0 |
> | Binlog_cache_disk_use | 0 |
> | Binlog_cache_use | 2 |
> | Bytes_received | 9615 |
> | Bytes_sent | 255934 |
> | Com_admin_commands | 4 |
> | Com_alter_db | 0 |
> | Com_alter_table | 0 |
> | Com_analyze | 0 |
> | Com_backup_table | 0 |
> | Com_begin | 9 |
> | Com_change_db | 11 |
> | Com_change_master | 0 |
> | Com_check | 0 |
> | Com_checksum | 0 |
> | Com_commit | 9 |
> | Com_create_db | 0 |
> | Com_create_function | 0 |
> | Com_create_index | 0 |
> | Com_create_table | 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 | 47 |
> | Com_set_option | 6 |
> | 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 | 1 |
> | Com_show_errors | 0 |
> | Com_show_fields | 56 |
> | 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 | 4 |
> | Com_show_slave_status | 0 |
> | Com_show_status | 17 |
> | Com_show_storage_engines | 0 |
> | Com_show_tables | 2 |
> | Com_show_triggers | 0 |
> | Com_show_variables | 5 |
> | 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 | 4 |
> | 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 | 23 |
> | Created_tmp_disk_tables | 58 |
> | Created_tmp_files | 5 |
> | Created_tmp_tables | 83 |
> | Delayed_errors | 0 |
> | Delayed_insert_threads | 0 |
> | Delayed_writes | 0 |
> | Flush_commands | 1 |
> | Handler_commit | 15 |
> | Handler_delete | 0 |
> | Handler_discover | 0 |
> | Handler_prepare | 4 |
> | Handler_read_first | 16 |
> | Handler_read_key | 80 |
> | Handler_read_next | 0 |
> | Handler_read_prev | 0 |
> | Handler_read_rnd | 0 |
> | Handler_read_rnd_next | 1028 |
> | Handler_rollback | 0 |
> | Handler_savepoint | 0 |
> | Handler_savepoint_rollback | 0 |
> | Handler_update | 0 |
> | Handler_write | 932 |
> | Innodb_buffer_pool_pages_data | 153 |
> | Innodb_buffer_pool_pages_dirty | 0 |
> | Innodb_buffer_pool_pages_flushed | 6 |
> | Innodb_buffer_pool_pages_free | 359 |
> | Innodb_buffer_pool_pages_latched | 0 |
> | Innodb_buffer_pool_pages_misc | 0 |
> | Innodb_buffer_pool_pages_total | 512 |
> | Innodb_buffer_pool_read_ahead_rnd | 2 |
> | Innodb_buffer_pool_read_ahead_seq | 0 |
> | Innodb_buffer_pool_read_requests | 1266 |
> | Innodb_buffer_pool_reads | 137 |
> | Innodb_buffer_pool_wait_free | 0 |
> | Innodb_buffer_pool_write_requests | 19 |
> | Innodb_data_fsyncs | 11 |
> | Innodb_data_pending_fsyncs | 0 |
> | Innodb_data_pending_reads | 0 |
> | Innodb_data_pending_writes | 0 |
> | Innodb_data_read | 4689920 |
> | Innodb_data_reads | 153 |
> | Innodb_data_writes | 14 |
> | Innodb_data_written | 201728 |
> | Innodb_dblwr_pages_written | 6 |
> | Innodb_dblwr_writes | 1 |
> | Innodb_log_waits | 0 |
> | Innodb_log_write_requests | 2 |
> | Innodb_log_writes | 5 |
> | Innodb_os_log_fsyncs | 8 |
> | Innodb_os_log_pending_fsyncs | 0 |
> | Innodb_os_log_pending_writes | 0 |
> | Innodb_os_log_written | 3584 |
> | Innodb_page_size | 16384 |
> | Innodb_pages_created | 0 |
> | Innodb_pages_read | 153 |
> | Innodb_pages_written | 6 |
> | 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 | 16 |
> | Innodb_rows_updated | 4 |
> | Key_blocks_not_flushed | 0 |
> | Key_blocks_unused | 13396 |
> | Key_blocks_used | 0 |
> | Key_read_requests | 0 |
> | Key_reads | 0 |
> | Key_write_requests | 0 |
> | Key_writes | 0 |
> | Last_query_cost | 0.000000 |
> | Max_used_connections | 4 |
> | Ndb_cluster_node_id | 0 |
> | Ndb_connected_host | |
> | Ndb_connected_port | 0 |
> | Ndb_number_of_storage_nodes | 0 |
> | Not_flushed_delayed_rows | 0 |
> | Open_files | 68 |
> | Open_streams | 0 |
> | Open_tables | 41 |
> | Opened_tables | 47 |
> | Qcache_free_blocks | 0 |
> | Qcache_free_memory | 0 |
> | Qcache_hits | 0 |
> | Qcache_inserts | 0 |
> | Qcache_lowmem_prunes | 0 |
> | Qcache_not_cached | 0 |
> | Qcache_queries_in_cache | 0 |
> | Qcache_total_blocks | 0 |
> | Questions | 198 |
> | Rpl_status | NULL |
> | Select_full_join | 0 |
> | Select_full_range_join | 0 |
> | Select_range | 4 |
> | Select_range_check | 0 |
> | Select_scan | 92 |
> | 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 | 52 |
> | Table_locks_waited | 0 |
> | Tc_log_max_pages_used | 0 |
> | Tc_log_page_size | 0 |
> | Tc_log_page_waits | 0 |
> | Threads_cached | 0 |
> | Threads_connected | 3 |
> | Threads_created | 22 |
> | Threads_running | 2 |
> | Uptime | 11504 |
> +-----------------------------------+----------+
> 249 rows in set (0.01 sec)
>
> mysql> select version();
> +-----------------+
> | version() |
> +-----------------+
> | 5.1.12-beta-log |
> +-----------------+
> 1 row in set (0.00 sec)
>
> mysql> show global variables;
> +-------------------------------------
> +----------------------------------------------+
> | Variable_name |
> Value |
> +-------------------------------------
> +----------------------------------------------+
> | auto_increment_increment |
> 1 |
> | auto_increment_offset |
> 1 |
> | automatic_sp_privileges |
> ON |
> | back_log |
> 50 |
> | basedir | /MySQL_51/
> mysql-5.1.12/ |
> | binlog_cache_size |
> 32768 |
> | binlog_format |
> STATEMENT |
> | 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 | /MySQL_51/mysql-5.1.12/
> share/mysql/charsets/ |
> | collation_connection |
> utf8_general_ci |
> | collation_database |
> utf8_general_ci |
> | collation_server |
> utf8_general_ci |
> | completion_type |
> 0 |
> | concurrent_insert |
> 1 |
> | connect_timeout |
> 5 |
> | datadir | /MySQL_51/mysql-5.1.12/
> data/ |
> | date_format | %Y-%m-%
> d |
> | datetime_format | %Y-%m-%d %H:%i:%
> s |
> | default_week_format |
> 0 |
> | delay_key_write |
> ON |
> | delayed_insert_limit |
> 100 |
> | delayed_insert_timeout |
> 300 |
> | delayed_queue_size |
> 1000 |
> | div_precision_increment |
> 4 |
> | engine_condition_pushdown |
> OFF |
> | event_scheduler |
> 1 |
> | expire_logs_days |
> 0 |
> | flush |
> OFF |
> | flush_time |
> 0 |
> | 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 | /MySQL_51/mysql-5.1.12/data/
> suse.log |
> | group_concat_max_len |
> 1024 |
> | have_archive |
> YES |
> | have_blackhole_engine |
> YES |
> | have_compress |
> YES |
> | have_crypt |
> YES |
> | have_csv |
> YES |
> | have_dynamic_loading |
> YES |
> | have_example_engine |
> YES |
> | have_federated_engine |
> YES |
> | have_geometry |
> YES |
> | have_innodb |
> YES |
> | have_merge |
> YES |
> | have_ndbcluster |
> DISABLED |
> | have_openssl |
> DISABLED |
> | have_partitioning |
> YES |
> | have_query_cache |
> YES |
> | have_row_based_replication |
> YES |
> | have_rtree_keys |
> YES |
> | have_symlink |
> YES |
> | init_connect
> | |
> | init_file
> | |
> | init_slave
> | |
> | innodb_additional_mem_pool_size |
> 1048576 |
> | innodb_autoextend_increment |
> 8 |
> | innodb_buffer_pool_awe_mem_mb |
> 0 |
> | innodb_buffer_pool_size |
> 8388608 |
> | innodb_checksums |
> ON |
> | innodb_commit_concurrency |
> 0 |
> | innodb_concurrency_tickets |
> 500 |
> | innodb_data_file_path |
> ibdata1:10M:autoextend |
> | innodb_data_home_dir
> | |
> | innodb_doublewrite |
> ON |
> | innodb_fast_shutdown |
> 1 |
> | innodb_file_io_threads |
> 4 |
> | innodb_file_per_table |
> OFF |
> | innodb_flush_method
> | |
> | innodb_force_recovery |
> 0 |
> | innodb_lock_wait_timeout |
> 50 |
> | innodb_locks_unsafe_for_binlog |
> OFF |
> | innodb_log_arch_dir
> | |
> | innodb_log_archive |
> OFF |
> | innodb_log_buffer_size |
> 1048576 |
> | innodb_log_file_size |
> 5242880 |
> | innodb_log_files_in_group |
> 2 |
> | innodb_log_group_home_dir
> | ./ |
> | innodb_max_dirty_pages_pct |
> 90 |
> | innodb_max_purge_lag |
> 0 |
> | innodb_mirrored_log_groups |
> 1 |
> | innodb_open_files |
> 300 |
> | innodb_support_xa |
> ON |
> | innodb_sync_spin_loops |
> 20 |
> | innodb_table_locks |
> ON |
> | innodb_thread_concurrency |
> 8 |
> | innodb_thread_sleep_delay |
> 10000 |
> | innodb_flush_log_at_trx_commit |
> 1 |
> | interactive_timeout |
> 28800 |
> | join_buffer_size |
> 131072 |
> | key_buffer_size |
> 8388600 |
> | key_cache_age_threshold |
> 300 |
> | key_cache_block_size |
> 1024 |
> | key_cache_division_limit |
> 100 |
> | language | /MySQL_51/mysql-5.1.12/
> share/mysql/english/ |
> | large_files_support |
> ON |
> | large_page_size |
> 0 |
> | large_pages |
> OFF |
> | lc_time_names |
> en_US |
> | license |
> GPL |
> | local_infile |
> ON |
> | locked_in_memory |
> OFF |
> | log |
> ON |
> | log_bin |
> OFF |
> | log_bin_trust_function_creators |
> OFF |
> | log_error | /MySQL_51/mysql-5.1.12/data/
> suse.err |
> | log_output |
> TABLE |
> | log_queries_not_using_indexes |
> OFF |
> | log_slave_updates |
> OFF |
> | log_slow_queries |
> ON |
> | log_warnings |
> 1 |
> | long_query_time |
> 10 |
> | low_priority_updates |
> OFF |
> | lower_case_file_system |
> OFF |
> | lower_case_table_names |
> 0 |
> | max_allowed_packet |
> 1048576 |
> | max_binlog_cache_size |
> 18446744073709551615 |
> | max_binlog_size |
> 1073741824 |
> | max_connect_errors |
> 10 |
> | max_connections |
> 100 |
> | 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 |
> | multi_range_count |
> 256 |
> | myisam_data_pointer_size |
> 6 |
> | myisam_max_sort_file_size |
> 9223372036854775807 |
> | myisam_recover_options |
> OFF |
> | myisam_repair_threads |
> 1 |
> | myisam_sort_buffer_size |
> 8388608 |
> | myisam_stats_method |
> nulls_unequal |
> | myisam_use_mmap |
> OFF |
> | ndb_autoincrement_prefetch_sz |
> 32 |
> | ndb_cache_check_time |
> 0 |
> | ndb_extra_logging |
> 0 |
> | ndb_force_send |
> ON |
> | ndb_index_stat_cache_entries |
> 32 |
> | ndb_index_stat_enable |
> ON |
> | ndb_index_stat_update_freq |
> 20 |
> | ndb_report_thresh_binlog_epoch_slip |
> 3 |
> | ndb_report_thresh_binlog_mem_usage |
> 10 |
> | ndb_use_copying_alter_table |
> OFF |
> | ndb_use_exact_count |
> ON |
> | ndb_use_transactions |
> OFF |
> | net_buffer_length |
> 16384 |
> | net_read_timeout |
> 30 |
> | net_retry_count |
> 10 |
> | net_write_timeout |
> 60 |
> | new |
> OFF |
> | old_alter_table |
> OFF |
> | old_passwords |
> OFF |
> | open_files_limit |
> 1024 |
> | optimizer_prune_level |
> 1 |
> | optimizer_search_depth |
> 62 |
> | pid_file | /MySQL_51/mysql-5.1.12/data/
> suse.pid |
> | plugin_dir | /MySQL_51/mysql-5.1.12/lib/
> mysql |
> | port |
> 3307 |
> | preload_buffer_size |
> 32768 |
> | prepared_stmt_count |
> 0 |
> | protocol_version |
> 10 |
> | query_alloc_block_size |
> 8192 |
> | query_cache_limit |
> 1048576 |
> | query_cache_min_res_unit |
> 4096 |
> | query_cache_size |
> 0 |
> | query_cache_type |
> ON |
> | query_cache_wlock_invalidate |
> OFF |
> | query_prealloc_size |
> 8192 |
> | range_alloc_block_size |
> 2048 |
> | read_buffer_size |
> 131072 |
> | read_only |
> OFF |
> | read_rnd_buffer_size |
> 262144 |
> | relay_log_purge |
> ON |
> | relay_log_space_limit |
> 0 |
> | rpl_recovery_rank |
> 0 |
> | secure_auth |
> OFF |
> | server_id |
> 0 |
> | skip_external_locking |
> ON |
> | skip_networking |
> OFF |
> | skip_show_database |
> OFF |
> | slave_compressed_protocol |
> OFF |
> | slave_load_tmpdir | /
> tmp |
> | slave_net_timeout |
> 3600 |
> | slave_skip_errors |
> OFF |
> | slave_transaction_retries |
> 10 |
> | slow_launch_time |
> 2 |
> | slow_query_log |
> ON |
> | slow_query_log_file | /MySQL_51/mysql-5.1.12/data/
> suse-slow.log |
> | socket | /tmp/
> mysql.sock |
> | sort_buffer_size |
> 2097144 |
> | sql_big_selects |
> ON |
> | sql_mode
> | |
> | sql_notes |
> ON |
> | sql_warnings |
> OFF |
> | ssl_ca
> | |
> | ssl_capath
> | |
> | ssl_cert
> | |
> | ssl_cipher
> | |
> | ssl_key
> | |
> | storage_engine |
> MyISAM |
> | sync_binlog |
> 0 |
> | sync_frm |
> ON |
> | system_time_zone |
> CEST |
> | table_definition_cache |
> 128 |
> | table_lock_wait_timeout |
> 50 |
> | table_open_cache |
> 64 |
> | table_type |
> MyISAM |
> | thread_cache_size |
> 0 |
> | thread_stack |
> 262144 |
> | time_format | %H:%i:%
> s |
> | time_zone |
> SYSTEM |
> | timed_mutexes |
> OFF |
> | tmp_table_size |
> 33554432 |
> | tmpdir | /
> tmp |
> | transaction_alloc_block_size |
> 8192 |
> | transaction_prealloc_size |
> 4096 |
> | tx_isolation | REPEATABLE-
> READ |
> | updatable_views_with_limit |
> YES |
> | version | 5.1.12-beta-
> log |
> | version_comment | Source
> distribution |
> | version_compile_machine |
> x86_64 |
> | version_compile_os | suse-
> linux |
> | wait_timeout |
> 28800 |
> +-------------------------------------
> +----------------------------------------------+
> 242 rows in set (0.00 sec)
>
> mysql> show global status;
> +-----------------------------------+----------+
> | Variable_name | Value |
> +-----------------------------------+----------+
> | Aborted_clients | 0 |
> | Aborted_connects | 0 |
> | Binlog_cache_disk_use | 0 |
> | Binlog_cache_use | 0 |
> | Bytes_received | 1204 |
> | Bytes_sent | 9856 |
> | Com_admin_commands | 0 |
> | Com_alter_db | 0 |
> | Com_alter_event | 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_event | 0 |
> | Com_create_function | 0 |
> | Com_create_index | 0 |
> | Com_create_table | 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_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 | 10 |
> | 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_event | 0 |
> | Com_show_create_table | 0 |
> | Com_show_databases | 0 |
> | Com_show_engine_logs | 0 |
> | Com_show_engine_mutex | 0 |
> | Com_show_engine_status | 0 |
> | Com_show_errors | 0 |
> | Com_show_events | 0 |
> | Com_show_fields | 0 |
> | Com_show_grants | 0 |
> | Com_show_keys | 0 |
> | Com_show_master_status | 0 |
> | Com_show_new_master | 0 |
> | Com_show_open_tables | 0 |
> | Com_show_plugins | 0 |
> | Com_show_privileges | 0 |
> | Com_show_processlist | 0 |
> | Com_show_slave_hosts | 0 |
> | Com_show_slave_status | 0 |
> | Com_show_status | 10 |
> | Com_show_storage_engines | 0 |
> | Com_show_tables | 0 |
> | Com_show_triggers | 0 |
> | Com_show_variables | 1 |
> | 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 | 12 |
> | Created_tmp_disk_tables | 0 |
> | Created_tmp_files | 5 |
> | Created_tmp_tables | 11 |
> | 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 | 3 |
> | Handler_read_key | 0 |
> | Handler_read_next | 0 |
> | Handler_read_prev | 0 |
> | Handler_read_rnd | 0 |
> | Handler_read_rnd_next | 274 |
> | Handler_rollback | 0 |
> | Handler_savepoint | 0 |
> | Handler_savepoint_rollback | 0 |
> | Handler_update | 0 |
> | Handler_write | 251 |
> | Innodb_buffer_pool_pages_data | 20 |
> | Innodb_buffer_pool_pages_dirty | 0 |
> | Innodb_buffer_pool_pages_flushed | 0 |
> | Innodb_buffer_pool_pages_free | 492 |
> | 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 | 108 |
> | Innodb_buffer_pool_reads | 13 |
> | Innodb_buffer_pool_wait_free | 0 |
> | Innodb_buffer_pool_write_requests | 0 |
> | Innodb_data_fsyncs | 3 |
> | Innodb_data_pending_fsyncs | 0 |
> | Innodb_data_pending_reads | 0 |
> | Innodb_data_pending_writes | 0 |
> | Innodb_data_read | 2510848 |
> | Innodb_data_reads | 26 |
> | Innodb_data_writes | 3 |
> | Innodb_data_written | 1536 |
> | Innodb_dblwr_pages_written | 0 |
> | Innodb_dblwr_writes | 0 |
> | Innodb_log_waits | 0 |
> | Innodb_log_write_requests | 0 |
> | Innodb_log_writes | 1 |
> | Innodb_os_log_fsyncs | 3 |
> | Innodb_os_log_pending_fsyncs | 0 |
> | Innodb_os_log_pending_writes | 0 |
> | Innodb_os_log_written | 512 |
> | Innodb_page_size | 16384 |
> | Innodb_pages_created | 0 |
> | Innodb_pages_read | 20 |
> | Innodb_pages_written | 0 |
> | 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 | 6698 |
> | Key_blocks_used | 0 |
> | Key_read_requests | 0 |
> | Key_reads | 0 |
> | Key_write_requests | 0 |
> | Key_writes | 0 |
> | Last_query_cost | 0.000000 |
> | Max_used_connections | 2 |
> | Ndb_cluster_node_id | 0 |
> | Ndb_config_from_host | |
> | Ndb_config_from_port | 0 |
> | Ndb_number_of_storage_nodes | 0 |
> | Not_flushed_delayed_rows | 0 |
> | Open_files | 19 |
> | Open_streams | 0 |
> | Open_table_definitions | 16 |
> | Open_tables | 8 |
> | Opened_tables | 14 |
> | Qcache_free_blocks | 0 |
> | Qcache_free_memory | 0 |
> | Qcache_hits | 0 |
> | Qcache_inserts | 0 |
> | Qcache_lowmem_prunes | 0 |
> | Qcache_not_cached | 0 |
> | Qcache_queries_in_cache | 0 |
> | Qcache_total_blocks | 0 |
> | Questions | 30 |
> | Rpl_status | NULL |
> | Select_full_join | 0 |
> | Select_full_range_join | 0 |
> | Select_range | 0 |
> | Select_range_check | 0 |
> | Select_scan | 11 |
> | 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 | 18 |
> | Table_locks_waited | 0 |
> | Tc_log_max_pages_used | 0 |
> | Tc_log_page_size | 0 |
> | Tc_log_page_waits | 0 |
> | Threads_cached | 0 |
> | Threads_connected | 2 |
> | Threads_created | 10 |
> | Threads_running | 2 |
> | Uptime | 11325 |
> +-----------------------------------+----------+
> 256 rows in set (0.00 sec)
>
Markus Popp
> I always found the reason to be network problems out in
> the wild word of the Internet.
Thanks for this tip. Since this occurs in a very unpredictable manner
and not very often, this sounds like a very plausible explanation.
Cheers,
Markus
Beat Vontobel schrieb:
Ronald Bradford
Regarding SHOW STATUS and SHOW VARIABLES, I'd like to see them in the INFORMATION_SCHEMA. I'd heard somebody was working on it from the conference, but you never know. There are plenty of these things I'd also really like to see in INFORMATION_SCHEMA. Another story.
I'd endevour to do it myself if I knew nobody else was working on it. Perhaps a query to the internals list might be a good start.
Infact, perhaps MySQL Internals could provide a list of nice to have smaller coding features, like a TODO LIST, and people can then allocate themselves to the task, ensuring that 5 people don't do the same thing. That way things like this can get onto the list, and it's stuff the community can contribute to.
Regards
Ronald
| ft_boolean_syntax | + -><()~*:""&| |
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /MySQL_51/mysql- 5.1.12/ |
| binlog_cache_size | 32768 |
| binlog_format | STATEMENT |
| 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 | /MySQL_51/mysql-5.1.12/share/mysql/charsets/ |
| collation_connection | utf8_general_ci |
| collation_database | utf8_general_ci |
| collation_server | utf8_general_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
| datadir | /MySQL_51/mysql- 5.1.12/data/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| event_scheduler | 1 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| 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 | /MySQL_51/mysql-5.1.12/data/suse.log |
| log_error | /MySQL_51/mysql- 5.1.12/data/suse.err |
| log_output | TABLE |
| log_queries_not_using_indexes | OFF |
| preload_buffer_size | 32768 |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /tmp |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.1.12-beta-log |
Jay Pipes
On Tue, 2006-08-29 at 13:31 +1000, Ronald Bradford wrote:
> Infact, perhaps MySQL Internals could provide a list of nice to have
> smaller coding features, like a TODO LIST, and people can then
> allocate themselves to the task, ensuring that 5 people don't do the
> same thing. That way things like this can get onto the list, and it's
> stuff the community can contribute to.
I am working on adding this kind of feature to MySQL Forge for community
members to form teams around specific features and "get it done" :)
Hopefully, next week or so. Been swamped with other things.
Jay