Tables Section

Database Information

Overview

Database type

MySQL

Version

5.0.91

Database URL

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

Base URL

http://nanwich.com

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	400
query_cache_size	171966464
query_cache_type	ON

Selected Status

Max_used_connections	214
Qcache_free_memory	43608360
Qcache_hits	234768476
Qcache_not_cached	6428594
Qcache_queries_in_cache	27876
Threads_cached	210
Threads_connected	4
Threads_created	214
Threads_running	2

Table Status

Table	Engine	Version	Row Format	Rows	Data Length	Index Length	Overhead	Operation
access	MyISAM	10	Dynamic	6	152	2,048		Show contents
accesslog	MyISAM	10	Dynamic	283,513	28,308,024	11,533,312		Show contents
actions	MyISAM	10	Dynamic	11	820	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	113	4,864	9,216		Show contents
blocks_roles	MyISAM	10	Dynamic	0	0	1,024		Show contents
book	MyISAM	10	Fixed	132	1,716	10,240		Show contents
boxes	MyISAM	10	Dynamic	5	1,184	4,096		Show contents
cache	MyISAM	10	Dynamic	6	186,256	6,144	600	Show contents
cache_block	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_filter	MyISAM	10	Dynamic	314	460,376	40,960	151,060	Show contents
cache_form	MyISAM	10	Dynamic	90	2,500,916	6,144		Show contents
cache_menu	MyISAM	10	Dynamic	1,721	8,299,264	90,112	9,808	Show contents
cache_mollom	MyISAM	10	Dynamic	4,109	4,096,956	197,632		Show contents
cache_nodewords	MyISAM	10	Dynamic	0	0	1,024		Show contents
cache_page	MyISAM	10	Dynamic	153	11,164,504	415,744	10,460,056	Show contents
cache_tax_image	MyISAM	10	Dynamic	58	33,028	6,144		Show contents
cache_update	MyISAM	10	Dynamic	1	8,020	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	217	114,312	17,408	4,800	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	100	3,580	5,120		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	17	247	3,072	26	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	354	45,960	51,200		Show contents
menu_per_role	MyISAM	10	Fixed	5	45	2,048		Show contents
menu_router	MyISAM	10	Dynamic	316	101,380	26,624		Show contents
mollom	MyISAM	10	Dynamic	6	560	6,144	160	Show contents
mollom_form	MyISAM	10	Dynamic	1	96	5,120		Show contents
node	MyISAM	10	Dynamic	339	20,180	87,040		Show contents
node_access	MyISAM	10	Dynamic	1	20	5,120		Show contents
node_comment_statistics	MyISAM	10	Dynamic	339	7,060	11,264		Show contents
node_counter	MyISAM	10	Fixed	0	0	1,024		Show contents
node_revisions	MyISAM	10	Dynamic	341	745,588	16,384		Show contents
node_type	MyISAM	10	Dynamic	5	964	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,568	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
search_dataset	MyISAM	10	Dynamic	339	473,164	7,168		Show contents
search_index	MyISAM	10	Dynamic	31,718	872,776	1,295,360		Show contents
search_node_links	MyISAM	10	Dynamic	85	3,416	3,072		Show contents
search_total	MyISAM	10	Dynamic	5,931	123,068	104,448		Show contents
sequences	MyISAM	10	Dynamic	8	180	5,120		Show contents
sessions	MyISAM	10	Dynamic	132	14,752	24,576	4,716	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	279	124,816	70,656		Show contents
system_module_users	MyISAM	10	Dynamic	0	0	1,024		Show contents
term_data	MyISAM	10	Dynamic	58	12,524	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	158	7,136	17,408		Show contents
users	MyISAM	10	Dynamic	72	8,936	8,192		Show contents
users_roles	MyISAM	10	Fixed	2	18	3,072		Show contents
variable	MyISAM	10	Dynamic	437	34,544	15,360	600	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,002	507,432	54,272	345,476	Show contents
weblinks	MyISAM	10	Dynamic	43	4,732	5,120		Show contents
xmlsitemap	MyISAM	10	Dynamic	158	9,472	13,312		Show contents
xmlsitemap_node	MyISAM	10	Fixed	157	3,297	4,096		Show contents
xmlsitemap_term	MyISAM	10	Fixed	1	21	2,048		Show contents
				----------	----------	----------	----------
total				334,351	58,408,536	14,440,448	10,977,302

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