Đang Thực Hiện

Slow Oscommerce on my server

My Oscommerce store is running slow on two pages. When an order is confirmed and when a new client is processed. This is the same on different stores on the same server. So it may be Mysql on server. You will need to diagnose and fix.

Here's a performance report from mysqltuner recommending several variables to adjust

root rzaca [~]# ./[url removed, login to view]

>> MySQLTuner 1.0.0 - Major Hayden <>

>> Bug reports, feature requests, and downloads at [url removed, login to view]

>> 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.95-community

[OK] Operating on 32-bit architecture with less than 2GB RAM

-------- Storage Engine Statistics -------------------------------------------

[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster

[--] Data in MyISAM tables: 365M (Tables: 2610)

[--] Data in InnoDB tables: 7M (Tables: 268)

[--] Data in MEMORY tables: 0B (Tables: 3)

[!!] Total fragmented tables: 183

-------- Performance Metrics -------------------------------------------------

[--] Up for: 9h 59m 31s (87K q [[url removed, login to view] qps], 5K conn, TX: 115M, RX: 13M)

[--] Reads / Writes: 52% / 48%

[--] Total buffers: [url removed, login to view] global + [url removed, login to view] per thread (1000 max threads)

[!!] Allocating > 2GB RAM on 32-bit systems can cause system instability

[!!] Maximum possible memory usage: [url removed, login to view] (198% of installed RAM)

[OK] Slow queries: 0% (0/87K)

[OK] Highest usage of available connections: 0% (7/1000)

[OK] Key buffer size / total MyISAM indexes: [url removed, login to view]

[OK] Key buffer hit rate: 97.6% (364K cached / 8K reads)

[OK] Query cache efficiency: 53.5% (27K cached / 52K selects)

[!!] Query cache prunes per day: 15588

[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)

[!!] Joins performed without indexes: 108

[!!] Temporary tables created on disk: 39% (1K on disk / 3K total)

[OK] Thread cache hit rate: 99% (7 created / 5K connections)

[!!] Table cache hit rate: 15% (1K open / 6K opened)

[OK] Open file limit used: 37% (1K/5K)

[OK] Table locks acquired immediately: 99% (79K immediate / 79K locks)

[OK] InnoDB data size / buffer pool: [url removed, login to view]

-------- Recommendations -----------------------------------------------------

General recommendations:

Run OPTIMIZE TABLE to defragment tables for better performance

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:

*** MySQL's maximum memory usage is dangerously high ***

*** Add RAM before increasing MySQL buffer variables ***

query_cache_size (> 4M)

join_buffer_size (> [url removed, login to view], or always use indexes with joins)

tmp_table_size (> 32M)

max_heap_table_size (> 16M)

table_cache (> 1024)

I also noticed at least one database table that needs to be repaired via /var/lib/mysql/[url removed, login to view]

120508 10:07:10 [ERROR] /usr/sbin/mysqld: Incorrect key file for table './wwweven_wordpress/[url removed, login to view]'; try to repair it

Here's one way to analyze, repair and optimize your databases

mysqlcheck --all-databases -r #repair

mysqlcheck --all-databases -a #analyze

mysqlcheck --all-databases -o #optimize

There are still several delayed queries for mysql

root rzaca [~]# mysqladmin processlist

+------+-----------+-----------+-----------+----------------+------+--------------------+------------------+

| Id | User | Host | db | Command | Time | State | Info |

+------+-----------+-----------+-----------+----------------+------+--------------------+------------------+

| 1686 | DELAYED | localhost | eximstats | Delayed insert | 3 | Waiting for INSERT | |

| 5373 | eximstats | localhost | eximstats |

Kỹ năng: MySQL, OSCommerce

Xem thêm: oscommerce slow, eximstats delayed insert, thread up, system err, statistics community, statistics archive, statistics architecture, root info, pool host, mysql memory engine, memory engine, bug statistics, architecture statistics, so slow, my reports, statistics r, rx, need help fix script, metrics, locks, fix slow, fix mysql query, diagnose, mysql join table, mysql general error

Về Bên Thuê:
( 210 nhận xét ) Newark, United States

Mã Dự Án: #1617696

Đã trao cho:

triamazikamno

Professional server/website optimizer with 14 years *nix experience.

$150 USD trong 2 ngày
(41 Đánh Giá)
6.2

3 freelancer đang chào giá trung bình $133 cho công việc này

anuragkadian

I have team of Expert Designers and Developers that can work for you, We can provide you Quick and Quality Work.

$100 USD trong 1 ngày
(0 Đánh Giá)
0.0
headwebmonkey

I am an expert in MySQL and Apache optimization. We will be sure to run your server at optimized performance for your RAM by using built in caching resources. My latest optimization was for a site getting 1.7 million h Thêm

$150 USD trong 1 ngày
(0 Đánh Giá)
0.0