Re: Locked myself out

solution to delete the whole thing and re-install it? stop the mysql process, then restart it with the --skip-grant-tables option, reset the passwords, and then restart it as normal. -- Jim Richardson http://www.eskimo.com/~warlock Have you ever noticed that at trade shows Microsoft is

Re: Speeding up MySQL server

hits) which would save a fair amount of contention time on the main table (If I understand it correctly). I'll have to look into this. -- Jim Richardson http://www.eskimo.com/~warlock Madness takes its toll. Please have exact change ready. signature.asc Description: Digital signature

Re: Speeding up MySQL server

On Wed, Mar 24, 2004 at 08:21:15PM -0600, Paul DuBois wrote: At 17:55 -0800 3/24/04, Jim Richardson wrote: I have a rather heavily loaded server, which I would like to tweak a little more performance out of. It currently is binlogging although there is no slave yet. Does the process of bin logging

Speeding up MySQL server

;t too bad. But I am curious about the internal to MySQL load of logging all that data. -- Jim Richardson http://www.eskimo.com/~warlock All true wisdom is found on T-shirts. signature.asc Description: Digital signature

Re: Max Open Tables

On Tue, Mar 23, 2004 at 11:34:13AM -0800, Jim Richardson wrote: I am trying to push the performance of a Mysql database a little more, it's pretty busy, but I hope to squeeze a tad more out of it. I am a newbie/pretty clueless wrt MySQL in general, so ... I run the status command, and se

Max Open Tables

nd avg: 322.082 The value for Open Tables is 512, which looks suspiciously to me like it's hit a limit. Is there a way to increase that limit? Or am I misunderstanding what status is telling me? -- Jim Richardson http://www.eskimo.com/~warlock Ahhh... I see the fuck-up fairy has visite

Re: Preventing Duplicate Entries

ve, but they will be few and far between. -- Jim Richardson http://www.eskimo.com/~warlock The race isn't always to the swift, nor the battle to the strong, But it's the safest way to bet. signature.asc Description: Digital signature

Moving server

aking into account? The firewall rules will block all connections to 3306 that don't come from either Alpha or Beta, the data isn't sensitive in any way, so I am not worried about sniffing, and I will shut the replication connection down after all is working on Beta. Thanks all. --

Re: privileges question

On Mon, Feb 23, 2004 at 05:30:38PM -0600, Paul DuBois wrote: At 15:18 -0800 2/23/04, Jim Richardson wrote: Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I don't feel like using stuff from out of the RH tree.) I am a little confused about the privileges. I have do

privileges question

so mysql -u [EMAIL PROTECTED] I get in, no password. How can I tell mysql to refuse anything that isn't from localhost, and to require a password for root no matter what? Thanks. New to MySQL and databases in general, trying to make sure I don't screw up too badly. -- Jim Richardson

Re: Advise on High Availability configuration

ny more people interested in yours experience. Greetings. A.J.Millan ZATOR Systems. Very much so! -- Jim Richardson http://www.eskimo.com/~warlock If space is warped, time is all that's weft. signature.asc Description: Digital signature

Re: Read Slaves, and load balancing between them...

I'll probably wind up using ssh or stunnel. -- Jim Richardson http://www.eskimo.com/~warlock I'll get a life when it is proven and substantiated to be better than what I am currently experiencing. signature.asc Description: Digital signature

Re: Read Slaves, and load balancing between them...

am considering stunnel, or ssh tunnel, or is there something in MySQL I can use to connect securely? -- Jim Richardson http://www.eskimo.com/~warlock "We have to go forth and crush every world view that doesn't believe in tolerance and free speech," - David Brin signature.asc Description: Digital signature

Re: BUG IN MYSQL

eports "appraised.MYD" cannot be opened. What is going on? Ran your exact command sequence here, on MySQL 4.0.16, running on Linux, and it worked just fine. No need to comment out the insert. -- Jim Richardson http://www.eskimo.com/~warlock Man's way to God is with beer in hand. --Koffyar Tribal Wisdom, Nigeria signature.asc Description: Digital signature

Re: Quering user privileges

to assign (GRANT) and remove (REVOKE) privileges, but there is not a SQL command to query current privileges. At least on MySQL 4.0.16, SHOW GRANTS FOR [EMAIL PROTECTED]; shows me the relevent info. I don't know if that's MySQL specific, or not present in 3.x or something. -- Jim

Hot standby database question

allow that in MySQL? As an aside, a recommendation on good beginner and intermediate level MySQL books would be appreciated. I want to RTFM, but I want to make sure it *is* the Fine manual :) Oh, and seasons greetings to all, yes I'm working on Christmas, it's a startup, what can I say