Lock database
==============
FLUSH TABLES WITH READ LOCK;
lock all the tables of a single database or to lock a particular table
lock tables db.* read;
UNLOCK TABLES;
FLUSH TABLES WITH READ LOCK; do not quit the mysql shell else you will lose the lock
LOCK TABLES t1 WRITE, t2 READ;
LOCK TABLES explicitly acquires table locks for the current client session. Table locks can be acquired for base tables or (as of MySQL 5.0.6) views. You must have the LOCK TABLES privilege, and the SELECT privilege for …
mysqladmin is a client for performing administrative operations. You
can use it to check the server’s configuration and current status,
create and drop databases, and more.
Invoke mysqladmin like this:
shell> mysqladmin [options] command [command-options] [command [command-options]] …
mysqladmin supports the following commands:
· create db_name
Create a new database named db_name.
· debug
Tell the server to write debug information to the error log.
· drop db_name
Delete the database named db_name and all its tables.
· extended-status
Display the server status variables and their values.
· flush-hosts
Flush …
If you are running 4 servers assuming you are using Dual Xeon processors ( classed as 4 cpu’s in linux)
Server 1 uses 60% CPU Usage
Server 2 Uses 60% CPU Usage
Server 3 Uses 20% CPU Usage
Server 4 Uses 20% CPU Usage
Rather than letting the distro automtically assign CPU’s it is sometimes better for you to do it manually. In this instance it would make server to have
Server 1 using CPU0
Server 2 using CPU1
Server 3 + 4 using CPU2
Leaving you with a …
