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	63
Qcache_free_memory	37535488
Qcache_hits	47971803
Qcache_not_cached	1448570
Qcache_queries_in_cache	44404
Threads_cached	59
Threads_connected	5
Threads_created	63
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	36,881	4,348,056	1,584,128		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,836	Show contents
cache_block	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_filter	MyISAM	10	Dynamic	405	405,232	41,984	15,456	Show contents
cache_form	MyISAM	10	Dynamic	0	356,192	6,144	356,192	Show contents
cache_menu	MyISAM	10	Dynamic	1,371	5,806,572	61,440		Show contents
cache_mollom	MyISAM	10	Dynamic	467	126,936	29,696		Show contents
cache_nodewords	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_page	MyISAM	10	Dynamic	948	3,616,020	66,560		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	184	109,424	16,384	20,108	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	0	377	3,072	377	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	14	656	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	208	644,032	74,752	629,040	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,264	236,840	23,552	23,436	Show contents
weblinks	MyISAM	10	Dynamic	43	5,376	5,120		Show contents
xmlsitemap	MyISAM	10	Dynamic	23	1,364	7,168		Show contents
xmlsitemap_node	MyISAM	10	Fixed	24	504	2,048		Show contents
xmlsitemap_term	MyISAM	10	Fixed	0	0	1,024		Show contents
				----------	----------	----------	----------
total				46,247	17,009,825	2,542,592	1,076,013

Total database size is 18.6 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