How should I config the my.ini file for mysql?

Posted Jan 01, 1970 12:00 AM

Thanks for taking your time to look at my question, and I hope that you can help me with this.

I have a Windows Server 2012 server, it has:

Memory : 3840MB Ram

Processor: Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz (2 CPUs), ~2.8GHz

But still mysql is going up to 100% cpu usage I ran the MySQLInstanceConfig.exe configuration Wizard to help me config everything for mysql and this is the my.ini config file that it created:

[client]

port=3306

[mysql]

default-character-set=latin1

[mysqld]

The TCP/IP Port the MySQL Server will listen on

port=3306

basedir="C:/Program Files/MySQL/MySQL Server 5.5/"

datadir="C:/ProgramData/MySQL/MySQL Server 5.5/data/"

character-set-server=latin1

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=100

query_cache_size=0

table_cache=256

tmp_table_size=192M

thread_cache_size=8

myisam_max_sort_file_size=100G

myisam_sort_buffer_size=384M

key_buffer_size=332M

read_buffer_size=64K read_rnd_buffer_size=256K

sort_buffer_size=256K

* INNODB Specific options *

innodb_additional_mem_pool_size=14M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=7M

innodb_buffer_pool_size=643M

innodb_log_file_size=65M

innodb_thread_concurrency=8

But Something is still wrong, it's taking to much CPU

Tagged mysql file time

Similar Topic Questions

How should I config the my.ini file for mysql?

Thanks for taking your time to look at my question, and I hope that you can help me with this. I have a Windows Server 2012 server, it has: Memory : 3840MB Ram Processor: Intel(R) Xeon(R) CPU E5-2680 v2 @ 2.80GHz (2 CPUs),...

Posted Mar 22, 2014 9:00 AM

How to get nested value from option that are in config.ini file using python

I'm newbie to python and was wondering how to iterate over the following option key1 within section1 below and print comma separated values. here is the ini file [section1] key1 = value1, value2, value3 key2 = value4, value5, value6 expected output, value1 value2 I'm using...

Posted Nov 21, 2013 5:17 AM

Is there a way to Indent between Name & values while generating a INI file using Config Parser?

Below is the INI file i am generating using the ConfigParser [Global] no_of_games = superconf = I am trying to generate an INI file with the "=" alligned uniformly as below , how could i achieve this , is there a way in the...

Posted Dec 27, 2013 8:36 AM

Main php.ini file for phpmyadmin in Centos 6.4 with ISP Config 3

Hi I'm trying to upload a backup database via phpmyadmin. But the max upload size is 2mb. I changed php.ini file and restarted the apache but it does not work. the ini file that I changed is in /etc/php.ini this does...

Posted Jan 07, 2014 5:55 AM

Geting all the database configurations from a config.ini file using Zend_Config_Ini

I'm new with Zend Framework, and I'm using the version 1.12. So I've a databases.ini file where I put all the databases configurations, like: [mysql-xpts] mysql.adapter = pdo_mysql mysql.params.host = 192.168.1.1 [mysql-so: mysql-xpts] mysql.params.dbname = so mysql.params.username = ***** mysql.params.password = **** [mysql-db: mysql-xpts] mysql.params.dbname = db mysql.params.username = ***** mysql.params.password...

Posted Feb 19, 2014 5:58 AM

How to write a config.ini file for Java Database Data?

So I've written a java Applet (GUI) to add, edit and delete data from a specific database,table. the java db_connection file works perfectly fine. Everything does what it has to do. But my problem is, that this assignment specifically asks the...

Posted Aug 12, 2014 6:19 AM

Setting my.ini file

What would be the best settings for Windows 7 64bit, 16GB memory, Mysql 5.6. Here is the current one. How can I improve this? MySQL Server Instance Configuration File pipe socket=mysql port= [mysql] default-character-set=utf8 SERVER SECTION ---------------------------------------------------------------------- The following options will be read by...

Posted Nov 11, 2013 5:54 AM

Can not read from INI file VS10

I have an application project works with ini file. File name is "config.ini" and it is in the application folder. It looks like this: [Config] Key1=Value1 Key2=Value2 ... I set its properties as below. Build action: None Copy to output directory: Copy always This is class that...

Posted Nov 27, 2013 4:58 AM

MAMP unable to update php.ini file

I'm having great trouble including an extension within MAMP. No matter which php.ini files I edit following a MAMP restart they have no affect? the phpinfo tells me it is using these: Configuration File (php.ini) Path /Applications/MAMP/bin/php/php5.4.10/conf Loaded Configuration File ...

Posted Nov 27, 2013 3:49 AM

Xampp error "something wrong with installation " whenever I change php.ini file on ubuntu

I don't get whats wrong with xampp. the localhost works fine if php.ini file is not changed. But when I change php.ini file and enable any extension which is uncommented then xampp suddenly stops working and start downloading...

Posted Dec 03, 2013 1:21 AM

Create ini file

I wounder how to make .ini file in Java. I know how to make .txt file, but how to make .ini file I don't. For reading and wrting I use ini4j lib and I thnik it works good. First I...

Posted Dec 09, 2013 2:47 AM

How to use multiple php.ini files for the same script

Basically, I need to override a critical value in php.ini. The behavior of the command line PHP is to use the first php.ini it detects and no others. I cannot change the 'global' php.ini because this value override is only...

Posted Dec 14, 2013 4:27 AM

Why are there many php.ini files in a system?

I just want to know why both Apache httpd and php environment need a php.ini file. Does modifying one of them require updating the other? If someone can recommend a specific book, article or tutorial to help me understand this, that...

Posted Apr 21, 2012 10:30 AM

How can i access to ini file with jquery?

I want to change value of an object which defined in the ini file.All of my ini file this is; var global_page_data = { "records_per_page2" : 22, ...

Posted Dec 19, 2013 8:25 AM

PHP ini file Setup Linux

I've recently upgraded to a dedicated server; previously I was on a shared server, so I have no experience with the php.ini file. I've opened it and looked through it, searched Google and SO but nothing is clear to me. Can...

Posted Dec 24, 2013 3:22 AM

Config Apache on Windows (or config Windows) to serve files in other dirs, ignoring permissions

I have Apache 2.2 installed on my Windows laptop just for experiments and tutorials. It's installed in "Program Files". I'm occasionally annoyed by permission problems with the files I'm trying to have it access. I often work around this...

Posted Dec 28, 2013 1:37 AM

My PHP.ini file is gone; how can I restore it?

I was wondering, is there any way to load the php.ini file from memory? From my understanding the php.ini is only loaded during start, so theoretically I should be able to load it somehow from memory? Since something pretty strange happened,...

Posted Dec 29, 2013 4:48 AM

Reading a ini file in python using configparser

I need to read an INI file in Python and the file format is as below: [app:main] use = egg:ePRO pyramid.reload_templates = true pyramid.debug_authorization = false pyramid.debug_notfound = true pyramid.debug_routematch = true pyramid.debug_templates = true sqlalchemy.url = postgres://scott:tiger@localhost:5432/db I'm using the ConfigParse module to read the file but unable...

Posted Jan 03, 2014 12:48 PM

Curious as to why system said it was loading php.ini file from different directory

I was wondering why my system says it is running the php from the /etc/php5/apache2/php.ini directory when in fact it was running it from the /etc/php5/cli/php.ini . When I did a phpinfo() on a file in the directory of the folder,...

Posted Jan 06, 2014 3:52 AM

 
 
Email:

Username:

Password:


Register

Username:

Password:

Login


Forgot Password
Reset my password!