On May 21, 2008, at 8:46 AM, Paul McCullagh wrote:
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search "item_id AND
i
On May 21, 2008, at 8:09 AM, Moon's Father wrote:
Now I want to know which way you use to create index of a table.
1、ix_u (item_id,item_count)
ix_item_count (item_count)
This makes sense if you have queries which search "item_id AND
item_count", and queries which just search the column
learnt
On Wed, Apr 30, 2008 at 5:18 AM, Mihail Manolov <[EMAIL PROTECTED]>
wrote:
> Hi all,
>
> I feel obliged to report on my success with migration from 32bit to 64bit
> platform.
>
> Last Sunday I braced myself and migrated 3 servers (one master and two
> slaves) with approximately 100GB data
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 ea
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 s
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.
>
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 back
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 correc
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:
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: DOMDocument::__construct
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
suggesti
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 th
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.
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]>
> wrot
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 ret
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
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 Rev
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 | se
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
>
> O
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,> >
20 matches
Mail list logo
