MYSQL  - Created Monday 20 October 2014

 

INFO

syscheck called by root

MySQL RPMs: Home

Sequence: 650  - Command: rpm -qa | grep -i mysql

perl-DBD-MySQL-4.022-1 
mysql-libs-5.1.73-1 
mysql-5.1.73-1 
mysql-bench-5.1.73-1 
mysql-server-5.1.73-1 
mysql-test-5.1.73-1 
MySQL startup file: Home

Sequence: 651  - Command: cat my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

# To allow mysqld to connect to a MySQL Cluster management daemon, uncomment
# these lines and adjust the connectstring as needed.
#ndbcluster
#ndb-connectstring="nodeid=4;host=localhost:1186"

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[ndbd]
# If you are running a MySQL Cluster storage daemon (ndbd) on this machine,
# adjust its connection to the management daemon here.
# Note: ndbd init script requires this to include nodeid!
connect-string="nodeid=2;host=localhost:1186"

[ndb_mgm]
# connection string for MySQL Cluster management tool
connect-string="host=localhost:1186"
		
MySQL version: Home

Sequence: 652  - Command: /opt/freeware/bin/mysqladmin version

/opt/freeware/bin/mysqladmin  Ver 8.42 Distrib 5.1.73, for ibm-aix5.1.0.0 on powerpc
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version		5.1.73
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			5 days 2 hours 18 min 8 sec

Threads: 1  Questions: 79  Slow queries: 0  Opens: 30  Flush tables: 1  Open tables: 23  Queries per second av
		
MySQL variables: Home

Sequence: 653  - Command: /opt/freeware/bin/mysqladmin variables

+-----------------------------------------+-------------------------------------------------------------------
| Variable_name                           | Value                                                             
+-----------------------------------------+-------------------------------------------------------------------
| auto_increment_increment                | 1                                                                 
| auto_increment_offset                   | 1                                                                 
| autocommit                              | ON                                                                
| automatic_sp_privileges                 | ON                                                                
| back_log                                | 50                                                                
| basedir                                 | /opt/freeware/                                                    
| big_tables                              | OFF                                                               
| binlog_cache_size                       | 32768                                                             
| binlog_direct_non_transactional_updates | OFF                                                               
| binlog_format                           | STATEMENT                                                         
| bulk_insert_buffer_size                 | 8388608                                                           
| character_set_client                    | latin1                                                            
| character_set_connection                | latin1                                                            
| character_set_database                  | latin1                                                            
| character_set_filesystem                | binary                                                            
| character_set_results                   | latin1                                                            
| character_set_server                    | latin1                                                            
| character_set_system                    | utf8                                                              
| character_sets_dir                      | /opt/freeware/share/mysql/charsets/                               
| collation_connection                    | latin1_swedish_ci                                                 
| collation_database                      | latin1_swedish_ci                                                 
| collation_server                        | latin1_swedish_ci                                                 
| completion_type                         | 0                                                                 
| concurrent_insert                       | 1                                                                 
| connect_timeout                         | 10                                                                
| datadir                                 | /var/lib/mysql/                                                   
| date_format                             | %Y-%m-%d                                                          
| datetime_format                         | %Y-%m-%d %H:%i:%s                                                 
| default_week_format                     | 0                                                                 
| delay_key_write                         | ON                                                                
| delayed_insert_limit                    | 100                                                               
| delayed_insert_timeout                  | 300                                                               
| delayed_queue_size                      | 1000                                                              
| div_precision_increment                 | 4                                                                 
| engine_condition_pushdown               | ON                                                                
| error_count                             | 0                                                                 
| event_scheduler                         | OFF                                                               
| expire_logs_days                        | 0                                                                 
| flush                                   | OFF                                                               
| flush_time                              | 0                                                                 
| foreign_key_checks                      | ON                                                                
| ft_boolean_syntax                       | + -><()~*:""&|                                                    
| ft_max_word_len                         | 84                                                                
| ft_min_word_len                         | 4                                                                 
| ft_query_expansion_limit                | 20                                                                
| ft_stopword_file                        | (built-in)                                                        
| general_log                             | OFF                                                               
| general_log_file                        | /var/lib/mysql/p520-aix61.log                                     
| group_concat_max_len                    | 1024                                                              
| have_community_features                 | YES                                                               
| have_compress                           | YES                                                               
| have_crypt                              | YES                                                               
| have_csv                                | YES                                                               
| have_dynamic_loading                    | YES                                                               
| have_geometry                           | YES                                                               
| have_innodb                             | NO                                                                
| have_ndbcluster                         | NO                                                                
| have_openssl                            | DISABLED                                                          
| have_partitioning                       | NO                                                                
| have_query_cache                        | YES                                                               
| have_rtree_keys                         | YES                                                               
| have_ssl                                | DISABLED                                                          
| have_symlink                            | YES                                                               
| hostname                                | p520-aix61.bluefinch.local                                        
| identity                                | 0                                                                 
| ignore_builtin_innodb                   | OFF                                                               
| init_connect                            |                                                                   
| init_file                               |                                                                   
| init_slave                              |                                                                   
| insert_id                               | 0                                                                 
| interactive_timeout                     | 28800                                                             
| join_buffer_size                        | 131072                                                            
| keep_files_on_create                    | OFF                                                               
| key_buffer_size                         | 8384512                                                           
| key_cache_age_threshold                 | 300                                                               
| key_cache_block_size                    | 1024                                                              
| key_cache_division_limit                | 100                                                               
| language                                | /opt/freeware/share/mysql/english/                                
| large_files_support                     | ON                                                                
| large_page_size                         | 0                                                                 
| large_pages                             | OFF                                                               
| last_insert_id                          | 0                                                                 
| lc_time_names                           | en_US                                                             
| license                                 | GPL                                                               
| local_infile                            | ON                                                                
| locked_in_memory                        | OFF                                                               
| log                                     | OFF                                                               
| log_bin                                 | OFF                                                               
| log_bin_trust_function_creators         | OFF                                                               
| log_bin_trust_routine_creators          | OFF                                                               
| log_error                               |                                                                   
| log_output                              | FILE                                                              
| log_queries_not_using_indexes           | OFF                                                               
| log_slave_updates                       | OFF                                                               
| log_slow_queries                        | OFF                                                               
| log_warnings                            | 1                                                                 
| long_query_time                         | 10.000000                                                         
| low_priority_updates                    | OFF                                                               
| lower_case_file_system                  | OFF                                                               
| lower_case_table_names                  | 0                                                                 
| max_allowed_packet                      | 1048576                                                           
| max_binlog_cache_size                   | 18446744073709547520                                              
| max_binlog_size                         | 1073741824                                                        
| max_connect_errors                      | 10                                                                
| max_connections                         | 151                                                               
| max_delayed_threads                     | 20                                                                
| max_error_count                         | 64                                                                
| max_heap_table_size                     | 16777216                                                          
| max_insert_delayed_threads              | 20                                                                
| max_join_size                           | 18446744073709551615                                              
| max_length_for_sort_data                | 1024                                                              
| max_long_data_size                      | 1048576                                                           
| max_prepared_stmt_count                 | 16382                                                             
| max_relay_log_size                      | 0                                                                 
| max_seeks_for_key                       | 18446744073709551615                                              
| max_sort_length                         | 1024                                                              
| max_sp_recursion_depth                  | 0                                                                 
| max_tmp_tables                          | 32                                                                
| max_user_connections                    | 0                                                                 
| max_write_lock_count                    | 18446744073709551615                                              
| min_examined_row_limit                  | 0                                                                 
| multi_range_count                       | 256                                                               
| myisam_data_pointer_size                | 6                                                                 
| myisam_max_sort_file_size               | 9223372036853727232                                               
| myisam_mmap_size                        | 18446744073709551615                                              
| myisam_recover_options                  | OFF                                                               
| myisam_repair_threads                   | 1                                                                 
| myisam_sort_buffer_size                 | 8388608                                                           
| myisam_stats_method                     | nulls_unequal                                                     
| myisam_use_mmap                         | OFF                                                               
| net_buffer_length                       | 16384                                                             
| net_read_timeout                        | 30                                                                
| net_retry_count                         | 10                                                                
| net_write_timeout                       | 60                                                                
| new                                     | OFF                                                               
| old                                     | OFF                                                               
| old_alter_table                         | OFF                                                               
| old_passwords                           | ON                                                                
| open_files_limit                        | 755                                                               
| optimizer_prune_level                   | 1                                                                 
| optimizer_search_depth                  | 62                                                                
| optimizer_switch                        | index_merge=on,index_merge_union=on,index_merge_sort_union=on,inde
| pid_file                                | /var/lib/mysql/p520-aix61.pid                                     
| plugin_dir                              | /opt/freeware/lib64/mysql/plugin                                  
| port                                    | 3306                                                              
| preload_buffer_size                     | 32768                                                             
| profiling                               | OFF                                                               
| profiling_history_size                  | 15                                                                
| protocol_version                        | 10                                                                
| pseudo_thread_id                        | 0                                                                 
| query_alloc_block_size                  | 8192                                                              
| query_cache_limit                       | 1048576                                                           
| query_cache_min_res_unit                | 4096                                                              
| query_cache_size                        | 0                                                                 
| query_cache_type                        | ON                                                                
| query_cache_wlock_invalidate            | OFF                                                               
| query_prealloc_size                     | 8192                                                              
| rand_seed1                              |                                                                   
| rand_seed2                              |                                                                   
| range_alloc_block_size                  | 4096                                                              
| read_buffer_size                        | 131072                                                            
| read_only                               | OFF                                                               
| read_rnd_buffer_size                    | 262144                                                            
| relay_log                               |                                                                   
| relay_log_index                         |                                                                   
| relay_log_info_file                     | relay-log.info                                                    
| relay_log_purge                         | ON                                                                
| relay_log_space_limit                   | 0                                                                 
| report_host                             |                                                                   
| report_password                         |                                                                   
| report_port                             | 3306                                                              
| report_user                             |                                                                   
| rpl_recovery_rank                       | 0                                                                 
| secure_auth                             | OFF                                                               
| secure_file_priv                        |                                                                   
| server_id                               | 0                                                                 
| skip_external_locking                   | ON                                                                
| skip_name_resolve                       | OFF                                                               
| skip_networking                         | OFF                                                               
| skip_show_database                      | OFF                                                               
| slave_compressed_protocol               | OFF                                                               
| slave_exec_mode                         | STRICT                                                            
| slave_load_tmpdir                       | /tmp/                                                             
| slave_max_allowed_packet                | 1073741824                                                        
| slave_net_timeout                       | 3600                                                              
| slave_skip_errors                       | OFF                                                               
| slave_transaction_retries               | 10                                                                
| slow_launch_time                        | 2                                                                 
| slow_query_log                          | OFF                                                               
| slow_query_log_file                     | /var/lib/mysql/p520-aix61-slow.log                                
| socket                                  | /var/lib/mysql/mysql.sock                                         
| sort_buffer_size                        | 2097144                                                           
| sql_auto_is_null                        | ON                                                                
| sql_big_selects                         | ON                                                                
| sql_big_tables                          | OFF                                                               
| sql_buffer_result                       | OFF                                                               
| sql_log_bin                             | ON                                                                
| sql_log_off                             | OFF                                                               
| sql_log_update                          | ON                                                                
| sql_low_priority_updates                | OFF                                                               
| sql_max_join_size                       | 18446744073709551615                                              
| sql_mode                                |                                                                   
| sql_notes                               | ON                                                                
| sql_quote_show_create                   | ON                                                                
| sql_safe_updates                        | OFF                                                               
| sql_select_limit                        | 18446744073709551615                                              
| sql_slave_skip_counter                  |                                                                   
| sql_warnings                            | OFF                                                               
| ssl_ca                                  |                                                                   
| ssl_capath                              |                                                                   
| ssl_cert                                |                                                                   
| ssl_cipher                              |                                                                   
| ssl_key                                 |                                                                   
| storage_engine                          | MyISAM                                                            
| sync_binlog                             | 0                                                                 
| sync_frm                                | ON                                                                
| system_time_zone                        | CEST                                                              
| table_definition_cache                  | 256                                                               
| table_lock_wait_timeout                 | 50                                                                
| table_open_cache                        | 64                                                                
| table_type                              | MyISAM                                                            
| thread_cache_size                       | 0                                                                 
| thread_handling                         | one-thread-per-connection                                         
| thread_stack                            | 262144                                                            
| time_format                             | %H:%i:%s                                                          
| time_zone                               | SYSTEM                                                            
| timed_mutexes                           | OFF                                                               
| timestamp                               | 1413802450                                                        
| tmp_table_size                          | 16777216                                                          
| tmpdir                                  | /tmp/                                                             
| transaction_alloc_block_size            | 8192                                                              
| transaction_prealloc_size               | 4096                                                              
| tx_isolation                            | REPEATABLE-READ                                                   
| unique_checks                           | ON                                                                
| updatable_views_with_limit              | YES                                                               
| version                                 | 5.1.73                                                            
| version_comment                         | MySQL Community Server (GPL)                                      
| version_compile_machine                 | powerpc                                                           
| version_compile_os                      | ibm-aix5.1.0.0                                                    
| wait_timeout                            | 28800                                                             
| warning_count                           | 0                                                                 
+-----------------------------------------+-------------------------------------------------------------------
		
MySQL status: Home

Sequence: 654  - Command: echo status | /opt/freeware/bin/mysql

--------------
/opt/freeware/bin/mysql  Ver 14.14 Distrib 5.1.73, for ibm-aix5.1.0.0 (powerpc) using readline 5.1

Connection id:		15
Current database:	
Current user:		root@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:		5.1.73 MySQL Community Server (GPL)
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	latin1
Conn.  characterset:	latin1
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			5 days 2 hours 18 min 9 sec

Threads: 1  Questions: 85  Slow queries: 0  Opens: 30  Flush tables: 1  Open tables: 23  Queries per second av
--------------

		
MySQL Database status: Home

Sequence: 655  - Command: /opt/freeware/bin/mysqlcheck --databases mysql -p

mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log
Error    : You can't use locks with log tables.
status   : OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log
Error    : You can't use locks with log tables.
status   : OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
		
MySQL Databases: Home

Sequence: 656  - Command: select * from db; | /opt/freeware/bin/mysql

ERROR 1046 (3D000) at line 1: No database selected
		
MySQL Users: Home

Sequence: 657  - Command: select * from user; | /opt/freeware/bin/mysql

ERROR 1046 (3D000) at line 1: No database selected
		

Licenced to: BlueFinch BV - sales@bluefinch.nl

Return to homepage


Licenced to: BlueFinch BV - sales@bluefinch.nl

Return to homepage