MySQL

MySQL

CPU Wait issue caused somehow probably by MySQL and possibly related to max_allowed_packet issue

Submitted by dhakimzadeh on March 4, 2010 - 9:45am

cpu wait is ridiculously high with nothing but mysql running (with the server actually serving, it was 90+% consistently).

top - 05:52:29 up 3 min, 1 user, load average: 0.84, 0.53, 0.22
Tasks: 69 total, 1 running, 68 sleeping, 0 stopped, 0 zombie
Cpu(s): 4.4%us, 1.1%sy, 0.0%ni, 47.8%id, 46.5%wa, 0.2%hi, 0.0%si, 0.0%st
Mem: 1035172k total, 1019344k used, 15828k free, 78404k buffers
Swap: 2650684k total, 552k used, 2650132k free, 712048k cached

Add new comment

MySQL Tuner

Submitted by dhakimzadeh on March 4, 2010 - 9:00am

Link Title and URL:

MySQL Tuner

MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.

Add new comment

Bash script to create MySQL database and user

Submitted by Benjamin Melançon on August 30, 2009 - 7:52pm

Link Title and URL:

Bash script to create MySQL database and user

command line mysql create database
mysql create database bash script

See also:

#!/bin/bash # Create new MySQL database.

# Environment-configurable variables
MYSQLUSER=root
MYSQLPASS=toor

if [ $# -lt 1 ]
then
echo "USAGE: $0 projectname";
echo " New MySQL database requires one argument (the name of the project to create a development database for)."
return
fi

User login

CPU Wait issue caused somehow probably by MySQL and possibly related to max_allowed_packet issue

MySQL Tuner

Bash script to create MySQL database and user

Search

Agaric?

Agaric Design Collective

Copyright