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:






The TCP/IP Port the MySQL Server will listen on


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

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












read_buffer_size=64K read_rnd_buffer_size=256K


* INNODB Specific options *







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-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

Appending the -Xss64m flag in the config.ini file doesn't work

I need to change the default Stack size of my Java projects in Eclipse in order not to do it manually by appending the -XssNUMm (e.g. -Xss64m) flag to the VM in every project I create, which can be many...

Posted Dec 20, 2014 7:36 AM

How to use an external config .ini file in VB .Net?

I have program in VB.Net that uses Winsock. I want to make an external config in .ini file. The program works when I'm running it, but when I want to lister the port I get an error. Here is the function...

Posted Apr 23, 2015 11:14 AM

Is there an open source, web-based config editor for editing valid php-style ini file?

Cpanel has some cool config editors that grab an .ini file, stick it all in a web spits out in plain text all comments, then offers an inline text input for valid a user can change configs through...

Posted Mar 24, 2011 10:30 AM

Config.ini file properties being replaced by another file properties in OSGI Run Time

I have an option in my config.ini file to set proxy settings in my OSGI application, eg: http:proxyHost= 192.168...... However, when I set them, out of nowhere in "" file they are overridden, eg: proxyData/http/host=something else ... I am wondering whether somehow eclipse thinks...

Posted Jul 20, 2015 11:49 AM

How to set class path in Config.ini file of a eclispe RCP product using -vm argument in linux

In my eclipse RCP product, I am bundling my JRE and am point to it by -vm argument in config.ini file. JRE is loading properly and it is working fine for me in windows. I need to do the same...

Posted Aug 12, 2015 7:07 AM

Parse a config.ini file into a php class using parse_ini_file()

I'm tryng to create a Database class for my project, in it i want to use the function parse_ini_file() to build my database variables and use them in the class. This is my class : <?php /** * ...

Posted Oct 05, 2015 3:22 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








Forgot Password
Reset my password!