Hi,
AFAIK, it may cause problem if used on table for which you are using INSERT
DELAYED.
http://www.mysql.com/doc/B/u/Bugs.html
Regards,
Jocelyn Fournier
- Original Message -
From: Benjamin Pflugmann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Mark [EMAIL PROTECTED]
Sent: Saturday,
Hi,
I wonder which index will be the most efficient for this query :
SELECT numreponse FROM searchhardwarefr7 WHERE pseudo='joce' AND
date'2001-01-01 00:00:00';
I tested a compound index on (pseudo,date,numreponse), and explain return :
mysql EXPLAIN SELECT numreponse FROM searchhardwarefr7
]; [EMAIL PROTECTED]
Sent: Friday, April 26, 2002 4:45 PM
Subject: Re: How does DISTINCT really work ?
Fournier Jocelyn [Presence-PC] writes:
Hi,
I have the latest 4.0.2 source installed, and the problem is still here
AFAIK :
mysql \s
--
mysql Ver 12.1 Distrib 4.0.2
Hi,
Try ALTER IGNORE TABLE your_table ADD UNIQUE
(column_where_you_dont_want_duplicates);
Regards,
Jocelyn Fournier
- Original Message -
From: Oswaldo Castro [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 26, 2002 8:20 PM
Subject: Duplicate Keys
Hi List
Sorry for
Hi,
For the first question you can make it in two step :
SELECT MIN(id) FROM names;
SELECT * FROM names WHERE id = min ;
SELECT MAX(id) FROM names;
SELECT * FROM names WHERE id = max ;
Regards,
Jocelyn Fournier
PresencePC
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
,
Jocelyn Fournier
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 5:54 PM
Subject: Re: How does DISTINCT really work
Hi,
Sorry finally there is no lock with 'use database', it only takes a huge
amont of time because of the number of table in my database :)
Regards,
Jocelyn
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL
Hi,
So why does I obtain duplicates numbers for 'topic' with the first query
with DISTINCT ? (perhaps a bug ?)
Regards,
Jocelyn Fournier
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 14
Message -
From: DL Neil [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 14, 2002 6:58 PM
Subject: Re: How does DISTINCT really work ?
Hi Jocelyn,
I don't have a quick/sure answer for you, but am wondering about the
relationship
Yes but when it's written DISTINCT is converted to a GROUP BY on all
columns, which columns are included in all columns ? :)
Thanks,
Jocelyn
- Original Message -
From: Carsten Gehling [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]; DL Neil
[EMAIL PROTECTED
In fact I couldn't suppress the LIMIT as it would return a lot of rows ;)
However the order by doesn't seem to have any effect.
- Original Message -
From: DL Neil [EMAIL PROTECTED]
To: Carsten Gehling [EMAIL PROTECTED]; Fournier Jocelyn [Presence-PC]
[EMAIL PROTECTED]; [EMAIL PROTECTED
Hi,
I wonder how works DISTINCT when using it with the following join.
Ex :
mysql SELECT DISTINCT topic FROM
searchmainhardwarefr7,searchjoinhardwarefr7 WHERE
searchmainhardwarefr7.numreponse=searchjoinhardwarefr7.numreponse AND
(mot='test') AND date = '2002-03-24' ORDER BY date DESC LIMIT
Hi,
5:40 a.m.
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL MYSQL SQL
MYSQL SQL
(is that enough, to get past the filter ?)
(sent this via the website, got a reply re the filter...)
Perhaps
- Original Message -
From: Tobias K. Tobiasen [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, April 04, 2002 6:46 PM
Subject: Group by?
Hello
I think the gruop by is behaving strange. Could someone please explain
this or maybe point me to a definition of the group by.
Hi,
As I'd got not answer, I repost my question ;)
I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :
For exemple :
dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI
(to
Hi,
What about taking a look at the manuel before ? ;)
http://www.mysql.com/doc/
Regards,
Jocelyn Fournier
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 22, 2002 12:14 PM
Subject: Optimizing tables
Hi,
Just set a unique index on the right column and you won't have anymore
duplicate in your table :)
ALTER TABLE yourtable ADD UNIQUE(your_column);
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Craig Westerman [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Hi,
I'm currently testing the BACKUP TABLE function, and to reconstruct the MYI
files, I'm performing the following action :
For exemple :
dd if=/home/mysql/Hardwarefr/cookie.MYI bs=16k count=1
of=/home/mirror/mysql/Hardwarefr
/cookie.MYI
(to restore the valid first 16 K block)
[root@forum]
-
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 3:31 PM
Subject: Re: Bug with heap table ??
Fournier Jocelyn [Presence-PC] writes:
Hi,
I encounter a strange problem on one of my server with a lot of heap
table
Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, March 02, 2002 3:31 PM
Subject: Re: Bug with heap table ??
Fournier Jocelyn [Presence-PC] writes:
Hi,
I encounter a strange problem on one of my server with a lot of heap
table.
(I'm using latest
Hi,
Try to upgrade PHP to the latest version (4.1.2) , it should run fine.
Regards,
Jocelyn Fournier
- Original Message -
From: Ronald Arenas [EMAIL PROTECTED]
To: Mysql [EMAIL PROTECTED]
Sent: Friday, March 01, 2002 9:18 PM
Subject: Please Help! MySql 4.01/PhP 4.06 looking for
Hi,
I encounter a strange problem on one of my server with a lot of heap table.
(I'm using latest mysql-4.0.2 version)
Here is the error :
mysql use forum;
Database changed
mysql SELECT * FROM online;
ERROR 1030: Got error 124 from table handler
mysql SELECT * FROM online;
ERROR 1030: Got error
Hi,
The warning: Found 22079089 partsShould be: 0 parts is a
known error of myisamchk in MySQL 4.0.1, and is already fixed in MySQL 4.0.2
:
Fixed new bug in myisamchk where it didn't correctly update number of
``parts'' in the MyISAM index file.
Hi,
Yes, just write :
perror 124
perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Christian M. Stamgren [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 11:49 AM
Hi,
It seems worst to me because in your case mysql has to retrieve all the
rows.
If it's a table with 1 million records or more, this should hurt ;)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Raymond Gubala [EMAIL PROTECTED];
WHERE field'ID00025' ORDER BY field ASC LIMIT 1
- Original Message -
From: Chris Boget [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]; Raymond Gubala
[EMAIL PROTECTED]; Mark Lo [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 22, 2002 9
Hi,
I think you can try to use REPLACE INTO table (a,b,c,d) SELECT e,f,g,h FROM
table2 WHERE field=what_you_want.
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Felix Richter [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 3:01 PM
Hi,
This is a bug in myisamchk. The problem is already fixed in mysql-4.0.2 :
http://www.mysql.com/doc/N/e/News-4.0.2.html
Fixed new bug in myisamchk where it didn't correctly update number of
``parts'' in the MyISAM index file.
Best Regards,
Jocelyn Fournier
Presence-PC
- Original
Hi,
No problem so far with mysql 4.0.x, no crash at all on a production server
with a really high load.
If you want to use mysql 4.0.2, take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From:
Hi,
In myisamchk.c replace the following line :
if (argument *argument == '0')
DBUG_POP();
else
DBUG_PUSH(argument ? argument : d:t:o,/tmp/myisamchk.trace);
by
if (argument *argument == '0')
{
DBUG_POP();
}
else
{
DBUG_PUSH(argument ?
Hi,
You can try to use ALTER IGNORE TABLE syntax :
ALTER IGNORE TABLE your_table ADD UNIQUE(Id);
Regards,
Jocelyn Fournier
- Original Message -
From: Rich [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Sunday, February 10, 2002 5:31 PM
Subject: Duplicate Records
How does one
Hi,
In myisamchk.c replace the following line :
if (argument *argument == '0')
DBUG_POP();
else
DBUG_PUSH(argument ? argument : d:t:o,/tmp/myisamchk.trace);
by
if (argument *argument == '0')
{
DBUG_POP();
}
else
{
DBUG_PUSH(argument ?
Hi,
You can try to use ALTER IGNORE TABLE syntax :
ALTER IGNORE TABLE your_table ADD UNIQUE(Id);
Regards,
Jocelyn Fournier
- Original Message -
From: Rich [EMAIL PROTECTED]
To: MySql [EMAIL PROTECTED]
Sent: Sunday, February 10, 2002 5:31 PM
Subject: Duplicate Records
How does one
Hi,
In myisamchk.c replace the following line :
if (argument *argument == '0')
DBUG_POP();
else
DBUG_PUSH(argument ? argument : d:t:o,/tmp/myisamchk.trace);
by
if (argument *argument == '0')
{
DBUG_POP();
}
else
{
DBUG_PUSH(argument ?
Of course not ;)
I only run myisamchk -a on several table, and I noticed sometime a similar
message (although the tables seem to work perfectly)
Jocelyn
- Original Message -
From: Gerald Clark [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED
Hi,
myisamchk shows me the following warning message on some of my tables :
myisamchk -a searchjoinhardwarefr2.MYI
Checking MyISAM file: searchjoinhardwarefr2.MYI
Data records: 264494 Deleted blocks:1288
- check file-size
- check key delete-chain
- check record delete-chain
- check
Hi,
I'm wondering what is the good syntax with version number after '!' with
MySQL 4 :
Should I use :
/*!40001 SQL_CALC_FOUND_ROWS */
or
/*!401 SQL_CALC_FOUND_ROWS */
Thank you !
Regards,
Jocelyn Fournier
Presence-PC
-
Hi,
Ok, it's 40001 according to #define MYSQL_VERSION_ID 40001 ;)
Regards,
Jocelyn
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, January 19, 2002 3:03 PM
Subject: Version number after '!' : what is the good syntax
in this case)
Regards,
Jocelyn
- Original Message -
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 3:57 PM
Subject: Re: Why does DISTINCT take so long time ??
Fournier Jocelyn [Presence-PC] writes:
Hi,
I've
-
From: Sinisa Milivojevic [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 4:27 PM
Subject: Re: Why does DISTINCT take so long time ??
Fournier Jocelyn [Presence-PC] writes:
Hi,
Yes it is 4.0.1.
But the first query has also to make
Hi,
Try :
SELECT a,COUNT(*) AS z FROM aa GROUP BY a HAVING z1;
Regards,
Jocelyn
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, January 18, 2002 10:30 PM
Subject: Column Alias Bug??
Is this a bug? I can't find an answer to this question
Hi,
It's already done since MySQL 4.0.1.
Take a look here :
http://www.mysql.com/doc/Q/u/Query_Cache.html
Regards,
Jocelyn
- Original Message -
From: Ioakim Spyros [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 17, 2002 6:52 PM
Subject: FW: Optimization
Hello all,
Hi,
I've notice sometimes DISTINCT clause take a really high amount of time to
remove duplicates whereas it should be really quick (I assume it should be
;))
My first query is :
mysql SELECT COUNT(*) as count, numreponse FROM searchhardwarefr3 GROUP BY
mot,date,numreponse HAVING count1 LIMIT
I agree with you, sometimes my server experiences some DoS and because MySQL
cannot handle all that connections, the load goes really high and we can't
do anything :(
- Original Message -
From: Dave Dyer [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, January 16, 2002 11:17 PM
Hi,
What about a 2.4.17 with 'aa' patch, as it seems to have much less VM
problem than vanilla kernel or rmap-10c patched kernel... (I have personnaly
installed 2.4.17rc2 + patch rc2aa2 with no problem :
http://www.kernel.org/pub/linux/kernel/people/andrea/kernels/v2.4/2.4.17rc2a
a2.bz2 )
Best
Hi,
I have a question about gcc 3.0.3 : since I have installed it, it refuses to
compile because it detect c++ as a crosscompiler :
checking whether the C++ compiler
(c++ -Wimplicit -Wreturn-type -Wid-clash-51 -Wswitch -Wtrigraphs -Wcomment -
W -Wchar-subscripts -Wformat -Wimplicit-function-dec
Hi,
I'm wondering what are those informations in the mysql .err file which
sometimes appear :
Status information:
Current dir: /home/mysql/
Current locks:
lock: 868e93c: read
read : 868f0b8 (79951:1);
lock: 8615e94:
lock: 85ba4bc:
lock: 856b104:
lock: 8521ad4:
lock: 84d84a4:
lock:
Hi,
You absolutely don't have to reconnect to the database each time a PHP-block
ends ! (it would be completely awfull !!).
Don't you forget to specify the mysql link in you 'mysql_query' ??
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: markus|lervik [EMAIL
]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, December 13, 2001 11:15 PM
Subject: Re: [PHP] Performance
On Thu, 2001-12-13 at 23:56, Fournier Jocelyn [Presence-PC] wrote:
Hi,
You absolutely don't have to reconnect to the database each time a
PHP-block
Hi,
When I try to do a bk pull, I have the following unexpected message :
bk pull
bk://work.mysql.com:7001: No route to host
What's wrong ?
Best Regards,
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
Hi,
I have a similar load problem when I start MySQL-4.0 and there is high
number of apache process requesting MySQL connection.
I had to shutdown and restart apache otherwise the load often goes up to 200
and more (!!). (there are more than 250 visitors always connected to the
server, so it
Hi,
Take a look here :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Best Regards,
Jocelyn Fournier
- Original Message -
From: Alexander Skwar [EMAIL PROTECTED]
To: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, December 12, 2001 10
Hi,
Try :
SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 UNION SELECT * FROM tbl3
cut UNION SELECT * FROM tbl15 WHERE title LIKE 'something' ORDER BY
date_created DESC
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: Deryck Henson [EMAIL PROTECTED]
To: MySQL [EMAIL
Hi,
A quite strange bug just occurs with MySQL 4.0 :
When I execute show processlist, I get :
mysql show processlist;
+---+-+---+++--+
---+
Hi,
Your record_buffer and sort_buffer seem far too high.
Don't forget MySQL could eat up ((sort_buffer + record_buffer) *
max_connections + key_buffer) Mo of memory.
Even with a max_connections set to 1, MySQL could eat in your case up to 7
Go of memory =)
- Original Message -
From:
Hi,
I know this problem has already been reported (but I don't remember the
solution :( ) :
I encounter the following error after installing gcc 3.0.1 and trying to
compile MySQL 4.0 :
mysqlbinlog.o(.gnu.linkonce.d._ZTV9Log_event+0x14): undefined reference to
`__cxa_pure_virtual'
Hi,
I have the solution for this problem.
Before compiling php, edit the /ext/mysql/php_mysql.c file in the php
distribution.
Then remove all the reference to mysql_connect, mysql_create_db and
mysql_drop_db :
function_entry mysql_functions[] = {
//PHP_FE(mysql_connect,
NULL)
Oups sorry, bad news :(
In fact it still doesn't works, I compiled PHP with the option --with-mysql,
so PHP used his internal mysql client :(
BTW how can I compile mysql-4.0 with the USE_OLD_FUNCTIONS option ?
Thank you,
Jocelyn Fournier
- Original Message -
From: Fournier Jocelyn
someone from the MySQL team please give us some details on
subselects
and the new load table functionality?
Best,
Kyle
On Tuesday 25 September 2001 14:29, Fournier Jocelyn [Presence-PC] wrote:
Take a look at this :)
http://www.mysql.com/doc/N/e/News-4.0.0.html
I'm currently using
Take a look at this :)
http://www.mysql.com/doc/N/e/News-4.0.0.html
I'm currently using MySQL 4.0 on two servers, and it works great :)
Union seems also to work really fine now although it remains some features
to be added before beeing perfect.
Jocelyn Fournier
Presence-PC
- Original
Hi,
I encounter a problem with a new freshly installed server : it seems
MySQL-4.0 doesn't want to create more than 254 threads.
Once I have reached this number, MySQL displays this error :
ERROR 1135: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult
Hi,
I'm using MySQL 4.0.0-alpha, and I'm wondering why sometimes I have so many
lock in my processlist (I don't see any non-locked INSERT which could cause
all the lock).
mysql show processlist;
+---+---+---++-+--+--+--
This is fixed in PhpMyAdmin 2.2.0
- Original Message -
From: Henning Schroeder [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, September 06, 2001 12:23 AM
Subject: RE: limit and order by issuse
sh Here is my query:
sh SELECT
sh
Hi,
I've just encoutered an error while compiling MySQL-4.0 :
gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/var/lib/mys
ql\ -DDATADIR=\/var/lib/mysql/var\
-DSHAREDIR=\/var/lib/mysql/share/mysql\ -DHAVE_C
ONFIG_H
Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, September 01, 2001 11:46 PM
Subject: problem while compiling mysql-4.0
Hi,
I've just encoutered an error while compiling MySQL-4.0 :
-DDEFAULT_MYSQL_HOME=\/var/lib/mys
ql
Sorry, I've just seen the problem has been already fixed by tonu in the
mysql-4.0 tree.
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Sunday, September 02, 2001 1:00 AM
Subject: Problem while compiling mysql-4.0
Hi,
This behaviour is normal. As long as you have varchar, blob or text field,
the row format used is dynamic, and so char are converted to varchar type.
If you want to convert you all your varchar to char, just execute ALTER
TABLE your_table ROW_FORMAT=fixed
Take a look at :
Hi,
I noticed an annoying behaviour with MySQL 4.0.0.
I have 11 tables with a lot of rows (about 1 Million and more) which are constantly
updated by a php script.
It seems after a shutdown of mysql (mysqladmin -uroot -p shutdown) and a restart, some
tables are corrupted (and not the same, it
Hi,
Try :
http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max-
3.23/
http://ftp.sunet.se/pub/unix/databases/relational/mysql/Downloads/MySQL-Max-
3.23/mysql-max-3.23.41-pc-linux-gnu-i686.tar.gz
Jocelyn Fournier
Presence-PC
- Original Message -
From: Jeremy
Hi,
I've just seen when the maximum connection number is reached and you try to shutdown
MySQL with mysqladmin shutdown, it couldn't be executed because of too many
connections error.
It would be smarter if mysqladmin could shutdown MySQL whatever the number of
connections, even if the
Hi,
I have more than 200 Delayed_insert running at the same time on my database (waiting
on cond state right now), and I just noticed a strange thing with the
not_flushed_delayed_rows variable :
| Not_flushed_delayed_rows | 4294967295 |
It would be quite annoying if it was true, but no, I've
- Original Message -
From: Fournier Jocelyn [Presence-PC]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 10:42 AM
Subject: Bug with not_flushed_delayed_rows in mysql-4.0 ?
Hi,
I have more than 200 Delayed_insert running at the same time on my database (waiting
on cond state
Hi,
I've just tested with MySQL 4.0, no error, but strange result :
mysql insert into visitkort (kategori_id) values (108);
Query OK, 1 row affected (0.00 sec)
mysql update visitkort set navn = 'test5' where id = last_insert_id();
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1
Take a look at :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
- Original Message -
From: Simon Green [EMAIL PROTECTED]
To: 'Fournier Jocelyn [Presence-PC]' [EMAIL PROTECTED]; Carsten
Gehling [EMAIL PROTECTED]; Sergei Golubchik [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent
Hi,
I just experienced a strange bug in MySQL 3.23.39 I couldn't explain (and couldn't
reproduce, it's why I post it on this list ;))
I misconfigured my my.cnf, so MySQL didn't found the host.frm.
The strange behaviour is just after the normal shutdown of mysql :
010717 00:01:19 mysqld
Hi,
I crash one table, and some datas are completely corrupted. However, myisamchk doesn't
seem to see any errors (I try -e, -o and -r option)...
Here is an extract of the table :
mysql SELECT * FROM forumconthardwarefr6 order by date desc limit 0,20;
Hi,
Is there any mean to not log the Aborting Connection line in the .err file ?
Thank you
Jocelyn Fournier
Presence-PC
www.presence-pc.com
- Original Message -
From: Fournier Jocelyn [Presence-PC] [EMAIL PROTECTED]
To: Tonu Samuel [EMAIL PROTECTED]
Sent: Friday, July 06, 2001 6:16 PM
Subject: Re: Annoying Aborting Connection in .err file
In fact pconnect aren't close at the end of the PHP Script. The MySQL
process stay
Hi,
Does DELETE take advantage of index to locate more quickly row to be deleted ?
Thank you :)
Jocelyn Fournier
Presence-PC
Hi,
I notice a strange behaviour with OPTIMIZE TABLE and ANALYZE TABLE (on MyISAM table) :
Before analysing my table, mysql show me :
mysql show index from forumcontpresencepc6;
80 matches
Mail list logo
