Illegal websites should not initiate any form of manual service requests to our staff. It is strictly prohibited to use honmau Media's technical support services and products to engage in any illegal activities. If discovered, no technical support will be provided.×
Current location:home> news > help and support

Baota installation MySQL 5.7 prompts that it requires [1560MB] memory mandatory cannot be installed

Many 1G VPS are installedBaotaLater, I wanted to upgrade MYSQL7.0, but Baota refused to upgrade it, so I had to upgrade it using SSH.

20220513152730.png

Enter ssh and execute the following command to force installation:
If you choose to install mysql by compiling and installing it, enter the following script:

wget http://download.bt.cn/install/0/mysql.sh;bash mysql.sh install 5.7

If you choose to install mysql at an extreme speed, enter the following script:

wget http://download.bt.cn/install/1/mysql.sh;bash mysql.sh install 5.7

Note: If you have already installed a database, the above command will uninstall and delete the current database and data

Baota Panel Minimum Memory and Minimum CPU Limit
Mysql 5.6: Minimum memory requirement of 768MB.
Mysql 5.7: The minimum memory requirement is 1560MB.
Mysql 8.0: Minimum memory requirement 3700MB, minimum number of CPUs: 2


Solutions to the minimum memory and minimum CPU limit of Baota Panel
Method 1: Modify the Baota Panel/www/server/panel/class/panel/Plugin.py file
A. Use the Baota Panel's online file editing tool directly to find the file/www/server/panel/class/panelPlugin.py in the file. Find the two codes in lines 137 and 138.

20220513152905.png

If it is a minimum memory limit, comment on the 138 line of code and precede this line with a #.
If it is a minimum CPU limit, comment on the 137 line of code and precede this line with a #.
B. Or use root privileges to connect to the server remotely and edit the/www/server/panel/class/panelPlugin.py file.

vim /www/server/panel/class/panelPlugin.py

Use vim to edit the file. In last line mode, enter set nu to display the line number. Find the two codes in lines 137 and 138.

if not self.check_mem_limit(versionInfo[mem_limit]): return public.returnMsg(False, requires at least [%dMB] memory to install % versionInfo[mem_limit])^M

If it is a minimum memory limit, comment on the code and add a #sign in front of the line of code.

if not self.check_cpu_limit(versionInfo[cpu_limit]): return public.returnMsg(False, you need at least [%d] CPU cores to install % versionInfo[cpu_limit])^M

If it is a CPU limitation, comment on this code and add it in front of this line of codeGo on #.
Saving the exit file will remove the minimum memory and minimum CPU count limits on the Baota Panel.
Note: To restart the panel, select the required mysql version and install it.

Method 2: Modify the pagoda panel file/www/server/panel/date/plugin.json
Find/www/server/panel/date in the Baota Panel file and modify the plugin.json file. search

/www/server/mysql/bin/mysql

20220513152955.png

Modify the corresponding configuration according to the mysql version you want to install. mem_limit is the memory limit and CPU_limit is the CPU limit. Change the corresponding value to a value less than the value of your server, your memory or CPU.

© Website copyright and disclaimer

1.[honmau Media] independently owns the copyright of all materials on relevant pages of this website;

2. No one is allowed to copy it without the express written permission of [honmau Media];

3. The articles that do not indicate "honmau Media" on this website are all from the Internet and are only for everyone to learn and refer;

4. If there is any infringement/violation/irregularity, please contact customer service QQ or email to delete it, please understand;

5.[honmau Media] reserves the right to correct, modify and update this statement at any time.legal notice

Message Board
* Contact customer service for urgent issues
submitted
submission
Working days: 8:30 - 22:00 Online QQ

customer service

Company Introduction
top