Hello,
Is there a way to enable the Slow Query Log on the fly without having to
restart mysqld
Regards,
Marc.
Hi,
Thank you for your answer.
But is there a chance to be able to do it one day?
I think it could be a nice feature.
Marc.
-Message d'origine-
De : Petr Chardin [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 5 avril 2006 13:06
À : Mechain Marc
Cc : MySQL
Objet : Re: Slow query log
I have a Mysql Server (4.1.8) where some sessions stay connected for a
value greater than Interactive timeout value.
Here is an abstract of the show processlist command:
| 129996 | fret | mtt04.back:33598 | fret | Sleep | 61756 |
| 129998 | fret | mtt04.back:33599 | fret |
Memory problem.
Error 12 = Cannot allocate memory
Marc.
-Message d'origine-
De : Cliff Daniel [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 21 avril 2005 07:43
À : mysql@lists.mysql.com
Objet : UNIONS 'Got error 12 from storage engine'
Have a query that consists of 10 unions. For a
May be a clue, for the data records you load into the table, the value for
numeric field such as DEPARTMENT_ID, LOCATION_ID should not be enclosed in
quote. If it is the case, mysql has to make a translation from character to
numeric.
Marc.
-Message d'origine-
De : [EMAIL PROTECTED]
I think he is talking about the innodb_flush_log_at_trx_commit parameter.
Try to put it at a value of 0.
innodb_flush_log_at_trx_commit = 0
If you have an IO bottleneck, this may help.
Marc.
-Message d'origine-
De : Hannes Rohde [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 10 février
Have a look at:
http://dev.mysql.com/doc/mysql/en/Old_client.html
Marc.
-Message d'origine-
De : nikos [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 5 janvier 2005 10:09
À : mysql@lists.mysql.com
Objet : MyODBC 3.5.9 and MySQL 4.1.8
Hello list and happy new year.
Recently I've
You can use the format() function:
select t.custcode, format(sum(t.cost),2) as Sub-Total
from customer c, transaction t
where c.custcode = t.custcode
group by t.custcode
Marc.
-Message d'origine-
De : sam wun [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 24 décembre 2004 11:23
À :
In your my.cnf there is no:
Query_cache_size -
http://dev.mysql.com/doc/mysql/en/Query_Cache_Configuration.html
Thread_cache_size -
http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
Marc.
-Message d'origine-
De : ManojSW [mailto:[EMAIL PROTECTED]
Envoyé : lundi 6
You can use:
show create table employee;
or
show table status like 'employee';
in the column comment you have the information you are looking for.
Marc.
-Message d'origine-
De : Varakorn Ungvichian [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 26 novembre 2004 09:32
À : [EMAIL
If you don't want to have those error messages:
Increase the value of Open File using ulimit shell command.
Do a ulimit -a to see the current value
Do a ulimit -n newvalue to increase it
You can also modify the /etc/limits file
Marc.
-Message d'origine-
De : Richard Bennett
May be a full off the filesystem where the relay logbin file is ?
Marc.
-Message d'origine-
De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoye?: mercredi 9 juin 2004 09:46
A?: [EMAIL PROTECTED]
Objet?: Replication is currupted ...Please help me...
Hi all.
My company has three
See answers in the message below.
Marc.
-Message d'origine-
De : Ben Clewett [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 4 juin 2004 10:37
À : [EMAIL PROTECTED]
Objet : Three quick questions about using MySQL
Three quick questions, I hope you can help me.
Using InnoDB on version
Hello,
Why such a SQL request running well on the master is not correctly replicated on the
slave,
set @providerId='012345';
insert into DATA_TYPE values (1,@providerId,'DATA_TYPE',1);
Here is an extract of the Slave Logfile:
MYBCK.log.1:ERROR: 1048 Column 'PROVIDER_ID' cannot be null
Is there a simple way to determine how fragmented a Innodb table is ?
Thanks,
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Add this in your my.cnf slave file:
slave-skip-errors = 1062
Marc.
-Message d'origine-
De : Georg Horn [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 21 avril 2004 17:31
À : [EMAIL PROTECTED]
Objet : Replication problem
Hi,
i'm new to this list, but i use mysql for years an are very
This query is to see if there are duplicate records, I'm not sure how else I
could do this and it only runs once every 10 minutes.
Why don't you put a unique index on locale,ggd,from,to,supplier,date so you won't have
to play that request any more ...
How can I determine if the problem is
How do I know the table is configured by InnoDB instead of normal table ?
Do a show table status or a show create table name_of_my_table
Should I at least see some entry in the /etc/my.cnf to indicate that InnoDB
is configured?
No, but if you don't want to use innodb you can add skip-innodb in
Could you do a :
select count(*) from bet;
Just to be sure that there is still something in the table.
Marc.
-Message d'origine-
De : John Hunter [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 31 mars 2004 17:12
À : MySQL mailing list
Objet : select * returns nothing
I have a database
Is the table you 're talking about critical ?
If not, you could use type=HEAP for it, so every access will be done in
memory.
Marc.
-Message d'origine-
De : Jim Richardson [mailto:[EMAIL PROTECTED]
Envoye : jeudi 25 mars 2004 04:17
A : [EMAIL PROTECTED]
Objet : Re: Speeding up MySQL
May be Unix acces permissions on /root/tmp
(Errcode: 13) = EACCES Permission denied
Like you are using an ORDER BY, mysql needs some temporary space to do the order.
Marc.
-Message d'origine-
De : Søren Neigaard [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 18 mars 2004 13:29
À : [EMAIL
To configure PHP for MYSQL from (http://www.php.net/manual/en/ref.mysql.php):
Requirements
In order to have these functions available, you must compile PHP with MySQL support.
Installation
By using the --with-mysql[=DIR] configuration option you enable PHP to access MySQL
databases.
In PHP
SHOW TABLE STATUS
In the Comment Column you have the definition of the foreign keys.
Marc.
-Message d'origine-
De : Don Vu [mailto:[EMAIL PROTECTED]
Envoyé : mardi 27 janvier 2004 17:48
À : [EMAIL PROTECTED]
Objet : FKs in InnoDB
Hi,
I'm using MySQL 4.0.16 with InnoDB tables.
From
To drop all tables, yes do a drop database.
To drop all with something like a exclude, no.
What you can do is an export of the tables you don't want to drop, then do a drop
database + create database + import
Marc.
-Message d'origine-
De : Nitin Mehta [mailto:[EMAIL PROTECTED]
Envoyé :
Documentation:
http://www.mysql.com/doc/en/Stored_Procedures.html
Marc.
-Message d'origine-
De : Peter Brawley [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 7 janvier 2004 16:32
À : [EMAIL PROTECTED]; [EMAIL PROTECTED]
Objet : Re: MYSQL 5 Stored Procedure
Matthew,
You need to run the
Does anybody have an idea of the number of sql commands that can be saved inside the
sql history command file ?
Is there a way to set this limit ?
Thanks,
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
You can afterwards the installation specify the path to the data in the my.cnf
config file.
Marc.
-Message d'origine-
De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 31 décembre 2003 01:08
À : [EMAIL PROTECTED]
Objet : MySQL on RAID server
Hello List:
Here comes a
You must be 'root' to do a ulimit -n 1024.
Marc.
-Message d'origine-
De : Carlos André Moura de Amorim [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 19 décembre 2003 14:55
À : Chris Elsworth
Cc : [EMAIL PROTECTED]
Objet : Re: Help me - please
i added ulimit -n 1024 in mysql_install_db,
Innodb may not use an index (full scan) where MyIsam does (index crc which is the only
relevant one).
Have you done an EXPLAIN on your query ?
May be an index on (origin,status,deleted) could help.
Marc.
-Message d'origine-
De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED]
Envoy :
, I still think that creating an index on
(origin,status,deleted)
is the good answer.
Marc.
-Message d'origine-
De : Janusz Krzysztofik [mailto:[EMAIL PROTECTED]
Envoy : lundi 24 novembre 2003 16:48
A : Mechain Marc
Cc : [EMAIL PROTECTED]
Objet : Inefficient use of index (was: Big
A DNS problem, may be ...
Marc.
-Message d'origine-
De : JOUANNET, Rodolphe [mailto:[EMAIL PROTECTED]
Envoyé : vendredi 5 septembre 2003 13:02
À : [EMAIL PROTECTED]
Objet : Very slow connexion
Hi,
This problem is specific to the WAN connexion, not to the LAN connexion.
I've a Sun
For the most important diferences:
INNODB: Foreign Keys, Row level Locking, Transactions
Tablespaces for the storage of data and index (quite similar to
Oracle)
MYISAM: Table level locking, No transaction, No Foreign key
Storage using One file per table or index
What is the value of sort_buffer_size, may be you could increase the value for
having faster ORDER BY (all in memory intead of using temporary file on disk).
Marc.
-Message d'origine-
De : Jesse Sheidlower [mailto:[EMAIL PROTECTED]
Envoyé : jeudi 21 août 2003 17:34
À : [EMAIL PROTECTED]
Two Questions:
Is the same query running directly on the linux server thru mysql is also very slow ?
Have you done a explain plan on the query ?
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Another way to do it, create a temporary table load the content of your text file in
it, and then do your update crossing the two tables.
Marc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In one of my logfiles I have quite repeatedly the following message:
InnoDB: Warning: using a partial-field key prefix in search
What does this warning mean ?
Regards,
Marc Mechain
Atos Origin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
First of all, thank you Jeremy for your answer.
You said:
It's the amount of time that thread has been in its current state.
Is it the current state column value (which is in fact nothing or the text of the
running SQL request)
or the current command column value (sleeping, opening table,
Thanks very much.
Marc.
-Message d'origine-
De : Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Envoyé : mercredi 13 août 2003 17:01
À : Mechain Marc
Cc : [EMAIL PROTECTED]
Objet : Re: Meaning of Column time in Show Processlist
On Wed, Aug 13, 2003 at 03:26:24PM +0200, Mechain Marc wrote
I would like to know (if possible, there is no explanation in the documentation) the
exact meanning of the column time in the show processlist command.
Why is it sometime so hight ?
When is it reinitialize (and why) ?
Is there any correlation between the time column and the variables wait
I have a configuration under MySQL 4.0.5a using many slaves and one master
under Linux 2.4.18.
The slaves always crash when using the command load data infile to
populate a table on the master (the table exists on the slaves).
Maybe this could help:
- The master and the slaves are bind on a
40 matches
Mail list logo