Tables Section

Database Information

Overview

Database type

MySQL

Version

5.0.89

Database URL

scheme	mysql
host	localhost
user	newich_admin
pass	••••••
path	/newich_drpl1

Base URL

http://nanwich.info

Database prefix

- none -

Privileges

USAGE

Selected Variables

character_set_database	latin1
character_set_results	utf8
collation_connection	utf8_general_ci
collation_database	latin1_swedish_ci
collation_server	latin1_swedish_ci
have_dynamic_loading	YES
have_innodb	YES
have_isam	NO
have_query_cache	YES
have_raid	NO
max_connections	500
query_cache_size	134217728
query_cache_type	ON

Selected Status

Max_used_connections	89
Qcache_free_memory	36954200
Qcache_hits	109142145
Qcache_not_cached	2886010
Qcache_queries_in_cache	40468
Threads_cached	87
Threads_connected	2
Threads_created	89
Threads_running	1

Table Status

Table	Engine	Version	Row Format	Rows	Data Length	Index Length	Overhead	Operation
access	MyISAM	10	Dynamic	0	0	1,024		Show contents
accesslog	MyISAM	10	Dynamic	35,316	4,419,972	1,584,128	109,180	Show contents
actions	MyISAM	10	Dynamic	10	744	5,120		Show contents
actions_aid	MyISAM	10	Fixed	0	0	1,024		Show contents
advanced_help_index	MyISAM	10	Dynamic	0	0	1,024		Show contents
authmap	MyISAM	10	Dynamic	16	648	4,096		Show contents
batch	MyISAM	10	Dynamic	0	0	1,024		Show contents
blocks	MyISAM	10	Dynamic	108	4,636	9,216		Show contents
blocks_roles	MyISAM	10	Dynamic	0	0	1,024		Show contents
book	MyISAM	10	Fixed	129	1,677	10,240		Show contents
boxes	MyISAM	10	Dynamic	3	716	4,096		Show contents
cache	MyISAM	10	Dynamic	3	197,652	6,144	30,864	Show contents
cache_block	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_filter	MyISAM	10	Dynamic	361	405,232	41,984	96,860	Show contents
cache_form	MyISAM	10	Dynamic	0	356,192	6,144	356,192	Show contents
cache_menu	MyISAM	10	Dynamic	756	4,571,932	43,008		Show contents
cache_mollom	MyISAM	10	Dynamic	499	135,628	30,720		Show contents
cache_nodewords	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_page	MyISAM	10	Dynamic	28	4,091,884	72,704	3,964,080	Show contents
cache_tax_image	MyISAM	10	Dynamic	58	32,916	6,144		Show contents
cache_views	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_views_data	MyISAM	10	Dynamic	0	0	1,024		Show contents
client	MyISAM	10	Dynamic	0	0	1,024		Show contents
client_system	MyISAM	10	Dynamic	0	0	1,024		Show contents
comments	MyISAM	10	Dynamic	187	109,424	16,384	19,048	Show contents
contact	MyISAM	10	Dynamic	2	156	10,240		Show contents
devel_queries	MyISAM	10	Dynamic	0	0	1,024		Show contents
devel_times	MyISAM	10	Fixed	0	0	1,024		Show contents
file_revisions	MyISAM	10	Dynamic	0	0	1,024		Show contents
files	MyISAM	10	Dynamic	0	0	1,024		Show contents
filter_formats	MyISAM	10	Dynamic	4	104	6,144		Show contents
filters	MyISAM	10	Dynamic	15	344	4,096		Show contents
flood	MyISAM	10	Dynamic	0	108	5,120	108	Show contents
gotcha	MyISAM	10	Dynamic	56	42,512	6,144		Show contents
gsitemap	MyISAM	10	Fixed	114	3,078	4,096		Show contents
gsitemap_additional	MyISAM	10	Dynamic	0	0	1,024		Show contents
history	MyISAM	10	Fixed	2	377	3,072	351	Show contents
menu	MyISAM	10	Dynamic	103	9,348	4,096		Show contents
menu_custom	MyISAM	10	Dynamic	5	888	2,048		Show contents
menu_links	MyISAM	10	Dynamic	341	44,040	45,056		Show contents
menu_per_role	MyISAM	10	Fixed	5	45	2,048		Show contents
menu_router	MyISAM	10	Dynamic	295	95,112	27,648		Show contents
mollom	MyISAM	10	Dynamic	17	784	9,216		Show contents
node	MyISAM	10	Dynamic	330	19,644	80,896		Show contents
node_access	MyISAM	10	Dynamic	1	20	5,120		Show contents
node_comment_statistics	MyISAM	10	Dynamic	330	6,876	11,264		Show contents
node_counter	MyISAM	10	Fixed	0	0	1,024		Show contents
node_revisions	MyISAM	10	Dynamic	330	660,584	16,384	424	Show contents
node_type	MyISAM	10	Dynamic	5	976	2,048		Show contents
nodewords	MyISAM	10	Dynamic	8	600	6,144		Show contents
nodewords_custom	MyISAM	10	Dynamic	0	0	1,024		Show contents
permission	MyISAM	10	Dynamic	3	2,276	3,072		Show contents
profile_fields	MyISAM	10	Dynamic	3	292	8,192		Show contents
profile_values	MyISAM	10	Dynamic	195	4,328	8,192		Show contents
role	MyISAM	10	Dynamic	3	76	3,072		Show contents
sequences	MyISAM	10	Dynamic	8	180	5,120		Show contents
sessions	MyISAM	10	Dynamic	214	644,032	74,752	628,412	Show contents
spam_custom	MyISAM	10	Dynamic	2	68	8,192		Show contents
spam_log	MyISAM	10	Dynamic	28	3,036	5,120		Show contents
spam_reported	MyISAM	10	Dynamic	0	0	1,024		Show contents
spam_tokens	MyISAM	10	Dynamic	410	12,296	44,032		Show contents
spam_tracker	MyISAM	10	Dynamic	211	16,132	29,696		Show contents
system	MyISAM	10	Dynamic	278	124,184	87,040		Show contents
system_module_users	MyISAM	10	Dynamic	0	0	1,024		Show contents
term_data	MyISAM	10	Dynamic	58	12,480	10,240		Show contents
term_hierarchy	MyISAM	10	Fixed	58	522	4,096		Show contents
term_image	MyISAM	10	Dynamic	24	596	2,048		Show contents
term_node	MyISAM	10	Fixed	217	2,821	13,312		Show contents
term_relation	MyISAM	10	Fixed	11	143	4,096		Show contents
term_synonym	MyISAM	10	Dynamic	0	0	1,024		Show contents
upload	MyISAM	10	Dynamic	0	0	1,024		Show contents
url_alias	MyISAM	10	Dynamic	152	6,900	16,384		Show contents
users	MyISAM	10	Dynamic	72	8,800	8,192		Show contents
users_roles	MyISAM	10	Fixed	2	18	3,072		Show contents
variable	MyISAM	10	Dynamic	399	32,048	17,408	36	Show contents
view_argument	MyISAM	10	Dynamic	0	0	1,024		Show contents
view_exposed_filter	MyISAM	10	Dynamic	0	0	1,024		Show contents
view_filter	MyISAM	10	Dynamic	0	0	1,024		Show contents
view_sort	MyISAM	10	Dynamic	0	0	1,024		Show contents
view_tablefield	MyISAM	10	Dynamic	0	0	1,024		Show contents
view_view	MyISAM	10	Dynamic	0	0	1,024		Show contents
views_display	MyISAM	10	Dynamic	0	0	1,024		Show contents
views_object_cache	MyISAM	10	Dynamic	1	976	4,096		Show contents
views_view	MyISAM	10	Dynamic	0	0	1,024		Show contents
vocabulary	MyISAM	10	Dynamic	4	548	6,144		Show contents
vocabulary_node_types	MyISAM	10	Dynamic	5	100	3,072		Show contents
votingapi_cache	MyISAM	10	Dynamic	0	0	1,024		Show contents
votingapi_vote	MyISAM	10	Dynamic	0	0	1,024		Show contents
watchdog	MyISAM	10	Dynamic	1,003	236,840	23,552	60,872	Show contents
weblinks	MyISAM	10	Dynamic	43	5,376	5,120		Show contents
xmlsitemap	MyISAM	10	Dynamic	27	1,604	7,168		Show contents
xmlsitemap_node	MyISAM	10	Fixed	26	546	2,048		Show contents
xmlsitemap_term	MyISAM	10	Fixed	0	0	1,024		Show contents
				----------	----------	----------	----------
total				42,894	16,332,067	2,531,328	5,266,427

Total database size is 18.0 MB

Return to main demonstration page.

Nancy's Web If you don't know where you've been, how do you know where you are?

Navigation

Recent comments

Overview

Selected Variables

Selected Status