OTECTED] On Behalf Of jay
Sent: Monday, February 27, 2006 6:06 PM
To: Philip Hallstrom
Cc: mysql@lists.mysql.com
Subject: [SPAM] - Re: MYSQL: Unlimited Forums, Scalablity Issues, advice
please? - Bayesian Filter detected spam
Hi Philip, thanks for the reply.
Single master + many read only slaves w
Hi Philip, thanks for the reply.
Single master + many read only slaves would only solve the problem of
handling many many concurrent read accesses, by distributing the load
across all slaves.
However, I guess the real problem, is that the writes would still need
to be performed across ALL da
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS of
"subforums that simulate full forums" would do.
2. Also regarding scalablity, I hope to "Add capacity" as and when its
needed. So i'll have one server runn
Hi there,
I am in the midst of creating a forums hosting site.
1. It has to be highly scalable, so I doubt a single MYSQL db with TONS
of "subforums that simulate full forums" would do.
2. Also regarding scalablity, I hope to "Add capacity" as and when its
needed. So i'll have one server runn
D]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 6:05 PM
Subject: Re: 3.23 thread error - help/advice please
> What kind of limit did you set?
> I think I've found the area in safe_mysqld you referred to. Is this
correct?
> --
fi
if test -n "$core_file_size"
then
ulimit -c $core_file_size
fi
fi
-
From: "Philipp" <[EMAIL PROTECTED]>
To: "my5ql _" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: Re: 3.23 thread error - help/advice please
Date:
.
regards,
philipp
- Original Message -
From: "my5ql _" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 3:04 PM
Subject: 3.23 thread error - help/advice please
> I tweaked my.cnf on a server.
> Changed wait_timeout from 80 to 7
I tweaked my.cnf on a server.
Changed wait_timeout from 80 to 75
and increased key_buffer to 1280M from 1024M
max_connections is set to 500
Max_used_connections was reported at 370 (from 'mysqladmin variables')
thread_cache is set to 48
I ran 'mysqladmin flush-hosts' as the mysql root user and go
>From: "George Pitcher" <[EMAIL PROTECTED]>
>
>I am about to start the planning process in moving my FileMaker/Lasso/PHP
>site over to MySQL/PHP.
>
>Before I get too far down the road, should I be using InnoDB or MyISAM
>tables?
InnoDB does not support FULLTEXT indeces. Since FileMaker searches ar
Hi George,
> I am about to start the planning process in moving my FileMaker/Lasso/PHP
> site over to MySQL/PHP.
> Before I get too far down the road, should I be using InnoDB or MyISAM
> tables? The service is initially going to be hosted on WinNT but may move
> over to Linux later.
=main respon
Hi,
I am about to start the planning process in moving my FileMaker/Lasso/PHP
site over to MySQL/PHP.
Before I get too far down the road, should I be using InnoDB or MyISAM
tables? The service is initially going to be hosted on WinNT but may move
over to Linux later.
My main database has about 2
Hi,
I am about to set up a network which has a central "main" server, and
several (up to 30) "shop" servers (it is for a retail chain). I'm intending
to link install mysql on all of them and link them up using the method
described below. What I'd like to know is (a.) Can anyone see a fatal flaw
Good luck,
John Galanopoulos
-Original Message-
From: George I. Develekos [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 10:30 AM
To: [EMAIL PROTECTED]
Subject: Tuning advice, please
Hi to all from a novice,
We run a database with roughly 200 tables and a total of 10,000 rows, o
Hi to all from a novice,
We run a database with roughly 200 tables and a total of 10,000 rows, on
Solaris, 1G RAM, 440MHz CPU, about 300 CPU-intensive queries per hour
(some math calculations are carried out with each query) all from a
web-server
via JDBC.
Since the database is really small com
Hi:
I'd like to store user preferences in one table, such that there are
default values but a user can override the preference. Default
preferences are stored as user 0. This is trivial to do with two
queries, but I'd like to compress it to one. Here's an example of what
I mean:
+--+--+
Hi:
I'd like to store user preferences in one table, such that there are
default values but a user can override the preference. Default
preferences are stored as user 0. This is trivial to do with two
queries, but I'd like to compress it to one. Here's an example of what
I mean:
+--+--+
16 matches
Mail list logo
