Release ED-Intelligent Boardcomputer Extension

Just tried loading this file , but keeping being told 'Error could not update dataBASE TO V0.1.0, can you please help as I have just come back to the game after a year away. Thanks
 
Hi Duke!

I would like to use this app as it looks very promising, however, nothing happens when I try to start the application.

I'm using a Dutch Windows 10 x64 Pro system.
 
...I would like to use this app as it looks very promising, however, nothing happens when I try to start the application....

Can you be a bit more precise ? When does "nothing happen" ? And what did you do until "nothing happen" ?
Was ED-IBE successfully installed (for this see the description in the "StartTipps"-files --> "black window" etc.) ?
 
Last edited:
Great tool, thank you for making this.

I leave the program open overnight and every morning when I start ED, the program crashes, it has happened 4 times already so I'm pretty certain it's a bug. Below is the link to the crash log, dump is around 400MB so if you need it, let me know.

http://pastebin.com/G1KFrwLe
 
I leave the program open overnight and every morning when I start ED, the program crashes, it has happened 4 times already so I'm pretty certain it's a bug.

The log tells me the connection to the database was lost.
Sometimes I also leave the program open overnight but I never got this error.
But my computer never is going to sleep (I switched that off) because my reason
to leave this program open is to collect all the EDDN data.
I suggest you to disable any standby modes on your PC OR simply close the program.
Because if it's in standby nothing will happen at all and so there's no reason to leave the program open (or?)
 
No, my PC does not sleep. Why not catch the exception and reestablish the connection, since you already know what the issue is?
 
I will check this. Maybe there's also a "stay alive" option in the connection settings.
What do you say how often this happens ? 100% or less ?
 
please try this:

Stop ED-IBE (be sure mysqld.exe has stopped too -> check the processes in the task manager)
The put the following lines in the "Elite.ini"-file of the mysql part (section [mysqld]):

wait_timeout=604800
interactive_timeout=604800

This should allow waiting for a week without loosing a connection.
 
Last edited:
in ../Program Files/ED-IBE are only binaries (due to default write protections)
All settings (and the database itself) are located by default in your users directory.
Please look into the StarterTipps files (https://github.com/Duke-Jones/ED-IBE) for more details.
 
Last edited:
Hi, I am getting back into trading. This toold look great! Can I ask what it s the difference betweent his and Trade Computer Extension?
 
Hi, I am getting back into trading. This toold look great! Can I ask what it s the difference betweent his and Trade Computer Extension?

wb :cool:

to be honest: no idea what the benefits of "Trade Computer Extension" are.

ED-IBE offers a local database where you can decide which market data you want to share or not.
Also there's a automatically written log with many different events (more coming) - but of course you also have the chance to insert your own comments or entries.
You can add multiple filters to the route calculation (trading) and also for the the log.
What ED-IBE not does: ED-IBE is no overlay. For best results you should have a second monitor where you can
run your browser, other programs and ED-IBE. Of course you also can use ED-IBE on a single monitor solution
but then you have to "ALT-TAB"ing - but this's not really a problem.

ED-IBE has a bidirectional EDDN interface (sending and recieving) and a interface to send to EDSM.
Also the companion data is directly and automatically collected
(which can be sent to EDDN->EDDB if you want - you can decide to send market data and/or outfitting data and/or shipyard data .... or send nothing)

I suggest to try both programs. But if you try to use ED-IBE read the StarterTips (you can find them here) !!!! There are many
valuable tips and hints for using like filtering, settings, background infos and so on.

fly save .....
 
Last edited:
Made the change you suggested, still crashes.

Code:
05.02.2017 09:44:28 : ED-IBE v0.6.3.0
05.02.2017 09:44:28 : Error while loading displaysettigns from event
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Error while loading display settings
05.02.2017 09:44:28 :    at IBE.GameSettings.LoadDisplaySettings() in E:\dev\RN\ED-IBE\ED-IBE\Elite Dangerous Specifics\GameSettings.cs:line 256
   at IBE.GameSettings.LoadDisplaySettings(Object sender, FileSystemEventArgs e) in E:\dev\RN\ED-IBE\ED-IBE\Elite Dangerous Specifics\GameSettings.cs:line 264
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Error in GetIniValue
05.02.2017 09:44:28 :    at IBE.SQL.DBConnector.getIniValue[T](String Group, String Key, String DefaultValue, Boolean AllowEmptyValue, Boolean RewriteOnBadCast) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 1026
   at IBE.GameSettings.LoadDisplaySettings() in E:\dev\RN\ED-IBE\ED-IBE\Elite Dangerous Specifics\GameSettings.cs:line 204
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Diese Konvertierung wird nicht unterstützt oder der Wert ist Nothing und conversionType ist ein Werttyp (Value-Rewrite done), R
05.02.2017 09:44:28 :    at IBE.SQL.DBConnector.getIniValue[T](String Group, String Key, String DefaultValue, Boolean AllowEmptyValue, Boolean RewriteOnBadCast) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 1016
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Error in GetIniValue
05.02.2017 09:44:28 :    at IBE.SQL.DBConnector.getIniValue(String Group, String Key, String DefaultValue, Boolean AllowEmptyValue) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 1103
   at IBE.SQL.DBConnector.getIniValue[T](String Group, String Key, String DefaultValue, Boolean AllowEmptyValue, Boolean RewriteOnBadCast) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 995
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Error on 'ExecuteReader', SQLString = <select InitValue from tbInitValue where InitGroup = 'Settings' and   InitKey   = 'ProductAppData'>(master)
05.02.2017 09:44:28 :    at IBE.SQL.DBConnector.Execute(String CommandText, DataTable Data) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 442
   at IBE.SQL.DBConnector.getIniValue(String Group, String Key, String DefaultValue, Boolean AllowEmptyValue) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 1062
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Fatal error encountered during command execution.
05.02.2017 09:44:28 :    at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at IBE.SQL.DBConnector.Execute(String CommandText, DataTable Data) in E:\dev\RN\ED-IBE\ED-IBE\SQL\DBConnector.cs:line 435
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : Unable to write data to the transport connection: An established connection was aborted by the software in your host machine.
05.02.2017 09:44:28 :    at MySql.Data.Common.MyNetworkStream.HandleOrRethrowException(Exception e)
   at MySql.Data.Common.MyNetworkStream.Write(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.TimedStream.Write(Byte[] buffer, Int32 offset, Int32 count)
   at MySql.Data.MySqlClient.MySqlStream.SendPacket(MySqlPacket packet)
   at MySql.Data.MySqlClient.NativeDriver.ExecutePacket(MySqlPacket packetToExecute)
   at MySql.Data.MySqlClient.NativeDriver.SendQuery(MySqlPacket queryPacket)
   at MySql.Data.MySqlClient.Driver.SendQuery(MySqlPacket p)
   at MySql.Data.MySqlClient.Statement.ExecuteNext()
   at MySql.Data.MySqlClient.PreparableStatement.Execute()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
--------------------------------------------------------------------------------
05.02.2017 09:44:28 : An established connection was aborted by the software in your host machine
05.02.2017 09:44:28 :    at System.Net.Sockets.Socket.Send(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
   at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)

********************************************************************************
 
Here you go.
Code:
	auto_increment_increment	1
	auto_increment_offset	1
	autocommit	ON
	automatic_sp_privileges	ON
	avoid_temporal_upgrade	OFF
	back_log	80
	basedir	C:\Program Files\ED-IBE\Database\
	big_tables	OFF
	bind_address	*
	binlog_cache_size	32768
	binlog_checksum	CRC32
	binlog_direct_non_transactional_updates	OFF
	binlog_error_action	IGNORE_ERROR
	binlog_format	STATEMENT
	binlog_gtid_simple_recovery	OFF
	binlog_max_flush_queue_time	0
	binlog_order_commits	ON
	binlog_row_image	FULL
	binlog_rows_query_log_events	OFF
	binlog_stmt_cache_size	32768
	binlogging_impossible_mode	IGNORE_ERROR
	block_encryption_mode	aes-128-ecb
	bulk_insert_buffer_size	8388608
	character_set_client	utf8
	character_set_connection	utf8
	character_set_database	utf8
	character_set_filesystem	binary
	character_set_results	
	character_set_server	utf8
	character_set_system	utf8
	character_sets_dir	C:\Program Files\ED-IBE\Database\share\charsets\
	collation_connection	utf8_general_ci
	collation_database	utf8_general_ci
	collation_server	utf8_general_ci
	completion_type	NO_CHAIN
	concurrent_insert	AUTO
	connect_timeout	10
	core_file	OFF
	datadir	C:\Users\xxxx\AppData\Local\ED-IBE\Database\data\
	date_format	%Y-%m-%d
	datetime_format	%Y-%m-%d %H:%i:%s
	default_storage_engine	InnoDB
	default_tmp_storage_engine	InnoDB
	default_week_format	0
	delay_key_write	ON
	delayed_insert_limit	100
	delayed_insert_timeout	300
	delayed_queue_size	1000
	disconnect_on_expired_password	ON
	div_precision_increment	4
	end_markers_in_json	OFF
	enforce_gtid_consistency	OFF
	eq_range_index_dive_limit	10
	error_count	0
	event_scheduler	OFF
	expire_logs_days	0
	explicit_defaults_for_timestamp	ON
	external_user	
	flush	OFF
	flush_time	0
	foreign_key_checks	ON
	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	OFF
	general_log_file	C:\Users\xxxx\AppData\Local\ED-IBE\Database\data\critic.log
	group_concat_max_len	1024
	gtid_executed	
	gtid_mode	OFF
	gtid_next	AUTOMATIC
	gtid_owned	
	gtid_purged	
	have_compress	YES
	have_crypt	NO
	have_dynamic_loading	YES
	have_geometry	YES
	have_openssl	DISABLED
	have_profiling	YES
	have_query_cache	YES
	have_rtree_keys	YES
	have_ssl	DISABLED
	have_symlink	YES
	host_cache_size	279
	hostname	critic
	identity	0
	ignore_builtin_innodb	OFF
	ignore_db_dirs	
	init_connect	
	init_file	
	init_slave	
	innodb_adaptive_flushing	ON
	innodb_adaptive_flushing_lwm	10
	innodb_adaptive_hash_index	ON
	innodb_adaptive_max_sleep_delay	150000
	innodb_additional_mem_pool_size	12582912
	innodb_api_bk_commit_interval	5
	innodb_api_disable_rowlock	OFF
	innodb_api_enable_binlog	OFF
	innodb_api_enable_mdl	OFF
	innodb_api_trx_level	0
	innodb_autoextend_increment	64
	innodb_autoinc_lock_mode	1
	innodb_buffer_pool_dump_at_shutdown	OFF
	innodb_buffer_pool_dump_now	OFF
	innodb_buffer_pool_filename	ib_buffer_pool
	innodb_buffer_pool_instances	8
	innodb_buffer_pool_load_abort	OFF
	innodb_buffer_pool_load_at_startup	OFF
	innodb_buffer_pool_load_now	OFF
	innodb_buffer_pool_size	696254464
	innodb_change_buffer_max_size	25
	innodb_change_buffering	all
	innodb_checksum_algorithm	innodb
	innodb_checksums	ON
	innodb_cmp_per_index_enabled	OFF
	innodb_commit_concurrency	0
	innodb_compression_failure_threshold_pct	5
	innodb_compression_level	6
	innodb_compression_pad_pct_max	50
	innodb_concurrency_tickets	5000
	innodb_data_file_path	ibdata1:12M:autoextend
	innodb_data_home_dir	
	innodb_disable_sort_file_cache	OFF
	innodb_doublewrite	ON
	innodb_fast_shutdown	1
	innodb_file_format	Antelope
	innodb_file_format_check	ON
	innodb_file_format_max	Antelope
	innodb_file_per_table	ON
	innodb_flush_log_at_timeout	1
	innodb_flush_log_at_trx_commit	1
	innodb_flush_method	
	innodb_flush_neighbors	1
	innodb_flushing_avg_loops	30
	innodb_force_load_corrupted	OFF
	innodb_force_recovery	0
	innodb_ft_aux_table	
	innodb_ft_cache_size	8000000
	innodb_ft_enable_diag_print	OFF
	innodb_ft_enable_stopword	ON
	innodb_ft_max_token_size	84
	innodb_ft_min_token_size	3
	innodb_ft_num_word_optimize	2000
	innodb_ft_result_cache_limit	2000000000
	innodb_ft_server_stopword_table	
	innodb_ft_sort_pll_degree	2
	innodb_ft_total_cache_size	640000000
	innodb_ft_user_stopword_table	
	innodb_io_capacity	200
	innodb_io_capacity_max	2000
	innodb_large_prefix	OFF
	innodb_lock_wait_timeout	50
	innodb_locks_unsafe_for_binlog	OFF
	innodb_log_buffer_size	6291456
	innodb_log_compressed_pages	ON
	innodb_log_file_size	50331648
	innodb_log_files_in_group	2
	innodb_log_group_home_dir	.\
	innodb_lru_scan_depth	1024
	innodb_max_dirty_pages_pct	75
	innodb_max_dirty_pages_pct_lwm	0
	innodb_max_purge_lag	0
	innodb_max_purge_lag_delay	0
	innodb_mirrored_log_groups	1
	innodb_monitor_disable	
	innodb_monitor_enable	
	innodb_monitor_reset	
	innodb_monitor_reset_all	
	innodb_old_blocks_pct	37
	innodb_old_blocks_time	1000
	innodb_online_alter_log_max_size	134217728
	innodb_open_files	512
	innodb_optimize_fulltext_only	OFF
	innodb_page_size	16384
	innodb_print_all_deadlocks	OFF
	innodb_purge_batch_size	300
	innodb_purge_threads	1
	innodb_random_read_ahead	OFF
	innodb_read_ahead_threshold	56
	innodb_read_io_threads	4
	innodb_read_only	OFF
	innodb_replication_delay	0
	innodb_rollback_on_timeout	OFF
	innodb_rollback_segments	128
	innodb_sort_buffer_size	1048576
	innodb_spin_wait_delay	6
	innodb_stats_auto_recalc	ON
	innodb_stats_include_delete_marked	OFF
	innodb_stats_method	nulls_equal
	innodb_stats_on_metadata	OFF
	innodb_stats_persistent	ON
	innodb_stats_persistent_sample_pages	20
	innodb_stats_sample_pages	8
	innodb_stats_transient_sample_pages	8
	innodb_status_output	OFF
	innodb_status_output_locks	OFF
	innodb_strict_mode	OFF
	innodb_support_xa	ON
	innodb_sync_array_size	1
	innodb_sync_spin_loops	30
	innodb_table_locks	ON
	innodb_thread_concurrency	8
	innodb_thread_sleep_delay	0
	innodb_tmpdir	
	innodb_undo_directory	.
	innodb_undo_logs	128
	innodb_undo_tablespaces	0
	innodb_use_native_aio	ON
	innodb_use_sys_malloc	ON
	innodb_version	5.6.35
	innodb_write_io_threads	4
	insert_id	0
	interactive_timeout	28800
	join_buffer_size	262144
	keep_files_on_create	OFF
	key_buffer_size	8388608
	key_cache_age_threshold	300
	key_cache_block_size	1024
	key_cache_division_limit	100
	large_files_support	ON
	large_page_size	0
	large_pages	OFF
	last_insert_id	0
	lc_messages	en_US
	lc_messages_dir	C:\Program Files\ED-IBE\Database\share\
	lc_time_names	en_US
	license	GPL
	local_infile	ON
	lock_wait_timeout	31536000
	log_bin	OFF
	log_bin_basename	
	log_bin_index	
	log_bin_trust_function_creators	OFF
	log_bin_use_v1_row_events	OFF
	log_error	C:\Users\xxxx\AppData\Local\ED-IBE\Database\data\critic.err
	log_output	FILE
	log_queries_not_using_indexes	OFF
	log_slave_updates	OFF
	log_slow_admin_statements	OFF
	log_slow_slave_statements	OFF
	log_throttle_queries_not_using_indexes	0
	log_warnings	1
	long_query_time	10.000000
	low_priority_updates	OFF
	lower_case_file_system	ON
	lower_case_table_names	1
	master_info_repository	FILE
	master_verify_checksum	OFF
	max_allowed_packet	1048576
	max_binlog_cache_size	18446744073709547520
	max_binlog_size	1073741824
	max_binlog_stmt_cache_size	18446744073709547520
	max_connect_errors	100
	max_connections	151
	max_delayed_threads	20
	max_digest_length	1024
	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	4294967295
	max_sort_length	1024
	max_sp_recursion_depth	0
	max_tmp_tables	32
	max_user_connections	0
	max_write_lock_count	4294967295
	metadata_locks_cache_size	1024
	metadata_locks_hash_instances	8
	min_examined_row_limit	0
	multi_range_count	256
	myisam_data_pointer_size	6
	myisam_max_sort_file_size	2146435072
	myisam_mmap_size	18446744073709551615
	myisam_recover_options	OFF
	myisam_repair_threads	1
	myisam_sort_buffer_size	67108864
	myisam_stats_method	nulls_unequal
	myisam_use_mmap	OFF
	named_pipe	OFF
	net_buffer_length	16384
	net_read_timeout	30
	net_retry_count	10
	net_write_timeout	60
	new	OFF
	old	OFF
	old_alter_table	OFF
	old_passwords	0
	open_files_limit	7048
	optimizer_prune_level	1
	optimizer_search_depth	62
	optimizer_switch	index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,subquery_materialization_cost_based=on,use_index_extensions=on
	optimizer_trace	enabled=off,one_line=off
	optimizer_trace_features	greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
	optimizer_trace_limit	1
	optimizer_trace_max_mem_size	16384
	optimizer_trace_offset	-1
	performance_schema	ON
	performance_schema_accounts_size	100
	performance_schema_digests_size	5000
	performance_schema_events_stages_history_long_size	1000
	performance_schema_events_stages_history_size	10
	performance_schema_events_statements_history_long_size	1000
	performance_schema_events_statements_history_size	10
	performance_schema_events_waits_history_long_size	1000
	performance_schema_events_waits_history_size	10
	performance_schema_hosts_size	100
	performance_schema_max_cond_classes	80
	performance_schema_max_cond_instances	1440
	performance_schema_max_digest_length	1024
	performance_schema_max_file_classes	50
	performance_schema_max_file_handles	32768
	performance_schema_max_file_instances	6250
	performance_schema_max_mutex_classes	200
	performance_schema_max_mutex_instances	6048
	performance_schema_max_rwlock_classes	40
	performance_schema_max_rwlock_instances	3313
	performance_schema_max_socket_classes	10
	performance_schema_max_socket_instances	230
	performance_schema_max_stage_classes	150
	performance_schema_max_statement_classes	168
	performance_schema_max_table_handles	732
	performance_schema_max_table_instances	729
	performance_schema_max_thread_classes	50
	performance_schema_max_thread_instances	288
	performance_schema_session_connect_attrs_size	512
	performance_schema_setup_actors_size	100
	performance_schema_setup_objects_size	100
	performance_schema_users_size	100
	pid_file	C:\Users\xxxx\AppData\Local\ED-IBE\Database\data\critic.pid
	plugin_dir	C:\Program Files\ED-IBE\Database\lib\plugin\
	port	3306
	preload_buffer_size	32768
	profiling	OFF
	profiling_history_size	15
	protocol_version	10
	proxy_user	
	pseudo_slave_mode	OFF
	pseudo_thread_id	402
	query_alloc_block_size	8192
	query_cache_limit	1048576
	query_cache_min_res_unit	4096
	query_cache_size	33554432
	query_cache_type	OFF
	query_cache_wlock_invalidate	OFF
	query_prealloc_size	8192
	rand_seed1	0
	rand_seed2	0
	range_alloc_block_size	4096
	read_buffer_size	2097152
	read_only	OFF
	read_rnd_buffer_size	8388608
	relay_log	
	relay_log_basename	
	relay_log_index	
	relay_log_info_file	relay-log.info
	relay_log_info_repository	FILE
	relay_log_purge	ON
	relay_log_recovery	OFF
	relay_log_space_limit	0
	report_host	
	report_password	
	report_port	3306
	report_user	
	rpl_stop_slave_timeout	31536000
	secure_auth	ON
	secure_file_priv	
	server_id	1
	server_id_bits	32
	server_uuid	2be71045-e54b-11e6-aa0b-94de80a191ae
	shared_memory	OFF
	shared_memory_base_name	MYSQL
	show_old_temporals	OFF
	simplified_binlog_gtid_recovery	OFF
	skip_external_locking	ON
	skip_name_resolve	ON
	skip_networking	OFF
	skip_show_database	OFF
	slave_allow_batching	OFF
	slave_checkpoint_group	512
	slave_checkpoint_period	300
	slave_compressed_protocol	OFF
	slave_exec_mode	STRICT
	slave_load_tmpdir	C:\Users\xxxx\AppData\Local\Temp
	slave_max_allowed_packet	1073741824
	slave_net_timeout	3600
	slave_parallel_workers	0
	slave_pending_jobs_size_max	16777216
	slave_rows_search_algorithms	TABLE_SCAN,INDEX_SCAN
	slave_skip_errors	OFF
	slave_sql_verify_checksum	ON
	slave_transaction_retries	10
	slave_type_conversions	
	slow_launch_time	2
	slow_query_log	OFF
	slow_query_log_file	C:\Users\xxxx\AppData\Local\ED-IBE\Database\data\critic-slow.log
	socket	MySQL
	sort_buffer_size	2097152
	sql_auto_is_null	OFF
	sql_big_selects	ON
	sql_buffer_result	OFF
	sql_log_bin	ON
	sql_log_off	OFF
	sql_mode	NO_ENGINE_SUBSTITUTION
	sql_notes	ON
	sql_quote_show_create	ON
	sql_safe_updates	OFF
	sql_select_limit	18446744073709551615
	sql_slave_skip_counter	0
	sql_warnings	OFF
	ssl_ca	
	ssl_capath	
	ssl_cert	
	ssl_cipher	
	ssl_crl	
	ssl_crlpath	
	ssl_key	
	storage_engine	InnoDB
	stored_program_cache	256
	sync_binlog	0
	sync_frm	ON
	sync_master_info	10000
	sync_relay_log	10000
	sync_relay_log_info	10000
	system_time_zone	South Africa Standard Time
	table_definition_cache	656
	table_open_cache	512
	table_open_cache_instances	1
	thread_cache_size	8
	thread_concurrency	10
	thread_handling	one-thread-per-connection
	thread_stack	262144
	time_format	%H:%i:%s
	time_zone	SYSTEM
	timed_mutexes	OFF
	timestamp	1486296295.158602
	tmp_table_size	16777216
	tmpdir	C:\Users\xxxx\AppData\Local\Temp
	transaction_alloc_block_size	8192
	transaction_allow_batching	OFF
	transaction_prealloc_size	4096
	tx_isolation	REPEATABLE-READ
	tx_read_only	OFF
	unique_checks	ON
	updatable_views_with_limit	YES
	version	5.6.35
	version_comment	MySQL Community Server (GPL)
	version_compile_machine	x86_64
	version_compile_os	Win64
	wait_timeout	28800
	warning_count	0

And here is the elite.ini (I set the timeouts to 48hr)
Code:
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
#innodb_buffer_pool_size = 256M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir ="C:/Program Files/ED-IBE/Database/"
datadir ="C:/Users/xxxx/AppData/Local/ED-IBE/Database/data/"
port = 3306
server_id = 1


# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M

sql_mode = NO_ENGINE_SUBSTITUTION
collation-server = utf8_general_ci
character-set-server = utf8
explicit_defaults_for_timestamp
lc-messages-dir ="C:/Program Files/ED-IBE/Database/share"
lc-messages = en_US
skip-name-resolve

#####################################

max_allowed_packet = 1M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 32M
wait_timeout=172800
interactive_timeout=172800

default-storage-engine=InnoDB

innodb_additional_mem_pool_size=12M
innodb_log_buffer_size=6M
innodb_buffer_pool_size=664M
innodb_thread_concurrency=8

#innodb_flush_log_at_trx_commit = 0   <-- change it only from RN if really needed
#innodb_flush_method = O_DIRECT       <-- only working on some unix systems


#general_log_file = host_name.log
log-error =

secure_file_priv=""
 
Last edited:
Back
Top Bottom