Hi,
I have a big table (900k rows, 200M MYD, 200M MYI) with a fulltext index
on it. The table gets corrupted every 1 week or so and I have to repair
it. I've tried upgrading to newer versions of mysql 3 times but the
problem persists. I think it may have something to do with the raid 1
mirror
` (`title`,`description`,`keywords`)
) TYPE=MyISAM
OS is RedHat 9 - 2.4.20-8smp
I'd rather not upload the crashed table because it is really big and it
has some sensitive data.
Thanks,
- Mark
Heikki Tuuri wrote:
Mark,
- Original Message - From: Mark Maggelet
[EMAIL PROTECTED]
Newsgroups
Thanks Mike,
It's hardware raid, but I don't know the manufacturer. I could try to
find out but if the problem is the hardware there isn't much I can do
about it anyway without turning it into a big project.
I'm not really expecting to solve this, I'm just hoping for some advice
on what the
Hi.
I'm having this problem on 4.1.2, when I run myisamchk -o on my table I
get a bunch of these lines:
Duplicate key 3 for record at 56134200 against new record at 244828223
then it segfaults.
key 3 is a fulltext. I tried the same thing on the same data with 4.0.14
and it worked fine, I
Hi.
I'm having this problem on 4.1.2, when I run myisamchk -o on my table I
get a bunch of these lines:
Duplicate key 3 for record at 56134200 against new record at 244828223
then it segfaults.
key 3 is a fulltext. I tried the same thing on the same data with 4.0.14
and it worked fine, I
I think you want to try 'having mo.date IS NULL' after the order by.
Daren wrote:
I'm query for a list of offers from a table, but am
trying to do a Left Join on the table that keeps track
of which members have completed which offers (so that
the query will not return offers that the member has
and delete the query that hosed the table
and then run the rest through mysql.
I don't think I can do this with a master/slave setup. Maybe I would have
better luck with version 5?
Thanks,
- Mark
I don't think I can do something li
Sasha Pachev wrote:
Mark Maggelet wrote:
Since I didn't get an answer
Since I didn't get an answer to this, I'll try asking it another way:
has anybody gotten a binlog with binary data (images) to load from one
server to another? And if so, what version are you using?
Thanks,
- Mark
On Mon, 1 Mar 2004 21:09:22 -0800, Mark Maggelet wrote:
Hi,
I'm having problems
Scanning a PC manufacturer's website, it seems easy to get 4x2.5GHz
Xeon, 1Mb L3, 8Gb ram, dual 15000 rpm Scsi with Raid 1 (for
performance as well as reliability).
Does this sound balanced for a MySQL engine? Or what would other
people advise?
I think you're better off with 4hd's and
here's a quick and dirty way to do it:
1) make the seasons table look like this:
dayofyear int
season enum('winter','spring','summer','fall')
rate decimal(5,2)
2) populate 'seasons' with 1-366 for dayofyear and the corresponding
season and daily rate.
3) to get the total rate do a query like:
Hi,
I'm having problems running queries in my binlog that contain binary
data. Apparently the / character is being interpreted as a mysql
command and I get errors. The queries must have gone through on the
original machine because they're there in the binlog. Specs are:
original server: mysqld
On Thu, 16 Aug 2001 14:11:59 -0500, Tim Thorburn
([EMAIL PROTECTED]) wrote:
Hi,
I'm attempting to store jpg images into a MySQL DB using PHP. I've
found a
few sample scripts that should do this for me, however, they don't
seem to
be working. Could someone take a look at this and see if you
On Fri, 16 Mar 2001 13:35:18 -0500, Hardy Merrill
([EMAIL PROTECTED]) wrote:
Sure it's easier, but which is safer?
I don't have Charles first message on this topic, but I believe
his error message was from logrotate which is a cron job.
If Charles put
mysqladmin -uuser -ppassword
into a
On Mon, 22 Jan 2001 10:49:28 -0800, Ann Ricchiazzi
([EMAIL PROTECTED]) wrote:
Dear mySQL Users,
I am trying to choose between mySQL and Oracle for a Linux server.
My
specific questions are:
1) Will mySQL handle 3000 hits/day well?
I'm on a site that does 90,000 database-heavy pages a day and
14 matches
Mail list logo