Just curious : if there's no index on the column why don't you try to
add one ? That's probably why it takes a lot of time on the production
machine.
Jocelyn
Le 04/03/2009 18:26, Morten Primdahl a écrit :
Thanks for all the suggestions. The caching must be done somewhere else.
There is no
MySQL Key buffer and OS cache could also have an impact.
Have you tried disabling the Key Buffer first ?
Jocelyn
Le 04/03/2009 18:26, Morten Primdahl a écrit :
Thanks for all the suggestions. The caching must be done somewhere
else. There is no index on the column and there are about 500.00
If SQL_NO_CACHE is specify, the cache will never be used :
The Query Cache behaviour is quite simple, it uses the exact given query
syntax as a hash to search into the query cache;
it means writing 'select' or 'SELECT' is different. It also means adding
SQL_NO_CACHE will search in the cache for
Hi,
Could try your script with the key_buffer set to 0 ?
Regards,
Jocelyn Fournier
[EMAIL PROTECTED] a écrit :
Hello,
Thanks for you help. You can see the results in the .err file below. I've
run it twice while the algorithm was running, but my knowledge in MySQL is
still too po
.
On 6/23/08, *Jocelyn Fournier* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi,
Oops, indeed, C is a primary key :)
But what's weird is MySQL is using a ref type for the join between B
and C, and not an eq_ref.
Could you check B.KR_ID and C.KR_ID are
words,kr_id) on B,
c.kr_id is a primary key.
Let me talk to my dev and check why they are using derived. Thanks for
noticing this.
On 6/23/08, *Jocelyn Fournier* <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Hi,
AFAIK, to optimize your query you should have
N ('CAMERA') and B.KR_ID = C.KR_ID and C.CLUSTER_ID =
A.CLUSTER_ID limit 40
Regards,
Jocelyn Fournier
Ananda Kumar a écrit :
explain select * from (select A.LEAF_CATEG_ID, A.CLUSTER_ID, A.SIGNATURE,
A.IS_NULL, A.HEIGHT, A.NO_LISTINGS, A.NO_SUCC_LISTINGS,
A.TOTAL_QTY,A.SOLD_Q
).
Regards,
Jocelyn Fournier
www.mesdiscussions.net
mos a écrit :
At 03:54 PM 1/25/2007, you wrote:
> Another thing to consider is:
heh, silly mail client :). Another thing to consider is this:
http://dev.mysql.com/doc/falcon/en/index.html
Though it's "Not recommended for p
Hi,
SELECT products.sku, products.title, products.price,
qty_price.qty, qty_price.qprice
FROM products LEFT JOIN qty_price ON (products.sku = qty_price.qsku)
WHERE products.vendor_id=15 AND products.category='widgets';
should do what you want.
Regards,
Jocely
Hi,
Thanks for the answer.
I don't think this is what's happening because I can also see within a
few seconds :
0
48
0
48
0
for example.
Thanks,
Jocelyn
Michael Loftis a écrit :
--On September 5, 2006 3:18:21 PM +0200 Jocelyn Fournier
<[EMAIL PROTECTED]> wrote:
H
Hi,
I encounter a really strange behaviour with some of my slaves servers :
I'm using MySQL 4.1.20 x86_64 on both master and slave servers.
If I issue three times the command SHOW SLAVE STATUS several times in a
few seconds, I could obtain the following results for the
Seconds_Behind_Master co
Hi,
It could be usefull when you need to wait the slave to be in sync with
the master, after some specific queries for example.
Regards,
Jocelyn
wangxu a écrit :
> Slave server should automatically catch up master server when it be started.
>
> When i need use master_pos_wait?
--
MySQL Gen
Hi,
Excepted if he found a bug in an older version of MySQL, it's of course
false ! (it would be a major issue which would make MySQL just unusable)
Regards,
Jocelyn
David Rabinowitz a écrit :
Hi,
We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old
server we tried not t
Hi,
I think you should change the tmpdir variable value to a directory which
have enough room to create your temp big table (by default, it points
to /tmp dir).
Regards,
Jocelyn
Patrick Herber a écrit :
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since
Hi,
What about SELECT count(*) FROM table1 - SELECT count(*) FROM table1
WHERE status = 1 ? (this query should be mush faster)
Regards,
Jocelyn
jpow wrote:
Hi everyone, I have this problem of slow "count *" when I use a where clause.
1. I have a table of ~1m rows.
2. There is a "status" c
Hi,
Are you using MySQL-4.1 ? (ON DUPLICATE KEY syntax has been introduced
in 4.1)
Regards,
Jocelyn
Siegfried Heintze wrote:
Thanks for deciphering that terrible message, Shawn. I accidentally must
have hit the paste key too many times.
Anyway, here is my new insert statement:
INSERT IN
Hi,
I've already seen this problem with gcc 4.0, I have to change
size_socket declaration to socklen_t.
Anyway, you won't be able to compile properly MySQL because of a bug in
gcc 4.0 which will be fixed in 4.0.1.
Take a look at
http://gcc.gnu.org/bugzilla/show_bug.cgi?id=21173
for more details.
Hi,
This is a known bug which will be fixed in MySQL 4.1.11.
See
http://bugs.mysql.com/bug.php?id=8675
and
http://bugs.mysql.com/bug.php?id=8147
Regards,
Jocelyn
Eli wrote:
Hi,
I got this table:
+--+-+--+-+-+---+
| Field| Type| N
Hi,
For me it sounds like a glibc issue.
BTW, currently the 4.1.10a build is compiled against glibc-2.2, does
MySQL plan to build next releases against glibc-2.3 which seems to
handle much better a high number of simultaneous connected threads ?
Thanks !
Jocelyn
Gleb Paharenko wrote:
Hello.
P
Hi,
It seems your latest resolve is wrong. (perhaps you've done it against
4.1.10 symbols ?)
Doing it on 4.1.10a symbols gives me :
0x808b193 handle_segfault + 423
0x82debe8 pthread_sighandler + 184
0x80dbbf8 MYSQL_LOG::write(Log_event *) + 1564
0x80b3caf close_temporary_tables(THD *) + 247
0x808
Hi,
The only limit I'm aware of is the size of a query itself, which can not
be bigger than the max_allowed_packet size.
Regards,
Jocelyn
Mauricio Pellegrini a écrit :
Hi ,
I'm using mysql 4.1.4 gamma with InnoDB suse 8.2 reiser fs.
I'am doing backups using mysqldump which creates a sql scrip
Hi,
It could perhaps be related to bug #8147.
http://bugs.mysql.com/bug.php?id=8147
Regards,
Jocelyn
Aleksandr Guidrevitch a écrit :
Hi all !
I'm having problem with INSERT ... ON DUPLICATE KEY UPDATE on mysql 4.1.10
--8<--8<--8<--8<--8<--8<--8<--8<--8<
INSERT
ts | 11156553 |
| Qcache_inserts | 1945643 |
| Qcache_lowmem_prunes| 372898 |
| Qcache_not_cached | 509594 |
| Qcache_queries_in_cache | 4101 |
| Qcache_total_blocks | 11000|
+-+--+
On Wed, 2005-03-09 at 20:19, Jocelyn Fou
Hi,
How many questions for thoses results ?
There's a lot of lowmem_prunes, so I would indeed increase the memory
size to reduce the risk of lowmem_prunes.
What is your query_cache_limit ?
Jocelyn
Mauricio Pellegrini a écrit :
Thanks, this the result of show status like "qcache%"
+
Hi,
I was assuming USE INDEX was only telling MySQL which INDEX it needed to
use, but it seems to be not always the case.
With MySQL 4.1.10, USE INDEX(topic) for the following query seems to change
the way the index is used.
mysql> EXPLAIN SELECT numreponse FROM searchjoinhardwarefr13 WHERE
id='
Hi,
I've just encountered a strange problem when trying to update a table :
UPDATE searchmainhardwarefr0, searchjoinhardwarefr0 SET
searchmainhardwarefr0.numeropost=searchjoinhardwarefr0.topic WHERE
searchmainhardwarefr0.numreponse=searchjoinhardwarefr0.numreponse;
ERROR 1114 (HY000): The table '
Hi,
This could also be a badly corrupted table, what does CHECK TABLE / REPAIR
TABLE report ?
Regards,
Jocelyn
- Original Message -
From: "Kevin A. Burton" <[EMAIL PROTECTED]>
To:
Sent: Monday, January 03, 2005 10:04 PM
Subject: MySQL 4.1.7 allows non-unique values in a unique index?
Hi Vlad !
Why not using
select (select min( a ) is null from a) or null;
as a workaround ?
Regards,
Jocelyn
- Original Message -
From: "Vlad Shalnev" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 03, 2004 7:01 AM
Subject: Re: Comparing bug in 4.1.7
>
>
> Sergei
running on this table, which could
lock the table (and thus explain why sometimes it takes up to 22 seconds) ?
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROT
find the result, and
putdatetime to order the result.
If you add topcategory in your query, you will see MySQL will use the index
(put, front, topcategory, putdatetime) without filesorting.
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schipper
Hi,
The only reason which could explain this is that statistics about the second
query are perhaps not uptodate.
Did you try to do an ANALYZE TABLE on it ?
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]&
Are you sure this not because your query is cached by the MySQL query cache
now ? (try RESET QUERY CACHE before testing your query to be sure)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: "Joce
e row in the right order directly.
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, September 18, 2004
Hi,
You can try to add an index on (put,front,topcategory,putdatetime) to avoid
MySQL has to do a filesorting on the data returned. (I assume you're using
MySQL 4.x)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Dirk Schippers" <[EM
Hi,
If you're using 4.0.20, jump to 4.0.21 :
"Fixed crash in MATCH ... AGAINST() on a phrase search operator with a
missing closing double quote."
Regards,
Jocelyn
> Hi,
>
> Our mysqld segfaults from time to time on our system. We don't see any
> other programs segfaulting, and therefore suspect a
Hi,
A quick fix would be to set the wait_timeout variable in the my.cnf to a
much smaller value than 28800 (default value).
Try to add wait_timeout=60 in the my.cnf for example, the connections should
be automatically closed after 60 secondes if there are not used anymore.
Regards,
Jocelyn
Hi,
AFAIK, date is *not* a reserved keyword, not need to backtick it :)
Regards,
Jocelyn Fournier
www.presence-pc.com
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "fgmmoribe" <[EMAIL PROTECTED]>
Cc: "mysql" <[EMA
Hi,
Add
skip-log-warnings
in your my.cnf. log-warnings seems to have been enabled by default since
4.0.19.
Regards,
Jocelyn
- Original Message -
From: "Don MacAskill" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 08, 2004 11:29 AM
Subject: Aborted connection error
Yes indeed, Lenz is preparing the build and has updated the news section.
(let's hope no critical bugs will be discovered which could slip the release
:))
Jocelyn
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier"
roduction
> > release if goes N days without a major bug report. Thus, even if 4.1.3
is
> > released as alpha, it could retroactively be declared beta, and then
even
> > release -- although that's pretty unlikely. The long and short of it
> > though, is that nobody can te
Hi,
AFAIK 4.1.3 should be beta.
Regards,
Jocelyn
- Original Message -
From: "John Murphy" <[EMAIL PROTECTED]>
To: "Emmanuel van der Meulen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 09, 2004 12:31 AM
Subject: Re: Production release of MySql 4.1
> Emmanuel van
Hi,
I'm using MySQL 4.0.18-max (same problem with 4.0.18-standard) on one
server, and I encounter a strange problem :
When I make some change on a table (adding index for exemple), at the end of
the ALTER process all the queries that must write on this table switch in
the "Waiting for table" stat
Hi,
If all your fields have a fixed length, you can change the type of the table
by doing :
ALTER TABLE your_table ROW_FORMAT=fixed;
Regards,
Jocelyn
- Original Message -
From: "Merten Christian" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, Februar
So take a look here :
http://bugs.php.net/bug.php?id=19529
and upgrade your PHP version, since it's fixed in PHP 4.3.x ;)
Jocelyn
- Original Message -
From: "Free Grafton" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Sent: Tues
Hi,
Do you use PHP ? If so, which version is installed ?
Regards,
Jocelyn
- Original Message -
From: "Free Grafton" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 26, 2003 10:05 PM
Subject: How to Track error - Commands Out of Sync
> We are currently running about
Hi,
ON DUPLICATE KEY UPDATE is only available with MySQL 4.1.x.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 8:32 AM
Subject: Insert...on duplicate key update
> >Description:
> I have been writing an update progr
Hi,
What about upgrading to MySQL 4.0.13 ?
4.0.0 is not a "production" release, and a lot of bugs have been fixed
between 4.0.0 and 4.0.13.
Regards,
Jocelyn
- Original Message -
From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 24, 2003 11:13 P
The 'user' table in the 4.3.7 chapter is a table used by the authentication
system in MySQL :)
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Grégoire Dubois"
<[EMAIL PROTECTED]>
Cc: &q
evelopment" <[EMAIL PROTECTED]>
To: "'Jocelyn Fournier'" <[EMAIL PROTECTED]>
Cc: "'Mysql'" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 12:38 AM
Subject: RE: Can we crypt passwords on MySQL
Jocelyn
Why is that not recommended ?
Hi,
Using PASSWORD function to crypt password is not recommended, it's mainly
used for internal mysql password encryption.
Prefer using MD5/SHA1 functions to encrypt a password.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Grégoire Dubois" <[EMAIL PROTECTED]>
Hi,
What do you call "hung up" ? All query appearing in "opening table" state
when doing a show processlist ?
If this is the case, I'm experiencing the same problem here with Linux.
Regards,
Jocelyn
- Original Message -
From: "LS" <[EMAIL PROTECTED]>
To: "Ted Rogers" <[EMAIL PROTECTED]
Hi,
Or simply use perror 28 :)
[EMAIL PROTECTED]:~$ perror 28
Error code 28: No space left on device
Regards,
Jocelyn
- Original Message -
From: "Brian Reichert" <[EMAIL PROTECTED]>
To: "Minal Amle" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 04, 2003 9:06 AM
Sub
Hi,
I opened today a bug report for a similar bug here :
http://bugs.mysql.com/bug.php?id=189
This problem only happens with DELAYED thread.
Regards,
Jocelyn
- Original Message -
From: "Sasa Ugrenovic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 25, 2003 5:37 PM
Su
Hi,
The right DELETE syntax is :
delete from where id > 5;
Regards,
Jocelyn
- Original Message -
From: "Anil Garg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 06, 2003 6:26 PM
Subject: command line exectution of query(newbie)
> Hi,
>
> What am i doing wrong:
>
Hi,
AFAIK, Aux is indeed a special filename in Windows (if I execute Aux under
the W2K console, it opens the "open with" window).
Regards,
Jocelyn
- Original Message -
From: "Pedro Vasconcelos" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Satur
Hi,
I just want to confirm MySQL 4.0.8 seems to be broken too. However MySQL
4.1 is working fine with this testcase.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 6:32 AM
Subject: non-unique indicies in HEAP tab
Hi,
I'm trying to use to following HANDLER syntax :
HANDLER tbl_name READ index_name=(value1);
However I fail since I don't know what is 'index_name' for a PRIMARY KEY (I
already tried PRIMARY, `PRIMARY KEY`, and the column name without success).
Any idea ?
BTW, are HANDLER statements cached b
Hi,
The performance problem on his query was due to the missing index on join
columns.
However I was assuming using table1 INNER JOIN table2 ON condition would
have helped the optimiser to choose the tables on which it had to perform
the join.
Regards,
Jocelyn
- Original Message -
From
Hi,
I think you'd better add an unique ID to both table defined as int
corresponding to each seq_ID, and then do the join on this ID rather than on
Seq_ID (join on varchar is far from the fastest solution :)) (unless seq_ID
could be converted into int directly ?)
(but it takes time, even for me (
Hi,
I assume you are speaking about this comment :
"++--+--+--
+
| Table | Op | Msg_type |
Msg_text |
++--+--+--
+
| database.table_name | optimize | error | 28
when fixing table |
| da
)
The load average is roughly 0.7.
Regards,
Jocelyn
- Original Message -
From: "W. D." <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; "Michael She" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>;
Hi,
I'm using MySQL on a database with 134 Millions of rows (10.9 GB) (some
tables contains more than 40 millions of rows) under quite high stress
(about 500 queries/sec avg). (using HEAP, MyISAM and InnoDB tables)
I never experienced any losses, *even with MySQL-4.1* (yes, I'm currently
using 4.1
Hi,
I assume it's because MySQL returns more than 30% of the totally of the
rows.
On one of my table, with 4.0.6-gamma :
mysql> SELECT COUNT(*) FROM news;
+--+
| COUNT(*) |
+--+
| 4985 |
+--+
1 row in set (0.00 sec)
mysql> SELECT COUNT(*) FROM news WHERE datec< '2000-
Hi,
You should downgrade automake to 1.5 and if it still doesn't work, try with
autoconf 2.52.
Regards,
Jocelyn
- Original Message -
From: "gnu_is_not_unix" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 8:52 PM
Subject: Re: Compiling 3.23.54-1 - new tool
Hi,
About "bk -r get -Sq", after a bk pull, is "bk -r edit" still needed or
"bk -r get -Sq" could replace it ?
Thanks and regards,
Jocelyn
- Original Message -
From: "Lenz Grimmer" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 12, 2002 2:56 PM
Subject: Re: The Man
Hi,
A "dirty" solution would be to search :
field LIKE '% one %' or field LIKE 'one %' or field LIKE '% one' or
field='one';
Regards,
Jocelyn
- Original Message -
From: "Beauford.2003" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, December 10, 2002 12:50 AM
Hi,
if ($var=='grade_num')
$filter='DESC';
else
$filter='ASC';
$fetch = mysql_query("SELECT * FROM players ORDER BY $var $filter");
should work.
Regards,
Jocelyn
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Monday, December 09
Hi,
Try also to download 4.0.5a (not 4.0.5), this version could solve your load
problem (due to a problem with the glibc used during the build)
Regards,
Jocelyn
- Original Message -
From: "Josh Marcus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 2:16 AM
Hi,
If you are using mysql_pconnect, your connections will not be closed at the
end of the script, even if mysql_close is used.
Regards,
Jocelyn
- Original Message -
From: "cristian ditoiu" <[EMAIL PROTECTED]>
To: "Dan Nelson" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday
Hi,
MySQL-4.0.5a is compiled again a new patched glibc library, to prevent from
MySQL having any load issues (which was the case on some systems).
Features are exactly the same between 4.0.5 and 4.0.5a.
Regards,
Jocelyn
- Original Message -
From: "Ray Elenteny" <[EMAIL PROTECTED]>
To:
Hi,
John :
I don't see any connection between corereader and this known bug in
MySQL-4.0.4 ??
Bill :
AFAIK, this problem has been fixed in MySQL-4.0.5, just take a look at the
changelog :
"Fixed a newly introduced bug that caused ORDER BY ... LIMIT # to not return
all rows. "
http://www.mysql.co
Hi,
No, you should set it to 4 if you have 2 CPU :) (2*2 ;))
Regards,
Jocelyn
- Original Message -
From: "Jacob Friis Larsen" <[EMAIL PROTECTED]>
To: "Mysql maillist" <[EMAIL PROTECTED]>
Sent: Monday, November 25, 2002 8:46 AM
Subject: thread_concurrency (Try number of CPU's*2 for threa
don't forget
FROM table1,table2 ;)
:
SELECT name, table1.position, table2.position
FROM table1,table2
WHERE table1.name=table2.name;
Regards,
Jocelyn
- Original Message -
From: "Dennis Salguero" <[EMAIL PROTECTED]>
To: "Osman Omar" <[EMAIL PROTECTED]>; "MySQL" <[EMAIL PROTECTED]>
Sent
Hi,
Try :
SELECT table1.name,table1.position,table2.position FROM table1 LEFT JOIN
table2 USING(name);
Take a look here :
http://www.mysql.com/doc/en/JOIN.html
Regards,
Jocelyn
- Original Message -
From: "Osman Omar" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Saturday,
Hi,
Take a look here :
http://www.mysql.com/doc/en/DATETIME.html
"Automatic updating of the first TIMESTAMP column occurs under any of the
following conditions:
a.. The column is not specified explicitly in an INSERT or LOAD DATA
INFILE statement.
b.. The column is not specified explicitly i
Hi,
Yes it works, but you can't insert and select data from the same table with
this syntax.
Regards,
Jocelyn
- Original Message -
From: "Mirza Muharemagic" <[EMAIL PROTECTED]>
To: "Eric" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 12:30 AM
Subject: Re: I
Hi,
Could you give us SHOW CREATE TABLE your_table ?
Greetings from France too ;)
Jocelyn
- Original Message -
From: "BPF Webmaster" <[EMAIL PROTECTED]>
To: "MySQL" <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 2:25 PM
Subject: Duplicate key delete record with same key
> Usin
I just want to add that unlike what it is printed ("Download BitKeeper from
http://www.bitmover.com/cgi-bin/download.cgi. You will need Bitkeeper 2.0 or
newer to access our repository."), Bitkeeper 3.x seems to be needed.
Perhaps the manual should be updated :)
Regards,
Jocelyn
- Original M
Hi,
Take a look here :
http://www.mysql.com/doc/en/Installing_source_tree.html
Regards,
Jocelyn
- Original Message -
From: "Daniel Kiss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 21, 2002 11:58 AM
Subject: Where is 4.1 source
> Hi all,
>
> Where can I downl
Hi,
Perror 13 means :
perror 13
Error code 13: Permission denied
So it seems you don't have the permission to create the temporary table is
this directory.
Regards,
Jocelyn
- Original Message -
From: "Stefan Hinz" <[EMAIL PROTECTED]>
To: "MySQL Main List" <[EMAIL PROTECTED]>
Sent: M
Hi,
It's known bug of PHP, which has just been fixed in 4.3 CVS.
Use mysql_connect instead of mysql_pconnect as a workaround of the problem.
(or get the latest CVS version of php 4.3.0)
For more infos :
http://bugs.php.net/bug.php?id=19529
Regards,
Jocelyn
- Original Message -
From:
Hi,
In fact it seems the list have had some problems this week-end, as sent
messages seems to have been delayed of about 1 day.
Regards,
Jocelyn
- Original Message -
From: "Bryant Hester" <[EMAIL PROTECTED]>
To: "'Siomara Pantarotto'" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Mo
Hi,
perhaps try :
ORDER BY SUBSTRING_INDEX(your_field, '-', 1) asc,SUBSTRING_INDEX(your_field,
'-', 2) asc,SUBSTRING_INDEX(your_field, '-', 3) asc;
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 13, 2002 4:38 PM
Subject
Hi,
This is a known bug of PHP :
http://bugs.php.net/bug.php?id=19529
A quick fix for this problem is to use mysql_connect instead of
mysql_pconnect.
Regards,
Jocelyn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 11, 2002 7:09 PM
Subjec
Hi,
It remains some bugs in MySQL 4.1 subselect implementation which are on the
way to be resolve. (take a look at the [EMAIL PROTECTED])
Also, support for IN subselect are not yet available (you can find the code
in reading the bk commit, but it's not yet push).
Lastly, subselect are not yet opti
Hi,
I don't see any "group" column in your table, are you displaying the right
table (describe pupils; instead of describe pupuils; ?).
A KEY column is a column which have an INDEX on it.
Regards,
Jocelyn
- Original Message -
From: "3mip1s4la-Emilio Pisanty" <[EMAIL PROTECTED]>
To: "R.
just kill mysqld_safe and then the mysqld process :)
(but AFAIK all the mysql thread are names mysqld ??)
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; "Jack Chen" <[EMAIL PROTECTED]&g
Hi,
Why not trying killall -9 mysqld ?
Regards,
Jocelyn
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Jack Chen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 09, 2002 12:08 PM
Subject: Re: mysqld refuse to die
> Hi,
> If you really wish to ki
What is the handler for Collaborate ?? (What does "show create table
Collaborate" display ?)
- Original Message -
From: "David Herring" <[EMAIL PROTECTED]>
To: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, November 08, 2002 2:29 AM
Subj
Hi,
In fact, it's :
joce@forum:~$ perror 124
Error code 124: Wrong medium type
124 = Wrong index given to function
but the solution to resolve the problem remains the same ;)
Regards,
Jocelyn
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi,
After a little search, it seems to mean to "treat BIGINT as INT".
Regards,
Jocelyn
- Original Message -
From: "Arthur" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 25, 2002 4:59 PM
Subject: Connection
> Hello mysql,
>
> Often I've seen OPTION=16384 in a con
Hi,
The problem comes from PHP :
http://bugs.php.net/bug.php?id=19529
Regards,
Jocelyn
- Original Message -
From: "Willem Bison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 23, 2002 11:06 AM
Subject: "Commands out of sync" using PHP
> I'm getting lots of ran
Hi,
In fact, I think you run out of disk space.
You MYD takes 135 GB.
You have 375 GB free
When MySQL try to add the index on your database, it copies the MYD and frm
under a #sql* name.
So again 135 GB are eaten again.
So it remains 240 GB to build the index file, so it's possible you run out
of
Hi,
[root@forum] /usr/local/mysql/var> perror 136
Error code 136: Unknown error 136
136 = No more room in index file
Are you sure your file system can handle the size of your index file ?
Regards,
Jocelyn
- Original Message -
From: "Chris Stoughton" <[EMAIL PROTECTED]>
To: <[EMAIL PRO
Hi,
Run mysqld_safe with the --log-bin switch (it will recreate a new bin log at
each crash, so it's much more simple to see which query is responsible for
the crash).
Regards,
Jocelyn Fournier
- Original Message -
From: "Eric" <[EMAIL PROTECTED]>
To: <[EM
Hi,
perror 28
Error code 28: No space left on device
Make some space on your hard disk ;)
Regards,
Jocelyn
- Original Message -
From: "tl" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 11, 2002 10:55 AM
Subject: Repair TABLE - OPERATION FAILED
> Hello,
> Please
Hi,
Well, why not trying... concat() :)
SELECT concat(numer,',',text) FROM Table;
http://www.mysql.com/doc/en/String_functions.html
Regards,
Jocelyn Fournier
- Original Message -
From: "MySQL" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thur
Regards,
Jocelyn
- Original Message -
From: "Heikki Tuuri" <[EMAIL PROTECTED]>
To: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
--+-++
> 3 rows in set (0.00 sec)
>
> So it seems ORDER BY + WHERE primarykey LIKE 'abc%' ORDER BY primarykey
DESC
> works fine now.
>
> Regards,
> Jocelyn
> - Original Message -
> From: "Heikki Tuuri" &l
| 2002-09-18 20:37:31 | 1360 |
+---+-++
3 rows in set (0.00 sec)
So it seems ORDER BY + WHERE primarykey LIKE 'abc%' ORDER BY primarykey DESC
works fine now.
Regards,
Jocelyn
- Original Message -
From: "Heikki Tuuri" <[EMAI
1 - 100 of 158 matches
Mail list logo