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:
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
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
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,
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
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
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 Someone
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
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
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;
--
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
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
12 matches
Mail list logo