err-report help me

Visolve DB Team · *nix forums beginner Joined: 21 Jul 2006 Posts: 3

Hi Peter,

Definitely using OR will slow up the performance of FULL TEXT searching.
Instead of using OR, you can try using UNION statement.

Hope this will be a fix for your issue.

Thanks,
ViSolve MySQL Support Team.

----- Original Message -----
From: "Peter Lauri" <lists@dwsasia.com>
To: "'JC'" <hiep@ee.ucr.edu>
Cc: <mysql@lists.mysql.com>
Sent: Thursday, July 20, 2006 4:21 PM
Subject: RE: FULL TEXT and Asian languages

Neculai Macarie · *nix forums beginner Joined: 13 Feb 2005 Posts: 8

Peter Lauri wrote:

Hiep Nguyen · *nix forums beginner Joined: 11 Aug 2005 Posts: 11

don't know about indexing, but try to search: LIKE '%sentences%'

JC

On Thu, 20 Jul 2006, Peter Lauri wrote:

Dominik Klein · *nix forums beginner Joined: 15 Mar 2006 Posts: 35

Hi Thomas

Peter Lauri · *nix forums beginner Joined: 25 Nov 2005 Posts: 40

Why can the Thai and Chinese not use regular sentences and word delimiter Smile

So I have to stick to my LIKE thing, just to erase the FULL TEXT index I
assume.

-----Original Message-----
From: Neculai Macarie [mailto:mack@eaccelera.ro]
Sent: Thursday, July 20, 2006 10:50 PM
To: mysql@lists.mysql.com
Subject: Re: FULL TEXT and Asian languages

Peter Lauri wrote:

Peter Lauri · *nix forums beginner Joined: 25 Nov 2005 Posts: 40

That is what I am doing right now, but it is not that fast if this system
would grow, and also it is not "ranking" the searches.

Right now I do something like this:

$searchwords = explode(" ", $searchstring);
foreach($searchwords AS $value) {
$Query.= "OR lajlaj LIKE '%$value%'"
}

If there are many search words, the OR will grow a bit, and OR are not that
fast as I read somewhere.

/Peter

-----Original Message-----
From: JC [mailto:hiep@ee.ucr.edu]
Sent: Thursday, July 20, 2006 10:46 PM
To: Peter Lauri
Cc: mysql@lists.mysql.com
Subject: Re: FULL TEXT and Asian languages

don't know about indexing, but try to search: LIKE '%sentences%'

JC

On Thu, 20 Jul 2006, Peter Lauri wrote:

Dilipkumar · *nix forums beginner Joined: 08 May 2006 Posts: 18

Hi,

If you have like insert statments try using this as

login into mysql
mysql -u root -p
use database-name

\. /tmp/filename.txt

Thanks & Regards
Dilipkumar
----- Original Message -----
From: "Marc Alff" <marc.alff@comcast.net>
To: <fleet@teachout.org>
Cc: <mysql@lists.mysql.com>
Sent: Monday, July 17, 2006 11:21 PM
Subject: Re: load-file() doesn't work [SOLVED]

<fleet@teachout.org> · *nix forums beginner Joined: 16 Jul 2006 Posts: 3

On Mon, 17 Jul 2006, Marc Alff wrote:

Marc Alff · *nix forums beginner Joined: 12 Mar 2006 Posts: 3

Hi Fleet

fleet@teachout.org wrote:

<fleet@teachout.org> · *nix forums beginner Joined: 16 Jul 2006 Posts: 3

SHORT SYNOPSIS:
The statement
INSERT INTO table (blob_column) VALUES
(load_file('/home/somebody/image.jpg'));

Produces no error; but fails to load the image file.

SOLUTION:
The image file (or other binary file, I assume) MUST reside in / or /tmp,
ie /image.jpg or /tmp/image.jpg. (At least in MySQL 3.23.36)

I *hope* this is a bug!

- fleet -

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

sheeri kritzer · *nix forums Guru Wannabe Joined: 19 Oct 2005 Posts: 243

create view v_authornames as
select authorid, CONCAT(lastname,',',firstname)
from t_authors;

Or replace the middle term in the CONCAT function to whatever you want
to separate it -- ie, ' ' for a space, or just
CONCAT(lastname,firstname) to get output "KritzerSheeri".

-Sheeri

On 6/25/06, Andreas Bauer <andreas_bauer@arcor.de> wrote:

Willy Mularto · *nix forums beginner Joined: 31 Mar 2005 Posts: 5

Hello,
I have solved this problem, thanks.

Regards

Willy
----- Original Message -----
From: Willy
To: mysql@lists.mysql.com
Sent: Wednesday, July 12, 2006 8:55 AM
Subject: datetime issue on MySQL 4.x

Hello,
I have a MyISAM table:

CREATE TABLE `dlr` (
`msisdn` varchar(20) NOT NULL default '',
`source` varchar(20) NOT NULL default '',
`operator_id` varchar(20) NOT NULL default '',
`sms_message` longtext NOT NULL,
`smsc_id` varchar(20) NOT NULL default '',
`sms_id` varchar(250) NOT NULL default '',
`dlr_smsc` text NOT NULL,
`dlr` tinyint(4) NOT NULL default '0',
`date_time` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM

I have a case here, on July 7 I imported some data into the table with this query:

INSERT INTO dlr (source, msisdn, operator_id, sms_message, smsc_id, sms_id, dlr_smsc, dlr, date_time)
VALUES
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW()),
('366508', '1234', 4, 'id:0943381383 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317 stat:EXPIRED err:999 text:xxxx, 'IM33665', MD5(RAND()), 'RE:id:0943381383 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317 stat:EXPIRED err:999 text:xxxx', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1226442088 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317 stat:EXPIRED err:999 text:xxxx', 'IM33665', MD5(RAND()), 'RE:id:1226442088 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317 stat:EXPIRED err:999 text:Silahkan tawar: XDA ', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, 'id:1861980498 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317 stat:EXPIRED err:999 text:xxxx', 'IM33665', MD5(RAND()), 'RE:id:1861980498 sub:001 dlvrd:000 submit date:0606280317 done date:0606290317 stat:EXPIRED err:999 text:xxxx', '2', '2006-06-28 03:17:00'),
('366508', '1234', 4, '', 'IM33665', MD5(RAND()), 'RE:', '2', NOW()).......

And when I try to fetch the data using PHP with this query:

SELECT operator_id, DATE_FORMAT(date_time,'%d-%m-%Y') AS tanggal, COUNT(*) AS TOTAL FROM dlr WHERE 1=1 AND dlr = 8 AND MONTH(date_time) = MONTH(NOW()) GROUP BY tanggal, operator_id ORDER BY date_time

The weird thing happened. Why does all the rows are shown or treated as July 7th data? If we see the imported data, there should be June 28, June 29.....until July 7. Please help and many thanks for any reply.

Regards

Willy

Jacob, Raymond A Jr · *nix forums beginner Joined: 21 Mar 2005 Posts: 27

Jacob, Raymond A Jr · *nix forums beginner Joined: 21 Mar 2005 Posts: 27

Brent Baisley · *nix forums Guru Wannabe Joined: 10 Feb 2005 Posts: 122

I've had to delete large amounts of records from tables with over 200 millions records. You are correct in that you want to do it in
chunks. How you divide the deletes is up to you to decide. You would want to do it based on a indexed column, like a date, and
specify a range.
DELETE data
FROM data, event
WHERE data.cid=event.cid
AND event.timestamp between "2006-01-01" and "2006-01-07"

DELETE data
FROM data, event
WHERE data.cid=event.cid
AND event.timestamp between "2006-01-08" and "2006-01-15"
....

You'l find it will go much, much quicker if you can narrow down the number of records deleted at one time. A delete that I would
give up on after a few hours take a few minutes by doing it in chunks.

BUT, if your data is always going to be divided into date chunks where you'll periodically delete everything prior to a certain
date, you may want to look into merge tables. Typically a merge table is a psuedo table that is comprised of a set of underlying
tables. You can add/drop underlying tables very quickly, or you could even reference an underlying table directly for certain tasks.
Under the right circumstances, merge tables can provide considerable amount of scalability.

----- Original Message -----
From: "Jacob, Raymond A Jr" <raymond.jacob@navy.mil>
To: <mysql@lists.mysql.com>
Sent: Sunday, July 09, 2006 10:36 PM
Subject: How does one speed up delete-Again

I started the operation below on Friday at 1300hrs EST
DELETE data
FROM data, event
WHERE data.cid = event.cid
AND event.timestamp < "2006-05-01"

It is now Sunday 22:00hrs EST and the operation is still running.

Question: Should it take this long to delete 7.5 million records from a
4.5GB
Table?

Question: Other than writing a script to export all the cid's to a file
and deleting the records one at a time so at least I can delete some
records.
Is there a way to delete records one at a time or in groups
so that if I have to stop the operation the delete will not rolled back?

Question:Does anyone on the list have experience deleting what I guess
is a large number of
records from a large table? i.e. how long does it take?

r/Raymond

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=brenttech@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

Google