Linux - Server This forum is for the discussion of Linux Software used in a server related context.
Notices
Welcome to
LinuxQuestions.org , a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free.
Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
Are you new to LinuxQuestions.org? Visit the following links:
Site Howto |
Site FAQ |
Sitemap |
Register Now
If you have any problems with the registration process or your account login, please
contact us . If you need to reset your password,
click here .
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a
virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month.
Click here for more info.
05-05-2014, 02:55 PM
#1
LQ Newbie
Registered: May 2014
Posts: 29
Rep:
mysql: unrecognized service
Hello ,
I have centos 6 32-bit
when i try to run this command
service mysql start
it give me : mysql: unrecognized service
what shall i do?
05-05-2014, 03:48 PM
#2
Moderator
Registered: Aug 2002
Posts: 25,694
Welcome to LinuxQuestions.
Is mysql installled? The correct syntax is mysqld
Are you logged as root or used su - from a terminal window.
05-05-2014, 03:49 PM
#3
LQ Newbie
Registered: May 2014
Posts: 29
Original Poster
Rep:
note : the mysqld give me
Stopping mysqld: [ OK ]
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
my log
Code:
140505 16:42:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-05-05 16:42:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-05-05 16:42:00 5657 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
2014-05-05 16:42:00 5657 [Note] Plugin 'FEDERATED' is disabled.
2014-05-05 16:42:00 5657 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-05-05 16:42:00 5657 [Note] InnoDB: The InnoDB memory heap is disabled
2014-05-05 16:42:00 5657 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-05-05 16:42:00 5657 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-05-05 16:42:00 5657 [Note] InnoDB: Using Linux native AIO
2014-05-05 16:42:00 5657 [Note] InnoDB: Not using CPU crc32 instructions
2014-05-05 16:42:00 5657 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-05-05 16:42:00 5657 [Note] InnoDB: Completed initialization of buffer pool
2014-05-05 16:42:00 5657 [Note] InnoDB: Highest supported file format is Barracuda.
2014-05-05 16:42:01 5657 [Note] InnoDB: 128 rollback segment(s) are active.
2014-05-05 16:42:04 5657 [Note] InnoDB: Waiting for purge to start
2014-05-05 16:42:04 5657 [Note] InnoDB: 5.6.17 started; log sequence number 6274671
2014-05-05 16:42:04 5657 [ERROR] Aborting
2014-05-05 16:42:04 5657 [Note] Binlog end
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'partition'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'ARCHIVE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_METRICS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMPMEM'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_CMP'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_LOCKS'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'INNODB_TRX'
2014-05-05 16:42:04 5657 [Note] Shutting down plugin 'InnoDB'
2014-05-05 16:42:04 5657 [Note] InnoDB: FTS optimize thread exiting.
2014-05-05 16:42:04 5657 [Note] InnoDB: Starting shutdown...
2014-05-05 16:42:07 5657 [Note] InnoDB: Shutdown completed; log sequence number 6274681
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'BLACKHOLE'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'MRG_MYISAM'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'CSV'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'MEMORY'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'MyISAM'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'sha256_password'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'mysql_old_password'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'mysql_native_password'
2014-05-05 16:42:07 5657 [Note] Shutting down plugin 'binlog'
2014-05-05 16:42:07 5657 [Note]
140505 16:42:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
05-05-2014, 03:51 PM
#4
Moderator
Registered: Aug 2002
Posts: 25,694
05-05-2014, 03:54 PM
#5
LQ Newbie
Registered: May 2014
Posts: 29
Original Poster
Rep:
Is mysql installled? yes it is
The correct syntax is mysqld see my log
Are you logged as root or used su - from a terminal window.
root
05-06-2014, 06:33 AM
#8
LQ Newbie
Registered: May 2014
Posts: 29
Original Poster
Rep:
[CENTER]
Quote:
Originally Posted by
michaelk
thanx i tired to do following
./scripts/mysql_install_db --defaults-file=my.cnf
bash: ./scripts/mysql_install_db: No such file or directory
this my my cnf
etc/my.cnf
i dont see basedir and lc-messages-dir = /usr/share/mysql
Code:
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Recommended in standard MySQL setup
no luck
Last edited by Yazeed98; 05-06-2014 at 09:56 AM .
05-06-2014, 10:45 AM
#9
Moderator
Registered: Aug 2002
Posts: 25,694
Check the output of the dmesg command. See of SELinux is denying permission to the file.
05-06-2014, 11:18 AM
#10
LQ Newbie
Registered: May 2014
Posts: 29
Original Poster
Rep:
Quote:
Originally Posted by
michaelk
Check the output of the dmesg command. See of SELinux is denying permission to the file.
Thank you i fix itby uninstall the re install but now i have problem that mysql taking 45% of ram(1gb)
how i can make it light ?
05-06-2014, 04:30 PM
#11
LQ Newbie
Registered: May 2013
Location: India
Posts: 6
Rep:
Hi Yazeed,
Please replace your my.cnf configuration with bellow.
============
[mysqld]
max_connections = 400
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
local-infile=0
==========
Once updated your my.cnf file. try to restart mysqld service.
Let me know if you seeing any errors on this.
Regards,
VANK.
05-08-2014, 09:58 AM
#12
LQ Newbie
Registered: May 2014
Posts: 29
Original Poster
Rep:
Quote:
Originally Posted by
VANK1989
Hi Yazeed,
Please replace your my.cnf configuration with bellow.
============
[mysqld]
max_connections = 400
key_buffer = 32M
myisam_sort_buffer_size = 32M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1024
thread_cache_size = 286
interactive_timeout = 25
wait_timeout = 1000
connect_timeout = 10
max_allowed_packet = 16M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
tmp_table_size = 16M
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
local-infile=0
==========
Once updated your my.cnf file. try to restart mysqld service.
Let me know if you seeing any errors on this.
Regards,
VANK.
Thank but after put the code mysqld didn't started it tells me it failed mysql the latest 5.6
Last edited by Yazeed98; 05-08-2014 at 10:02 AM .
All times are GMT -5. The time now is 11:28 AM .
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know .
Latest Threads
LQ News