mysqld keeps crashing

estarted -- Thanks in advance, Joshua Thomas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: My.cnf

e in effect? > What settings were run prior to this file being in place as > there was no > my.cnf? > -- 1) Run 'SHOW VARIABLES' 2) Restart your mySQL server. 3) Run 'SHOW VARIABLES' again to see the changes. 4) Read The Fine Manual: http://www.mysql.com/doc/

RE: Replace to update records

ecute $select_query: $!\n"); $count = $select_sth->fetchall_arrayref([0]); if ($count > 0) { my $update_sth->execute || die("Could not execute $update_query: $!\n"); } else { my $insert_sth->execute || die("Could not execute $insert_query: $!\n"

RE: SELECT

\u SHOW TABLES Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- Ninety percent of this game is half mental. - Yogi Berra --- > -Original Message- > From: Seena Blace [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January

tuning key_buffer_size

Key_write_requests is usually near 1'; mine is very, very small (< 0.0001). This server is also running apache/php. Any suggestions on how I should proceed in tuning key_buffer_size? Thanks, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED

RE: consistency checking InnoDB tables

That's ok, we got the right answer. Mailing lists are great like that. :-) Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi

consistency checking InnoDB tables

Hi folks, I'm familar with using myisamchk to check/repair myISAM databases; how do I do consistency checks and repair operations on an InnoDB database? Thanks, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there

RE: The Future of MySQL with .NET Plataform

Hi Carlos, Could you please post once and only once, and wait for someone who has insight to respond, instead of spamming this list? Thank you, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between

RE: Mysql 5.x versus 4.x

Download it and try it yourself. That's the only sure way to know. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra --- > -

RE: Deciding whether to convert to InnoDB

Do you need foreign keys? Then the switch to InnoDB may be worthwhile. That's part of the reason I switched. I also had occasional table corruption with my myISAM tables; this also went away when I switched to InnoDB. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 51

RE: Dropping a foreign key in 4.1.x

Nevermind, I found out that the DROP feature is only available in >= 4.0.13 or >= 4.1.1 ...*sigh* Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is.

Dropping a foreign key in 4.1.x

like "CONSTRAINT '0_22'" before the FOREIGN KEY declaration and were able to use that number. Any idea how I get this? I'd really like to drop this key so I can re-add it with an ON DELETE and ON UPDATE clause; :-) Thanks, Joshua Thomas Network Operations Engineer Power

Unexpected restarts

My mySQL server unexpectedly restarts itself from time to time. I am able to verify this as the server uptime resets. I caught it 'in the act' today, but can't tell what the problem is. Does anyone know what causes this behavior? Thanks, Joshua Thomas Network Operations Engineer

RE: Questions about indexing

I agree with all your points. Indexes are very useful, even necessary in some situations. On the other hand, they also use up diskspace, and can slow INSERTs and UPDATEs. If you have a very small database, you may simply not need them. Joshua Thomas Network Operations Engineer PowerOne Media, Inc

RE: Questions about indexing

Find out the real way: Use EXPLAIN and BENCHMARK() commands to get the speed of your operations with and without an index. That's the only way to know for certain. Cheers, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory the

RE: MySQL or MaxDB or PostgreSQL or Interbase/Firebird or ?

curious about what issues you had with PGSQL. Cheers, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. - Yogi Berra ---

RE: Haw to get specific result?

'SELECT product, COUNT(product) FROM table GROUP BY product' will do this, I believe. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory and practice. In practice there is. -

RE: storing .tar files in mysql

s is simplified, but it seems like more overhead. What's the "best practice" method to retrieve images stored in a database for webserving? Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference b

RE: storing .tar files in mysql

s would be much more intensive and require more bandwith and CPU power, again driving our hardware needs up. You could argue that we'd loose the need for the NASes. I haven't done a comparison on how the pricing would work. That's my .02$ and a then some. Joshua Thomas > &

RE: storing .tar files in mysql

Can I ask why? Why not define a char(50) (or whatever size) with the relative or complete path to the .tar file? Storing it in your database would create huge row sizes. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no

RE: MySQL Error

u'll see that you can grant only use of SELECT, or SELECT and UPDATE, and so forth. Your import may be using an option you don't have the correct GRANT rights for. Please review the manual, check your current GRANT rights for your user, adjust as necessary, and let us know how it goes. Cheers, Joshua Thomas

RE: MySQL Error

Several possibilites: 1) Your password for user 'master2' is wrong; 2) master2 doesn't have the proper GRANT rights to do what you want; 3) master2 doesn't exist. Check the mySQL manual. Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL

Creating temp table is causing locking?

s to normal. I turned on slow query logging and general query logging, and I'll be looking through them for any strange queries, but aside from that, is there anything I can do to prevent this locking issue? Thanks all, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-