mysqlcamp II

if this is on the wrong mysql list :) Thanks John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475

monitoring mysql

Ssl_verify_depth Ssl_verify_mode Ssl_version Table_locks_immediate Table_locks_waited Tc_log_max_pages_used Tc_log_page_size Tc_log_page_waits Threads_cached Threads_connected Threads_created Threads_running Uptime John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631

RE: mysqldump/restore

){ `mysql -ppassword $db $db.sql `; } How 'bout something like that? Not perfect but should be ok John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: B. Keith Murphy [mailto:[EMAIL PROTECTED] Sent

Binlog errors

20 Jun 13 17:08 relay.index -rw-r--r-- 1 root root 55 Jun 27 10:53 test.txt What is going on here? John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475

RE: Binlog errors

Ext3 fs on an emc SAN. Rhel 4 box with 4 cpus and tons of memory. I have no problems with other types of files- only binlogs. I am using mostly innodb tables. It is a high load server but that's no excuse to corrupt all the binlogs John Mancuso Linux Administrator/MySQL DBA IT Infrastructure

RE: Binlog errors

Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 12:04 PM To: John Mancuso Cc: mysql@lists.mysql.com Subject: Re: Binlog errors Do

index question

If I have 2 large tables A and B and I need to join them: select * from A,B where A.col1=B.col1 If A.col1 is an index and B.col1 is not, if I create an index on B.col1 will this index be used? In other words how are indexes used on table joins? Thanks John Mancuso Linux Administrator/MySQL

RE: {Spam?} Re: mysqldump problem with large innodb tables...

Have you considered using the archive storage engine? I have gotten 30:1 compression using it. Create table archive_multimedia engine=Archive as select * from multimedia table John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475

Looking for a MySQL 5 DBA

if this is the wrong forum/mailing list. Thanks everyone John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

Have you looked in your mysql error log in your data directory? Check /datadir/hostname.err FYI- the locate command needs to be updated. It can show old info if you don't run updatedb frequently John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

Start mysqld_safe with --console OR --error-log=/logdirectory/errlog.err --console will print your errors to the screen ./mysqld_safe --console John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From

RE: ERROR 2002 (HY000): Can't connect to local MySQL server

I would try my best to find a way to login as root or maybe user mysql. John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 12

RE: maximum number of records in a table

We have 1/2 a billion records in one Innodb table on one server. Still extremely quick. The only limit is hardware John Mancuso Linux Administrator/MySQL DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Paul DuBois [mailto:[EMAIL