Re: SAN and ibdata files

e the processes they are referring? > > Thanks, > Rajan > > On 10/8/07, Scott Tanner <[EMAIL PROTECTED]> wrote: > > > > Rajan, > > In a SAN configuration, the lun/volume should appear just like a > > locally attached physical disk on your server. MySQL w

Re: SAN and ibdata files

Rajan, In a SAN configuration, the lun/volume should appear just like a locally attached physical disk on your server. MySQL will not need any special configurations to access it, just poiint the datadir to the SAN disk. Regards, Scott Tanner On Mon, 2007-10-08 at 11:06 +0530, Ace wrote

Re: Slave Misbehavin'

Maybe I missed this in the text below, but are you trying to daisy chain the slaves (master -> slave 1 -> slave 2) or have multiple slaves connecting to one master? Is slave 1 configured with log-slave-updates? Regards, Scott On Wed, 2007-09-19 at 12:31 -0500, [EMAIL PROTECTE

Re: MySql Host through Heartbeat

There's a 'report-host' option that can be set in the conf file to mask the host name. Sounds like this may be set. If you want to get the server's actual host name from within mysql, how about running a system command: mysql> \! hostname; or mysql> \! cat /etc/hostnames; (debi

Re: Diff between restore from tar and recover from power outage

our servers, and we haven't had an issue yet (restoring daily to a testing environment). Regards, Scott Tanner On Mon, 2007-06-04 at 14:57 -0700, Wm Mussatto wrote: > On Mon, June 4, 2007 14:21, murthy gandikota said: > > Hi > > When restoring a DB from a tar file, I had t

Re: SAN backend for DB's

I think you'll need to do a lot of testing to yourself to find the right answer to that. The number of disks, type of disks, and raid configuration will have the most effect on performance. Personally, we had roughly 15% increase in performance from ditching our EMC clarion and going with exte

Re: mysql creating lots of processes (not threads, linux processes)

ook on this page about starting issues: > > http://dev.mysql.com/doc/refman/5.0/en/unix-post-installation.html#starting- > server > > Geoffroy > > -Message d'origine--

Re: mysql creating lots of processes (not threads, linux processes)

Sounds like your not using threaded libraries. Was mysql built differently, or are you using a different RPM on this server? Scott On Tue, 2007-05-29 at 22:49 +0200, Quentin Gouedard wrote: > No, I have just collectd+mrtg, but i don't even use them to monitor mysql. > I launch mysql via /etc/i

Re: Bin logs and mysql 4

On Fri, 2007-04-27 at 09:19 -0500, [EMAIL PROTECTED] wrote: > So if one is doing a full mysqldump every night, all bin-logs can be > deleted after this? On the slave - Yes. In fact I would highly recommend it before starting the slave processes again. This will reset the bin log's 'position' b

Re: Bin logs and mysql 4

mysqldump, just add the --delete-master-logs option. If you want to turn the logs off, remove log-bin and log-bin-index from the conf file. Regards, Scott Tanner On Thu, 2007-04-26 at 09:47 -0700, Scott Haneda wrote: > > In the short term, see the manual page for PURGE MASTER L

Re: Database Replication Fallover

server. Hope this helps, Scott Tanner On Mon, Apr 02, 2007 at 08:43:35AM +0100, Ben Clewett wrote: > I forgot to mention that I am running Linux. > > If anybody has some idea of software which can do this, I'd be very > interested. > > Regards, > > Ben >

Re: More than 4 CPUs?

logy/mysql-performance-whitepaper.pdf I know there were some presentations at this years MySQL Conference that went over this (MySQL Performance Landscape comes to mind). You might be able to find a presentations on the mysql site. Regards, Scott Tanner On Fri, 2006-08-11 at 14:44 -0400, Ed Paule

Re: I don't understand why SCSI is preferred.

were very comparative. The number of disks in the array seemed to have a larger effect then the type of disk. SAS also has more fiber like features then SCSI, making it better suited for HA environments. Just something else to consider. Regards, Scott Tanner Sys Admin www.amientertainment.net

Re: Replicating queries to testing server

On Tue, 2006-06-13 at 19:04, Dan Trainor wrote: > Jake Peavy wrote: > > On 5/24/06, *Dan Trainor* <[EMAIL PROTECTED] > > > wrote: > > > > Hi - > > > > I would like to be able to replicate all queries from a live MySQL > > server, to a testing server at the o

Re: replication after editing bin logs

Can you post the failed SQL statement from your altered bin log, and maybe the preceding commands related to that table? Scott Tanner AMi Entertainment.net On Thu, 2006-03-09 at 08:28, Goldblatt, Eric wrote: > Scott, > > The table already existed before the binlog. The strange

Clarification on innodb status message

Does anyone know what the various lock modes mean in the show innodb status reports? We are investigating a dead-lock issue, and see lock_mode x and lock_mode s. We have transaction that locks a record in mode x, and is appears to be waiting for a lock on the same record in mode s - by the s

Re: host blocked, but can't see errors

I've been having this issue as well, happening more frequently to our production web /ejb servers. I've increased the logging to warning level, but my logs don't contain much (if any) information. Is there a way to increase logging to debug level, or get more information as to what is causing th