troubleshooting Question

MySql Configuration

Avatar of recruitit
recruitit asked on
MySQL Server
1 Comment1 Solution542 ViewsLast Modified:
Our website is currently experiencing a database bottleneck and we are wondering if its our configuration, we have the configuration posted below, we are not experienced in this matter, we tried to copy the configuration as best as possible from our previous website but it was a newer version of mysql, also the mysql workbench is throwing an error saying that...

"Configuration file did not contain section [mysqld], so a new one was added.  If that is not correct, please fix the sesction name in the Server Instance Editor and reopen the administrator."

this is causing an issue since we cant edit our configuration in the MySql Workbench.
[mysqld]

port=3306
basedir=C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL
datadir=C:\\Program Files (x86)\\Parallels\\Plesk\\Databases\\MySQL\\Data
default-character-set=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=400


# properties that are different from previous version, 64M,2M,1520
query_cache_size=1MB
query_cache_limit=128MB


tmp_table_size=64MB
key_buffer_size=256M
read_buffer_size=1M
table_cache=1520
myisam_sort_buffer_size=32M
innodb_additional_mem_pool_size=384M
thread_cache_size=38
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
read_rnd_buffer_size=256K


innodb_flush_log_at_trx_commit=1
innodb_log_file_size=10M
innodb_thread_concurrency=8
sync_binlog=1
ft_min_word_len=2
innodb_log_buffer_size=3M
innodb_buffer_pool_size=218M



old_passwords=1
thread_stack=196608
binlog_cache_size=32768
net_read_timeout=30
net_retry_count=10
net_write_timeout=30
thread_concurrency=10
open_files_limit=0
character-set-server=latin1
sort_buffer_size = 256k
wait_timeout = 360

[client]
port=3306

[mysql]
default-character-set=utf8
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros