New answers tagged

2

It is possible using cgroups. Some tutorials are available as well as shell script for Ubuntu 14.04. See also Is there any option to limit mongodb memory usage? on Stack Overflow.


1

The problems got removed, when i swapped the my.cnf file, with a highly simplified version of it, which was earlier present in a machine, having MySQL 5.6. So possibly the issue was with my.cnf file. # For advice on how to change settings please see # http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html [mysqld] init-connect='SET ...


0

I tried creating /tmp which was not existing as a separate file system and kept 4gb of space. But the issue did not get resolved. I try to keep my temporary file in a different place where the space available around 20gb. Still issue did not get resolved. Finally I had to run the below command which resolved the issue. I couldn't find the solution so ...


2

Such a tool would be almost completely worthless in practical use. max_connections has nothing to do with performance. It's a safety mechanism to prevent a runaway application from making so many connections that the server becomes overwhelmed. The value makes absolutely no difference unless you are using that many connections. It is also a value that ...


-2

I have been using mysqltuner.pl from mysqltuner.com for years. It's not automatic, it analyses and makes recommendations. Good for part time dba's like me.


0

Im not sure about a script but you can build your own based on MySQL recommendations and good practices shared by experts here: InnoDB Buffer Pool Hit Rate How much memory do I need for innodb buffer pool? Optimal Number of MySQL InnoDB Buffer Pool Instances Making sense of INNODB buffer pool stats How to clear/flush mysql innodb buffer pool? MySQL ...


0

INS-30131: Initial setup required for execution of installer validation failed Cause: "Failed to access the temporary location". This error occurs when you lack of space on /tmp directory. You should allocate space on /tmp according to the Installation Guide Also review this Oracle Support Document Doc ID 2092409.1


1

No, you do not want to go there. Why ? The mysqld_safe script is responsible for creating and destroying the PID file You can see it when you grep for it $ MYSQLD_SAFE_SCRIPT=`which mysqld_safe` $ grep -n pid_file < ${MYSQLD_SAFE_SCRIPT} 26:pid_file= 198: --pid-file=*) pid_file="$val" ;; 638:if test -z "$pid_file" 640: ...


0

A nagiosxi specific method that worked for me was running their repair_databases.sh script found in /usr/local/nagiosxi/scripts/. Make sure you run it as root.


0

You might want to look at the following links: https://bugs.mysql.com/bug.php?id=79272 https://www.percona.com/forums/questions-discussions/mysql-and-percona-server/43922-fatal-error-trying-to-sync-percona-5-7-slave-to-mysql-5-5-master Seems like you need to upgrade to 5.6 prior to replicating to 5.7 from 5.5. Too bad, the documentation is so cryptic " ...


0

The following is the excerpt of runInstaller.sh file # Abort the install, if install/.oui file is not found in the stage area # if [ ! -f $CMDDIR/install/.oui ] then echo "Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives." exit 1 fi # Which clearly states that if you have missed the .oui ...


1

Use the below steps to reset the password: $ sudo systemctl start mysqld Reset the MySQL server root password. $sudo grep 'temporary password' /var/log/mysqld.log Output something like: 10.744785Z 1 [Note] A temporary password is generated for root@localhost: o!5y,oJGALQa Use the above password during reset mysql_secure_installation process. $ sudo ...


1

You have to ask yourself the question "How much is my data worth to me/the company?". Cheap solution: You could buy 2 2TB disks to replace the 2 1TB ones you already have. That would be a stop gap IMHO. RAID0 really doesn't cut the mustard these days with bit-rot and 24x7 operation. If one of your disks goes down, you'll place a lot of extra strain on the ...


0

I would go for option increase RAID desks since\if you are using one instance. since RIAD size id dynamic, can be increased any time you want, and you don't have to do any splitting. your options are" add another RAID 0 ==> means you added another drive that will not be best solution for you. that will be nice if you are using more than one DB instance. ...


0

May be you need monitoring system like Zabbix or Nagios or something else. Where you can stat some data of your system and DB than get reports.


0

I have made a script that digs through the error log to find the shutdown and startup times for a MySQL server: ###################### ##BY: Michael ## ##Created: 4-1-2016 ## ##Version: 1.01 ## ###################### ##################### ######Variables###### ############################################################# #LogFile is where the ...



Top 50 recent answers are included