Getting mysql wait timeout from php

Question

Is there a way to get mysql wait timeout directly from php?

He wants to know if you can find out from the DB how long its timeout (like max execution time in PHP) is from PHP. @user718480 you will likely need to use some sort of query to the db. — ohmusama
– ohmusama, Commented Apr 21, 2011 at 7:39

Shakti Singh · Accepted Answer · 2011-04-21 08:13:29Z

7

Just make a normal mysql query.

mysql> show variables where Variable_name='wait_timeout';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| wait_timeout  | 28800 |
+---------------+-------+
1 row in set (0.07 sec)

In PHP it'd look something like this.

// it's been a while to there might be typos
$res = mysql_query("show variables where Variable_name='wait_timeout'");
$arr = mysql_fetch_assoc($res);
echo $arr['Variable_name'];
echo $arr['Value'];

edited Apr 21, 2011 at 8:13

Shakti Singh

86.8k21 gold badges142 silver badges156 bronze badges

answered Apr 21, 2011 at 7:40

jmathai

4532 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

anon Over a year ago

Yeah, I know about that. So I can't get this info without sql-query?

Shakti Singh Over a year ago

Your answer is improved updated Feel free to rollback if anything gone wrong

Collectives™ on Stack Overflow

Getting mysql wait timeout from php

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related