نمایش نسخه قابل چاپ
با سلام
جدیدا یه مشکلی که واسه سرور بنده پیش اومده این که مرتبا این پیام میاد و لود سرور زیاد شده.سایت ها زیاد نشده و اونایی هم که هستن استفاده انچنانی ندارن لطفا راهنمایی کنید مشکل از کجاست.
کد PHP:1608 mysql 20 0 1881m 83m 5844 S 11.3 1.1 14:11.42 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/net.test.com.err --pid-file=/var/lib/mysql/net.test.com.pid
با بهینه سازی مشکلتون برطرف میشه
ممنون میدونم با بهینه سازی حل میشه ولی بهتر بود یه مقدار جزئیات بیشتری رو ذکر میکردید خیلی کلی جواب دادیننقل قول:
نوشته اصلی توسط ULTRAWEB
تشکر.منتظر پاسخ بقیه دوستان هستم
up
مشکل من شدید تر شده دوستان راهنمایی نمیکنید در این مورد
کاش تاپیک های اموزش ها مثل فروش بود،
سلام مجدد
بنده هنوز این مشکل رو دارمواسه حل این مشکل چی پیشنهادی دارین+پرداخت هزینهنقل قول:
1608 mysql 20 0 1881m 83m 5844 S 11.3 1.1 14:11.42 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/net.test.com.err --
pid-file=/var/lib/mysql/net.test.com.pid
نقل قول:
140407 11:08:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140407 11:08:59 [Note] Plugin 'FEDERATED' is disabled.
140407 11:08:59 InnoDB: The InnoDB memory heap is disabled
140407 11:08:59 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140407 11:08:59 InnoDB: Compressed tables use zlib 1.2.3
140407 11:08:59 InnoDB: Using Linux native AIO
140407 11:09:00 InnoDB: Initializing buffer pool, size = 128.0M
140407 11:09:01 InnoDB: Completed initialization of buffer pool
140407 11:09:02 InnoDB: highest supported file format is Barracuda.
140407 11:09:05 InnoDB: Waiting for the background threads to start
140407 11:09:06 InnoDB: 5.5.31 started; log sequence number 3264448
140407 11:09:06 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140407 11:09:06 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140407 11:09:06 [Note] Server socket created on IP: '0.0.0.0'.
140407 11:09:06 [Note] Event Scheduler: Loaded 0 events
140407 11:09:06 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
140407 11:18:58 [Note] /usr/sbin/mysqld: Normal shutdown
140407 11:18:58 [Note] Event Scheduler: Purging the queue. 0 events
140407 11:18:58 InnoDB: Starting shutdown...
140407 11:19:00 InnoDB: Shutdown completed; log sequence number 3264458
140407 11:19:00 [Note] /usr/sbin/mysqld: Shutdown complete
140407 11:19:00 mysqld_safe mysqld from pid file /var/lib/mysql/tset.user.net.pid ended
140407 11:19:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140407 11:19:40 [Note] Plugin 'FEDERATED' is disabled.
140407 11:19:41 InnoDB: The InnoDB memory heap is disabled
140407 11:19:41 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140407 11:19:41 InnoDB: Compressed tables use zlib 1.2.3
140407 11:19:41 InnoDB: Using Linux native AIO
140407 11:19:41 InnoDB: Initializing buffer pool, size = 128.0M
140407 11:19:41 InnoDB: Completed initialization of buffer pool
140407 11:19:41 InnoDB: highest supported file format is Barracuda.
140407 11:19:41 InnoDB: Waiting for the background threads to start
140407 11:19:42 InnoDB: 5.5.31 started; log sequence number 3264458
140407 11:19:42 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140407 11:19:42 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140407 11:19:42 [Note] Server socket created on IP: '0.0.0.0'.
140407 11:19:42 [Note] Event Scheduler: Loaded 0 events
140407 11:19:42 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
140409 21:23:09 [Note] /usr/sbin/mysqld: Normal shutdown
140409 21:23:10 [Note] Event Scheduler: Purging the queue. 0 events
140409 21:33:27 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140409 21:33:47 [Note] Plugin 'FEDERATED' is disabled.
140409 21:33:49 InnoDB: The InnoDB memory heap is disabled
140409 21:33:49 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140409 21:33:49 InnoDB: Compressed tables use zlib 1.2.3
140409 21:33:49 InnoDB: Using Linux native AIO
140409 21:34:07 InnoDB: Initializing buffer pool, size = 128.0M
140409 21:34:16 InnoDB: Completed initialization of buffer pool
140409 21:34:32 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
140409 21:34:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
140409 21:39:01 InnoDB: Waiting for the background threads to start
140409 21:39:02 InnoDB: 5.5.31 started; log sequence number 9985611
140409 21:39:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140409 21:39:02 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140409 21:39:02 [Note] Server socket created on IP: '0.0.0.0'.
140409 21:39:21 [Note] Event Scheduler: Loaded 0 events
140409 21:39:21 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.5.31' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)