>
> Hold on, "(it should be, its the same file)", you're saying that db2 on
> server1 and server2 are using the same database files (datadir)? If that's
> the case, why? That doesn't make any sense.
>
>
> Atle
> -
> Flying Crocodile Inc, Unix Systems Administrator
>
Im replying from another accoun
On 4/8/06, Kevin Burton <[EMAIL PROTECTED]> wrote:
> Is there anyway I can tune MySQL to improve this operation?
There's a fundamental problem with B-trees - inserts in a big B-tree
can be very slow, cause it may require tree rebalancing.
One workaround for this problem is partitioning. MySQL 5.1
I'm sending this back to the mailing list where it belongs; that way, other
people can jump in to help and others can learn from the discussion, either
now or via the list archive.
- Original Message -
From: "Martin Gallagher" <[EMAIL PROTECTED]>
To: "'Rhino'" <[EMAIL PROTECTED]>
Sent
You can't specify multiple IPs for bind-address.
Let's back up. You want to run both 4.0 and 5.0, and you want to be able
to set it up so it's 'easy' to connect to each separate instance, i.e.
without having to specify different ports. This is pretty easy to do. In
this case you use separate c
- Original Message -
From: "Martin Gallagher" <[EMAIL PROTECTED]>
To:
Sent: Saturday, April 08, 2006 6:34 PM
Subject: COUNT() Efficiency
Hi,
If I did a query like:
SELECT COUNT(id) AS count1, COUNT(id) AS count2 FROM table WHERE id<100
Would MySQL run the COUNT() calculation once
Hi,
If I did a query like:
SELECT COUNT(id) AS count1, COUNT(id) AS count2 FROM table WHERE id<100
Would MySQL run the COUNT() calculation once or twice?
Cheers
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
On 08.04.2006 23:14 (+0100), Eric Braswell wrote:
> Yves Goergen wrote:
>> How can I enter multiple IP addresses there? This isn't documented
>> online. I need to bind it to one specific external address and
>> additionally to localhost (127.0.0.1). The other server is only bound to
>> another exte
It is not possible to make specific suggestions based on the information
you've provided. The list would need to know the nature and platform of
your application, the amount and type of the traffic you see, your
current mysql vs. apache load (like queries, requests per sec), current
server conf
Yves Goergen wrote:
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
my.cnf:
bind-address =
Will probably do the trick.
How can I enter multiple IP addresses there? This isn't documented
online. I need to bind it to one specific external address and
additionally to localhost (127.0.0.1). T
On 08.04.2006 18:31 (+0100), Kishore Jalleda wrote:
> bind-address =
Doesn't work. MySQL binds to address 255.255.255.255 instead. Also a
colon-separated list does this.
> bind-address = IP1
> bind-address = IP2
This always takes the last option, so if I add 127.0.0.1 after the other
IP, it wil
I found High Performance MySQL http://highperformancemysql.com/ very
useful. Also, throwing some money at the people at MySQL should get
you a highly informed answer.
One of the first tests I run for a customer is to see if the
structure of their data and indices match the needs of the queries
Hi,
I get this weird error message:
ErrNo: 2006
Error: MySQL server has gone away.
What does it mean? I couldn't find anything useful on google and the
error message isn't exactly "verbose".. :)
regards,
martin
--
MySQL General Mailing List
For list archives: http://lists
That would be pretty dangerous if I ever needed to say rebuild a table and
run out of memory.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Sat, 8 Apr 2006, Gabriel PREDA wrote:
> If there is plenty of free memory...
> Can't you completly disable SWAP ?
> --
> Gabriel PREDA
> S
On Sat, 8 Apr 2006, Leonardus Setiabudi wrote:
> when i log into server 2 using port 3307, i can see the data in db2
> updated, which means the replication succeed (show slave status tells
> the same thing), and the same thing with server 3, i can see db3
> updated, also with server 4 where db4 up
If there is plenty of free memory...
Can't you completly disable SWAP ?
--
Gabriel PREDA
Senior Web Developer
On 4/7/06, Atle Veka <[EMAIL PROTECTED]> wrote:
>
> However, even though
> there is plenty of free memory linux makes weird decisions from time to
> time, temporarily killing performan
> We are currently building a webfarm to replace our all in one box
solution. We are experiencing problems when we get linked to a site like the
drudgereport and we are seeing 1000's of hits a minute. Both apache and
mysql start chocking and we get dropped because we cant deliver content. I
am tryi
I would be tempted to say
bind-address =
or
Just a list of such statements one per line
bind-address = IP1
bind-address = IP2
.
.
But since you said this is not properly documented, I would encourage you to
give this a shot and find it out for yourself on a Spare/Test Mysql Bo
On 04.04.2006 23:17 (+0100), Eric Braswell wrote:
> my.cnf:
>
> bind-address =
>
> Will probably do the trick.
How can I enter multiple IP addresses there? This isn't documented
online. I need to bind it to one specific external address and
additionally to localhost (127.0.0.1). The other serve
My block digrams didn't come out so well.
Fig 1.
Pix ---> Load Blanace ---> 4 servers running apache and mysql > SAN
holdin the data and scripts
Fig 2.
Pix---> Load Balance -> 3 servers running apache ---> 1 server runnin
mysql > SAN holding data and scripts
- Original Messag
We are currently building a webfarm to replace our all in one box solution. We
are experiencing problems when we get linked to a site like the drudgereport
and we are seeing 1000's of hits a minute. Both apache and mysql start chocking
and we get dropped because we cant deliver content. I am try
Are you wanting to insert into two tables (messages,
social_networking) with one statement?
If not, an INSERT / SELECT might work well for you. Like so:
INSERT INTO messages
(author, recipient, subject, body, timestamp)
SELECT
1, social_networking.user_id, 'dfdf', 'adfgdf', 1144463208
FROM soc
Hello,
I wanted only to report that I removed and re-added the Index as Martijn
suggested and now it's OK.
Thanks again for your help
Regards,
Patrick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
2006/4/8, Dan Buettner <[EMAIL PROTECTED]>:
> Seems like what you're looking for is a way to query your database
> more efficiently/quickly, and still find all links in either
> direction.
>
> I think the use of a UNION statement should allow this. Basically
> write your query twice, joining
Yes Eric You are correct. Thankyou for your reply. It helped me.
Bala
24 matches
Mail list logo
