Re: Odd Behavior During Replication Start-Up

going to try this again tomorrow: shutting down MySQL completely, creating a ZFS snapshot, and rsync'ing the snapshot over to the slave server. I did this once before unsuccessfully, but I'll do it one more time just to be sure. -- Tim Gustafson t...@soe.ucsc.edu 831-459-5354 Baskin Engine

Re: Odd Behavior During Replication Start-Up

? Or perhaps does that also only work for MyISAM tables? If so, that ought to be called out more clearly in the documentation. -- Tim Gustafson t...@soe.ucsc.edu 831-459-5354 Baskin Engineering, Room 313A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Odd Behavior During Replication Start-Up

t in one statement ("LOAD DATA FROM MASTER"), but they dropped it because of the difficulties in getting all the master data that way. -- Tim Gustafson t...@soe.ucsc.edu 831-459-5354 Baskin Engineering, Room 313A -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Odd Behavior During Replication Start-Up

can't be sure. I'm doing an "optimize table" on all my tables across all my databases now to make sure there's no weird corruption going on, but I'm not holding my breath with regard to if that will fix anything. -- Tim Gustafson t...@soe.ucsc.edu 831-459-5354

Pruning the slow_log Table

r_host column was broken up into two separate columns, "user" and "host", and if those values would match exactly the data in the mysql.user table so that the two tables are easier to correlate. Thanks! Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@so

Re: Problems Connecting with SSL

et no more information when I use "--verbose --verbose --verbose" than when I don't. Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Problems Connecting with SSL

t any useful debugging information, I'm having a hard time understanding why. As to why I didn't call Redwood Shores: I didn't realize that Oracle was in the business of giving out free tech support. I just e-mailed the mySQL general support list, which is usually what I do when

Re: Problems Connecting with SSL

mysql> select version(); ++ | version() | ++ | 5.1.51-log | ++ The server and the client are both running FreeBSD as follows: FreeBSD 8.1-RELEASE-p2 Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailing Lis

Problems Connecting with SSL

oing wrong? I'm using the exact same command line options and ssl-ca file that I am using on other clients, which can connect successfully. (As an aside: feature request: better SSL connection debugging, please!) Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.ed

Re: selecting data for computation

lan on changing the limit clause from "limit %d, 1" to something like "limit 500" and then iterating through the results until I get one that succeeds, as that is more efficient than running multiple select queries. Anyhow, thanks for all the good suggestions and poin

Re: selecting data for computation

s 0, do the processing, otherwise do: i = i + 1; continue; and that seems to be working like a charm now. Thanks for your help! Tim Gustafson 831-332-1496 t...@tgustafson.com http://tgustafson.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: selecting data for computation

column and indexed it, and set its current value to length(image_data), and modified my "update" query to set image_data_size correctly once the job is done. When I run more than one compute job, they all start processing the same job simultaneously. What am I missing? Tim Gu

Re: selecting data for computation

column as it's a longblob and I was under the impression that indexing a longblob field wasn't helpful. Maybe I should add a work_data_size field as an integer, index that, and search for records where work_data_size = 0. For what it's worth, the table currently has 800,000 rows in

selecting data for computation

I can't seem to find the answer. Does anyone have any suggestions? Tim Gustafson 831-332-1496 t...@tgustafson.com http://tgustafson.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Database Quotas

ve built in to mySQL for people who don't have ZFS, or who can't use it for some reason. Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Database Quotas

If they're still in good health, then I suppose that I could use ZFS file systems to allocate space for databases...it just seems that this ought to be a feature of the database. :) Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General M

Re: Database Quotas

ictions, and what we're trying to accomplish is to prevent any one of those users from going out of control (either by accident, due to a bug, or on purpose) and clobbering the entire mySQL server. Better to have one "dead" database than a whole server. Tim Gustafson Baskin

Re: spamassassin database

> Given a database that is doing 90% writes, what database engine should I > use? You may also want to increase your key_buffer_size: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_key_buffer_size Tim Gustafson Baskin School of Engineering UC Santa

Re: spamassassin database

engine should I > use? myISAM will be the fastest for this type of access, I think. Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.co

Re: Database Quotas

ow, that's the first time I've read a message on a support list that seriously said "use another program" in response to a (IMHO) reasonable feature request. :) But then again, your domain name is "obviouslymalicious.com", so... Tim Gustafson Baskin School of E

Re: Database Quotas

ven statement would cause the database to exceed its quota (and it could do so in a way that doesn't corrupt the database files) Or it could work the opposite way: check the current usage against the quota before executing a statement, and if the database is already over quota, don't even a

Database Quotas

at can corrupt the database if the disk becomes full. So, is this a feature that seems useful to other people? It would certainly be useful to me. Thanks for a great product! Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailin

Re: Master/Slave Replication Question

n read-heavy environments. As I mentioned before, my main goal here is geographic redundancy, load balancing and the ability to use applications that aren't really designed to be used with master/slave replication (Drupal, WordPress, etc) without having to modify those applications.

Re: Master/Slave Replication Question

ation that I'd like to see in mySQL. If you don't like my idea, don't use the feature if and when it ever comes into being. Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Master/Slave Replication Question

raphically redundant. So yeah, maybe lots of custom-written software handles the read/write split configuration well, but there's lots more that doesn't. I don't know of a single open source application that does. So again, I go back to my original statement: replication is a data

Re: Master/Slave Replication Question

e server problem, not an application problem. Tim Gustafson Baskin School of Engineering UC Santa Cruz t...@soe.ucsc.edu 831-459-5354 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Master/Slave Replication Question

t could totally be implemented as a configurable option, something like a simple my.cnf setting that says "slave_pass_upadtes_to_master" or something. Has anyone suggested anything like this before? Any thoughts/comments/flames? Tim Gustafson Baskin School of Engineering UC Santa Cruz t..

CVS-Like System For Database Changes

ectly) so that when a customer uses CVS to get the newest version of the code for their project, they can also get (and automatically apply) all changes to their database for the new version. Does such a system exist? How do other people cope with these types of updates? Thanks for any guidance!

Can't find any matching row in the user table

fied by 'hispassword'; Any help is appreciated. Tim -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tim Gustafson - [EMAIL PROTECTED] http://www.falconsoft.com/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Question: REPLACE function

--+ Thanks in advance for any help. At the worst case, I guess this is a request for a feature. Tim -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Tim Gustafson - [EMAIL PROTECTED] http://www.falconsoft.com/ -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-