mysql log rotation

the MySQL server process. To turn it on again: fix the cause, shutdown the MySQL server and restart it. I'm looking for either solutions to this problem or alternate, more reliable, methods to accurately rotate the log data. Regards, Atle -- MySQL General Mailing List For list archiv

Negative connection/thread IDs in mysqld.log?

Id CommandArgument 101212 8:00:01 -2049127301 Connect ... Regards, Atle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Finding replicated database

Hi, care to elaborate on the pit-falls of binlog-do-db? Thanks, Atle On Wed, 4 Mar 2009, Baron Schwartz wrote: No. But I would recommend removing binlog-do-db and using replicate-wild-do-table=.% on the slave instead. The binlog-do-db approach has many pitfalls anyway, and is likely to

Re: Master-to-Master replication on same server

You should be able to do this fine. It would help if you specified what the error you were getting was. Atle On Tue, 22 Jul 2008, Jim Lyons wrote: I recently installed 2 instances of mysql on the same server, using port 3307 for the second server, the normal 3306 for the first server. I

Re: Reset of Status Parameters

I don't think anyone answered your actual question, so here's my attempt.. http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html "Many status variables are reset to 0 by the FLUSH STATUS statement." Atle On Fri, 20 Jun 2008, Venu Madhav Pada

Re: multiple instances on same server

er is to consolidate old legacy products onto a single server to save on rackspace. Works great in my experience. Atle On Fri, 30 Nov 2007, Sid Lane wrote: this is more of a best practices question than a techical one but when/why has anyone run multiple mysql instances on the same serv

Re: MySQL - master/slave replation question

; http://www.byveka.com/files/check_replic Cheers, Atle On Thu, 15 Nov 2007, bruce wrote: Hi... If I have a master/slave setup, I can do a "mysql>show slave status\G" and get information on the overall status of the slave. Is there a way to break out this information with

Re: master status is null

Sounds like Gerald is right, your database server is not configured to support replication. Have you given your database server a 'server-id'? On Wed, 20 Jun 2007, Gerald L. Clark wrote: > Ananda Kumar wrote: > > Hi All, > > We have setup replication. Mysql version 5.0.40. On master db, if i ex

Re: MySql Host through Heartbeat

name (SHOW VARIABLES LIKE 'server_id') as it is unique. Ben - just curious, why is heartbeat tied in with the server IP? Is it monitoring the server instead of the mysql daemon to check if it's up? :) Cheers, Atle On Wed, 13 Jun 2007, Scott Tanner wrote: > There's a

Re: mysqldump running out out of memory

Have you tried this flag? -q, --quick Don't buffer query, dump directly to stdout. On Sun, 29 Apr 2007, Fredrik Carlsson wrote: > Hi, > > I have a problem with mysqldump, its exiting with the message > > mysqldump: Error 5: Out of memory (Needed 22042208 bytes) when dumping > table `t

Re: How to overwrite existing file with SELECT .. INTO?

There is no option to do this to my knowledge. However, this would be a quick workaround: - TRUNCATE TABLE ; # clears table completely, akin to doing DROP/CREATE TABLE - INSERT INTO SELECT .. FROM ..; On Mon, 16 Apr 2007, Amer Neely wrote: > > At 08:14 AM 4/13/2007, Amer Neely wrote: > >> I'm

Re: Replication performance questions

Out of curiosity, how many queries/sec are you able to push from each slave? If I may ask.. :) Atle On Mon, 5 Mar 2007, Ross Vandegrift wrote: > On Fri, Mar 02, 2007 at 12:57:25AM -0800, Gary W. Smith wrote: > > Pdns? > > Close! bind-dlz > > > Anyway, did you enabl

Re: SQL and PHP: Incorrect errorcode

Joern, is the client version of mysql in PHP the same as your client libs on the server (where you run perror)? PHP is often times compiled with its own mysql libs and you have to specifically tell PHP to build with the system mysql libs if you want to. Just a thought. Atle On Sun, 25 Feb 2007

Re: 2 ways replication

ml If you need more than 2 masters, then all bets are off.. Atle On Mon, 12 Feb 2007, Rilawich Ango wrote: > Hi all, > > I know it is an old question and I have read from the mysql website > about the topic. Until now, mysql still doesn't support 2 ways > replication, qu

Re: Questions about delete and optimize

NOW()) http://dev.mysql.com/doc/refman/5.0/en/insert-select.html - DROP TABLE `` - RENAME TABLE `` TO `` - UNLOCK TABLES The above may be faster if you have an index on 'date'. Atle On Thu, 1 Feb 2007, Ian Barnes wrote: > Hi, > > We are looking at various methods t

Re: Replication Problem?

Ed, this is unfortunately "by design". Personally I don't get why this choice was made... Reference: http://lists.mysql.com/mysql/190869 Regards, Atle FCI, Inc. - Unix Systems Administrator On Tue, 12 Dec 2006, Ed Pauley II wrote: > We recently upgraded t

Re: MySQL on a ram disk?

ur data and how you work with it in more detail as the list will be able to help you tune your database. Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 8 Nov 2006, Ryan Stille wrote: > We have an intense data process that runs every few minutes, clearing > and then lo

Re: mysqld_multi startup stop

multi_admin account by executing the following commands for each server: shell> mysql -u root -S /tmp/mysql.sock -p Enter password: mysql> GRANT SHUTDOWN ON *.* -> TO 'multi_admin'@'localhost' IDENTIFIED BY 'multipass'; The username/password goes in your my.cnf

Re: Running a Staging and Development DB on the same server?

databases on a different daemon? Issue one bad query on the devel database and you take down your website... Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 29 Sep 2006, Jay Paulson wrote: > I'm setting up our one server for staging and development. I am need to set &g

Re: Slave behind master... or not ?

our 1st and 2nd 'SHOW SLAVE STATUS' query a large amount of replicated queries were processed causing the slave to temporarily lag behind. Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 5 Sep 2006, Jocelyn Fournier wrote: > Hi, > > I encounter a really strang

Re: MySQL Load Balancing

rite ratio where you can get by having only one master while using multiple replicated slaves (even for really high traffic sites). Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 4 Aug 2006, Atle Veka wrote: > You can have a simple LVS setup running with a plugi

Re: MySQL Load Balancing

mysql loadbalancer in my experience. Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 4 Aug 2006, Ed Pauley II wrote: > I am looking into a scale-out solution for MySQL. I have read white > papers and searched the web but I can't find a load balancer that claims > to

Re: MySQL Performance Question

nt to hog all the disk IO? Ignoring the latter questions, with a properly designed database and tuned queries this doesn't seem like an impossible setup on a single database daemon. Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 16 Jun 2006, Robinson, Eric wrote: > Our s

Re: Replicating queries to testing server

ttlenecks. It's much easier and less time consuming to do things like above and generally being in tune with your system. Setting up performance graphs based on your system or mysqld performance is worth the time. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL Gene

RE: Fixing Databases When Replication Is Enabled?

L 4.1 or up; the commands that mysqlcheck (by default) send the master will be replicated to the slave. I hope this made sense. :) Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 3 May 2006, Robinson, Eric wrote: > So, just to be clear, when I run: > > mysqlche

Re: Fixing Databases When Replication Is Enabled?

REPAIR statement on the slave will not fix the data consistency issue. I can't say this for sure, but I would imagine there aren't many scenarios where a REPAIR on a slave would fix consistency issues. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing

Re: ~Mysql performance~

n both the servers that inserts 25,00,000 records. first server takes > 7.5 hrs, while the second server takes around 17 hrs for the same > process. Are these queries run from localhost or from a remote location? It's very unusual for an IDE based system to outperform SCSI. Atle - Flyin

Re: ~Master & Slave setup on the same machine~

Yes, that is certainly possible and would be just the same as configuring replication between different machines. Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 20 Apr 2006, Mohammed Abdul Azeem wrote: > Hi, > > Is it possible to configure a master and slave server on

Re: mysql on tmpfs

That would be pretty dangerous if I ever needed to say rebuild a table and run out of memory. Atle - Flying Crocodile Inc, Unix Systems Administrator On Sat, 8 Apr 2006, Gabriel PREDA wrote: > If there is plenty of free memory... > Can't you completly disable SWAP ? > -- &

Re: Problem running multi master replication

n :) ) Hold on, "(it should be, its the same file)", you're saying that db2 on server1 and server2 are using the same database files (datadir)? If that's the case, why? That doesn't make any sense. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL G

mysql on tmpfs

from time to time, temporarily killing performance, swapping in/out to make room. debian w/ 2.6.15 kernel Thanks, Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Re: Replication for historical data

ueries and when they occur, you may have to look into parsing the binlogs yourself... Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 7 Apr 2006, Ian Collins wrote: > Hi, > I have a customer who wants to be able to replicate their live MySQL > database to a second serv

Thank you MySQL Cluster

attend. Should I also thank you for selling my email address to a 3rd party company (Continuent, Inc) advertising 'Replication and load-balancing' Webcasts, or did they automatically gather emails from the main MySQL mailinglist? And, no thanks, I'm no longer interested in MySQL Cl

Re: replication after editing bin logs

the SUPER privilege to set this option. This means that you can run the DELETE queries on the master only, leaving the slave untouched. Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 8 Mar 2006, Goldblatt, Eric wrote: > Hello, > > > Another division in my organization

Re: Database Corruption and MySQL

tables into database query> UNLOCK TABLES; Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 7 Mar 2006, Michael Jeung wrote: > Hi Folks, > > We've got a Single Master/Multiple Slave environment. > Recently, we had some corruption on one of the slaves and I had to

Re: MySQL and Hyperthreading

n all servers wherever possible.. Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 2 Mar 2006, Hiro Yoshioka wrote: > Hi, > > We found a severe performance degradation when Hyperthreading is on > and thread_concurrency=20. > > We are using OSDL DBT-1 as the benchmark a

Re: Multi Master Replication

Your subject is misleading, I would rather call this something like Chained Replication. Unless your slaves all replicate from 'Master', in that case your drawing is the culprit. :) Does the error log on slave3 or slave2 indicate any problems? Atle - Flying Crocodile Inc, Un

Re: Local 'replication'

To my knowledge the only way you can do this is by running 2 daemons on the same host. You can easily do this with the 'mysqld_multi' script that comes with mysql. Atle - Flying Crocodile Inc, Unix Systems Administrator On Mon, 13 Feb 2006, Rob Gormley wrote: > Short of runn

Re: Relication from multiple databases

No, unfortunately you cannot have multiple masters on a single replication slave. You can however have multiple daemons running on system (C) via mysqld_multi. Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 13 Jan 2006, Jeff wrote: > Anyone know if it's possib

Re: MySQL Replication

propriately in your code, say $dbh_write and $dbh_readonly. Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 6 Jan 2006, Jason Williard wrote: > I am trying to understand exactly how replication works. So far, I see that > changes made on a master server are replica

Re: ISAM tables broken

Where are your .frm files, are you not including them in your directory listing or are they missing? If they're missing, that's most likely your problem right there.. :) Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 4 Jan 2006, Simon Faulkner wrote: > An ol

Re inconsistent replication?

them have ever had problems that didn't come from user error. :) Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: load balance for mysql servers

ibute your connections. I have quoted optimal as your success depends on how you configure your distribution, but it should still work better than the previous solution. Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 29 Dec 2005, lee_mezimedia wrote: > Hello, > > We have

Re: what about slave_skip_errors variables

, with the exception for replication (slave) threads and users with the SUPER privilege It's hard to say what happened when you told mysqld to skip the error. What are your mysqld versions? Atle - Flying Crocodile Inc, Unix Systems Administrator

Re: PHP4 or PHP5?

Just be glad you're not stuck supporting a product that was designed about 6 years ago. "Hey, let's have each account get its own table" [db1:~] find -L /usr/local/mysql -name \*.frm | wc -l 8116 The programmer that designed that system is now synonymous with bad desi

Re: Bug in 4.0? 'CREATE TABLE `db`.`table ..' fails silently on replication slave

More investigation shows that the query does make it to the slave, at least into the relay log, yet it's still ignored. 'replicate-do-db' is set and shows the correct DB in the slave status. Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 20 Oct 2005, Atle Veka

Bug in 4.0? 'CREATE TABLE `db`.`table ..' fails silently on replication slave

cific database. This works whether or not there is a current database. If you use quoted identifiers, quote the database and table names separately. For example, `mydb`.`mytbl` is legal, but `mydb.mytbl` is not." Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailin

RAID stripe size recommendations

etc)? Is linux preferred, if so why? Thanks! Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Timezone setting wrong?

I use this in my.cnf (along with mysqld_multi settings fwiw) and it works great (mysql version 4.0.X): [mysqld_safe] timezone = GMT It depends on how you start up mysqld.. If you don't use mysqld_safe, the above wont work for you. Atle - Flying Crocodile Inc, Unix Systems Administ

Re: spreading the disk load

)? | DATA DIRECTORY = 'absolute path to directory' | INDEX DIRECTORY = 'absolute path to directory' Having the data and index files on seperate drives can certainly speed up IO. I know these options work for MyISAM, but am not sure about InnoDB. Atle - Flying Crocodi

Re: Split a table?

Depends on how your table is designed. You could do an 'INSERT INTO .. SELECT FROM ..' with a WHERE/ORDER BY/LIMIT combo (switch the ORDER BY for each new table). It would be probably easiest if you have an AUTO_INCREMENT field.. Atle - Flying Crocodile Inc, Unix Systems Administrat

Re: Tuning MySQL

un [in the client]: 'EXPLAIN ' . That will give you an idea of where index(es) would benefit. Check the manual for EXPLAIN to decipher the output. Good luck! Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 1 Jul 2005, Siegfried Heintze wrote: > Are there any tools f

Re: replication general question

r how accurate it is.. Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 23 Jun 2005 [EMAIL PROTECTED] wrote: > > I have two mysql boxes setup. Fast machines, I think they are dual 3ghz > with boat loads of ram. They are not real busy servers but they have > some pretty

Re: Will multiple MASTER threaded writes break replication?

tabase. Offloading queries onto something like memcached can also give you great speed increases, but along with that are some gotchas to be aware of. Just some cents from my side, I obviously don't know anything about the setup you are working with. :) Atle - Flying Crocodile Inc, Unix Systems Adm

Re: Will multiple MASTER threaded writes break replication?

r is 1. Out of curiosity, how many queries are we talking and what sort of complexity level? I've had replication setups do 600 (simple) updates/s and slaving was current most of the time and never more than 1 second behind. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL

Re: Considering migration from MyISAM to InnoDB

ven't already done so. Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 14 Jun 2005, Stembridge, Michael wrote: > I currently use MyISAM on an internal web application server; our data takes > up 10mb at this time, though this is likely to grow substantially in the >

Re: [Newbie] Slow slave update.

On Fri, 10 Jun 2005, Nico Alberti wrote: > 2005/6/10, Atle Veka <[EMAIL PROTECTED]>: > > The speed of the drive will have a lot to say on how long the queries run. > > You haven't said anything about what type of master you have, OS, mysqld > > Thank you all for y

Re: [Newbie] Slow slave update.

emons configured/tuned? Atle - Flying Crocodile Inc, Unix Systems Administrator On Thu, 9 Jun 2005, Nico Alberti wrote: > Hi everybody. > > Is it normal that, after a massive number (300.000) of INSERTs on the > master server (that however did not take more than some minutes), my > l

Re: how can I close the cache for mysql

... queries. 2 = DEMAND = Cache only SELECT SQL_CACHE ... queries. (http://dev.mysql.com/doc/mysql/en/select.html) Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 7 Jun 2005, qin lei wrote: > I am running a test on mysql. In a specific conditiob I need avoid using > the

Re: replication stopped

It's impossible to say pretty much without more information. Have you checked the error log on the slave? How about 'SHOW SLAVE STATUS'? Did your "backup guy" gzip all binlogs, if so that would most definitely stop replication. Atle - Flying Crocodile Inc, Unix Systems

Re: Is there a way

SELECT ... INTO OUTFILE 'filename' export_options': http://dev.mysql.com/doc/mysql/en/select.html The 'export_options' are the same as this syntax: http://dev.mysql.com/doc/mysql/en/load-data.html That may work for you. Atle - Flying Crocodile Inc, Unix Systems Admi

Re: Opteron HOWTO?!

I can see for myself.. Atle - Flying Crocodile Inc, Unix Systems Administrator On Mon, 9 May 2005, Kevin Burton wrote: > Great! I created a wiki node for this issue. > > http://hashmysql.org/index.php?title=Opteron_HOWTO -- MySQL General Mailing List For list archives: http://lists

Re: MySQL not using optimum disk throughput.

9% of the queries on the non-RAID setup are simple UPDATEs. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL not using optimum disk throughput.

.00 0 0.00 0.00 0 0.00 0 2 14 1 83 The last setup was barely able to handle the load with pthreads as it does spike to 700q/s daily, but with linuxthreads it's not even that loaded anymore. Both of these systems are dual P4s. Atle - Flying Crocodile Inc, Unix Systems Administrator -

Re: Need help w/ re-starting Replication

? Does 'SHOW SLAVE STATUS\G' show any errors? Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication and switching master

, and asking more specific questions. :) Atle - Flying Crocodile Inc, Unix Systems Administrator On Fri, 29 Apr 2005, Patrik Wallstrom wrote: > Hi! > > I have setup replication with one master and one slave. > What do I have to think about in order to minimize hassle > and dow

Re: Replication - is there a "server lag"?

her than that: does anybody here have a Nagios script that checks if > replication is running O.K.? :-) I just put the one I use up on the web, use it at your own risk! :) http://byveka.com/nagios/ Regards, Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing

Re: slave out of sync

eak just by itself, most of the time it's a misconfiguration or users sending updates directly to the slave. We have replication setups that generate up to 4gigs of binlog data daily, and none of them have ever broken just by themselves. It's always been a misconfiguration, IE user error. Hope t

Re: MyISAM and Dirty Reads

Sounds like this is what you want: http://dev.mysql.com/doc/mysql/en/handler.html Atle - Flying Crocodile Inc, Unix Systems Administrator On Wed, 13 Apr 2005, Homam S.A. wrote: > Is there a way to use dirty reads (that acquire no > read locks on the table) with MyISAM tables? > &g

Re: Question about replication

Here are two posts on list that you might find relevant: http://lists.mysql.com/mysql/182017 http://lists.mysql.com/mysql/180889 Atle - Flying Crocodile Inc, Unix Systems Administrator On Tue, 12 Apr 2005, Luis Calero wrote: > Hello, I've been discussing with a coworker if it'

Re: Grants not entirely propagated to slaves?

What version of MySQL are you using? Also, are you issuing only "GRANT .." statements or modifying the privilege tables manually as well? Search for 'GRANT': http://dev.mysql.com/doc/mysql/en/replication-features.html Atle - Flying Crocodile Inc, Unix Systems Administrator

Re: Making Slave a Master

r (dual master) replication setup? It's covered in the High Performance MySQL book by Derek Balling and Jeremy Zawodny: http://dev.mysql.com/books/hpmysql-excerpts/ch07.html However, be very careful if you have any AUTO_INCREMENT fields. Good luck! :) Atle - Flying Crocodile Inc, Unix Sy

Re: load data from master

his approach myself so keep that in mind as I may have missed some steps while plotting it out in my head; I would suggest trying this out in a test environment first. Let us know how it works out if you decide to try it out. Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL Ge

Re: safe way of replication?

Even if you replicate the 'mysql' DB, GRANT/REVOKE statements are not replicated, nor are FLUSH statements. So if you are adding new access privileges on the master they will not be active on the slave until you issue FLUSH PRIVILEGES (one the slave). Hope this helps. :) Atl

Re: Read / Write statistics

ounters (I do however recommend using a DERIVE ds vs. COUNTER). Cacti is an open source tool based on rrdtool with a MySQL statistics plugin, also something to look at: http://forums.cacti.net/about6108-0-asc-0.html Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing

Re: replication with automatic master failover problems

g information as it will start from the beginning. I have never tried this exact scenario myself, but hopefully you can work with the ideas. :) Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Excessive Server Load Problems

the data and if it was able to use any indexes. Links: http://dev.mysql.com/doc/mysql/en/explain.html http://dev.mysql.com/doc/mysql/en/mysql-indexes.html If you're still having issues, show us your table design. :) Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL Genera

Re: Excessive Server Load Problems

concurrent connections, assuming you are the only one using the mysql server. Atle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Empty 'Relay_Master_Log_File'?

mmand on the > new slave so it starts downloading relay logs at the proper position. Eric, interesting point, I will have to get to the bottom of that so that I can ensure that my slaves have identical data! ;) Luckily I alway seed from an idle slave so it should only be minor inconsistencies if that e

Re: Empty 'Relay_Master_Log_File'?

ay logs. > http://dev.mysql.com/doc/mysql/en/slave-logs.html > > -Eric Hi Eric, I do not include the relay logs/relay-log.info when I seed slaves as from what I understand the new slave will start populating new relay logs starting at the position from master.info. Thanks, Atle -- My

Re: Empty 'Relay_Master_Log_File'?

lay_Master_Log_File: [..] The way the seeding was done was that the slave got a copy of the replicated DB + master.info from an existing slave. Thanks, Atle -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Empty 'Relay_Master_Log_File'?

nyone else has experienced this? The reason why I caught this is that our monitoring software relies on that field being populated to calculate replication delay. Thanks, Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Re: load balacing in a replicated environment

The easiest way, which does not need any code changes, is to set up DNS round robin. Every time the application resolves the database domain name it gets a "random" (I believe the nameserver just circulates the list) IP back. Atle - Flying Crocodile Inc, Unix Systems Administrator

Replication fails to resume after master crash

were reported in any of the error logs. The fix both times was to issue "SLAVE STOP ; SLAVE START ;". The 4.1 slave has been unaffected in both instances. Is this a known bug? Thanks! Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list arch

Master/Master failover setup question

a few discussions on the topic of failover setups and circular replication but haven't found anything that satisfies my needs yet. Any help/pointers would be greatly appreciated. Thanks! Atle - Flying Crocodile Inc, Unix Systems Administrator -- MySQL General Mailing List For list arc

Re: Problems maintaining large high-availability search

#x27;DELETE ... LIMIT' takes by adjusting the vs. how many times an hour/day you want to run it. If you still want your table optimized every so often, try doing it only every Sunday morning or whenever the database activity is low. :) Atle - Flying Crocodile Inc, Junior Unix Systems Administra

Re: MySQL performance on FreeBSD compared to Linux

you'll get the most gains from by far. :) I would also strongly advise you to upgrade to 15k SCSI drives as the speed improvements are well worth it. Regards, Atle - Flying Crocodile Inc, Junior Unix Systems Administrator On Fri, 21 May 2004, Chris Elsworth wrote: > Forenote: I h

RE: mysqld too busy to check its grant tables?

What versions are you seeing this on? We've seen it exclusively on 3.23.58, with or without LinuxThreads enabled. See: http://lists.mysql.com/mysql/164717 Atle - Flying Crocodile Inc, Junior Unix Systems Administrator On Mon, 26 Apr 2004, Donny Simonton wrote: > Jeremy, > We hav

Re: mysqld too busy to check its grant tables?

//dev.mysql.com/doc/mysql/en/News-3.23.58.html Atle - Flying Crocodile Inc, Junior Unix Systems Administrator On Mon, 26 Apr 2004, Jeremy Zawodny wrote: > On Mon, Apr 26, 2004 at 11:27:46AM -0700, MySQL wrote: > > > > Hi, I have a FreeBSD 4.9-R server running 3.23.58-log an

Re: mysqld too busy to check its grant tables?

;ve found that neither FLUSH HOSTS or FLUSH PRIVIELGES > have any effect. > > Was that the case for you folks as well? It actually fixed itself once the server calmed down. Your book (High Performance MySQL) is on order and we'll be working in linuxthreads testing into our schedule at s

Privilege table replication

ts. Anyone ever done something like this, or have any suggestions? Please reply to me as well as the list as I am not normally on the list (and lately signing up for the list has taken 24+hrs). Thanks! Atle - Flying Crocodile Inc, Junior Unix Systems Administrator

Re: Q about mysql_install_db under FreeBSD ports

I guess part of my question is: . When did the change in the mysql code happen so that the -s switch is added to hostname for the mysql_install_db? . For what particular reason? :) Thanks, Atle On Wed, 31 Oct 2001, Atle Veka wrote: > > On Wed, 31 Oct 2001, Dan Nelson wrote: >

Re: Q about mysql_install_db under FreeBSD ports

On Wed, 31 Oct 2001, Dan Nelson wrote: > In the last episode (Oct 31), Atle Veka said: > > Is there any good reason for ``mysql_install_db'' to use the -s > > option to hostname instead of using FQDN? Every time I install mysql > > 3.23 out of ports, it fails ru

Q about mysql_install_db under FreeBSD ports

; work/mysql-3.23.36/scripts/mysql_install_db hostname=`/bin/hostname -s`# Install this too in the user table Thanks! :) Atle - Flying Crocodile Inc, Unix Systems Administrator - Before posting, please check:

mysql 3.23 w/ replication enabled silently "dies" (pluss a littleventing..)

pens: 86 Flush tables: 1 Open tables: 80 Queries per second avg: 638.305 # uname -a FreeBSD 3.2-RELEASE FreeBSD 3.2-RELEASE #0: Tue Feb 13 01:06:48 PST 2001 root@: i386 Regards, Atle - Flying Crocodile Inc, Unix Systems Administrator

RE: more date problems

what type is the signup_date field? AFAIK, datetime fields should show show the full date (and time) even though you don't insert it. So it should be '2001-03-01 00:00:00' or whatever NOW() inserts, if thats what you use :) Atle

Re: Maximum Password length?

rantee that it won't break anything) Atle On Wed, 28 Feb 2001, Tyrone Mills wrote: > My apologies if this is an easy question. I've looked at the docs in the > privilege section and haven't found a mention of the max length of password > for MySQL. I want to set a fairly

Re: PHP and mysql

ou show us here, we can't really help you much. btw; PHP doesn't care what SQL statements you use. It's MySQL that complains and demands the correct syntax.. :) Atle On Tue, 27 Feb 2001, Chris Hallgren wrote: > PHP and mysql dont work for some reason i installed both as directed

Re: Problem with mysql

ere is quite normal from what he's doing (although it's clearly not what he wants to do). this is the same thing as doing: select 1+1; which will give 2 as a result. instead of a numerical expression he's doing a string. Atle > Chris Hallgren wrote: > > > > ok here i

Re: Problem with mysql

; ehh.. You are not selecting the database there ;) use is the correct syntax to select a database. MySQL is doing exactly what it's being told by you :) by quoting it, it's just saying display me this.. HTH Atle ---

  1   2   >