We had a similar issue a bit back - and although it sounds similar - based
on your followups it probably isnt, but will just toss this out there
anyhows. We were experiencing connection timeouts when load would ramp up.
Doing some digging we learned that our firewall between the servers
Wanted to thank everyone for the insights for some of this date/time issues!
Pretty much what I was looking at, just wanted a little confirmation!
I will also need to research that PHP function -
Thanks - Chris
On 3/6/07, Marcus Bointon [EMAIL PROTECTED] wrote:
On 6 Mar 2007, at 17:12, David
On 3/1/07, Brian Dunning [EMAIL PROTECTED] wrote:
Is there such a thing as a PHP script that I can put on a cron job to
run every minute and make a test query, and upon failure, restart the
service and maybe send an email to Rackspace support? I don't know
how you'd check that the query was
Does anyone have any resources, guides, insight into the best practice
for storing date/time information when developing a custom web app?
I am mainly concerned with how the TZ should be stored? Should it go
in as UTC and the code accounts for the user TZ? How does one handle
tracking the
On 2/26/07, Chris W [EMAIL PROTECTED] wrote:
Can someone here give some insight and suggest other options I could
look into?
you could replicate all the data between web/application servers, and
use the local store as a read-only database, and push all your
updates to a central update
On 2/22/07, Istvan Hubay Cebrian [EMAIL PROTECTED] wrote:
Hi everyone,
Say I have a DB named... well... database1, this db has the following
tables:
What I want to do is copy each of the tables (exactly as they are, including
primary keys, data, etc) but at the same time change the
I am trying to get a few instances of mysql running at boot time - and
I have come across the command mysqld_multi. Seems to have a lot of
documentation about kicking those off via command line - but not much
on setting it up to start at boot. anyone have any insight into this?
Either using
Starting to build a new schema, and one of the items is image storage
In the past I have always used filesystem storage.
Was wondering if I could get a conversation started on the pros/cons
of database storage verse filesystem
Thanks!
--
--
please respond to the
thanks for everyone help/suggestions --
I wound up swapping the media, and what was corrupt prior, seems to be
all nice and happy now --
so - as suggested, looks to be that the drive was starting to fault
On 7/31/05, Chris McKeever [EMAIL PROTECTED] wrote:
Thanks for all the help - I tried
the same problems running on the
old RH 7.3 kernel (2.4.17 was it?) After upgrading to RH9 it was fine.
Chris McKeever wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two tables that
refuse to stay clean
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two tables that
refuse to stay clean. After a myisamchk (below) they show corruption.
I run a myisamchk -r, they get fixed, and the next day, they are once
again corrupt.
as
the dump - reinsert
On Thursday 28 July 2005 17:45, Chris McKeever wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two tables that
refuse to stay clean. After a myisamchk (below) they show corruption
?
RedHat 7.3
Dan T
On Jul 28, 2005, at 8:45 AM, Chris McKeever wrote:
MySQL 4.0.16
I am having this annoying persistent corruption issue, and am
wondering if anyone has any suggestions. I have two tables that
refuse to stay clean. After a myisamchk (below) they show corruption
On Sun, 22 Aug 2004 16:40:24 -0700, Mike Wexler [EMAIL PROTECTED] wrote:
Chris McKeever wrote:
On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the
piggy bank and build a new linux mysql server
On Mon, 23 Aug 2004 00:25:36 -0500, Debbie Woods
[EMAIL PROTECTED] wrote:
I am building a search feature with Cold Fusion and need to have similar
string matches included in the search results. I have a search form field
called hsname. I am trying to use the SOUNDEX function in my query like
On Sat, 21 Aug 2004 10:18:06 -0700, Info [EMAIL PROTECTED] wrote:
After 2 days in Microsoft HELL with my SQLsvr databases, I'm ready to rob the piggy
bank and build a new linux mysql server. Here's my problem: I have, at present,
two rather large databases. (A: 4Million records in one
I have been plowing through the mysql.com resources for something regarding
the run-time
configuration options as well as the my.cnf. In particular, I am trying to
move the entire information store to a separate hard-drive.
This line confuses me:
--- Note that this is the directory that was
Sorry from the low-level posts, but I am trying to get my grips around some
simple set-up configuration.
- What exactly does basedir do? It defauts to / which to me means it is at
the 'base' of the filesystem. Why/when would you need to change it (since
you would only be moving it up levels -
I also found out that
mysqld --help provides a whole lot more of the information that I was
looking for than just mysql --help!
whoops
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 5:15 PM
To: Chris McKeever; [EMAIL PROTECTED
19 matches
Mail list logo