Re: 2 cursors in a store procedure

Thanks for your reply. Actually, I want to do the following. But I have no idea how to do it. create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare contine handler for not fou

Re: 2 cursors in a store procedure

At 10:57 AM +0800 2/11/08, Rilawich Ango wrote: HI all, How can a store procedure to contain 2 cursors? Any advise? ango create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare

2 cursors in a store procedure

HI all, How can a store procedure to contain 2 cursors? Any advise? ango create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare contine handler for not found set y=1; -- M

Re: If I downgrade MySQL from ver-5 to ver-4.

Brown, Charles wrote: Hello. Can someone tell me if I will run into any problems? 1. If I downgrade MySQL from ver-5 to ver-4. 2. If I run replication between version 4 and version 5 of the software. Meaning slave is version 4 and the master is version 5. Some back ground: We have replication

Re: Large Database Performance - Reference Sites?

You will likely need to be a lot more specific about what you are asking for here, David. What is a "large select"? What constitutes a "large update"? What number of joined tables composes a "multi join" in your specific case? What is "text functionality"? -jay David Stoller wrote: Can S

Re: Server Crash

See Thread at: http://www.techienuggets.com/Detail?tx=24273 Posted on behalf of a User Help! I'm still facing this problem. I can run a check error successfully but when I try to dump the database using MySQL Administrator halfway through one table the server crashes. See message at the end. I

Re: Inefficient query processing?

Yves, > My problem is that the sub-select in line 7 > ("SELECT 1") takes a rather long time It might be possible to simplify. Do I have the schema right? message (messageID) keylist (keylistID) tag ( tagID, readaccesskeylist references keylist(keylistID) ) message_revision_tag ( ???, messageID

Server Crash

See Thread at: http://www.techienuggets.com/Detail?tx=24273 Posted on behalf of a User Hi I'm running 5.0.51a on Windows machine. The server crashes with: 080210 15:56:38 InnoDB: Page checksum 2545965801, prior-to-4.0.14-form checksum 1667729874 InnoDB: stored checksum 1195984440, prior-to-4.0

Inefficient query processing?

Hi, I have a performance problem with one of my SQL queries. It's a rather complex one so I'll spare you the details. This is the situation: In my system, there's messages, tags and keylists. Each message has message_revisions, each message_revision can be assigned tags (stored in message_re

MYSQL db no-no: deleted root permissions (smile)

Hey folks, As with many lessons in linux world it takes a big oop for a big lesson. system: gentoo OS webmin/virtualmin frontend I was trying to apply permissions to usetrs so they can only access certain DB's. This involved removing the associated user permissions from the permissions list and

Large Database Performance - Reference Sites?

Can Someone with Large Databases (100million records 20K-row avg )X5 contact me for some questions, regarding performance on: 1. Text functionality 2. Performance large selects multi joins large updates bulk inserts

Server Getting crashed, Any Help Comments?

Hello I am running a Freebsd server: 1. Software: Apache 1.3 mysql 5.0.27 php 4.4 2. Hardware: 2 intel procerssors 4 gb ram RAID 10 with hard drives 15K rpm I am having this problem quite often now. Apache stops responding due to mysql (my guess). And I cannot connect to mysql server: /usr/lo