Questions tagged [my.ini]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
92 views

Is There a Workaround to Reduce MySQL Table size?

Long story short. I have a MySQL database that has only one table and is around 50GB, while my drive storage is almost full and cannot get reduced. So the only way is to reduce the size of the 50GB ...
Chris921's user avatar
0 votes
4 answers
2k views

Performance issues after upgrading from MySQL 5.7 to MySQL 8.0

Recently I upgraded MySQL on my server from newest 5.7.x to newest 8.0.x and I imported my entire database with multi-indexes that I created when I was using MySQL 5.7.x. These indexes optimize SELECT ...
Programming Caveman's user avatar
0 votes
1 answer
1k views

MariaDB not starting in windows 10 after crash

MariaDB 10.7 service suddenly stopped in Windows 10 after a crash and the service is not starting. The pop up shows 'windows cannot start mariadb service). The windows event viewer gives the following ...
sariDon's user avatar
  • 111
1 vote
1 answer
4k views

Mysql Workbench 8 doesn't detect the my.ini file for my MySql 5.7 server. How can I point it to the correct file? [duplicate]

I upgraded MySql workbench to version 8. I'm running MySql Server 5.7. When I open the options file in workbench it says it cannot locate a file for MySql 8 and that it will create one in the path C:\...
mal's user avatar
  • 181
2 votes
1 answer
9k views

How to properly configure my.ini for MySQL? [closed]

I've just installed on my new server MySQL 5.0.24 64bit (till now i've used same version of MySQL but 32bit on another server), on the old server i've changed in my.ini the parameters of ...
Igor Mytyuk's user avatar
0 votes
1 answer
181 views

How to change MySQL 8.0 data folder. Can I use OneDrive folders?

I'm trying to create a DataBase for a very little program that just I and 2 more friends use, so the database will be little. What I want to do is to share this database with these 2 friends, so I ...
Gerard Ramon's user avatar
-1 votes
1 answer
411 views

Cannot find innodb_page_size option in [mysqld] section in my.ini file

Where can I find innodb_page_size option? Since I cannot find it in [mysqld] section in my.ini file. I want to change it to 32k or 64k since I am getting the below error: MySQL: Error Code: 1118 ...
pytorch's user avatar
0 votes
1 answer
205 views

innodb_page_size is not present in [mysqld] section in my.ini file in MySQL Server 8.0?

I have to edit the innodb_page_size to 32K but I cannot find innodb_page_size in [mysqld] section in my.ini file. I am using MySQL Server 8.0.13. Where can I find it?
Pytorch's user avatar
-1 votes
1 answer
68 views

MySQL: I would like to export the "description" of the MySQL Server variables to a csv [closed]

I need a CSV with all the MySQL Server Variables and a basic description of what the variable means. Like you can find here: http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html I know ...
homefreelancer's user avatar
0 votes
1 answer
2k views

Not Able to Increase InnoDB Buffer Pool Size in Mysql

I am facing a very rare problem with my DB. I have Windows Server with 64 GB RAM but I am not able to increase innodb buffer pool size in mysql. Current InnoDb buffer pool Size : 1.6G When I ...
Mahesh Vema's user avatar
5 votes
1 answer
24k views

How can I check the path of my.ini, through the command line?

I would like to know, if possible, how to display (using the command line) the path to my.ini used by the server. I am using MySQL 5.6 inside a windows IIS. I have the following: Program Files\...
IgorAlves's user avatar
  • 327
1 vote
1 answer
2k views

`lc_time_names` has no effect

I have a Windows MySQL server running (5.6), and in the my.ini file I have the following directive under [mysqld]: lc_time_names = 'fr_FR'; But it has ZERO effect. When I start up the server, all ...
Stephen's user avatar
  • 111