Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
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.
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.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
I ran a mysqltuner.pl and this were it's recommendations:
Add skip-innodb to MySQL configuration to disable InnoDB
MySQL started within last 24 hours - recommendations may be inaccurate
Enable the slow query log to troubleshoot bad queries
Adjust your join queries to always utilize indexes
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries without LIMIT clauses
Increase table_cache gradually to avoid file descriptor limits
Variables to adjust:
query_cache_size (> 128M)
sort_buffer_size (> 2M)
read_rnd_buffer_size (> 512K)
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)
table_cache (> 1800)
but still the load still remains high and below is mytop results:
MySQL on localhost (5.5.28) up 0+11:01:26 [08:13:17]
Queries: 5.0 qps: 0 Slow: 0.0 Se/In/Up/De(%): 62917380/00/00/00
qps now: 0 Slow qps: 0.0 Threads: 22 ( 14/ 118) 25100/00/00/00
Key Efficiency: 100.0% Bps in/out: 0.0/ 0.7 Now in/out: 8.2/ 3.2k
Id User Host/IP DB Time Cmd Query or State
-- ---- ------- -- ---- --- ----------
2587588 admin localhost test 0 Query show full processlist
2587885 umempltd_ localhost umempltd_p 0 Query delete from ASB_TBL_g_tc5aI7z96Q28j06SN1o_9XPEfDYsUwTr3i_0B4_135
2587886 codeca localhost codeaorg_c 0 Query SELECT * FROM jos_session WHERE session_id = '3av2um8gnosots40pi
2585090 ufwgadmin localhost envatorg_u 1 Sleep
2585691 urbag_roc localhost urbagcom_u 1 Sleep
2587647 codeca localhost codeaorg_c 1 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587649 codeca localhost codeaorg_c 1 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587815 webdb localhost actvaorg_w 1 Sleep
2587883 codeca localhost codeaorg_c 1 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587884 codeca localhost codeaorg_c 1 Query UPDATE `jos_session` SET `time`='1352877196',`userid`='0',`usert
2587758 codeca localhost codeaorg_c 2 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587760 codeca localhost codeaorg_c 2 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587591 codeca localhost codeaorg_c 3 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587703 bigeye localhost big10000_b 3 Sleep
2587759 bigeye localhost big10000_b 3 Sleep
2587562 codeca localhost codeaorg_c 4 Query SELECT * FROM jos_phocaguestbook_items WHERE catid = 1 AND publi
2587644 bigeye localhost big10000_b 5 Sleep
2587283 bigeye localhost big10000_b 11 Sleep
2585152 webdb localhost actvaorg_w 26 Sleep
2464558 admin localhost 2539 Query SELECT IFNULL(SUM(INDEX_LENGTH),0) FROM information_schema.TABLE
2464438 admin localhost 2541 Query SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TA
2426522 admin localhost 3252 Query SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_sc
Could you please advise on how i should go about this.