mysqlcamp II
Has any info been posted yet on mysqlcamp II in Brooklyn NY at Polytechnic University? I've looked all over mysqlcamp.org but haven't found any schedules, speakers, topics.. etc yet. I figured that 1 month away there would be some kind of buzz/discussion. I apologize ahead of time 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
I am running a fairly large Innodb database on mysql 5.x and would like to know what would be the best variables to monitor (for Nagios)- for instance: threads connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow queries etc Aborted_clients Aborted_connects Binlog_cache_disk_use Binlog_cache_use Bytes_received Bytes_sent Com_admin_commands Com_alter_db Com_alter_table Com_analyze Com_backup_table Com_begin Com_change_db Com_change_master Com_check Com_checksum Com_commit Com_create_db Com_create_function Com_create_index Com_create_table Com_dealloc_sql Com_delete Com_delete_multi Com_do Com_drop_db Com_drop_function Com_drop_index Com_drop_table Com_drop_user Com_execute_sql Com_flush Com_grant Com_ha_close Com_ha_open Com_ha_read Com_help Com_insert Com_insert_select Com_kill Com_load Com_load_master_data Com_load_master_table Com_lock_tables Com_optimize Com_preload_keys Com_prepare_sql Com_purge Com_purge_before_date Com_rename_table Com_repair Com_replace Com_replace_select Com_reset Com_restore_table Com_revoke Com_revoke_all Com_rollback Com_savepoint Com_select Com_set_option Com_show_binlog_events Com_show_binlogs Com_show_charsets Com_show_collations Com_show_column_types Com_show_create_db Com_show_create_table Com_show_databases Com_show_errors Com_show_fields Com_show_grants Com_show_innodb_status Com_show_keys Com_show_logs Com_show_master_status Com_show_ndb_status Com_show_new_master Com_show_open_tables Com_show_privileges Com_show_processlist Com_show_slave_hosts Com_show_slave_status Com_show_status Com_show_storage_engines Com_show_tables Com_show_triggers Com_show_variables Com_show_warnings Com_slave_start Com_slave_stop Com_stmt_close Com_stmt_execute Com_stmt_fetch Com_stmt_prepare Com_stmt_reset Com_stmt_send_long_data Com_truncate Com_unlock_tables Com_update Com_update_multi Com_xa_commit Com_xa_end Com_xa_prepare Com_xa_recover Com_xa_rollback Com_xa_start Compression Connections Created_tmp_disk_tables Created_tmp_files Created_tmp_tables Delayed_errors Delayed_insert_threads Delayed_writes Flush_commands Handler_commit Handler_delete Handler_discover Handler_prepare Handler_read_first Handler_read_key Handler_read_next Handler_read_prev Handler_read_rnd Handler_read_rnd_next Handler_rollback Handler_savepoint Handler_savepoint_rollback Handler_update Handler_write Innodb_buffer_pool_pages_data Innodb_buffer_pool_pages_dirty Innodb_buffer_pool_pages_flushed Innodb_buffer_pool_pages_free Innodb_buffer_pool_pages_latched Innodb_buffer_pool_pages_misc Innodb_buffer_pool_pages_total Innodb_buffer_pool_read_ahead_rnd Innodb_buffer_pool_read_ahead_seq Innodb_buffer_pool_read_requests Innodb_buffer_pool_reads Innodb_buffer_pool_wait_free Innodb_buffer_pool_write_requests Innodb_data_fsyncs Innodb_data_pending_fsyncs Innodb_data_pending_reads Innodb_data_pending_writes Innodb_data_read Innodb_data_reads Innodb_data_writes Innodb_data_written Innodb_dblwr_pages_written Innodb_dblwr_writes Innodb_log_waits Innodb_log_write_requests Innodb_log_writes Innodb_os_log_fsyncs Innodb_os_log_pending_fsyncs Innodb_os_log_pending_writes Innodb_os_log_written Innodb_page_size Innodb_pages_created Innodb_pages_read Innodb_pages_written Innodb_row_lock_current_waits Innodb_row_lock_time Innodb_row_lock_time_avg Innodb_row_lock_time_max Innodb_row_lock_waits Innodb_rows_deleted Innodb_rows_inserted Innodb_rows_read Innodb_rows_updated Key_blocks_not_flushed Key_blocks_unused Key_blocks_used Key_read_requests Key_reads Key_write_requests Key_writes Last_query_cost Max_used_connections Not_flushed_delayed_rows Open_files Open_streams Open_tables Opened_tables Qcache_free_blocks Qcache_free_memory Qcache_hits Qcache_inserts Qcache_lowmem_prunes Qcache_not_cached Qcache_queries_in_cache Qcache_total_blocks Questions Rpl_status Select_full_join Select_full_range_join Select_range Select_range_check Select_scan Slave_open_temp_tables Slave_retried_transactions Slave_running Slow_launch_threads Slow_queries Sort_merge_passes Sort_range Sort_rows Sort_scan Ssl_accept_renegotiates Ssl_accepts Ssl_callback_cache_hits Ssl_cipher Ssl_cipher_list Ssl_client_connects Ssl_connect_renegotiates Ssl_ctx_verify_depth Ssl_ctx_verify_mode Ssl_default_timeout Ssl_finished_accepts Ssl_finished_connects Ssl_session_cache_hits Ssl_session_cache_misses Ssl_session_cache_mode Ssl_session_cache_overflows Ssl_session_cache_size Ssl_session_cache_timeouts Ssl_sessions_reused Ssl_used_session_cache_entries 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-622-6382 c: 516-652-2475
RE: mysqldump/restore
#!/usr/bin/perl
#dump all files
@db=`mysql -e -ppassword show databases | sed s/-//g | sed s/
//g`;
foreach $db(@db){
chomp($db);
`mysqldump $db -ppassword $db.sql`;
}
#multiple files will load simultaneously. multiple processes should run
much faster
foreach $db(@db){
`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: Tuesday, July 10, 2007 4:36 PM
To: mysql
Subject: mysqldump/restore
hey all. Let me throw out a quick question. We are upgrading from some
version of 4.1 to the latest version of 5.0. MySQL recommends that you
dump and re-import data with this type of move. Not only do they
recommend the dump/import - it would be nice to optimize all our tables
at the same time!!
I have done a test dump of a couple of gigs of data with just a straight
mysqldump. That worked, but the import is happening slower than
Christmas. I know that one technique for speeding up the imports is to
where you configure the dump so that it generates file(s) with the
schema for the table(s) and file(s) with actual data. Then you can use
the load data infile command to import the data after generating the new
tables (maybe by using 'mysql table1.sql').
So here is the problem. It worked, but it was slow. Not because of the
speed of the import but because I am having to issue a command (and type
in the root password) for each table import. I could do the following:
'cat *.sql database.sql' to get a complete schema for all the tables
in the database and then just 'mysql database.sql' to set up all the
tables at the same time. You can't do that with the import of the actual
data. You have to individually load the data into each table. something
like 'load data infile /root/table1.txt'.
This is fine for one..but what happens when you have 100 tables? I can't
take the time to sit there and hit the up-arrow to retrieve the command
and then type in the new file name. Is there some way to automate this
data import?
Thanks,
Keith
--
B. Keith Murphy
Database Administrator
iContact
2635 Meridian Parkway, 2nd Floor
Durham, North Carolina 27713
(o) 919-433-0786
(c) 850-637-3877
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Binlog errors
This seems to be a frequent occurrence: [EMAIL PROTECTED] dblog]# mysqlbinlog mysql.25 /*!40019 SET @@session.max_insert_delayed_threads=0*/; ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15 Could not read entry at offset 4:Error in log format or read error This is happening to all my binlogs (other servers as well) all the time. There is nothing wrong with the drive- I have other data on there that never gets corrupted. [EMAIL PROTECTED] dblog]# ll total 4676748 drwx-- 2 mysql mysql 16384 May 29 11:50 lost+found -rw-rw 1 mysql mysql 1073746319 Jun 24 00:43 mysql.20 -rw-rw 1 mysql mysql 1073784914 Jun 24 03:50 mysql.21 -rw-rw 1 mysql mysql 1073754672 Jun 24 06:57 mysql.22 -rw-rw 1 mysql mysql 1073743683 Jun 26 10:24 mysql.23 -rw-rw 1 mysql mysql 111863423 Jun 26 11:41 mysql.24 -rw-rw 1 mysql mysql 377289867 Jun 27 10:53 mysql.25 -rw-rw 1 mysql mysql120 Jun 26 23:00 mysql.index -rw-rw 1 mysql mysql 12418 Jun 26 23:47 mysql-slow.log -rw-rw 1 mysql mysql117 Jun 13 17:08 relay.01 -rw-rw 1 mysql mysql 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 American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 11:33 AM To: John Mancuso Subject: Re: Binlog errors Not that any ideas are jumping out at me but what file system are you employing here? and what types of MySQL tables are you using? I note from the listing above that you seem to be taking extremely high volumn (1G in barely over 3 hours on a couple occasions). It seems a bit spooky to me that the majority of your logs are capped at a level just over 1 Gig (2^30 = 1073741824). MyISAM has been known to spontaneously corrupt it's data files under extremely high load although I have not heard of this happening at the binlog level. - michael dykman On 6/27/07, John Mancuso [EMAIL PROTECTED] wrote: This seems to be a frequent occurrence: [EMAIL PROTECTED] dblog]# mysqlbinlog mysql.25 /*!40019 SET @@session.max_insert_delayed_threads=0*/; ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15 Could not read entry at offset 4:Error in log format or read error This is happening to all my binlogs (other servers as well) all the time. There is nothing wrong with the drive- I have other data on there that never gets corrupted. [EMAIL PROTECTED] dblog]# ll total 4676748 drwx-- 2 mysql mysql 16384 May 29 11:50 lost+found -rw-rw 1 mysql mysql 1073746319 Jun 24 00:43 mysql.20 -rw-rw 1 mysql mysql 1073784914 Jun 24 03:50 mysql.21 -rw-rw 1 mysql mysql 1073754672 Jun 24 06:57 mysql.22 -rw-rw 1 mysql mysql 1073743683 Jun 26 10:24 mysql.23 -rw-rw 1 mysql mysql 111863423 Jun 26 11:41 mysql.24 -rw-rw 1 mysql mysql 377289867 Jun 27 10:53 mysql.25 -rw-rw 1 mysql mysql120 Jun 26 23:00 mysql.index -rw-rw 1 mysql mysql 12418 Jun 26 23:47 mysql-slow.log -rw-rw 1 mysql mysql117 Jun 13 17:08 relay.01 -rw-rw 1 mysql mysql 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 -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Binlog errors
I ran mysqlbinlog --force and that spit it out: # at 15873 #070626 13:07:43 server id 2 log_pos 15539 Query thread_id=85 exec_time=0 error_code=0 SET TIMESTAMP=1182877663; @[EMAIL PROTECTED]@[EMAIL PROTECTED]@ [EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@^H^@ #070626 13:07:43 server id 2 log_pos 15759 Query thread_id=85 exec_time=0 error_code=0 SET TIMESTAMP=1182877663; @[EMAIL PROTECTED]@[EMAIL PROTECTED]@ [EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED] [EMAIL PROTECTED]@[EMAIL PROTECTED]@[EMAIL PROTECTED]@insert into Table (ID, col2, col3, col4, col5, col6) values (, , xx, xx, xx, xxx); # at 16311 There is no windows/unix conversion here- not sure where these characters are coming from. Could this be a SAN driver issue? I changed some of the queries by the way to hide some query details. John 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 you have any other applications which work the SAN as hard as MySQL does? Im not familiar with the EMC but have you run it through through a stress test? I agree that load sohuldn't cause corruption but, sad to say, in some cases it does. We have had similar difficulties with certain SANs under high stress. - michael dykman On 6/27/07, John Mancuso [EMAIL PROTECTED] wrote: 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 American Home Mortgage w: 631-622-6382 c: 516-652-2475 -Original Message- From: Michael Dykman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 11:33 AM To: John Mancuso Subject: Re: Binlog errors Not that any ideas are jumping out at me but what file system are you employing here? and what types of MySQL tables are you using? I note from the listing above that you seem to be taking extremely high volumn (1G in barely over 3 hours on a couple occasions). It seems a bit spooky to me that the majority of your logs are capped at a level just over 1 Gig (2^30 = 1073741824). MyISAM has been known to spontaneously corrupt it's data files under extremely high load although I have not heard of this happening at the binlog level. - michael dykman On 6/27/07, John Mancuso [EMAIL PROTECTED] wrote: This seems to be a frequent occurrence: [EMAIL PROTECTED] dblog]# mysqlbinlog mysql.25 /*!40019 SET @@session.max_insert_delayed_threads=0*/; ERROR: Error in Log_event::read_log_event(): 'Found invalid event in binary log', data_len: 94, event_type: 15 Could not read entry at offset 4:Error in log format or read error This is happening to all my binlogs (other servers as well) all the time. There is nothing wrong with the drive- I have other data on there that never gets corrupted. [EMAIL PROTECTED] dblog]# ll total 4676748 drwx-- 2 mysql mysql 16384 May 29 11:50 lost+found -rw-rw 1 mysql mysql 1073746319 Jun 24 00:43 mysql.20 -rw-rw 1 mysql mysql 1073784914 Jun 24 03:50 mysql.21 -rw-rw 1 mysql mysql 1073754672 Jun 24 06:57 mysql.22 -rw-rw 1 mysql mysql 1073743683 Jun 26 10:24 mysql.23 -rw-rw 1 mysql mysql 111863423 Jun 26 11:41 mysql.24 -rw-rw 1 mysql mysql 377289867 Jun 27 10:53 mysql.25 -rw-rw 1 mysql mysql120 Jun 26 23:00 mysql.index -rw-rw 1 mysql mysql 12418 Jun 26 23:47 mysql-slow.log -rw-rw 1 mysql mysql117 Jun 13 17:08 relay.01 -rw-rw 1 mysql mysql 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 -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] - All models are wrong. Some models are useful. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 DBA IT Infrastructure American Home Mortgage w: 631-622-6382 c: 516-652-2475
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
-Original Message-
From: DuĊĦan Pavlica [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 19, 2007 5:08 AM
To: Hartleigh Burton
Cc: MySql
Subject: {Spam?} Re: mysqldump problem with large innodb tables...
Try to look for Lost connection error in MySQL manual and it can give your some
hints like http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Dusan
Hartleigh Burton napsal(a):
Hi All,
I have a database which is currently at ~10GB in it's test phase. It
is containing uncompressed audio and is expected to reach 1.5TB in no
time at all. I am just running some backup tests and I have been
having lots of problems creating an accurate backup.
I have tried both MySQL Administrator mysqldump, both applications
drop out on the same table, the table `trackdata` which contains ~9GB
worth of data. There is no single row any larger than 50MB, most
average around 40MB. Windows 2000 Server, MySQL v5.0.37-community-nt
and all tables are InnoDB.
If anyone can help me out with this problem the assistance is greatly
appreciated. I have scoured google and various other sources and not
found much information that has been useful to me. I hope I have
enough info below... if more is required let me know.
mysqldump example
P:\mysqldump -u username -p mraentertainment mraentertainment.sql
--opt --verbose --max_allowed_packet=500M --hex-blob
--single_transaction --net_buffer_length=100M Enter password: **
-- Connecting to localhost...
-- Retrieving table structure for table albums...
-- Sending SELECT query...
...
-- Retrieving rows...
-- Retrieving table structure for table trackdata...
-- Sending SELECT query...
-- Retrieving rows...
mysqldump: Error 2013: Lost connection to MySQL server during query
when dumping table `trackdata` at row: 1
my.ini configuration file
[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
log-bin=itd002-bin
server-id=1
port=3306
wait_timeout=86400
max_allowed_packet=100M
basedir=C:/Program Files/MySQL/MySQL Server 5.0/
datadir=C:/Program Files/MySQL/MySQL Server 5.0/Data/
default-character-set=latin1
default-storage-engine=INNODB
sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_connections=100
query_cache_size=0
table_cache=256
tmp_table_size=77M
thread_cache_size=8
#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_max_extra_sort_file_size=100G
myisam_sort_buffer_size=154M
key_buffer_size=130M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K
#skip-innodb
innodb_additional_mem_pool_size=6M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=3M
innodb_buffer_pool_size=252M
innodb_log_file_size=126M
innodb_thread_concurrency=8
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Looking for a MySQL 5 DBA
Looking for a MySQL 5 DBA with linux experience to work with me for a large company on Long Island New York. Good salary/benefits etc. We're doing a lot of cutting edge stuff with replication as well as other areas. Feel free to call me or drop me an email with a resume if you know anyone. Sorry 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 c: 516-652-2475 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 12:25 PM To: John Mancuso Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server Hiya, I could not find .err file anywhere. and my mysql.sock file is showing 0 bytes in it. - ash# --- John Mancuso [EMAIL PROTECTED] wrote: 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 c: 516-652-2475 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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:48 PM To: John Mancuso Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070619 17:40:10 mysqld ended --- John Mancuso [EMAIL PROTECTED] wrote: Hiya, These are the outputs i get when using mysqld_safe --console as root mysqld_safe --console Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysqld.pid 070619 17:45:48 mysqld ended as user [EMAIL PROTECTED] mysql]$ mysqld_safe --console Starting mysqld daemon with databases from /var/lib/mysql /usr/bin/mysqld_safe: line 363: /var/log/mysqld/mysqld.log: Permission denied rm: cannot remove `/var/lib/mysql/mysql.sock': Permission denied /usr/bin/mysqld_safe: line 371: /var/log/mysqld/mysqld.log: Permission denied STOPPING server from pid file /var/run/mysqld/mysqld.pid tee: /var/log/mysqld/mysqld.log: Permission denied 070619 17:46:52 mysqld ended tee: /var/log/mysqld/mysqld.log: Permission denied I could not locate the logdirectory, any pointers to this please? - ash# 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: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 12:25 PM To: John Mancuso Subject: RE: ERROR 2002 (HY000): Can't connect to local MySQL server Hiya, I could not find .err file anywhere. and my mysql.sock file is showing 0 bytes in it. - ash# --- John Mancuso [EMAIL PROTECTED] wrote: 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 c: 516-652-2475 -Original Message- From: Ahamarshan jn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 11:54 AM To: mysql@lists.mysql.com Subject: ERROR 2002 (HY000): Can't connect to local MySQL server Hi, I was appending Grant previledges to some databases in mysql; either i typed something wrong or there is a bug which I am uncertain about, but what happened was I could not login as su anymore. I then solved this problem by changing grp (chgrp) permission in /bin/su and it works fine. However I could not connect to mysql again When I start mysql I get the following error $ mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I could not start nor stop any running mysql I tried to reboot my system hoping that the process will terminate and restart fresh but during shutdown I see the message that mysql shutdown failed. Upon booting again I could not start mysql Even though it shows the file here [EMAIL PROTECTED] locate mysql.sock /var/lib/mysql/mysql.sock the cat of my.cnf is $ cat my.cnf [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with old and # shorter password hash. # Reference: http://dev.mysql.com/doc/mysql/en/Password_hashing.html old_passwords=1 [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] err-log=/var/log/mysqld/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Also I tried to kill mysql by using PID ie kill -9 'PID' but each time the PID changes when i do ps -ax|grep mysql and it fails to kill mysql. Can some Mysql messiah help me solve this problem. Thank you in advance - ash# PS: I guessed it was quite a common error but when searched through the list it retrived me null post, hence I am posting this. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 PROTECTED] Sent: Tuesday, June 19, 2007 4:53 PM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: maximum number of records in a table At 6:24 PM -0400 6/11/07, kalin mintchev wrote: hi all... from http://dev.mysql.com/doc/refman/5.0/en/features.html: Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows. that's cool but i assume this is distributed over a few machines... No. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
