Database reference - sakila

Database overview

Documentation

Documentation generated on: 9/15/2011 7:48:14 PM

Database objects

typecount
tables17
views7
procedures3
functions3
all columns139
all parameters13
triggers6

Database properties

namevalue
namesakila
serverlocalhost
server version5.1.32-community
default char setlatin1
default collationlatin1_swedish_ci

Server variables

namevalue
auto_increment_increment
auto_increment_offset
autocommitON 
automatic_sp_privilegesON 
back_log50 
basedirC:\Program Files\MySQL\MySQL Server 5.1\ 
big_tablesOFF 
binlog_cache_size32768 
binlog_formatSTATEMENT 
bulk_insert_buffer_size8388608 
character_set_clientlatin1 
character_set_connectionlatin1 
character_set_databaselatin1 
character_set_filesystembinary 
character_set_results 
character_set_serverlatin1 
character_set_systemutf8 
character_sets_dirC:\Program Files\MySQL\MySQL Server 5.1\share\charsets\ 
collation_connectionlatin1_swedish_ci 
collation_databaselatin1_swedish_ci 
collation_serverlatin1_swedish_ci 
completion_type
concurrent_insert
connect_timeout10 
datadirC:\ProgramData\MySQL\MySQL Server 5.1\Data\ 
date_format%Y-%m-%d 
datetime_format%Y-%m-%d %H:%i:%s 
default_week_format
delay_key_writeON 
delayed_insert_limit100 
delayed_insert_timeout300 
delayed_queue_size1000 
div_precision_increment
engine_condition_pushdownON 
error_count
event_schedulerOFF 
expire_logs_days
flushOFF 
flush_time1800 
foreign_key_checksON 
ft_boolean_syntax+ -><()~*:""&| 
ft_max_word_len84 
ft_min_word_len
ft_query_expansion_limit20 
ft_stopword_file(built-in) 
general_logOFF 
general_log_fileC:\ProgramData\MySQL\MySQL Server 5.1\Data\SPRING.log 
group_concat_max_len1024 
have_community_featuresYES 
have_compressYES 
have_cryptNO 
have_csvYES 
have_dynamic_loadingYES 
have_geometryYES 
have_innodbYES 
have_ndbclusterNO 
have_opensslDISABLED 
have_partitioningYES 
have_query_cacheYES 
have_rtree_keysYES 
have_sslDISABLED 
have_symlinkYES 
hostnameSPRING 
identity
ignore_builtin_innodbOFF 
init_connect 
init_file 
init_slave 
innodb_adaptive_hash_indexON 
innodb_additional_mem_pool_size2097152 
innodb_autoextend_increment
innodb_autoinc_lock_mode
innodb_buffer_pool_size49283072 
innodb_checksumsON 
innodb_commit_concurrency
innodb_concurrency_tickets500 
innodb_data_file_pathibdata1:10M:autoextend 
innodb_data_home_dir 
innodb_doublewriteON 
innodb_fast_shutdown
innodb_file_io_threads
innodb_file_per_tableOFF 
innodb_flush_log_at_trx_commit
innodb_flush_method 
innodb_force_recovery
innodb_lock_wait_timeout50 
innodb_locks_unsafe_for_binlogOFF 
innodb_log_buffer_size1048576 
innodb_log_file_size25165824 
innodb_log_files_in_group
innodb_log_group_home_dir.\ 
innodb_max_dirty_pages_pct90 
innodb_max_purge_lag
innodb_mirrored_log_groups
innodb_open_files300 
innodb_rollback_on_timeoutOFF 
innodb_stats_on_metadataON 
innodb_support_xaON 
innodb_sync_spin_loops20 
innodb_table_locksON 
innodb_thread_concurrency10 
innodb_thread_sleep_delay10000 
insert_id
interactive_timeout28800 
join_buffer_size131072 
keep_files_on_createOFF 
key_buffer_size26214400 
key_cache_age_threshold300 
key_cache_block_size1024 
key_cache_division_limit100 
languageC:\Program Files\MySQL\MySQL Server 5.1\share\english\ 
large_files_supportON 
large_page_size
large_pagesOFF 
last_insert_id
lc_time_namesen_US 
licenseGPL 
local_infileON 
logOFF 
log_binOFF 
log_bin_trust_function_creatorsOFF 
log_bin_trust_routine_creatorsOFF 
log_errorC:\ProgramData\MySQL\MySQL Server 5.1\Data\SPRING.err 
log_outputFILE 
log_queries_not_using_indexesOFF 
log_slave_updatesOFF 
log_slow_queriesOFF 
log_warnings
long_query_time10.000000 
low_priority_updatesOFF 
lower_case_file_systemON 
lower_case_table_names
max_allowed_packet1048576 
max_binlog_cache_size4294963200 
max_binlog_size1073741824 
max_connect_errors10 
max_connections100 
max_delayed_threads20 
max_error_count64 
max_heap_table_size16777216 
max_insert_delayed_threads20 
max_join_size18446744073709551615 
max_length_for_sort_data1024 
max_prepared_stmt_count16382 
max_relay_log_size
max_seeks_for_key4294967295 
max_sort_length1024 
max_sp_recursion_depth
max_tmp_tables32 
max_user_connections
max_write_lock_count4294967295 
min_examined_row_limit
multi_range_count256 
myisam_data_pointer_size
myisam_max_sort_file_size107374182400 
myisam_recover_optionsOFF 
myisam_repair_threads
myisam_sort_buffer_size36700160 
myisam_stats_methodnulls_unequal 
myisam_use_mmapOFF 
named_pipeOFF 
net_buffer_length16384 
net_read_timeout30 
net_retry_count10 
net_write_timeout60 
newOFF 
oldOFF 
old_alter_tableOFF 
old_passwordsOFF 
open_files_limit622 
optimizer_prune_level
optimizer_search_depth62 
pid_fileC:\ProgramData\MySQL\MySQL Server 5.1\Data\SPRING.pid 
plugin_dirC:\Program Files\MySQL\MySQL Server 5.1\lib/plugin 
port3306 
preload_buffer_size32768 
profilingOFF 
profiling_history_size15 
protocol_version10 
pseudo_thread_id
query_alloc_block_size8192 
query_cache_limit1048576 
query_cache_min_res_unit4096 
query_cache_size
query_cache_typeON 
query_cache_wlock_invalidateOFF 
query_prealloc_size8192 
rand_seed1 
rand_seed2 
range_alloc_block_size4096 
read_buffer_size65536 
read_onlyOFF 
read_rnd_buffer_size262144 
relay_log 
relay_log_index 
relay_log_info_filerelay-log.info 
relay_log_purgeON 
relay_log_space_limit
report_host 
report_password 
report_port3306 
report_user 
rpl_recovery_rank
secure_authOFF 
secure_file_priv 
server_id
shared_memoryOFF 
shared_memory_base_nameMYSQL 
skip_external_lockingON 
skip_networkingOFF 
skip_show_databaseOFF 
slave_compressed_protocolOFF 
slave_exec_modeSTRICT 
slave_load_tmpdirC:\Windows\TEMP 
slave_net_timeout3600 
slave_skip_errors 
slave_transaction_retries10 
slow_launch_time
slow_query_logOFF 
slow_query_log_fileC:\ProgramData\MySQL\MySQL Server 5.1\Data\SPRING-slow.log 
sort_buffer_size262144 
sql_auto_is_nullON 
sql_big_selectsON 
sql_big_tablesOFF 
sql_buffer_resultOFF 
sql_log_binON 
sql_log_offOFF 
sql_log_updateON 
sql_low_priority_updatesOFF 
sql_max_join_size18446744073709551615 
sql_modeSTRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 
sql_notesON 
sql_quote_show_createON 
sql_safe_updatesOFF 
sql_select_limit18446744073709551615 
sql_slave_skip_counter 
sql_warningsOFF 
ssl_ca 
ssl_capath 
ssl_cert 
ssl_cipher 
ssl_key 
storage_engineInnoDB 
sync_binlog
sync_frmON 
system_time_zonePacific Daylight Time 
table_definition_cache256 
table_lock_wait_timeout50 
table_open_cache256 
table_typeInnoDB 
thread_cache_size
thread_handlingone-thread-per-connection 
thread_stack196608 
time_format%H:%i:%s 
time_zoneSYSTEM 
timed_mutexesOFF 
timestamp1316141294 
tmp_table_size18874368 
tmpdirC:\Windows\TEMP 
transaction_alloc_block_size8192 
transaction_prealloc_size4096 
tx_isolationREPEATABLE-READ 
unique_checksON 
updatable_views_with_limitYES 
version5.1.32-community 
version_commentMySQL Community Server (GPL) 
version_compile_machineia32 
version_compile_osWin32 
wait_timeout28800 
warning_count

Storage engines

namesupportedcomment
MEMORYYESHash based, stored in memory, useful for temporary tables
FEDERATEDNOFederated MySQL storage engine
MyISAMYESDefault engine as of MySQL 3.23 with great performance
BLACKHOLEYES/dev/null storage engine (anything you write to it disappears)
MRG_MYISAMYESCollection of identical MyISAM tables
CSVYESCSV storage engine
ARCHIVEYESArchive storage engine
InnoDBDEFAULTSupports transactions, row-level locking, and foreign keys

Code

CREATE DATABASE `sakila` /*!40100 DEFAULT CHARACTER SET latin1 */



Documentation generated by SqlSpec