MySQL Forums - Database Administration

backing up mulitple databases (no replies)

Charles White — Thu, 19 Nov 2009 22:39:21 +0000

I am trying to back up a set of 6 databases (all Innodb) that have some dependencies on each other. I want to take a backup of all 6 using mysqldump commands and I want to make sure that the databases are consistent with each other. All databases are replicated to a second server that we have for failover.

I know that there are various switches in mysqldump such as single-transaction that would possibly allow me to get the dumps, if I can dump all databases in a single command. However, because one of the databases contains several GB of data that I don't want to back up, I use various where clauses and multiple mysqldump commands to eliminate the extra data.

I have a couple of approaches that I think will work, but am not sure if they will do what I want. Because I have a readily available replicant I am going to do the backups on that server.

Approach 1:
Stop slave;
flush logs;
mysqldump db 1;
mysqldump db 2;
...
mysqldump db 6;
start slave;

Approach 2:
flush tables with read lock;
mysqldump db 1;
mysqldump db 2;
...
mysqldump db 6;
unlock tables;

I don't know if either method accomplishes what I want. Approach #1 has the downside of causing our monitoring software to squawk that replication is down. Not a bad thing, unless you happen to be the person on-call.

Any guidance would be appreciated.

How to troubleshoot thread concurrency issues? (no replies)

BOoyah Child — Tue, 17 Nov 2009 23:50:16 +0000

(sorry to cross-post, didn't get any replies in 'Newbie')

I have a script that loops over a list of approx 250 rows from a table 'Product' and updates a single field in each row with a value retrieved from an external web service. At the end of each iteration, the Product row is 'saved', which fires an SQL UPDATE command.

While the script is running, other pages on the site that READ from the same table are 'stuck' on loading until the script process has complete updating all the rows.

My question is: what can I do to find out why the table is not allowing other processes to READ?

I am working with a website that uses a PHP Framework called Yii (www.yiiframework.com). This framework uses ADODB so I don't have complete control over the SQL statements being executed, but I can profile them.

I don't know much about engine types and locking, but if it helps all the tables are MyIsam, and I've also tried changing them all to InnoDB but the same problem occurs.

Thanks in advance for any help. Happy to provide more information about the server environment if this will help.

--- my.cnf -----

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

# Performance additions
skip-locking
max_connections=1500
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size= 16M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"

------ SQL Profiling output ----- (the queries that are 'locking' the table')

Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `Product`) 1 0.06349 0.06349 0.06349 0.06349

system.db.CDbCommand.execute(UPDATE `Product` SET `id`=:yp0, `productId`=:yp1, `name`=:yp2, `seoTitle`=:yp3, `ratingId`=:yp4, `checkIn`=:yp5, `checkOut`=:yp6, `address`=:yp7, `country`=:yp8, `regionId`=:yp9, `subRegionId`=:yp10, `latitude`=:yp11, `longitude`=:yp12, `description`=:yp13, `facilities`=:yp14, `image`=:yp15, `videoTour`=:yp16, `ratesTable`=:yp17, `rate`=:yp18, `createTime`=:yp19, `updateTime`=:yp20 WHERE `Product`.`id`=235) 1 0.01820 0.01820 0.01820 0.01820

system.db.CDbCommand.query(SHOW COLUMNS FROM `Product`) 1 0.00803 0.00803 0.00803 0.00803

system.db.CDbCommand.execute(UPDATE `Product` SET `id`=:yp0, `productId`=:yp1, `name`=:yp2, `seoTitle`=:yp3, `ratingId`=:yp4, `checkIn`=:yp5, `checkOut`=:yp6, `address`=:yp7, `country`=:yp8, `regionId`=:yp9, `subRegionId`=:yp10, `latitude`=:yp11, `longitude`=:yp12, `description`=:yp13, `facilities`=:yp14, `image`=:yp15, `videoTour`=:yp16, `ratesTable`=:yp17, `rate`=:yp18, `createTime`=:yp19, `updateTime`=:yp20 WHERE `Product`.`id`=258) 1 0.00633 0.00633 0.00633 0.00633

system.db.CDbCommand.execute(UPDATE `Product` SET `id`=:yp0, `productId`=:yp1, `name`=:yp2, `seoTitle`=:yp3, `ratingId`=:yp4, `checkIn`=:yp5, `checkOut`=:yp6, `address`=:yp7, `country`=:yp8, `regionId`=:yp9, `subRegionId`=:yp10, `latitude`=:yp11, `longitude`=:yp12, `description`=:yp13, `facilities`=:yp14, `image`=:yp15, `videoTour`=:yp16, `ratesTable`=:yp17, `rate`=:yp18, `createTime`=:yp19, `updateTime`=:yp20 WHERE `Product`.`id`=223) 1 0.00583 0.00583 0.00583 0.00583

system.db.CDbCommand.execute(UPDATE `Product` SET `id`=:yp0, `productId`=:yp1, `name`=:yp2, `seoTitle`=:yp3, `ratingId`=:yp4, `checkIn`=:yp5, `checkOut`=:yp6, `address`=:yp7, `country`=:yp8, `regionId`=:yp9, `subRegionId`=:yp10, `latitude`=:yp11, `longitude`=:yp12, `description`=:yp13, `facilities`=:yp14, `image`=:yp15, `videoTour`=:yp16, `ratesTable`=:yp17, `rate`=:yp18, `createTime`=:yp19, `updateTime`=:yp20 WHERE `Product`.`id`=242) 1 0.00572 0.00572 0.00572 0.00572

..... etc. for around 250 rows.

MySQL Configuration Wizard (9 replies)

Arvind Sastry — Wed, 18 Nov 2009 06:24:30 +0000

I'm trying to install mysql 5.1 in windows 7... Its going upto configuration wizard and then its giving

security settings could not be applied.
Error Number 1045.
Access denied for user 'root@localhost' (using password: YES)

Am unable to solve this problem.. Please give a solution for this..

Waiting for your resposne..
Thanks..

Logging MySQL Client Session Warnings (1 reply)

Bob Ingraham — Mon, 16 Nov 2009 08:46:08 +0000

Hello,

Is there a way to log client session warnings on the server side?

I'm talking about things that are warnings on insert/update/delete, etc.

Thanks,
Bob

Using the general log (1 reply)

Mosheh Wolfish — Sat, 14 Nov 2009 08:45:17 +0000

First off, I am a real neophyte to the world of MySQL.
A 3rd party SW vendor has asked me to "prove" that the failing query that I submit through their Pass-Through mechanism, runs just fine (thank you) in the MySQL browser. They want me to send them the log of the query showing a successful run.
I know that I need to use the general log, but I don't know how and where. Can I do this through the browser window? Do I need to log onto the server itself? Through a command window? Etc.
All guidance is appreciated. Thanks

Schema for index creation (no replies)

Lou Vuono — Fri, 13 Nov 2009 15:46:21 +0000

I am trying to create an index on a table specifying a schema name for the index (CREATE INDEX s.indexname ON TABLE r.tablename... ), using MySQL 5.1 which fails with invalid syntax.

My question is, can a schema name be specified for an index? The INFORMATION_SCHEMA.STATISTICS view has a column for index schema, yet it seems it can not be specified on the create index statement. Or does the schema always match the table schema?

Thanks,
Lou

URGENT HELP...on Timeout Exceeded. (1 reply)

sreedhar chava — Wed, 11 Nov 2009 22:00:00 +0000

here is the below info i got when i executed "SHOW ENGINE INNODB STATUS;"
any idea what to look at and how to solve this issue.

---TRANSACTION 0 968269613, ACTIVE 42 sec, process no 29276, OS thread id 2947189616 inserting
mysql tables in use 1, locked 1
LOCK WAIT 4 lock struct(s), heap size 320, 2 row lock(s), undo log entries 1
MySQL thread id 389, query id 45352 192.168.10.210 HTN update
INSERT INTO HTN_SESSION_LOG (
Session_Invoked_At,
Vendor_Emp_Id,
Unique_Id,
Created_By,
Created_Date,
Session_Active
)
VALUES (
Now(),

------- TRX HAS BEEN WAITING 42 SEC FOR THIS LOCK TO BE GRANTED:
RECORD LOCKS space id 0 page no 14676 n bits 296 index `RefHTN_EMPLOYEES139` of table `HTN`.`HTN_SESSION_LOG` trx id 0 968269613 lock_mode X locks gap before rec insert intention waiting
Record lock, heap no 210 PHYSICAL RECORD: n_fields 2; compact format; info bits 0

How to get bare database list??? (2 replies)

Don Muller — Thu, 12 Nov 2009 17:35:42 +0000

HI,

I need to get a list of databases for use in a bash script. I know how to get a list of the databases but everything I've tried creates the list in the following manner.

+--------------------+
| Databases |
+--------------------+
| information_schema |
| database1 |
| mysql |
| database2 |
| database3 |
| database4 |
+--------------------+

Above display slightly off because of forum formatting.

What I would like to get is a list in a bare format without all of the formatting like the following:

information_schema
database1
mysql
database2
database3
database4

How do I get MySQL to produce this??

Thanks
Don

Executing shell command from MySQL prompt (5 replies)

Hasini G — Fri, 13 Nov 2009 12:08:48 +0000

Hi,

How to execute a shell command from MySQL prompt in MySQL Version 5.1.
In MySQL Version 5.0 we used to execute in below format.

mysql> \! ls

How to do this in MySQL Version 5.1.34.

Thanks,
Hasini.

Move MySQL database directory (1 reply)

Jari Kanerva — Tue, 10 Nov 2009 09:37:27 +0000

I have tried to move my MySQL database directory. I have followed these
http://forums.mysql.com/read.php?35,107018,107595#msg-107595
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive

I have changed the database directory in /etc/mysql/my.cnf and /etc/apparmor.d/usr.sbin.mysqld

But MySQL won't start. The error log is empty.

Are there anything missing on those pages? Or how can I make MySQL write something to the error log?

how to parse transactions on 'mysql' sys database from binlogs (1 reply)

Ravi Thati — Tue, 17 Nov 2009 10:57:27 +0000

Hello Everyone,

I am trying to collect the list of events which happened on 'mysql' database like user modifications, privilege changes,etc.

here is what i tried:
1. add new users
2. add new permissions to these users.

I can see the events from querying 'show binlog events;' on server. along with these i also found event of other user databases.

Now i want filer these admin transactions from bin logs to some other file which i can save.

I tried using the argument "-D mysql" to mysqlbinlog command, but it does not give the expected results.

How do i proceed? any solution?? like special APIs,open source tools??

FIND slow queries (1 reply)

sreedhar chava — Tue, 10 Nov 2009 09:37:58 +0000

How to Identify Slow Queries apart of checking the logs or setting the slow_query_log time interval in MY.CNF, is there a Command to show which queries are running slow and how to Resolve the issue.

how mysql manage connetions to databases (no replies)

khalid touati — Wed, 04 Nov 2009 16:30:26 +0000

Hi All,
i have two questions please, i have the two following issues:
1- I don’t know why it shows a lot of connections using “root” as user like 40 to 45 connection.
2- When i close an application the connections being used don’t get freed in a short time it takes a long time 6 hours or so.
if any ideas, thanks for sharing!

Table corruption issue (1 reply)

omkar prabhu — Tue, 10 Nov 2009 09:41:04 +0000

We are using mysql 5.0 with master slave setup. When we describe any table it gives following error
Error 'Incorrect information in file: './livedb/tablename.frm
Master database looks ok, only slave is having problem,when we do show slave status, we see below information

Replicate_Wild_Ignore_Table:
Last_Errno: 1033
Last_Error: Error 'Incorrect information in file: './livedb/print.frm'' on query. Default database: 'livedb2'. Query: 'DELETE FROM livedb.print WHERE TIMESTAMPDIFF(dayvalue, date_created, '2009-11-02 01:58:06') >= 9999'
Skip_Counter: 0
Exec_Master_Log_Pos: 653241805
Relay_Log_Space: 3073839
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Can anyone let me know how to trouble shoot this issue ie. reason behind this issue and how to go about fixing it?

Slow quesry on small table (no replies)

Randall Petras — Mon, 02 Nov 2009 15:15:47 +0000

Hi, I am having some issues that have cropped up recently with a query that has been running well for about a year.

We are running our installation on a Sun system and mysql version 5.0.51b.

We have the queries, scripts, etc. backed up to a development system running the same config.

The query uses 2 sub selects, which can be slow, but runs sub second on the dev system and has recently started taking 5 mins + on the primary.

While the data may be different from dev to prod, the query uses an ID field and a time field, not user created data to perform the select. Note that there are only 675 rows in the table, not a lot by any standard!

I'm not sure what to do to diagnose this.

I've run an EXPLAIN and a SHOW TABLE STATUS which I've listed below:

mysql> explain select issueID, iprTime, probDesc, bi, impact, wip,ir, owner, if(active=1,'Open','Restored'), level, unix_timestamp(startTime), startTime, unix_timestamp(iprTime) from ipr.issueHist where (issueID,iprTime) in (select issueID, max(iprTime) from ipr.issueHist where issueID in (select distinct issueID from ipr.issueHist)  group by issueID) and (active = 1 or unix_timestamp(iprTime) > unix_timestamp(now())-7200);
+----+--------------------+-----------+------+---------------+------+---------+------+------+----------------------------------------------+
| id | select_type        | table     | type | possible_keys | key  | key_len | ref  | rows | Extra                                        |
+----+--------------------+-----------+------+---------------+------+---------+------+------+----------------------------------------------+
|  1 | PRIMARY            | issueHist | ALL  | NULL          | NULL | NULL    | NULL |  675 | Using where                                  |
|  2 | DEPENDENT SUBQUERY | issueHist | ALL  | NULL          | NULL | NULL    | NULL |  675 | Using where; Using temporary; Using filesort |
|  3 | DEPENDENT SUBQUERY | issueHist | ALL  | NULL          | NULL | NULL    | NULL |  675 | Using where; Using temporary                 |
+----+--------------------+-----------+------+---------------+------+---------+------+------+----------------------------------------------+
3 rows in set (0.00 sec)

mysql> SHOW TABLE STATUS LIKE 'issueHist';
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| Name      | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time         | Update_time         | Check_time          | Collation         | Checksum | Create_options | Comment |
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
| issueHist | MyISAM |      10 | Dynamic    |  675 |            375 |      253188 | 281474976710655 |         9216 |         0 |           1046 | 2009-01-05 12:27:23 | 2009-11-01 09:03:03 | 2009-11-02 09:42:06 | latin1_swedish_ci |     NULL |                |         |
+-----------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+-------------------+----------+----------------+---------+
1 row in set (0.00 sec)

IF BETWEEN (no replies)

anang jablai — Sat, 31 Oct 2009 12:26:12 +0000

i have a query but it does not work.

if(khs.result between 90 and 100),'A',if(khs.result between 80 and 90),'B',if(khs.result between 70 and 80),'A','C' AS FINALRESULT

help me to correct this query.

couldn't connect to database (no replies)

yash mistrey — Sat, 31 Oct 2009 07:18:05 +0000

Hello

I am new to php mysql

Actually i have read A tutorial on nettuts
"http://net.tutsplus.com/tutorials/php/create-a-signup-form-with-email-confirmation/";

According i copy all source code & change some setting only in config.php file

then i copy all file to my website folder "http://www.makemycreative.in/source/index.php";

now it showing error like...

"I couldn't connect to your database, please make sure your info is correct!"

in config.php.. there is asking for

----------------------------------------------------------------------------------------------------------------

"mysql_connect('localhost', 'root', 'root') or die("I couldn't connect to your database, please make sure your info is correct!");
mysql_select_db('email_signup') or die("I couldn't find the database table ($table) make sure it's spelt right!");"

I fill instead of above....these...

"mysql_connect('localhost', 'makemycr', 'samson01') or die("I couldn't connect to your database, please make sure your info is correct!");
mysql_select_db('user1') or die("I couldn't find the database table ($table) make sure it's spelt right!");"

-------------------------------------------------------------------------------------------------------------------

I am not what to write instead of localhost.. i am very confused abt localhost..

rest of i know.. i think it's a problem of localhost...

couldn't connect to database (no replies)

yash mistrey — Sat, 31 Oct 2009 07:18:42 +0000

Hello ncovil !

I am new to php mysql

Actually i have read A tutorial on nettuts
"http://net.tutsplus.com/tutorials/php/create-a-signup-form-with-email-confirmation/";

According i copy all source code & change some setting only in config.php file

then i copy all file to my website folder "http://www.makemycreative.in/source/index.php";

now it showing error like...

"I couldn't connect to your database, please make sure your info is correct!"

in config.php.. there is asking for

----------------------------------------------------------------------------------------------------------------

"mysql_connect('localhost', 'root', 'root') or die("I couldn't connect to your database, please make sure your info is correct!");
mysql_select_db('email_signup') or die("I couldn't find the database table ($table) make sure it's spelt right!");"

I fill instead of above....these...

"mysql_connect('localhost', 'makemycr', 'samson01') or die("I couldn't connect to your database, please make sure your info is correct!");
mysql_select_db('user1') or die("I couldn't find the database table ($table) make sure it's spelt right!");"

-------------------------------------------------------------------------------------------------------------------

I am not what to write instead of localhost.. i am very confused abt localhost..

rest of i know.. i think it's a problem of localhost...

no properly closed connections ==> run out connections!!! (no replies)

khalid touati — Fri, 30 Oct 2009 14:57:40 +0000

Hi Guys,
i need some help from this forum, or if not possible so please redirect me to the right one (i'm not familliar with mysql world).
my issue is at a given moment, i open the website and it says 'Mysql cannot connect to database", this issue is not hapening in the weekend, probably because people are not using a helpdesk application that i suspect not to close properly connections. so that in weekdays, mysql work fine for like 4 hours before it run out connections and then 'Mysql cannot connect to database' appears.

1-i tried to repair this db using: myisamchk --silent --force */*.MYI.
2-i retrieved some debug info using: mysqladmin -uroot -p variables debug.

and it gives me the following:

Memory status:
Non-mmapped space allocated from system: 21061552
Number of free chunks: 5
Number of fastbin blocks: 0
Number of mmapped regions: 20
Space in mmapped regions: 915787776
Maximum total allocated space: 0
Space available in freed fastbin blocks: 0
Total allocated space: 20721408
Total free space: 340144
Top-most, releasable space: 337592
Estimated memory (with thread stack): 947269552

Status information:

Current dir: /home/mysql/
Running threads: 59 Stack size: 196608
Current locks:
lock: 0x16900b40:

lock: 0x168bc8f0:
....
lock: 0x16689c48:

lock: 0x16681120:

Key caches:
default
Buffer_size: 134217728
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 1018
not flushed: 0
w_requests: 980
writes: 854
r_requests: 582143
reads: 1018

handler status:
read_key: 315293
read_next: 1771454
read_rnd 2392
read_first: 322
write: 35816
delete 256
update: 1218

Table status:
Opened tables: 186
Open tables: 180
Open files: 161
Open streams: 0

Alarm status:
Active alarms: 58
Max used alarms: 59
Next alarm time: 24385

KILL UNWANTED SLEEPING CONNECTIONS (1 reply)

Arunkumar N — Tue, 10 Nov 2009 09:45:05 +0000

Hi
im developing an application with c#.net and MySQL using mysql manager.
Connection open and close is working perfect. Thanks to application manager
But My Issue is

Lot of Sleeping connections alive in the server so the performance was reduced.

I tried the following commands to reduce the "wait_timeout"

mysql>set global "wait_timeout =30"

and

mysql>set @@session.wait_timeout=30

but after some minutes i checked the timeout variable value it shows the default(28800)

im using appache-my sql server version

pls suggest me to break the head-ace

Thanks in Advance
Arun

error 134 on a table cause Mysql server to stop connecting to db's (1 reply)

khalid touati — Thu, 19 Nov 2009 09:13:47 +0000

Hi Guys,
i have an error taht miss up everything using mysql in my server, including websites of course.
here is the thing: the error start with a table as it says here in the logs:

091023 12:45:40 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:02 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:11 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:17 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 12:46:23 [ERROR] Got error 134 when reading table './otrs/user_preferences'
091023 14:26:06 [Note] /usr/sbin/mysqld: Normal shutdown

091023 14:26:08 InnoDB: Starting shutdown...
091023 14:26:12 InnoDB: Shutdown completed; log sequence number 1 3966143693
091023 14:26:12 [Note] /usr/sbin/mysqld: Shutdown complete

091023 14:26:12 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=/var/run/mysqld/mysqld-bin' to avoid this problem.
091023 14:26:13 InnoDB: Started; log sequence number 1 3966143693
091023 14:26:13 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.44-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Gentoo Linux mysql-5.0.44-r2

this error make that when you connect to website it says "mysql cannot connect to database", so i restared the mysql and i get the warning below it stays normal for few hours like 6 hours and the cycle get launched again.
any idea that can get ma out of the cycle please!!?

Large table issue (1 reply)

omkar prabhu — Tue, 27 Oct 2009 12:30:41 +0000

I have a table growing immensely every day , currently it has around 18777410 records.
Our site is available 24x7 and we are using mysql replication to distrubute load on the database server ( a master and single slave combination).
It is almost two years we running the application on mysql 5.0.45 everything seems to fine, but now we are facing problem with maintaining this huge table.
Following are key problem areas:
a) Running aggregate queries takes more than 5 minutes, which is not acceptable with respect to site performane
b) Adding index is not possible as it takes more than 3/4 hours which result in site downtime
c) command like optimize and analyze cant be run as it is online application and it will result in locking of this important table.

Can any one suggest possible approach to solve this problem, we are thinking of trying following approach
a) Have seperate table for having archive data,so query requiring complete data, will need to be fire two queries or have union on archive data and live data
b) Upgrade to mysql 5.1 and see having partitioning on this table helps
c) have mutliple database slave server to hit queries on most used use cases on this table.

Let me know if anyone faced similar problem and how to go about solving it

Insert with Where Not Exists (5 replies)

Craig Paterson — Mon, 26 Oct 2009 16:20:23 +0000

I cant figure out what i need to change to make this work?

Insert into stockchart (symbol,date,open,high,low,close,volume,adjclose) Values ('LVN.V','2009-10-22','0.26','0.37','0.25','0.37','809200','0.37') WHERE NOT EXISTS (select * from stockchart where symbol='LVN.V' and date='2009-10-22' LIMIT 1);

"optimize table" takes long time (no replies)

justin ux — Tue, 20 Oct 2009 06:53:47 +0000

Hi,
I use 'optimize table ' to maintein a table very Monday and Friday, usaually it needs 1 hour normally , but sometime ,the 'optimize table' operation take serval hours or longer, today the 'optimize table ' runs for near 10 hours and not finish . Please help to check the problem.
The table is MyISAM table. The CPU,disk IO and Memory status are OK.
-bash-3.00$ ls
-rw-rw---- 1 mysql mysql 2629828608 Oct 19 23:51 tabname.TMD
-rw-r----- 1 mysql mysql 2348271616 Oct 19 22:12 tabname.MYI
-rw-rw---- 1 mysql mysql 5564438256 Oct 19 13:15 tabname.MYD
-rw-rw---- 1 mysql mysql 13672 Sep 21 18:39 tabname.frm

+-------+------------+--------------------+----------+------------+-------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------------+--------------------+----------+------------+-------+----------------------+------------------------------------------------------------------------------------------------------+
| 84297 | useracc | localhost | nondb | Query | 34267 | Repair with keycache | OPTIMIZE TABLE `mytable`

mysql> show variables;
+---------------------------------+---------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /store2/local/mysql-standard-5.0.24-solaris10-sparc-64bit/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /store2/local/mysql-standard-5.0.24-solaris10-sparc-64bit/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
| datadir | /usr/local/mysql/data/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_merge_engine | YES |
| have_openssl | DISABLED |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 3600 |
| join_buffer_size | 8384512 |
| key_buffer_size | 3221225472 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /store2/local/mysql-standard-5.0.24-solaris10-sparc-64bit/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |
| max_allowed_packet | 67107840 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 150 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 276823040 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 100 |
| max_write_lock_count | 18446744073709551615 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 16106127360 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 1572864000 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 760 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /usr/local/mysql/data/dbnode.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1420 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_load_tmpdir | /usr/local/mysql/data/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 8388600 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | PDT |
| table_cache | 300 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 8 |
| thread_concurrency | 16 |
| thread_stack | 262144 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /usr/local/mysql/data |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.24-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | sparc |
| version_compile_os | sun-solaris2.10 |
| wait_timeout | 3600 |
+---------------------------------+---------------------------------------------------------------------------------+
220 rows in set (0.00 sec)

mysql> show status;;
+-----------------------------------+-------------+
| Variable_name | Value |
+-----------------------------------+-------------+
| Aborted_clients | 11818 |
| Aborted_connects | 1449 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 278 |
| Bytes_sent | 17129 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 0 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 0 |
| Com_insert_select | 0 |
| Com_kill | 1 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 0 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 7 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_triggers | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 0 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 91280 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 1812 |
| Created_tmp_tables | 2 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 221 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 0 |
| Handler_write | 350 |
| Innodb_buffer_pool_pages_data | 20 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 491 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 1 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 669 |
| Innodb_buffer_pool_reads | 13 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 3 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2510848 |
| Innodb_data_reads | 26 |
| Innodb_data_writes | 3 |
| Innodb_data_written | 1536 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 1 |
| Innodb_os_log_fsyncs | 3 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 512 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 20 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 968570 |
| Key_blocks_unused | 1409065 |
| Key_blocks_used | 2586872 |
| Key_read_requests | 11596369138 |
| Key_reads | 286439943 |
| Key_write_requests | 1572236319 |
| Key_writes | 291256289 |
| Last_query_cost | 10.499000 |
| Max_used_connections | 40 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 580 |
| Open_streams | 0 |
| Open_tables | 291 |
| Opened_tables | 0 |
| Qcache_free_blocks | 3 |
| Qcache_free_memory | 103520328 |
| Qcache_hits | 4934 |
| Qcache_inserts | 6246809 |
| Qcache_lowmem_prunes | 1329004 |
| Qcache_not_cached | 3721641 |
| Qcache_queries_in_cache | 28138 |
| Qcache_total_blocks | 56314 |
| Questions | 90691580 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 2 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 65626916 |
| Table_locks_waited | 23837 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 7 |
| Threads_connected | 16 |
| Threads_created | 1260 |
| Threads_running | 6 |
| Uptime | 434382 |
+-----------------------------------+-------------+
245 rows in set (0.00 sec)

"optimize table" takes long time (no replies)

justin ux — Tue, 20 Oct 2009 06:51:29 +0000

Hi,
I use 'optimize table ' to maintein a table very Monday and Friday, usaually it runs 1 hour normally , but sometime ,the 'optimize table' operation take serval hours or longer, today the 'optimize table ' runs for near 10 hours . Please help to check the problem.

+-------+------------+--------------------+----------+------------+-------+----------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------------+--------------------+----------+------------+-------+----------------------+------------------------------------------------------------------------------------------------------+
| 84297 | useracc | localhost | nondb | Query | 34267 | Repair with keycache | OPTIMIZE TABLE `mytable`

mysql> show variables;
+---------------------------------+---------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /store2/local/mysql-standard-5.0.24-solaris10-sparc-64bit/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /store2/local/mysql-standard-5.0.24-solaris10-sparc-64bit/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| completion_type | 0 |
| concurrent_insert | 1 |
| connect_timeout | 5 |
| datadir | /usr/local/mysql/data/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | YES |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_dynamic_loading | YES |
| have_example_engine | NO |
| have_federated_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_ndbcluster | NO |
| have_merge_engine | YES |
| have_openssl | DISABLED |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_checksums | ON |
| innodb_commit_concurrency | 0 |
| innodb_concurrency_tickets | 500 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_doublewrite | ON |
| innodb_fast_shutdown | 1 |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_support_xa | ON |
| innodb_sync_spin_loops | 20 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| innodb_thread_sleep_delay | 10000 |
| interactive_timeout | 3600 |
| join_buffer_size | 8384512 |
| key_buffer_size | 3221225472 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /store2/local/mysql-standard-5.0.24-solaris10-sparc-64bit/share/mysql/english/ |
| large_files_support | ON |
| large_page_size | 0 |
| large_pages | OFF |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_bin_trust_function_creators | OFF |
| log_error | |
| log_queries_not_using_indexes | OFF |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |
| max_allowed_packet | 67107840 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 150 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 276823040 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_sp_recursion_depth | 0 |
| max_tmp_tables | 32 |
| max_user_connections | 100 |
| max_write_lock_count | 18446744073709551615 |
| multi_range_count | 256 |
| myisam_data_pointer_size | 6 |
| myisam_max_sort_file_size | 16106127360 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 1572864000 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 760 |
| optimizer_prune_level | 1 |
| optimizer_search_depth | 62 |
| pid_file | /usr/local/mysql/data/dbnode.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 134217728 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 1420 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_compressed_protocol | OFF |
| slave_load_tmpdir | /usr/local/mysql/data/ |
| slave_net_timeout | 3600 |
| slave_skip_errors | OFF |
| slave_transaction_retries | 10 |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 8388600 |
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
| ssl_ca | |
| ssl_capath | |
| ssl_cert | |
| ssl_cipher | |
| ssl_key | |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| system_time_zone | PDT |
| table_cache | 300 |
| table_lock_wait_timeout | 50 |
| table_type | MyISAM |
| thread_cache_size | 8 |
| thread_concurrency | 16 |
| thread_stack | 262144 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| timed_mutexes | OFF |
| tmp_table_size | 33554432 |
| tmpdir | /usr/local/mysql/data |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| updatable_views_with_limit | YES |
| version | 5.0.24-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | sparc |
| version_compile_os | sun-solaris2.10 |
| wait_timeout | 3600 |
+---------------------------------+---------------------------------------------------------------------------------+
220 rows in set (0.00 sec)

mysql> show status;;
+-----------------------------------+-------------+
| Variable_name | Value |
+-----------------------------------+-------------+
| Aborted_clients | 11818 |
| Aborted_connects | 1449 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 278 |
| Bytes_sent | 17129 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 0 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 0 |
| Com_dealloc_sql | 0 |
| Com_delete | 0 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_drop_user | 0 |
| Com_execute_sql | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 0 |
| Com_insert_select | 0 |
| Com_kill | 1 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 0 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 0 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 0 |
| Com_set_option | 0 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_charsets | 0 |
| Com_show_collations | 0 |
| Com_show_column_types | 0 |
| Com_show_create_db | 0 |
| Com_show_create_table | 0 |
| Com_show_databases | 0 |
| Com_show_errors | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 7 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 0 |
| Com_show_triggers | 0 |
| Com_show_variables | 1 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 0 |
| Com_stmt_execute | 0 |
| Com_stmt_fetch | 0 |
| Com_stmt_prepare | 0 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 0 |
| Com_update_multi | 0 |
| Com_xa_commit | 0 |
| Com_xa_end | 0 |
| Com_xa_prepare | 0 |
| Com_xa_recover | 0 |
| Com_xa_rollback | 0 |
| Com_xa_start | 0 |
| Compression | OFF |
| Connections | 91280 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_files | 1812 |
| Created_tmp_tables | 2 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 0 |
| Handler_discover | 0 |
| Handler_prepare | 0 |
| Handler_read_first | 0 |
| Handler_read_key | 0 |
| Handler_read_next | 0 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 0 |
| Handler_read_rnd_next | 221 |
| Handler_rollback | 0 |
| Handler_savepoint | 0 |
| Handler_savepoint_rollback | 0 |
| Handler_update | 0 |
| Handler_write | 350 |
| Innodb_buffer_pool_pages_data | 20 |
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_pages_flushed | 0 |
| Innodb_buffer_pool_pages_free | 491 |
| Innodb_buffer_pool_pages_latched | 0 |
| Innodb_buffer_pool_pages_misc | 1 |
| Innodb_buffer_pool_pages_total | 512 |
| Innodb_buffer_pool_read_ahead_rnd | 1 |
| Innodb_buffer_pool_read_ahead_seq | 0 |
| Innodb_buffer_pool_read_requests | 669 |
| Innodb_buffer_pool_reads | 13 |
| Innodb_buffer_pool_wait_free | 0 |
| Innodb_buffer_pool_write_requests | 0 |
| Innodb_data_fsyncs | 3 |
| Innodb_data_pending_fsyncs | 0 |
| Innodb_data_pending_reads | 0 |
| Innodb_data_pending_writes | 0 |
| Innodb_data_read | 2510848 |
| Innodb_data_reads | 26 |
| Innodb_data_writes | 3 |
| Innodb_data_written | 1536 |
| Innodb_dblwr_pages_written | 0 |
| Innodb_dblwr_writes | 0 |
| Innodb_log_waits | 0 |
| Innodb_log_write_requests | 0 |
| Innodb_log_writes | 1 |
| Innodb_os_log_fsyncs | 3 |
| Innodb_os_log_pending_fsyncs | 0 |
| Innodb_os_log_pending_writes | 0 |
| Innodb_os_log_written | 512 |
| Innodb_page_size | 16384 |
| Innodb_pages_created | 0 |
| Innodb_pages_read | 20 |
| Innodb_pages_written | 0 |
| Innodb_row_lock_current_waits | 0 |
| Innodb_row_lock_time | 0 |
| Innodb_row_lock_time_avg | 0 |
| Innodb_row_lock_time_max | 0 |
| Innodb_row_lock_waits | 0 |
| Innodb_rows_deleted | 0 |
| Innodb_rows_inserted | 0 |
| Innodb_rows_read | 0 |
| Innodb_rows_updated | 0 |
| Key_blocks_not_flushed | 968570 |
| Key_blocks_unused | 1409065 |
| Key_blocks_used | 2586872 |
| Key_read_requests | 11596369138 |
| Key_reads | 286439943 |
| Key_write_requests | 1572236319 |
| Key_writes | 291256289 |
| Last_query_cost | 10.499000 |
| Max_used_connections | 40 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 580 |
| Open_streams | 0 |
| Open_tables | 291 |
| Opened_tables | 0 |
| Qcache_free_blocks | 3 |
| Qcache_free_memory | 103520328 |
| Qcache_hits | 4934 |
| Qcache_inserts | 6246809 |
| Qcache_lowmem_prunes | 1329004 |
| Qcache_not_cached | 3721641 |
| Qcache_queries_in_cache | 28138 |
| Qcache_total_blocks | 56314 |
| Questions | 90691580 |
| Rpl_status | NULL |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 0 |
| Select_range_check | 0 |
| Select_scan | 2 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 0 |
| Sort_scan | 0 |
| Ssl_accept_renegotiates | 0 |
| Ssl_accepts | 0 |
| Ssl_callback_cache_hits | 0 |
| Ssl_cipher | |
| Ssl_cipher_list | |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_ctx_verify_depth | 0 |
| Ssl_ctx_verify_mode | 0 |
| Ssl_default_timeout | 0 |
| Ssl_finished_accepts | 0 |
| Ssl_finished_connects | 0 |
| Ssl_session_cache_hits | 0 |
| Ssl_session_cache_misses | 0 |
| Ssl_session_cache_mode | NONE |
| Ssl_session_cache_overflows | 0 |
| Ssl_session_cache_size | 0 |
| Ssl_session_cache_timeouts | 0 |
| Ssl_sessions_reused | 0 |
| Ssl_used_session_cache_entries | 0 |
| Ssl_verify_depth | 0 |
| Ssl_verify_mode | 0 |
| Ssl_version | |
| Table_locks_immediate | 65626916 |
| Table_locks_waited | 23837 |
| Tc_log_max_pages_used | 0 |
| Tc_log_page_size | 0 |
| Tc_log_page_waits | 0 |
| Threads_cached | 7 |
| Threads_connected | 16 |
| Threads_created | 1260 |
| Threads_running | 6 |
| Uptime | 434382 |
+-----------------------------------+-------------+
245 rows in set (0.00 sec)

Unable to start slave (2 replies)

n g — Tue, 10 Nov 2009 09:48:25 +0000

I need help in solving below issue with my slave mysql instance. Can somebody provide required steps to solve the issue?

show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: lon-prd-absql03.eutrips.live
Master_User: replicator
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000804
Read_Master_Log_Pos: 58430312
Relay_Log_File: abritelsql-relay-bin.001043
Relay_Log_Pos: 786867
Relay_Master_Log_File: mysql-bin.000731
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error: Could not parse relay log event entry. The possible reasons are: the master's binary log is
corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can
check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code
. If you want to check the master's binary log or slave's relay log, you will be able to know their names by issuing 'SH
OW SLAVE STATUS' on this slave.
Skip_Counter: 0
Exec_Master_Log_Pos: 128
Relay_Log_Space: 6688360057
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
1 row in set (0.01 sec)

change name of table in transaction or with lock? (no replies)

Andreas Andersson — Thu, 15 Oct 2009 15:10:08 +0000

I have a table with read and writes ALL the time (it's actually a test bench for proof of concept so I really mean ALL the time :)) and I need to swap two tables names.

So, test becomes test_old and test_new becomes test. I need to do this with out any clients noting it, the table structure is the same.

My first plan was to get a write lock, change the names and release the locks. However, that didn't work cause mysql unlocks the table when running alter table.

Next idea was to use rename table but that doesn't work with the table locked or in a transaction.

So, is there any way of doing this?

Thanks

Grant within a STORED PROCEDURE (1 reply)

Marco Antonio Rios — Wed, 14 Oct 2009 08:43:21 +0000

After more than a year after the first attempt to have a response, I re-submit this thread
--------------------------------------------------------
Posted by: Marco Antonio Rios ()
Date: April 21, 2008 11:15AM

I am trying to update the privileges of the MySQL users within a STORED PROCEDURE, reading the names of the users from a table.
The problem is that the privileges are assigned to a user with the same name as the VARIABLE used in the SP.
Is there a SPECIAL form to use the variables?

the procedure is as follows:

CREATE DEFINER=`marcoa`@`%` PROCEDURE `sp_act_privilegios`()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE cUsuario CHAR(16);
DECLARE b,c INT;
DECLARE curUsuario CURSOR FOR SELECT clave FROM usuarios.usr_usuarios;
DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;

OPEN curUsuario;
REPEAT
FETCH curUsuario INTO cUsuario;
IF NOT done THEN
GRANT UPDATE (vendidos, disponibles, tiempos_limites, a_solicitud),
SELECT (id_inventario, allotment, vendidos, disponibles, tiempos_limites, a_solicitud)
ON Contratos.contr_hoteles_inventario
TO cUsuario ;
END IF;
UNTIL done END REPEAT;

CLOSE curUsuario;
END

Reg. Mysql restarting Automatically (no replies)

vijay sai — Mon, 12 Oct 2009 07:05:51 +0000

Hi All,

I am using mysql 5.0.67 version on one of my servers. The mysql is restarting automatically very often. When i saw the error logs i found the following information.

Number of processes running now: 0
091011 17:33:12 mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
091011 17:33:13 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 8131331, file name ./mysql-bin.000073
091011 17:33:13 InnoDB: Started; log sequence number 0 217758
091011 17:33:13 [Note] Recovering after a crash using mysql-bin
091011 17:33:13 [Note] Starting crash recovery...
091011 17:33:13 [Note] Crash recovery finished.
091011 17:33:14 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.67-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)

I read some articles on the above error and also created new innodb log files by removing old data and log files and restoring data from the backup but mysql kept restarting automatically again.

Any help regarding this would be very useful.

Thanks in advance.

MySQL crash - log file shows normal shutdown (no replies)

Rob Barnett — Thu, 08 Oct 2009 15:53:42 +0000

I have an odd situation or at least I think so. Yesterday mysql went down on our server and I had to manually start it up again. The log file shows that it was shut down normally however I know that no one issued a command to shut it down. Is there any other reason why the log file would show this? I thought perhaps that there are too many connections or a query that was too large which caused it to crash. The default configurations are still in place so max connections should be 100 and 1 MB would be the largest query able to run, I think. I might be going down the wrong path which is why I'm posting this question:

Here is the log file:

091007 10:28:34 [Note] /usr/libexec/mysqld: Normal shutdown

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692698 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692632 user: 'woburnmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692568 user: 'woburnmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692563 user: 'woburnmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692555 user: 'waymoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692532 user: 'wboylstonmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692396 user: 'nvtmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692348 user: 'avonmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692340 user: 'nortmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692318 user: 'walthmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692315 user: 'natmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692309 user: 'gdmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692308 user: 'chatmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692306 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692302 user: 'hollmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692301 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692299 user: 'woburnmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692298 user: 'waymoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692296 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692295 user: 'bphsmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692294 user: 'mascdmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692292 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692291 user: 'amesmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692289 user: 'dcmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692288 user: 'maldenmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692287 user: 'ccthsmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692286 user: 'admin'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692285 user: 'nbmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692284 user: 'everettmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692283 user: 'watermoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692282 user: 'oxfordmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692280 user: 'westmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692279 user: 'bvtmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692278 user: 'chatmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692277 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692275 user: 'hudsmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692273 user: 'testsitemoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692272 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692271 user: 'douglasmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692268 user: 'chatmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692266 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692265 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692264 user: 'admin'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692263 user: 'dcmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692262 user: 'methuenmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692260 user: 'dphsmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692259 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692258 user: 'westwoodmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692256 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692255 user: 'casamoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692254 user: 'casamoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692252 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692249 user: 'wellmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692243 user: 'natmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692242 user: 'amschoolmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692240 user: 'marshmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692239 user: 'nsboromoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692238 user: 'romeomoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692236 user: 'lindadmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692094 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 692068 user: 'millmoodler'

091007 10:28:36 [Warning] /usr/libexec/mysqld: Forcing close of thread 691870 user: 'hopkmoodler'

091007 10:28:43 InnoDB: Starting shutdown...
091007 10:28:46 InnoDB: Shutdown completed; log sequence number 0 113028589
091007 10:28:46 [Note] /usr/libexec/mysqld: Shutdown complete

091007 10:28:46 mysqld ended

091007 10:28:47 mysqld started
091007 10:28:47 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091007 10:28:47 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
091007 10:28:47 InnoDB: Started; log sequence number 0 113028589
091007 10:28:48 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution