That is fine.
On Thu, May 8, 2008 at 4:51 PM, Neil Tompkins [EMAIL PROTECTED]
wrote:
Perfect. It worked just how I wanted.
Thanks for your help.
Neil
Date: Wed, 7 May 2008 19:54:39 +0200 To: [EMAIL PROTECTED]
Subject: Re: Order Problem From: [EMAIL PROTECTED] Hi, You should
look
Change the following parameter:
myisam_sort_buffer_size=300MB
Larger than here.
myisam_max_sort_file_size=10GB
Reduce this value to 30% of your real memory.
On Tue, May 13, 2008 at 7:10 PM, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Krishna,
how do i make my index to get more key blocks
On
Hi,
can someone could explain where are problems in this query:
EXPLAIN
SELECT ID
FROM ven_tes
WHERE ID IN (SELECT ID FROM ven_tes WHERE ID_ven=6573)
+++-+-++-+-+--+--+--+
| id |
Hello List,
As an editor for the german Linux Magazine I am looking for Authors who would
want to write an article of about 5-7 pages (=15-2 characters) on MySQL
Troubleshooting and a second on Clustering and Replication issues. The Article
is planned for our forthcoming Linux Technical
in mysql sub queries dont perform well.
You can could try this
SELECT a.ID
FROM ven_tes a, ven_tes b where a.id=b.id and b.id_ven=6573 .
On 5/20/08, Wakan [EMAIL PROTECTED] wrote:
Hi,
can someone could explain where are problems in this query:
EXPLAIN
SELECT ID
FROM ven_tes
WHERE
We use a sub select on a 8M+ row table because it takes better advantage
of indexes.
SELECT startip,endip FROM geodb a
WHERE a.startip = (SELECT max(startip) FROM geodb WHERE b.startip =
3250648033) AND a.endip = 3250648033;
startip and endip are INT(10) unsigned and unique keys.
This
Hi,
Thanks for the reply. Now I also manipulate it using PHP script to loop
every 1000 of records.
Regards,
Willy
On Tue, 2008-05-20 at 11:48 +0800, Moon's Father wrote:
To make the parameter max_allowed_packet larger.
On Mon, May 19, 2008 at 12:17 PM, sangprabv [EMAIL PROTECTED]
wrote:
On Tue, May 20, 2008 at 7:05 AM, Wakan [EMAIL PROTECTED] wrote:
can someone could explain where are problems in this query:
EXPLAIN
SELECT ID
FROM ven_tes
WHERE ID IN (SELECT ID FROM ven_tes WHERE ID_ven=6573)
If that subselect only returns a single result, try using = instead of
IN. MySQL
On Tue, May 20, 2008 at 11:33 AM, Perrin Harkins [EMAIL PROTECTED] wrote:
If that subselect only returns a single result, try using = instead of
IN. MySQL performed very poorly on OR queries before version 5. It
would avoid using indexes. The new index merge stuff in version 5
fixed that.
Thanks. That sounds pretty labor intensive, since I'd have to do the copy
for each table. That makes the process much harder to automate. And I'm not
sure the end result would be what I wanted anyway. I would like to be able
to do this without copying data around. Does anybody have another
Customer has tested his site in Mysql 5.1 and we are running Mysql 4.1 .
His test works but over here we get:
Warning: DOMDocument::__construct() [function.DOMDocument---construct]:
Malloc(88) in /usr/home/vesna/html/pryvit/church_maps/data_genxml.php on line 5
Warning:
You should post this question to php section.
On Wed, May 21, 2008 at 6:51 AM, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem [EMAIL PROTECTED] wrote:
Customer has tested his site in Mysql 5.1 and we are running Mysql 4.1 .
His test works but over here we get:
You should keep it on in my opinion.
On Tue, May 13, 2008 at 6:04 PM, Nico Sabbi [EMAIL PROTECTED] wrote:
Hi,
I guess that when I'm using only Innodb and no replication I can
safely disable mysql's (bin-) log files (that grow to no end) because
Innodb has its own log files. Is it correct?
What is LVM?
2008/5/12 MarisRuskulis [EMAIL PROTECTED]:
Hello!
I'm wondering about MySQL LVM2 preformance, but cant found any
comparisions. I know that there is some speed decrease with LVM,
something about 30%. But how this decrease impacts overal MySQL
performance?
Now we are backuping
Don't you use the following statements instead of yours?
...month between 10 and 12
On Wed, May 7, 2008 at 1:46 AM, kabel [EMAIL PROTECTED] wrote:
I have a table from which I need to calculate the percentage growth of
downloads from specific countries over two distinct periods of time.
The general version can not be replaced *frequently *
On Fri, May 9, 2008 at 4:23 PM, Dominik Klein [EMAIL PROTECTED] wrote:
Upgrade to 5.0.51b seems to have solved the problem. On wednesday, I saw
the problem about a dozen times during a peak time. Upgraded wednesday night
and have not seen
Just try to get it.
On Mon, May 5, 2008 at 10:12 PM, SQL Maestro Group [EMAIL PROTECTED]
wrote:
Hi!
SQL Maestro Group announces the release of Data Wizard for MySQL 8.4, a
powerful Windows GUI solution for MySQL data management.
Data Wizard for MySQL provides you with a number of
17 matches
Mail list logo