lps
Regards
Jeremy
--
Jeremy Oliver
Bluejays PC Repair
tel 020 8656 1056
mob 07855833401
www.bluejayspc.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear Sirs.
We are programers in Brasil and we are currently conducting tests with MySQL
version 3.23.49 Max working with Dephi 6.0. For testing purposes we
developed a very simple program that inserts 500 records into a table. The
folowing teste has been conducted: With the test program two statio
Dear Sirs.
We are programers in Brasil and we are currently conducting tests with MySQL
version 3.23.49 Max working with Dephi 6.0. For testing purposes we
developed a very simple program that inserts 500 records into a table. The
folowing teste has been conducted: With the test program two statio
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: S
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
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
>
> Sor
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>; <[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
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 PROT
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 P
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-alpha, for pc-linux-gnu (i686)
-=[root@anedroide]=(/usr/local/mysql-4.0)# bk export -tpatch
<(13:29:52)
# This is a BitKeeper generated patch f
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]>; "Fo
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 [Presen
---+
2 rows in set (0.00 sec)
Jocelyn
- Original 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 re
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 PROTEC
22 |
| 108096 |
| 106794 |
++
20 rows in set (0.10 sec)
Does DISTINCT implicitely check columns included in the WHERE clause ?
Thanks you.
Regards,
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
ht
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...)
>
Pe
> +-++---+
> |0001 | A | 3.45 |
> |0002 | A | 10.99 |
> |0003 | B | 1.45 |
> |0004 | D | 19.95 |
> +-++---+
> 4 rows in set (0.00 sec)
>
> QUESTION: I had expected 7 rows - where did the rest go?
Tr
ookie'
Data records: 95289
[root@forum] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI
-rw-r--r--1 root root 1577984 Mar 12 01:56 cookie.MYI
Why does the MYI is know nearly twice as big as the old cookie.MYI fil
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:
] /home/mirror/mysql/Hardwarefr> ls -la cookie.MYI
-rw-r--r--1 root root 1577984 Mar 12 01:56 cookie.MYI
Why does the MYI is know nearly twice as big as the old cookie.MYI file ?
Thanks you !
Jocelyn Fournier
Presence-PC
-
Hi,
Take a look here :
http://www.mysql.com/doc/A/L/ALTER_TABLE.html
Regards,
Jocelyn Fournier
- Original Message -
From: "Jarkko Toivonen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 09, 2002 9:59 PM
Subject: Changing datatypes "on the fly"?
> I have a column d
al Message -
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 en
.
Regards,
Jocelyn Fournier
- Original Message -
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:
| 1 | 0 |
+-++-+---++
2 rows in set (0.00 sec)
How could this be possible with a heap table ??
Thank you :)
Regards,
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
htt
Hi,
Perhaps try to suppress -e and -f switch ?
Regards,
Jocelyn Fournier
- Original Message -
From: "Eric Mayers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 02, 2002 12:27 AM
Subject: myismchk messages (too small length)
I'm running myisamchk (when the database
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
ttp://www.mysql.com/doc/N/e/News-4.0.2.html)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 12:19 AM
Subject: Indexing fails, myisamchk cannot repair, no error
ELECT * FROM table 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]>; "
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: &qu
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]>
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, Feb
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
Pr
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
}
else
{
DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
}
Like this it works perfectly for me :)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Sasha Pachev&q
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 do
}
else
{
DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
}
Like this it works perfectly for me :)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Sasha Pachev&q
}
else
{
DBUG_PUSH(argument ? argument : "d:t:o,/tmp/myisamchk.trace");
}
Like this it works perfectly for me :)
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Sasha Pachev&q
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 do
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]" <[
see only myisamchk -o can fixed this in my case)
Thank you :)
Best Regards,
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
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 a
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 Fourn
Hi,
Try :
SELECT a,COUNT(*) AS z FROM aa GROUP BY a HAVING z>1;
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 qu
ssage -
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,
> >
>
(it
should be really fast 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
ULL |
2026032 | Using index; Using temporary |
+---+---+---+-+-+--+
-+--+
1 row in set (0.00 sec)
Why does it take so much time to remove duplicates in only 58 rows ??
Thank you :)
Regards,
Jocelyn Fournier
Presence-PC
---
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
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
z2 )
Best Regards,
Jocelyn Fournier
Presence-PC
www.presence-pc.com
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, Januar
it failed :
checking return type of sprintf... configure: error: can not run test
program while cross compiling
Any idea of what I have to do to run the compilation successfully ?
Thank you in advance,
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Sinisa Milivo
Hi,
It should be really soon, Monty wrote me today he was building a
distribution with the current 4.0.1 code...
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Franklin Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, Dec
AIL PROTECTED]>
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,
> >
> >
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: &qu
hanks in advance,
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL P
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 PROTE
is problem...
Thanks in advance :)
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Arndt Jenssen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 8:27 PM
Subject: High load problem with 3.23.45
> Maybe some coding/mysql maste
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 pos
Hi,
Try :
SELECT * FROM tbl1 UNION ALL SELECT * FROM tbl2 UNION SELECT * FROM tbl3
UNION SELECT * FROM tbl15 WHERE title LIKE 'something' ORDER BY
date_created DESC
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Deryck Henson" <[EMAIL
|
| NULL
|
| 40939 | mysql | localhost | Hardwarefr | Sleep | 0|
| NULL
|
| 40940 | mysql | localhost | Hardwarefr | Sleep | 0|
| NULL
|
| 40941 | mysql | localhost | Hardwarefr | Sleep | 0|
| NULL
|
+---+-+---+----
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: "
SQL compile ?
Thank you !
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail &l
er Jocelyn [Presence-PC]" <[EMAIL PROTECTED]>
To: "Willem Scholten" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, October 21, 2001 12:31 AM
Subject: Re: Mysql 4.0.0-alpha and php-4.0.6 and Apache
> Hi,
>
> I have the solution for this problem.
>
,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Willem Scholten" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 17, 2001 9:20 PM
Subject: Mysql 4.0.0-alpha and php-4.0.6 and Apache
> After I have build Mysql-4.0.0-alpha from sou
I'm sending variables in an HTML request such as
http://localhost/connexion.php?ID1=&ID2=
When the variable ID2 is numeric, everything is OK and the query made by
PHP (such as SELECT my_table WHERE ident1 = $id1, ident2=$id2;) works very
well.
The column ident2 in mySQL is defined as a VARCHAR(
we
> have been able to write our own complex code to do this, but it is far
from
> the level of automation that we want.
>
> Could someone from the MySQL team please give us some details on
subselects
> and the new load table functionality?
>
> Best,
> Kyle
>
> On Tuesday 25 Sep
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
- Ori
!
Jocelyn Fournier
Presence-PC
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To u
ql | localhost | Hardwarefr | Sleep | 15 | |
NULL
|
| 42298 | mysql | localhost | Hardwarefr | Sleep | 2| |
NULL
|
+---+---+---++-+--+--+--
----
+
204 rows in set (0.00 sec)
Any idea ??
Thank you :)
Jocelyn Fournier
Presence-PC
-
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>
articleId,arttitle,artsourc
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
- Original 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 :
>
e] Error 1
make[1]: Leaving directory `/usr/local/mysql-4.0'
make: *** [all-recursive-am] Error 2
./BUILD/compile-pentium 372.92s user 97.04s system 146% cpu 5:20.54 total
I'm using bk pull / bk -r edit / ./BUILD/compile-pentium standard procedure.
I'v
Hi people
I am using mySQL and PHP for my web page database management thingy. I've
managed to get my date field from my Table into my page ($myDate). I was
wondering, how would I format the date from -MM-DD format to something a
bit nicer like DD/MM/YY ?
Is this meant to be a SQL side thing
at :
http://www.mysql.com/doc/D/y/Dynamic_format.html
http://www.mysql.com/doc/S/t/Static_format.html
Jocelyn Fournier
Presence-PC
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 19, 2001 12:23 AM
Subject: CHAR transformed to V
Hi people,
Anyone know how to get a field in one of my table in a form that any number
that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for
the cost instead of 0.2?
Or do I have to do this with the Server Side Language I'm using to format
the value? Or some extra SQL command
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: "J
inst new record at 30946868
Duplicate key 1 for record at 30978024 against new record at 30946900
Data records: 977538
myisamchk: warning: 11 records have been removed
Any idea ? (hardware related or mysql related ?)
Thank you :)
Jocelyn Fournier
Presence-PC
ections, even if the maximum connection ratio is reached.
What do you think about it ?
Jocelyn Fournier
Presence-PC
www.presence-pc.com
- 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
27;ve not inserted so many rows :D
Is there anything wrong with it ? (I unfortunately don't succeed in reproducing this
bug on my second server)
Thank you.
Jocelyn Fournier
Presence-PC
www.presence-pc.com
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 PROTECTE
0 |0 |0 | 0 ||
|||
++-+---+---+-++-+-+---+-
-+-+-+---+--+--+-+--
--++++
Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Carsten Gehling" <[EMAIL PROTECTED]>
To: "Sergei Golubchik" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 12:06 PM
veral times to reproduce the bug, no way :(
The server is perfectly stable and was running for days MySQL without a glitch, it's
why I don't think the hardware could be involved in this issue.
Do you have any idea of how it could have been happened ?
Thank you,
Jocelyn Fournier
Presence-PC
e le répertoire `/usr/local/mysql-4.0'
make: *** [all-recursive-am] Erreur 2
What should I do to fix the error ?
Thank you,
Jocelyn Fournier
Presence-PC
Thanks a lot !
Jocelyn Fournier
Presence-PC
dwarefr1 | repair | error| Can't find file:
|'threadhardwarefr1.MYD' (errno: 2) |
+--++--+-+
1 row in set (0.00 sec)
MYD file is here, but MYI is missing...
Thank you !
Jocelyn Fournier
Presence-PC
- 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&#x
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
Hi,
Does DELETE take advantage of index to locate more quickly row to be deleted ?
Thank you :)
Jocelyn Fournier
Presence-PC
| NULL | |
+--++---+--+-+---+-+--++-+
3 rows in set (0.00 sec)
Is this behaviour OK ?? (I was assuming OPTIMIZE TABLE request wasn't resetting the
cardinality information)
Thanks,
Jocelyn Fournier
Presence-PC
www.presence-pc.com
91 matches
Mail list logo
