| Question: |
good day, I can tell what can be the problem when konekta to the database. the first query runs the order of 7 seconds, followed less than a second. And the first request itself is not heavy |
| Answer: |
I`d like to know. Check amps. the request is sent to the local database or on an external server? |
| Question: |
to the local database |
| Answer: |
unfortunately we do not know the reasons |
| Question: |
but at least the assumptions are any there? |
| Answer: |
there are very few data about the problem |
| Question: |
and what data you need? |
| Answer: |
all for what it is.&in the problem description did not indicate how it is possible to see |
| Question: |
http://screnner777.com/myappdev.php/_profiler/ce7c92?panel=dbвот the queries on the page are completed. maybe you like that will help |
| Answer: |
Before you run the first queries addressed to the database or is the first query after connect? |
| Question: |
this is the first query on the page, but not the first database |
| Answer: |
Sampras sent to the administrator. |
| Answer: |
the problem is not clear. we performed a database check using mysqltuner here`s the result >> MySQLTuner 1.6.4 - Major Hayden <[email protected]>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with `--help` for additional options and output filtering
[OK] Logged in using credentials from debian maintenance account.
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version: 5.5.46-0+deb7u1
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +BLACKHOLE +CSV -FEDERATED +InnoDB +MRG_MYISAM
[--] Data in MyISAM tables: 24K (Tables: 10)
[--] Data in InnoDB tables: 1G (Tables: 16)
[!!] Total fragmented tables: 16
-------- Security Recommendations -------------------------------------------
[OK] There are no anonymous accounts for any database users
[OK] All database users have passwords assigned
[!!] There is no basic password file list!
-------- CVE Security Recommendations ---------------------------------------
[--] Skipped due to --cvefile option is undefined
-------- Performance Metrics -------------------------------------------------
[--] Up for: 26d 1h 17m 31s (8M q [3.650 qps], 2K conn, TX: 2B, RX: 2B)
[--] Reads / Writes: 0% / 100%
[--] Binary logging is disabled
[--] Total buffers: 192.0 M global + 2.7 M per thread (151 max threads)
[OK] reached Maximum memory usage: 221.6 M (2.77% of installed RAM)
[OK] Maximum possible memory usage: 597.8 M (7.48% of installed RAM)
[OK] Slow queries: 0% (17/8M)
[OK] Highest usage of available connections: 7% (11/151)
[!!] Aborted connections: 7.32% (168/2294)
[OK] Query cache efficiency: 65.5% (3K cached / 5K selects)
[OK] Query cache prunes per day: 0
[!!] Sorts requiring temporary tables: 40% (373 temp sorts / sorts 916)
[!!] Temporary tables created on disk: 34% (983 on disk / 2K total)
[OK] Thread cache hit rate: 99% (19 created / 2K connections)
[OK] Table cache hit rate: 92% (89 open / opened 96)
[OK] Open file limit used: 6% (68/1K)
[OK] Table locks acquired immediately: 100% (7M immediate / 7M locks)
-------- MyISAM Metrics ------------------------------------------------------
[!!] Key buffer used: 18.2% (used 3M / 16M cache)
the[OK] Key buffer size / total MyISAM indexes: 16.0 M/127.0 K
[!!] Read Key buffer hit rate: 0.0% (1 cached / 1 reads)
-------- InnoDB Metrics ------------------------------------------------------
[--] InnoDB is enabled.
[!!] InnoDB buffer pool / data size: 128.0 M/1.3 G
[OK] InnoDB buffer pool instances: 1
[OK] InnoDB buffer Used: 100.00% (used 8191/ 8191 total)
[OK] InnoDB buffer Read efficiency: 99.10% (587479366 hits/ 592812458 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 213410 writes)
-------- ThreadPool Metrics --------------------------------------------------
[--] ThreadPool stat is disabled.
-------- AriaDB Metrics ------------------------------------------------------
[--] AriaDB is disabled.
-------- TokuDB Metrics ------------------------------------------------------
[--] TokuDB is disabled.
-------- Galera Metrics ------------------------------------------------------
[--] Galera is disabled.
-------- Replication Metrics -------------------------------------------------
[--] No replication slave(s) for this server.
[--] This is a standalone server..
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
Enable the slow query log to troubleshoot bad queries
Reduce or eliminate unclosed connections and network issues
When making adjustments, make tmp_table_size/max_heap_table_size equal
Reduce your SELECT DISTINCT queries which have no LIMIT clause
Variables to adjust:
sort_buffer_size (> 2M)
read_rnd_buffer_size (> 256K)
tmp_table_size (>16M)
max_heap_table_size (>16M)
innodb_buffer_pool_size (>=1G), if possible. |
