Hi Friends,
I need a document on why tables crash in MYSQL and what are the repair
methods?
I would also like to know if there are any preventive measures to avoid
table crashes?
Regards,
Amarnath Shivashankar
SQL Database Management
The information contained in this electronic me
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)),
MAX(access_expire)
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
e
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 t
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,
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 th
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
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 au
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 ~
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 work
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 after
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
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
- Mensag
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
[
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 implementation
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 r
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 this
Thinking about his very briefly, I suspect you need two tables and a flag.
The first table would be something like
person:
===
person_id
names:
==
person_id
is_primary_name (Boolean)
name
For each person, you'd have one or more names with the one you want as the
"working" name flagged.
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
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
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 the
21 matches
Mail list logo