السلام عليكم
كيف الحال يا اخوان
لدي مشكلة في اللود العالي على السيرفر
وبعد الاستعلام والبحث اتضح ان المشكلة حدثت بعد نقل قاعدة البيانات على سيرفر جديد
هل هناك شركة معينة اجنبية او عربية ينصح بها وتستطيع ان تخدمني في تصحيح تلك الاخطاء
ايضا قمت بالاستعلام بواسطة mysqltuner
وكانت النتيجة
root@soft [~]# ./mysqltuner.pl
>> MySQLTuner 1.0.0 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
-------- General Statistics --------------------------------------------------
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 5.0.67-community
[!!] Switch to 64-bit OS - MySQL cannot currently use all of your RAM
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
ERROR 1102 (42000) at line 1: Incorrect database name 'fashion_vb.bk'
ERROR 1102 (42000) at line 1: Incorrect database name 'fashion_vb.bk'
[!!] InnoDB is enabled but isn't being used
Argument "" isn't numeric in numeric gt (>) at ./mysqltuner.pl line 495 (#1)
(W numeric) The indicated string was fed as an argument to an operator
that expected a numeric value instead. If you're fortunate the message
will identify which operator was so unfortunate.
[OK] Total fragmented tables:
ERROR 1102 (42000) at line 1: Incorrect database name 'fashion_vb.bk'
-------- Performance Metrics -------------------------------------------------
[--] Up for: 20h 14m 7s (7M q [108.245 qps], 341K conn, TX: 3B, RX: 2B)
[--] Reads / Writes: 86% / 14%
[--] Total buffers: 82.0M global + 4.4M per thread (500 max threads)
[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability
[!!] Maximum possible memory usage: 2.3G (28% of installed RAM)
[OK] Slow queries: 1% (132K/7M)
[OK] Highest usage of available connections: 50% (254/500)
Argument "" isn't numeric in numeric eq (==) at ./mysqltuner.pl line 679 (#1)
[!!] None of your MyISAM tables are indexed - add indexes immediately
[OK] Query cache efficiency: 48.4% (3M cached / 6M selects)
[!!] Query cache prunes per day: 156087
[OK] Sorts requiring temporary tables: 8% (192K temp sorts / 2M sorts)
[!!] Joins performed without indexes: 20102
[OK] Temporary tables created on disk: 9% (135K on disk / 1M total)
[OK] Thread cache hit rate: 95% (16K created / 341K connections)
[!!] Table cache hit rate: 0% (512 open / 1M opened)
[OK] Open file limit used: 18% (463/2K)
[!!] Table locks acquired immediately: 92%
-------- Recommendations -----------------------------------------------------
General 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
Increase table_cache gradually to avoid file descriptor limits
Optimize queries and/or use InnoDB to reduce lock wait
Variables to adjust:
query_cache_size (> 48M)
join_buffer_size (> 8.0K, or always use indexes with joins)
table_cache (> 512)
لاحظت ان هناك مشكلة Maximum possible memory usage: 2.3G (28% of installed RAM)
ماهي الطريقة الصحيحة لزيادة قدرة المومري حيث ان هناك 8 رامات على السيرفر وموقع واحد بقاعدة بيانات واحدة والمومري لايتعدى 30% رغم ان اللود يصل الى 79.59 (4 cpus)