I generally drop them into /tmp for easy access and cleanup after the data
load, but you can put them any place that the mysql daemon process has
access to read.
Scott Helms
Vice President of Technology
ZCorum
(678) 507-5000
http://twitter.com/kscotthelms
le type?
Have you looked at the processes that are running when run your query?
mysqladmin -p process
Will show what is happening, another very useful tool is mytop:
http://jeremy.zawodny.com/mysql/mytop/
Scott Helms
--
MySQL General Mailing List
For list archives: http://lists.mysq
information on your set up thats about all anyone
can provide. If you are reason
Scott Helms
On Fri, 2003-08-01 at 15:17, Daniel Negron/KBE wrote:
> I have an osCommerce Site along with another Dating site on a completely
> different server. on the oscommerce site I have 1200 products a
on the master, this gave me fits for
several hours one day while moving a slave to being the master when the
then current master died of a bad hard drive.
No guarantees, but this will greatly improve your chances of an
intelligent answer. ;p
Scott Helms
On Mon, 2003-03-31 at 17:04, trashMan wrote
Massi,
How about looking in the data directory, on the master. There will be
a file called hostname.err the contents will probably lead you to the
answer or least give some more data for the list to look at ;p
Scott Helms
On Mon, 2003-03-31 at 16:29, trashMan wrote:
> There are
se problems are close to universal in the space.
Scott Helms
On Mon, 2003-03-31 at 12:00, Ben Edwards wrote:
> Anyone know why the two ISPs I use (www.pair.com, www.oneandone.co.uk)
are
> still using V3 and don't have any timescal
k
changing the RDBMS will fix the problem.
Scott Helms
- Original Message -
From: "Benji Spencer" <[EMAIL PROTECTED]>
To: "Brent Baisley" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 10:13 AM
Subject: Re: How much data ca
estart the slave. Once that is done
test replication by going to the master and creating a database, then check
on the slave to ensure its there with a show databases.
Scott Helms
- Original Message -
From: "Bartomiej Dolata" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]&g
ack in with the root password and all of your other
accounts are unaffected.
Scott Helms
- Original Message -
From: "Nick Wilson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 1:32 PM
Subject: Re: lost root password trouble
> -
hanging the new
(4.x) tree.
Scott Helms
- Original Message -
From: "Joe Bifano" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 5:54 PM
Subject: MYSQL REPLICATION
> I am trying to configure mysql for redundancy using replication and th
priv: N
Index_priv: N
Alter_priv: N
1 row in set (0.01 sec)
Scott Helms
Director of Technology, ZCorum
- Original Message -
From: "Leonard Megliola" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, March 27, 2002 12:16 PM
Subject: Re: Replicati
oint, I can feel
the water getting deeper :-)
Scott Helms
Director of Technology, ZCorum
(770) 888-8900 ext 2205
- Original Message -
From: "Alexander, Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 25, 2002 12:21 PM
Subject: RE: Problem loading
browser.
It should show the mysl support section.
Scott Helms
- Original Message -
From: "Alexander, Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 25, 2002 11:34 AM
Subject: RE: Problem loading PC DB into Solaris
> Yep, all that st
;
and had no problem, now when I try this I have to grab a new shot of the
master's data directory and copy it over to the slaves.
Info:
Solaris 8
MySql version 3.23.41-log
Thanks,
Scott Helms
-
Before posting, please
lem probably isn't MySql, however, I think
you will identify the problem before reaching the end :-)
Scott Helms
Director of Technology, ZCorum
- Original Message -
From: "Alexander, Chris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 25
I have a fairly decent server who is handling lots of connections, but very
simple SQL and I am looking for tuning advice. I have a pretty high number
of simultaneous connections and the box is showing a few signs of stress,
that I want to address before they become a problem. Any help will be
g
Luc,
I think you have to do the manual inserts to make this work before the
tables are there. I wrestled with this problem briefly, before writing a
quick script.
Scott Helms
Director of Technology, ZCorum
- Original Message -
From: "Luc Foisy" <[EMAIL PROTECTED]>
Mark,
This probably won't get you the response you wanted. How about letting
us know where you have gotten to and where things seem to be breaking. A
generalized request for "what do I do" often recieves little or no help.
Some basic system information would also be much appreciated; what d
ot;host=%", but I don't
reccomend this! Instead read this section from the manual on adding users:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#Adding_users
I also reccomend you read the section on the privilege system:
http://www.mysql.com
Try this:
If you are using a table handler in MySQL that doesn't support transactions,
you must use LOCK TABLES if you want to ensure that no other thread comes
between a SELECT and an UPDATE. The example shown below requires LOCK TABLES
in order to execute safely:
mysql> LOCK TABLES trans READ,
Steve,
There isn't an automated way, but you can at least semi-script this. To
switch the slave to the master after the old master has failed and then
brought back up do this:
Shut down MySQL on the NEW master
mysqladmin -u root -p shutdown
Snapshot all the data on your NEW master server.
Steve,
Are the two servers roughly equal in terms of hardware?
Scott Helms
>
> Please help, I've read through the manual and this case is suggested but
> not really
> laid out. I'm using mysql 3.23.37 and can't upgrade to 4.0 yet.
>
> Okay, I'v
Robert,
You need to provide alot more data. How about platform and MySQL
version to start, a copy of your config (my.cnf) file, and provide exactly
what you're typing and the response.
Scott Helms
- Original Message -
From: "robertix" <[EMAIL PROTECTED]>
23 matches
Mail list logo
