Dear All,
I want to set wait_timeout variable on mysqld startup.
Is there any way to do that?
--
Sincerely,
Hadi Rastgou
A Google Account is the key that unlocks the world of Google.
a href= http://www.spreadfirefox.com/?q=affiliatesamp;id=0amp;t=1; Get
FireFox! /a
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
Dear All,
I want to set wait_timeout variable on mysqld startup.
Is there any way to do that?
Put wait_timeout = XXX into the [mysqld] stanza of your
/etc/mysql/my.cnf (or wherever your global config file is).
bye,
-christian-
--
MySQL
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify it at the command line : set wait_timeout=x
or start mysqld with --wait_timeout=x along with other options.
Thanks
ViSolve DB Team
- Original Message -
From: Sayed Hadi Rastgou Haghi [EMAIL PROTECTED]
Thanks
But this sets. GLOBAL wait_timeout variable.
Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
On 11/7/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hi
specify it in the .cnf file in the mysqld options: wait_timeout=x
or specify it at the command line : set wait_timeout=x
On 2006-11-07 Sayed Hadi Rastgou Haghi wrote:
Thanks
But this sets. GLOBAL wait_timeout variable.
Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES;
Ah, yes, MySQL is very confusing about this special variable:
You have to use interactive_timeout = XXX to change what is called
Hi
Try command line option, like
mysql set @@session.wait_timeout=15;
mysql show variables;
Thanks
Visolve DB Team.
- Original Message -
From: Sayed Hadi Rastgou Haghi [EMAIL PROTECTED]
To: Visolve DB Team [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 07, 2006
Thanks again
I have some questions that may help me explain my problem well.
1- What's this mean:
mysql SHOW PROCESSLIS;
+--+---+--++---+-++-+
| Id | User | Host |db | Command | Time | State |
We've added a new appendix to the MySQL Reference Manual:
- Frequently Asked Questions About MySQL 5.1
(http://dev.mysql.com/doc/refman/5.1/en/faqs.html)
- Frequently Asked Questions About MySQL 5.0
(http://dev.mysql.com/doc/refman/5.0/en/faqs.html)
The FAQ answers frequently asked questions
Hi
According to the VARIABLE wait_timeout [default: 28800 seconds] a running
MySQL daemon clears up idle connections if their
idle period wait_timeout.so the sleeping threads will be
automatically cleared if the time exceeds 'wait_timeout' variable value.
'wait_timeout' variable : The
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
interleaving, join and suspend/resume it supports XA. I think that puts it
about on par with Ingres and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 7 Nov 2006, at 12:35, Jochem van Dieten wrote:
On 11/6/06, Leandro Guimarães Faria Corcete DUTRA wrote:
Em Thu, 02 Nov 2006 10:22:18 -0800, Jochem van Dieten escreveu:
PostgreSQL supports 2 phase commit. IIRC except for transaction
Hello,
i am looking for a simple Web interface,
for normal users (non admin), that will only have access to their Database,
and have the possibility to manage their tables (create,delete,insert,...).
for root access, i already have phpMyAdmin installed on the server.
--
MySQL General
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Vittorio Zuccalà ha scritto:
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Uff...
I didn't remember...
If it is not enought you can use Dadabik (www.dadabik.org)
It is great: do not be impressed from its simple interface. It is very
completed
Vittorio Zuccalà wrote:
Anthony ha scritto:
for root access, i already have phpMyAdmin installed on the server.
You can also use phpmyadmin for normal user.
In my organization i use it for all users...
Indeed, if you set PHPMyAdmin to 'HTTP' or 'cookie' authentication mode
it will ask the
We have been using older versions of mysql without any problem (5.0.19)
I updated our test server to 5.0.27
senario is.. temp table performs data conversion, master table is never
deleted/updated, only new records insert, insert takes 30-40 minutes for
bulk loads
under old mysql versions we
Hello,
Ever since I upgraded to MySQL 5.0.x, phpMyAdmin has appeared to be buggy
as hell (and yes, of course, I updated the client API in PHP). I guess it
really was more of a MyQL 4.0 thingy.
At any rate, does anyone know what I could use instead, as semi-graphical
interface, on Apache?
Mark wrote:
Hello,
Ever since I upgraded to MySQL 5.0.x, phpMyAdmin has appeared to be buggy
as hell (and yes, of course, I updated the client API in PHP). I guess it
really was more of a MyQL 4.0 thingy.
At any rate, does anyone know what I could use instead, as semi-graphical
interface, on
At any rate, does anyone know what I could use instead, as
semi-graphical interface, on Apache? (FreeBSD). I'm ready to
do away with phpMyAdmin.
Thanks,
- Mark
Just a couple of hours ago Vittorio Zuccalà suggested dadabik -
http://www.dadabik.org/ - which looks pretty good to me,
Hello,
I have accidently droped a table from one of my database's. The table was an
innodb table. Is there anyway that I can recover the table or is that
information gone for good if I don't have a current backup of that table?
Thank you
Eric H. Lommatsch
Programmer
MICRONix, Inc.
2087 South
Only if you had enabled the log or bin-log options, and the log's
history contains the information you need (depending on the log's
creation date).
Carlos
On 11/7/06, Eric Lommatsch [EMAIL PROTECTED] wrote:
Hello,
I have accidently droped a table from one of my database's. The table was an
There is only ONE SLIM HOPE.
Is your binary logging enabled ???
If yes, how far back ??
You could theoretically recreate the table from the binary logs
up to the moment just before you accidentally dropped the table
if the binary logs contain the moment you first created the table
along with all
Eric, as far as SQL is concerned, there is no way to recover dropped tables
and, to my knowledge, there is no MYSQL-specific way to do that either, so,
your only hope is to have a rather fresh backup of your database.
BTW, this gives me an idea: I suppose that dropping a database table is a
On 11/7/06, Eric Lommatsch [EMAIL PROTECTED] wrote:
I have accidently droped a table from one of my database's. The table was
an innodb table. Is there anyway that I can recover the table or is that
information gone for good if I don't have a current backup of that table?
At 11:09 PM 11/7/2006
Any thoughts on using BINARY(N) or CHAR(N) as a primary key?
Performance issues? In mysql, in general?
Yes, in the context of the application, there is a very good
reason for doing this, and not using an auto increment integer.
Michael
--
Michael Fischer Happiness is
Ok, here's one. Either its impossible, or someone might
be able to point me to the light.
Given:
* A table TABLE_DESC, which is rather like a system table,
in that it contains the names and column_names of other tables.
* A table MY_TABLE, which contains ordinary data, and has a set
of rows in
I suspect, from experimentation, that substr() is not binary safe,
in that if some part of the field contains an all-bits-zero byte,
it will stop short.
What I wish to do is to pick out byte ranges of arbitrary length,
at an arbitary offset into a BINARY(N) column.
Perhaps LEFT() and RIGHT()
In the last episode (Nov 07), Michael Fischer said:
Given:
* A table TABLE_DESC, which is rather like a system table,
in that it contains the names and column_names of other tables.
* A table MY_TABLE, which contains ordinary data, and has a set
of rows in TABLE_DESC.
What I wish to do
Hi
I set the wait_timeout in my.cnf.
Sometimes it works well and there is no idle process 120 seconds time.
But sometimes there are idle processes with 1900s time.
What the reason can be?
On 11/7/06, Visolve DB Team [EMAIL PROTECTED] wrote:
Hi
According to the VARIABLE wait_timeout
Hi All,
Is it possible to restore the database from an XML file (
generated from mysqldump -X)?
Please provide me the syntax. (mysql database xmlbackupfile is not
working ).
But restore is working fine with the normal backup file.
Please throw some light on it.
Thanks
30 matches
Mail list logo
