> since some days we have a critical problem:
> 1 or 2 times a day the mysql CPU usage grows up to 97%
> (normally 20-40%) and mysql-daemon freezes.
> mysql : 3.22.22
> os : FreeBSD 3.2
> system : intel dual pentium
> ram : 512 MB
This is a known problem with the threading library on FreeBSD. A
> From: Oleg Prokopyev <[EMAIL PROTECTED]>
>
> > freebsd 4.4 stable mysql3.23.47
[deletia]
BTW - I tried to send the threads explanation to
your account, but I got a bounce-back with "spam host
denied" message... (!?)
Russ.
---
From: Oleg Prokopyev <[EMAIL PROTECTED]>
> freebsd 4.4 stable mysql3.23.47
>
> when i start it - it works -
> but after 10-15 minutes cpu usage became about 100%
> and mysqld do not responds to any query
Yes. It's caused by a problem in the FreeBSD threads
library, and this problem has been ar
> I need to save my database (comma separated)in file which i can do by
> mysql..admin commandnow what i want to do is that this file gets
> auto-emailed once a week to the concerned personthe site that uses
mysql
> is hosted on a linux machine.
> I can add a process that does the above i
> We've requested a database from different companies, and specifically
> said we wanted MySQL or PostgreSQL because of the open source angle
> and we're a library.
> One company offered MS SQL as the platform and said that they can later on
> port it to MySQL. For this they wanted 18 000 euro. No
> We thought about having one massive file for all this data, BUT, we
archive
> something like 100,000 articles a day. We store articles for 6 months, so
> this table would very quickly have 18,000,000 rows. Now, we need to
select
> a group of articles based on source and date. We also need to
From: "Kevin Smith" <[EMAIL PROTECTED]>
> I'm "considering" making a huge table, by that I mean approx. 26 millions
> records which will be static data, no updates, or deletes, etc. will be
> performed on this table, only select statements.
...
> At a guess the raw data may be in the region of 9G
Hi all,
I'm having a problem where the optimiser seems to take a *very* long time to
work out which indexes to use.
Although I'm using a lot of joins, it takes around 10 minutes to give an
EXPLAIN of the query shown below. The actual query takes only a second or
two (or so it appears).
linklist
From: Dvoøáèek Michal <[EMAIL PROTECTED]>
> Hi there,
>
> little problem. I have program (like phorums) and there is command
> mark all posts as readed. On one board is about 4000 posts, and if is
> new user and want mark all posts as readed - it's problem (big).
>
> All is written in ANSI C (usin
From: ryc <[EMAIL PROTECTED]>
> I am aware that currently innobase tables can not have abritararly large
> text/varchar fields and support for this will be released sometime in the
> month of June. The application I am working with requires text fields
> (usually less than 64k), and I desperatly
> On 14-Jun-01 Terminal Velocity wrote:
> > I would like to use MySQL to manage my company data, but my clients want
> > all their information sent to them in an Excel spreadsheet. Presently I
> > use Access, and export a SELECT statement into Excel, and then make a
> > couple changes to the Excel
From: Don Read <[EMAIL PROTECTED]>
> On 14-Jun-01 Kenneth Johansen wrote:
> > hi all, ive got a small problem (again).
> > i have a table with an entry "foo" which is an int(3).
> >
> > my problem is that whenever i collect the values in my c program.
> > they are returned as characters with mysql
From: Suresh Kumar R <[EMAIL PROTECTED]>
> I want to have the absentee list of students per hour_of_day
per day for a week, done for the entire course.
>
> One possibility I thought was to create a table with date and
each hour of the day as columns, then each cell would have to
have variable num
> >Just a question of curiousity. Can you install PHP using tars files?
> >I was looking at purchasing a few servers last fall and when I looked at
the
> >RAQ3/4 they (colbalt) told me that you could only install their stuff and
> >they didn't have new versions of MySQL and only PHP3.
> The only
14 matches
Mail list logo
