mysqld keeps crashing

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

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/en/index.html Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel

RE: Replace to update records

$update_query: $!\n); } else { my $insert_sth-execute || die(Could not execute $insert_query: $!\n); } -- Good luck, Joshua Thomas Network Operations Engineer PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- Ninety percent of this game is half mental. - Yogi Berra

RE: SELECT

\u database 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 21

tuning key_buffer_size

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] --- In theory

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 Berra

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

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: 518-687

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 --- -Original

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

Dropping a foreign key in 4.1.x

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 PowerOne Media, Inc. tel: 518-687-6143 [EMAIL PROTECTED] --- In theory there is no difference between theory

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. - Yogi

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 PowerOne Media

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. - Yogi Berra

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

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: 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

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: storing .tar files in mysql

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 dan Joshua Thomas wrote: Can I ask why? Why not define a char(50) (or whatever size) with the relative or complete path to the .tar file

RE: storing .tar files in mysql

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 between theory and practice. In practice there is. - Yogi Berra --- Conversely

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

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 PROTECTED

RE: MySQL Error

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

Creating temp table is causing locking?

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-687-6143 [EMAIL PROTECTED