Hi Rob,
I agree this is a problem for one major reason:
I never know, if someone replies to my post, without the CC to the
list, whether the writer wants to take the conversation off the list,
or if he just hit reply (instead of reply-to-all) out of habit.
If the default is to reply to
Hi Chad,
Yes, I agree. This is a really good idea. I think that it makes a lot
of sense to make streaming part of the standard MySQL protocol.
Your suggestion solves the problem that always comes with a
transition to a new protocol.
On Oct 19, 2007, at 6:20 PM, Chad MILLER wrote:
On 19
A colleague and I are having a discussion about the best way to handle
high traffic sites. For example, take a social networking site with 1
million users.
I think it would be better to have multiple web servers with multiple
database servers in a master/slave scenario with replication.
My
Thinking about his very briefly, I suspect you need two tables and a flag.
The first table would be something like
person:
===
person_id
other unique information, such as pointer to image, date of birth, etc.
names:
==
person_id
is_primary_name (Boolean)
name
For each person, you'd have
I highly recommend you hire a consultant or a freelance DBA to try to work
this out.
You are talking about something pretty extensive. I would recommend
replication across quite a few high-end servers (all 64 bit of course with
plenty of RAM). Clustering can be a pretty big headache. A lot of
Craig,
Thank you for your insight. Having never worked with clustering
solutions, what kinds of headaches might one see with that solution?
Does anyone know of any white papers that might shed some light into the
pros and cons of each solution?
-Erich-
Craig Huffstetler wrote:
I highly
Hi,
There are a lot of clustering you techniques you can use. Read on
livejournal attack on this problem. You need to start from the schema
poorly constructed schema will kill your hardware.
Go to Mysql Site search for whitepapers and friendster (I'm not
saying it the best
Hi friends,
I'm read somethings about the MySQL works with the option --shared-memory on
Windows and about this I have some doubts.
Anybody here know explain what are the chages compered without the parameter?
Thk`s...
Wagner Bianchi
Diretor de Tecnologia - INFODBA Technologies Consulting
You can treat it with DATE_FORMAT() and TIME_FORMAT(), change the format of
MySQL variable, don't have way.
You have to make a explicity convertion.
;-)
Wagner Bianchi
Diretor de Tecnologia - INFODBA Technologies Consulting
[EMAIL PROTECTED] - (31) 3272 - 0226 / 8427 - 8803
-
I have a query to extract some data. Two columns include a setup date
(setupdt) and a completed data (compdt).
I would like the data grouped to get sub-totals but shown in different
orders/ I would like the compdt with the newest first i.e. desc order and
setup date with the oldest first i.e. asc
I tried posting this on the Replication list, and got no response. Maybe
someone here can help...
OK. Still battling this issue after weeks of working with it. I'm racking
my brains. I re-set the slave again on Saturday, and got replication
started again. It was working fine until this
Hi Jesse,
Jesse wrote:
I tried posting this on the Replication list, and got no response.
Maybe someone here can help...
OK. Still battling this issue after weeks of working with it. I'm racking
my brains. I re-set the slave again on Saturday, and got replication
started again. It was
Hi Jesse,
071020 14:43:51 InnoDB: Started; log sequence number 0 142497221
071020 14:43:51 [Note] C:\Program Files\MySQL\MySQL Server
5.0\bin\mysqld-nt: ready for connections.
as i can see you are running mysql on windows.
If i start my db server (5.0.45/innodb/win2k) the server uses about
I've seen this debate on a lot of lists. I firmly believe having a
list munge reply-to is almost universally a very bad idea (the
main exception being very small lists of people who know each other).
Most email programs allow you to tell them the names of the lists you
subscribe to, and/or can
On 10/22/07, Ofer Inbar [EMAIL PROTECTED] wrote:
I've seen this debate on a lot of lists. I firmly believe having a
list munge reply-to is almost universally a very bad idea (the
main exception being very small lists of people who know each other).
Most email programs allow you to tell them
Erich C. Beyrent wrote:
Craig,
Thank you for your insight. Having never worked with clustering
solutions, what kinds of headaches might one see with that solution?
Does anyone know of any white papers that might shed some light into the
pros and cons of each solution?
You *did* look at
You are using a correlated subquery, which MySQL is terrible at.
Whenever you find yourself doing a correlated subquery, see if you
can switch it to a derived table with a join, which MySQL is far
better at. A derived table is like a virtual table you create on
the fly. It's very simple,
Indeed, as you say, Brent, correlated subqueries are not well-optimized
in MySQL. The specific subquery (the IN() subquery) demonstrated in the
original post is, however, optimized in MySQL 6.0 :)
More comments inline.
Brent Baisley wrote:
You are using a correlated subquery, which MySQL is
Is there a way to know how many rows were used in a computation?
I tried this 'trick' but I still get 1, when I know that there are 3 rows
used...
SELECT SQL_CALC_FOUND_ROWS
MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours
HOUR)),
MAX(access_expire)
FROM
Hi,
Daevid Vincent wrote:
Is there a way to know how many rows were used in a computation?
I tried this 'trick' but I still get 1, when I know that there are 3 rows
used...
SELECT SQL_CALC_FOUND_ROWS
MAX(DATE_ADD('2007-10-18 18:04:45', INTERVAL user_access_hours
HOUR)),
20 matches
Mail list logo
