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
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
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
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 poor
') 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_QTY, A.ASP, A.NO_BIDS
,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 :
1 index
.
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 of the same data
).
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 production use
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,
Jocelyn Fournier
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
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:
Hi,
Any idea
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
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).
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
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
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
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
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|
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.
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
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 INTO
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
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%
|
| 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 Fournier wrote:
Hi,
How many questions
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
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: mysql@lists.mysql.com
Sent: Monday, January 03, 2005 10:04 PM
Subject: MySQL 4.1.7 allows non-unique values
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
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]
To: Jocelyn Fournier
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 [EMAIL PROTECTED]
To: [EMAIL
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 bug
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 [EMAIL PROTECTED]
Sent: Tuesday, July 27, 2004 7:11 AM
Subject
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
, is that nobody can tell you how long until 4.1 will go beta.
-JF
-Original Message-
From: Jonathan Soong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 29, 2004 7:20 PM
To: Jocelyn Fournier
Cc: John Murphy; Emmanuel van der Meulen; [EMAIL PROTECTED]
Subject: Re: Production
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 [EMAIL PROTECTED]
Cc: Andrew Pattison
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 der Meulen
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 state
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, February 09,
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 50
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: Tuesday, August 26, 2003 10:23 PM
Subject: Re: How
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 program in
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 PM
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]
Cc:
[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 ?
Do you have any links for how to encrypt the password with MD5 ?
Freddie
-Original
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: 'Mysql' [EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 12:42
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]; [EMAIL
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
Subject: Re:
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
Hi,
The right DELETE syntax is :
delete from table name 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: Saturday,
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 tables
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
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 -
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
)
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]; Muruganandam [EMAIL PROTECTED]
Sent: Wednesday, December 18, 2002 5:38 PM
Hi,
I assume you are speaking about this comment :
++--+--+--
+
| Table | Op | Msg_type |
Msg_text |
++--+--+--
+
| database.table_name | optimize | error | 28
when fixing table |
|
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 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
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 Manual on
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 tools
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, 2002
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
Subject:
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.
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
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
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,
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: Saturday,
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 download
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
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
Using PHP
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: INSERT
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: Monday,
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,
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: Monday,
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
Subject:
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
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 kill the
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];
[EMAIL PROTECTED]
Sent: Saturday, November 09, 2002 12
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. Hannes
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]
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
Subject: Re:
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 connection
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 random
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
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: [EMAIL PROTECTED]; [EMAIL PROTECTED
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 help
|
+---+-++
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 [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Jocelyn Fournier [EMAIL
Zawodny [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: Jocelyn Fournier [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 8:25 PM
Subject: Re: InnoDB: Assertion failure in file
PROTECTED]
To: Jocelyn Fournier [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 9:28 PM
Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
Jocelyn
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: Thursday, September 26, 2002 8:46 PM
Subject
Hi Jeremy,
Same problem for me, I submitted a bug report with a repeatable testcase
yesterday to the bugs list.
Reading the source code and changeset 1.1287, it appears this part of the
source code should be desactivated ?
(ChangeSet
1.1287 02/09/15 02:23:53 [EMAIL PROTECTED] +2 -0
queries was apparently put to the wrong place in ha_innodb.h. The
assertion
I had added to 4.0.4 revealed this hidden bug.
The patch fixes also the crash submitted by Jocelyn Fournier earlier
today:
...
CREATE TABLE `threadhardwarefr13` (
`numeropost` mediumint(8) unsigned NOT NULL default
Hi Steven,
Some precisions : after taking a look at my mail, I noticed the very first
time I saw this error was with PHP 4.2.1 and MySQL 4.0.2 (reported on this
list on 27 june 2002).
Regards,
Jocelyn
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
To: 'Jocelyn Fournier
Hi,
Same problem for me, although it was already here with 4.2.0 for me (well it
seems to be also a high QPS problem...). The problem seems to disappear with
an apache restart, but sometimes appear again randomly.
Regards,
Jocelyn
- Original Message -
From: Steven Roussey [EMAIL
1 - 100 of 153 matches
Mail list logo
