Hi,
I found the solution for this issue. I separate into 2 queries and put
the result onto an array, and do PHP array_intersect_assoc to match.
Much more simpler, fast, about 200 thousands record matched in 10
seconds. Many thanks for your helps.
Regards,
Willy
On Thu, 2008-05-22 at 07:40 -0700
On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud <
[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I have 2 MySQL servers.
> One master and one slave.
> In order to add new slave server, and because i can't stop the master one,
> i
> have tried this:
>
> http://forums.mysql.com/read.php?26,99846,102058
Hi all.
I have 2 MySQL servers.
One master and one slave.
In order to add new slave server, and because i can't stop the master one, i
have tried this:
http://forums.mysql.com/read.php?26,99846,102058
"
*You don't have to modify the other slaves configuration. What you need to
do is obtain a sna
On Thu, May 22, 2008 at 10:00 AM, Tom Brown <[EMAIL PROTECTED]> wrote:
>
>
>> I don't think you need to flush your bin logs.
>>
>> CHANGE MASTER TO MASTER HOST = 'hostname';
>> Look at this for more info at
>> http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
>> There is a lot more you
On Thu, May 22, 2008 at 10:41 AM, François Beausoleil <[EMAIL PROTECTED]>
wrote:
> Hi all!
> I must be stupid or something. I can't find what my problem is.
>
> I searched this list, and did find a couple of hits, but nothing that
> seemed fully relevant. This one in particular was interesting:
Dan Nelson schrieb:
In the last episode (May 22), Samuel Vogel said:
Hey,
I am wondering how I can trigger an Action every 24 hours inside of mysql.
A cron job would also do the job, but it won't work on shared hosts and
it's just another point of failure.
So is there any way to run a spe
LOAD DATA LOCAL INFILE
http://dev.mysql.com/doc/refman/5.0/en/load-data.html
http://www.mysql.com/news-and-events/newsletter/2002-05/a12.html
-Original Message-
From: Velen [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 22, 2008 2:24 PM
To: mysql@lists.mysql.com
Subject: Load d
No. You need to use MySQL 5.1 as that is now a standard feature.
Or, if all your functionality is 100% MySQL, just run a stored procedure in an
infinite loop and check every 60 seconds for
DELIMITER $$
DROP PROCEDURE IF EXISTS `rolando`.`runjob` $$
CREATE PROCEDURE `rolando`.`runjob` (scheduled
Hi,
I would like to know if I can use the Load data infile to update a table on the
server from a workstation?
I tried it but was unsuccessful. Is there any other way to do this from a
workstation?
Thanks.
Regards,
Velen
In the last episode (May 22), Samuel Vogel said:
> Hey,
>
> I am wondering how I can trigger an Action every 24 hours inside of mysql.
> A cron job would also do the job, but it won't work on shared hosts and
> it's just another point of failure.
>
> So is there any way to run a specific SQL com
Hey,
I am wondering how I can trigger an Action every 24 hours inside of mysql.
A cron job would also do the job, but it won't work on shared hosts and
it's just another point of failure.
So is there any way to run a specific SQL command every 24 hours inside
of mysql?
I'm using MySQL 5.0.51
David,
What I am trying to limit this query to is the top 100 details ordered by
SUM(Volume) DESC for each unique LongDescription
For some solutions see 'Within-group quotas (Top N per group)' at
http://www.artfulsoftware.com/infotree/queries.php
PB
-
David Perron wrote:
Hello MySQL Us
There is a huge difference !!!
When You Load a Table with a Primary Key, the Primary get built automatically.
Not even ALTER TABLE DISABLE KEYS has an effect since it disables
non-unique indexes. Hence, loading the table is a one-pass operation.
In contrast, loading a table with two non-uniqu
Hi all!
I must be stupid or something. I can't find what my problem is.
I searched this list, and did find a couple of hits, but nothing that
seemed fully relevant. This one in particular was interesting: http://lists.mysql.com/mysql/212863
I have a single master (server-id=1) and a single
Kevin Hunter wrote:
At 1:43p -0400 on Wed, 21 May 2008, bruce wrote:
The basic goal of the project is to be able to track the sites that I'm
visiting via a Firefox extension. I want to be able to implement something
like the "breadcrumbs" extension, but I want to be able to go a lot further.
I
Sub queries suck in mysql. It is probably worth while to post the results of:
EXPLAIN SELECT msgdata
FROM sent_sms
WHERE momt = 'MT'
AND binfo IN (SELECT
binfo
FROM sent_sms
WHERE momt = 'DLR')
Are binfo and momt indexed? If not, they probably should be. A
replacement for the
At 1:43p -0400 on Wed, 21 May 2008, bruce wrote:
> The basic goal of the project is to be able to track the sites that I'm
> visiting via a Firefox extension. I want to be able to implement something
> like the "breadcrumbs" extension, but I want to be able to go a lot further.
If this is for a on
Hi,
I am developing a geo-spatial application that requires the DISTANCE function.
We have been using 5.1.23-GIS beta, but have noted that it appears not to be
in the 5.1.24 beta or the 6.0 alpha release. I also can find no documentation
as to when this will be merged into the main release or g
On Thu, May 22, 2008 at 9:20 AM, Tom Brown <[EMAIL PROTECTED]> wrote:
>
> Hi
>>
>> I had master-master working fin in dev - i move them to prd now and so
>> change the hostnames, on starting i see this error
>>
>> 080522 11:53:40 mysqld started
>> 080522 11:53:40 InnoDB: Started; log sequence n
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
'./devnagios01-
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
'./devnagios01-re
If i am not using zerofill. Then is there any different between int(10) and
int
On Thu, May 22, 2008 at 2:23 PM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> int(10) will pad with zeros on return, i.e. if value = 59
>
> int(10) 59
> int59
>
> - Original Message
> > Fr
Hi,
Thanks for the reply. The query seems doing something but after minutes
of waiting it still return no result.
Regards,
Willy
On Wed, 2008-05-21 at 23:06 -0400, David Lazo wrote:
> Would this work for you?
>
> SELECT msgdata
> FROM sent_sms
> WHERE momt = 'MT'
> AND binfo IN (SELECT
>
what kind of datatype it is int(50)
parent_id| int(50)
is that big int?
Saravanan
--- On Thu, 5/22/08, Norbert Tretkowski <[EMAIL PROTECTED]> wrote:
> From: Norbert Tretkowski <[EMAIL PROTECTED]>
> Subject: Re: integer
> To: mysql@lists.mysql.com
> Date: Thursday, May 22, 2008, 3:3
Am 22.05.2008, 14:04 +0530 schrieb Krishna Chandra Prajapati:
> I would to know the difference between the two
>
> int(10) and int (Used in create table )
MySQL has an excellent documentation, which of course also answers your
question:
http://dev.mysql.com/doc/refman/5.1/en/numeric-types.html
If you didn't define zerofill
int is equal to int(11)
if the actual variable is 59,then all display 59.
On Thu, May 22, 2008 at 4:53 PM, Glyn Astill <[EMAIL PROTECTED]> wrote:
> int(10) will pad with zeros on return, i.e. if value = 59
>
> int(10) 59
> int59
>
> - Orig
int(10) will pad with zeros on return, i.e. if value = 59
int(10) 59
int59
- Original Message
> From: Krishna Chandra Prajapati <[EMAIL PROTECTED]>
> To: MYSQL General List
> Sent: Thursday, 22 May, 2008 9:34:55 AM
> Subject: integer
>
> Hi,
>
> I would to know
Hi,
I would to know the difference between the two
int(10) and int (Used in create table ) Which one is better and why.
Regards,
--
Krishna Chandra Prajapati
MySQL DBA,
28 matches
Mail list logo