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 pro
t(11) NOT NULL default '0',
`reviewer` varchar(255) default NULL,
`day` date default NULL,
`status` varchar(255) NOT NULL default 'active',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
KEY `media` (`media`),
FULLTEXT KEY `title` (`title`,`description`,`
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 b
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 als
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
alr
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 als
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'
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&#
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:
> 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
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 Ver
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 y
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
>
>
I think it would be easier to just go:
mysqladmin -uuser -ppassword
On Fri, 16 Mar 2001 11:09:37 -0500, Hardy Merrill
([EMAIL PROTECTED]) wrote:
>Charles,
>
>I think I know what's happening - your MySQL "root" user has
>a password, and "mysqladmin" wants a password before it will
>execute for "r
Hi,
Is there a way to have mysql give up on a query after a certain
length of time?
thanks,
- Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
On Fri, 9 Feb 2001 13:46:45 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>Hi Everyone,
>I have a big problem, that I bet could be solved pretty simply
>but I am
>new to mysql so its killing me and my database.
>
>Ok heres the problem, suddenly out of no where when my php
>script tri
On Fri, 9 Feb 2001 13:46:45 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>Hi Everyone,
>I have a big problem, that I bet could be solved pretty simply
>but I am
>new to mysql so its killing me and my database.
>
>Ok heres the problem, suddenly out of no where when my php
>script tri
On Tue, 30 Jan 2001 10:04:47 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>This underscores a problem I have found with a few asp-driven
>college
>websites. Ungodly long URLs are used to address some of their pages.
>When I have inquired about this, and how to tell a friend where to
>find p
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
19 matches
Mail list logo
