Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [my.ini]

12 questions
5
votes
1 answer

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\MySQL\MySQL Server…
IgorAlves
  • 337
  • 3
  • 5
  • 16
2
votes
1 answer

How to properly configure my.ini for MySQL?

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 key_buffer_size, innodb_buffer_pool_size and some options for…
Igor Mytyuk
  • 129
  • 1
  • 1
  • 7
1
vote
1 answer

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?

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:\ProgramData\MySql\MySql Server 8\my.ini I do not…
mal
  • 181
  • 1
  • 7
1
vote
1 answer

`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 time names are still in English. If I then launch…
Stephen
  • 111
  • 1
  • 3
0
votes
1 answer

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 MySQL data table (the app I use is MySQL…
Chris921
  • 1
  • 1
0
votes
4 answers

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 queries that run with WHERE clause on few…
Programming Caveman
  • 31
  • 1
  • 2
  • 5
0
votes
1 answer

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 data: InnoDB: Your database may be corrupt or…
sariDon
  • 121
  • 4
0
votes
1 answer

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 thought about storing the data in a OneDrive shared…
Gerard Ramon
  • 11
  • 2
0
votes
1 answer

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
  • 1
0
votes
1 answer

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 increase it and restart Mysql then it throws Error…
Mahesh Vema
  • 3
  • 3
-1
votes
1 answer

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 Row size too large (> 8126). Changing some columns to…
pytorch
  • 1
  • 1
-1
votes
1 answer

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

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 how to get the Server Variables + values, but I…
homefreelancer
  • 1
  • 3