MySQL optimization for hosting 32gb RAM
Hi,
I have a E3-1240 v3 dedicated server, with 32GB RAM, running CENTOS 6.5 x86_64 standard and WHM 11.40.1 (build 1)
Total processors: 8
Processor #1
Vendor
GenuineIntel
Name
Intel(R) Xeon(R) CPU E3-1240 v3 @ 3.40GHz
Speed
3392.256 MHz
Cache
8192 KB
I would like to optimize it the best to use correctly my 32gb here is my my.cnf:
and the mysqltuner report:
thank you very much.
# Example MySQL config file for very large systems.
#
# This is for a large system with memory of 1G-2G where the system runs mainly
# MySQL.
#
# MySQL programs look for option files in a set of
# locations which depend on the deployment platform.
# You can copy this option file to one of those
# locations. For information about these locations, see:
# [url=http://dev.mysql.com/doc/mysql/en/option-files.html]MySQL :: MySQL 5.6 Reference Manual :: 4.2.3.3 Using Option Files
#
# In this file, you can use all long options that a program supports.
# If you want to know which options a program supports, run the program
# with the "--help" option.
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /var/lib/mysql/mysql.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
key_buffer_size = 384M
max_allowed_packet = 32M
table_open_cache = 5096
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size = 64M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
log-slow-queries
local-infile=0
innodb_file_per_table=1
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
#
#skip-networking
# Replication Master Server (default)
# binary logging is required for replication
#log-bin=mysql-bin
# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id = 1
max_connections = 400
open_files_limit=11354
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeoutand the mysqltuner report:
>> MySQLTuner 1.2.0 - Major Hayden
>> 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.5.34-cll
[OK] Operating on 64-bit architecture
-------- Storage Engine Statistics -------------------------------------------
[--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
[--] Data in MyISAM tables: 903M (Tables: 1231)
[--] Data in InnoDB tables: 114M (Tables: 854)
[--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17)
[--] Data in MEMORY tables: 0B (Tables: 26)
[!!] Total fragmented tables: 83
-------- Security Recommendations -------------------------------------------
[OK] All database users have passwords assigned
-------- Performance Metrics -------------------------------------------------
[--] Up for: 1h 42m 0s (566K q [92.557 qps], 17K conn, TX: 1B, RX: 68M)
[--] Reads / Writes: 71% / 29%
[--] Total buffers: 608.0M global + 12.4M per thread (400 max threads)
[OK] Maximum possible memory usage: 5.4G (17% of installed RAM)
[OK] Slow queries: 0% (4/566K)
[OK] Highest usage of available connections: 26% (105/400)
[OK] Key buffer size / total MyISAM indexes: 384.0M/72.1M
[OK] Key buffer hit rate: 99.5% (3M cached / 16K reads)
[OK] Query cache efficiency: 71.9% (302K cached / 420K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 4K sorts)
[!!] Joins performed without indexes: 214
[!!] Temporary tables created on disk: 47% (19K on disk / 41K total)
[OK] Thread cache hit rate: 96% (674 created / 17K connections)
[OK] Table cache hit rate: 97% (2K open / 2K opened)
[OK] Open file limit used: 23% (2K/11K)
[OK] Table locks acquired immediately: 99% (172K immediate / 173K locks)
[OK] InnoDB data size / buffer pool: 114.4M/128.0M
-------- Recommendations -----------------------------------------------------
General recommendations:
Run OPTIMIZE TABLE to defragment tables for better performance
MySQL started within last 24 hours - recommendations may be inaccurate
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
Variables to adjust:
join_buffer_size (> 128.0K, or always use indexes with joins)
tmp_table_size (> 16M)
max_heap_table_size (> 16M)thank you very much.
-
Hello :) I recommend letting MySQL run for at least 24 hours before running the tuner to get the most accurate results. Thank you. 0 -
thank u very much, now my server have more than 24 hours and i got these results from mysqltuner: root@panama [~]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> 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.5.34-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 892M (Tables: 1231) [--] Data in InnoDB tables: 114M (Tables: 853) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 0B (Tables: 26) [!!] Total fragmented tables: 48 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 0h 52m 33s (4M q [52.971 qps], 150K conn, TX: 13B, RX: 554M) [--] Reads / Writes: 76% / 24% [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads) [OK] Maximum possible memory usage: 5.4G (17% of installed RAM) [OK] Slow queries: 0% (8/4M) [OK] Highest usage of available connections: 26% (105/400) [OK] Key buffer size / total MyISAM indexes: 384.0M/68.1M [OK] Key buffer hit rate: 99.6% (32M cached / 129K reads) [OK] Query cache efficiency: 68.6% (2M cached / 3M selects) [!!] Query cache prunes per day: 5436 [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 49K sorts) [!!] Joins performed without indexes: 2540 [!!] Temporary tables created on disk: 41% (77K on disk / 187K total) [OK] Thread cache hit rate: 96% (5K created / 150K connections) [OK] Table cache hit rate: 46% (4K open / 9K opened) [OK] Open file limit used: 33% (3K/11K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB data size / buffer pool: 114.8M/128.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance 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 Variables to adjust: query_cache_size (> 64M) join_buffer_size (> 128.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M)
at the beginning is my my.cnf also, i would like to optimize my server to use better the 32gb and have websites load more faster. thank you.0 -
thank u very much, now my server have more than 24 hours and i got these results from mysqltuner: root@panama [~]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> 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.5.34-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 892M (Tables: 1231) [--] Data in InnoDB tables: 114M (Tables: 853) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 0B (Tables: 26) [!!] Total fragmented tables: 48 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 1d 0h 52m 33s (4M q [52.971 qps], 150K conn, TX: 13B, RX: 554M) [--] Reads / Writes: 76% / 24% [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads) [OK] Maximum possible memory usage: 5.4G (17% of installed RAM) [OK] Slow queries: 0% (8/4M) [OK] Highest usage of available connections: 26% (105/400) [OK] Key buffer size / total MyISAM indexes: 384.0M/68.1M [OK] Key buffer hit rate: 99.6% (32M cached / 129K reads) [OK] Query cache efficiency: 68.6% (2M cached / 3M selects) [!!] Query cache prunes per day: 5436 [OK] Sorts requiring temporary tables: 0% (2 temp sorts / 49K sorts) [!!] Joins performed without indexes: 2540 [!!] Temporary tables created on disk: 41% (77K on disk / 187K total) [OK] Thread cache hit rate: 96% (5K created / 150K connections) [OK] Table cache hit rate: 46% (4K open / 9K opened) [OK] Open file limit used: 33% (3K/11K) [OK] Table locks acquired immediately: 99% (1M immediate / 1M locks) [OK] InnoDB data size / buffer pool: 114.8M/128.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance 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 Variables to adjust: query_cache_size (> 64M) join_buffer_size (> 128.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M)
at the beginning is my my.cnf also, i would like to optimize my server to use better the 32gb and have websites load more faster. thank you.0 -
i just run the tool again [COLOR="silver">- - - Updated - - - got this: root@panama [~]# ./mysqltuner.pl >> MySQLTuner 1.2.0 - Major Hayden >> 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.5.34-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 894M (Tables: 1231) [--] Data in InnoDB tables: 114M (Tables: 853) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 0B (Tables: 26) [!!] Total fragmented tables: 52 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 2d 1h 54m 34s (9M q [52.125 qps], 283K conn, TX: 28B, RX: 1B) [--] Reads / Writes: 78% / 22% [--] Total buffers: 608.0M global + 12.4M per thread (400 max threads) [OK] Maximum possible memory usage: 5.4G (17% of installed RAM) [OK] Slow queries: 0% (25/9M) [OK] Highest usage of available connections: 83% (334/400) [OK] Key buffer size / total MyISAM indexes: 384.0M/70.9M [OK] Key buffer hit rate: 99.8% (66M cached / 137K reads) [OK] Query cache efficiency: 68.3% (4M cached / 7M selects) [!!] Query cache prunes per day: 9085 [OK] Sorts requiring temporary tables: 0% (4 temp sorts / 98K sorts) [!!] Joins performed without indexes: 5067 [!!] Temporary tables created on disk: 39% (129K on disk / 328K total) [OK] Thread cache hit rate: 95% (12K created / 283K connections) [OK] Table cache hit rate: 41% (4K open / 10K opened) [OK] Open file limit used: 33% (3K/11K) [OK] Table locks acquired immediately: 99% (3M immediate / 3M locks) [OK] InnoDB data size / buffer pool: 114.8M/128.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance 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 Variables to adjust: query_cache_size (> 64M) join_buffer_size (> 128.0K, or always use indexes with joins) tmp_table_size (> 16M) max_heap_table_size (> 16M)0 -
please adjust those sort_buffer_size = 256K read_buffer_size = 128K read_rnd_buffer_size = 256K table_open_cache = 2000 thread_concurrency = 8 - remove that add innodb_buffer_pool_size = 300M join_buffer_size = 512K tmp_table_size = 50M max_heap_table_size = 50M anyway that won't make big difference, since [!!] Temporary tables created on disk: 39% (129K on disk / 328K total) the problem here is bad queries that uses temporary tables on disk, which doesn't scale if you are using popular CMS, then third party plugins would most likely have such bad queries or any not optimized custom code you can track slow queries like that in my.cnf: slow_query_log_file=mysql-slow.log long_query_time=0.1 then you can review it and see which queries takes most CPU time to review it run pt-query-digest like that cd /root wget 0 -
u recommend me to track slow queries? [COLOR="silver">- - - Updated - - - i got this: >> MySQLTuner 1.2.0 - Major Hayden >> 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.5.34-cll [OK] Operating on 64-bit architecture -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster [--] Data in MyISAM tables: 1G (Tables: 1231) [--] Data in InnoDB tables: 114M (Tables: 857) [--] Data in PERFORMANCE_SCHEMA tables: 0B (Tables: 17) [--] Data in MEMORY tables: 0B (Tables: 26) [!!] Total fragmented tables: 69 -------- Security Recommendations ------------------------------------------- [OK] All database users have passwords assigned -------- Performance Metrics ------------------------------------------------- [--] Up for: 8d 5h 0m 27s (49M q [69.437 qps], 1M conn, TX: 145B, RX: 5B) [--] Reads / Writes: 76% / 24% [--] Total buffers: 1.4G global + 4.9M per thread (2000 max threads) [OK] Maximum possible memory usage: 11.0G (35% of installed RAM) [OK] Slow queries: 0% (17/49M) [OK] Highest usage of available connections: 25% (507/2000) [OK] Key buffer size / total MyISAM indexes: 384.0M/153.8M [OK] Key buffer hit rate: 100.0% (315M cached / 82K reads) [OK] Query cache efficiency: 71.7% (27M cached / 38M selects) [!!] Query cache prunes per day: 1514 [OK] Sorts requiring temporary tables: 0% (2K temp sorts / 443K sorts) [!!] Joins performed without indexes: 24107 [!!] Temporary tables created on disk: 40% (626K on disk / 1M total) [OK] Thread cache hit rate: 99% (7K created / 1M connections) [!!] Table cache hit rate: 9% (3K open / 31K opened) [OK] Open file limit used: 25% (2K/11K) [OK] Table locks acquired immediately: 99% (15M immediate / 15M locks) [OK] InnoDB data size / buffer pool: 115.0M/300.0M -------- Recommendations ----------------------------------------------------- General recommendations: Run OPTIMIZE TABLE to defragment tables for better performance Increasing the query_cache size over 128M may reduce performance Adjust your join queries to always utilize indexes Temporary table size is already large - reduce result set size Reduce your SELECT DISTINCT queries without LIMIT clauses Increase table_cache gradually to avoid file descriptor limits Variables to adjust: query_cache_size (> 256M) [see warning above] join_buffer_size (> 4.0M, or always use indexes with joins) table_cache (> 3000)0 -
did you add this long_query_time=0.1 ? 0 -
should i leave it running 24 hours right and then run the tool? because now im getting # No events processed. i just restarted the mysql server few minutes ago 0 -
ok now is working i got this in slow.txt: # 100ms user time, 10ms system time, 24.68M rss, 201.43M vsz # Current date: Thu Jan 2 22:49:19 2014 # Hostname: panama.dbspma.com # Files: /var/lib/mysql/mysql-slow.log # Overall: 4 total, 4 unique, 0.02 QPS, 0.01x concurrency ________________ # Time range: 2014-01-02 22:43:36 to 22:46:39 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 992ms 153ms 487ms 248ms 477ms 136ms 329ms # Lock time 139us 17us 62us 34us 60us 16us 48us # Rows sent 1 0 1 0.25 0.99 0.43 0 # Rows examine 138.29k 0 138.29k 34.57k 136.54k 59.12k 0.99 # Query size 348 56 125 87 124.25 26.45 108.49 # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ============= ===== ====== ===== =============== # 1 0xFBC33BE3D16F31B6 0.4868 49.1% 1 0.4868 0.00 SELECT u?lgq_k?_comments # 2 0x65792F8C7D00F1DA 0.1830 18.4% 1 0.1830 0.00 INSERT mvkhb_session # 3 0x11F8C8E8FCD8E300 0.1693 17.1% 1 0.1693 0.00 UPDATE session # 4 0x566718AE69A06133 0.1526 15.4% 1 0.1526 0.00 DELETE mvkhb_session # Query 1: 0 QPS, 0x concurrency, ID 0xFBC33BE3D16F31B6 at byte 0 ________ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2014-01-02 22:43:36 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 25 1 # Exec time 49 487ms 487ms 487ms 487ms 487ms 0 487ms # Lock time 44 62us 62us 62us 62us 62us 0 62us # Rows sent 100 1 1 1 1 1 0 1 # Rows examine 99 138.29k 138.29k 138.29k 138.29k 138.29k 0 138.29k # Query size 20 70 70 70 70 70 0 70 # String: # Databases dbspma_innova # Hosts localhost # Users dbspma_innova # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_comments'\G # SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_comments`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM u9lgq_k2_comments WHERE itemID=28 AND published=1\G # Query 2: 0 QPS, 0x concurrency, ID 0x65792F8C7D00F1DA at byte 1637 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2014-01-02 22:45:36 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 25 1 # Exec time 18 183ms 183ms 183ms 183ms 183ms 0 183ms # Lock time 16 23us 23us 23us 23us 23us 0 23us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 35 125 125 125 125 125 0 125 # String: # Databases panasyst_nueva # Hosts localhost # Users panasyst_2013 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G # SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G INSERT INTO `mvkhb_session` (`session_id`, `client_id`, `time`) VALUES ('586328a696b7f16a79f87fc15d1caec7', 1, '1388720736')\G # Query 3: 0 QPS, 0x concurrency, ID 0x11F8C8E8FCD8E300 at byte 1946 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2014-01-02 22:46:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 25 1 # Exec time 17 169ms 169ms 169ms 169ms 169ms 0 169ms # Lock time 26 37us 37us 37us 37us 37us 0 37us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 1 1 1 1 1 0 1 # Query size 27 97 97 97 97 97 0 97 # String: # Databases roundcube # Hosts localhost # Users roundcube # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `roundcube` LIKE 'session'\G # SHOW CREATE TABLE `roundcube`.`session`\G UPDATE session SET changed='2014-01-02 22:46:38' WHERE sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select changed='2014-01-02 22:46:38' from session where sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G # Query 4: 0 QPS, 0x concurrency, ID 0x566718AE69A06133 at byte 1377 _____ # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2014-01-02 22:43:37 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 25 1 # Exec time 15 153ms 153ms 153ms 153ms 153ms 0 153ms # Lock time 12 17us 17us 17us 17us 17us 0 17us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 1 1 1 1 1 0 1 # Query size 16 56 56 56 56 56 0 56 # String: # Databases panasyst_nueva # Hosts localhost # Users panasyst_2013 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G # SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G DELETE FROM `mvkhb_session` WHERE `time` < '1388719717'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from `mvkhb_session` WHERE `time` < '1388719717'\G0 -
You need to run it after at least several hours, the best would be 24h, then generate result 0 -
i got a big file: # 1.1s user time, 30ms system time, 28.72M rss, 208.85M vsz # Current date: Sun Jan 5 21:11:13 2014 # Hostname: panama.dbspma.com # Files: /var/lib/mysql/mysql-slow.log # Overall: 6.79k total, 138 unique, 0.03 QPS, 0.01x concurrency __________ # Time range: 2014-01-02 22:43:36 to 2014-01-05 21:10:40 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 1781s 100ms 20s 262ms 477ms 609ms 148ms # Lock time 13s 0 370ms 2ms 63us 22ms 33us # Rows sent 1.97M 0 427.84k 304.93 0.99 9.43k 0 # Rows examine 51.90M 0 427.84k 7.83k 59.57k 26.09k 0.99 # Query size 4.28M 31 4.46k 661.06 2.06k 745.67 124.25 # Profile # Rank Query ID Response time Calls R/Call V/M Item # ==== ================== ============== ===== ====== ===== ============== # 1 0xFBC33BE3D16F31B6 375.0039 21.1% 803 0.4670 0.07 SELECT u?lgq_k?_comments # 2 0x1E21092605FA81DF 282.2854 15.9% 1529 0.1846 0.78 UPDATE mvkhb_session # 3 0x65792F8C7D00F1DA 211.4516 11.9% 767 0.2757 3.33 INSERT mvkhb_session # 4 0x11F8C8E8FCD8E300 200.9503 11.3% 1112 0.1807 0.54 UPDATE session # 5 0x566718AE69A06133 163.0799 9.2% 601 0.2713 2.49 DELETE mvkhb_session # 6 0x55563D0553F47299 106.1432 6.0% 640 0.1658 0.06 UPDATE session # 7 0x50B012B84A236154 68.0200 3.8% 255 0.2667 0.31 UPDATE jos_session # 8 0xA916BBE720639679 61.4734 3.5% 77 0.7984 3.90 UPDATE jos_docman # 9 0x9AB0AEA4D3D3F693 40.7853 2.3% 19 2.1466 7.04 INSERT u?lgq_session # 10 0xB1CEA974F1B8D5C4 30.3524 1.7% 161 0.1885 1.06 UPDATE ayk?j_session # 11 0x67A347A2812914DF 22.3469 1.3% 42 0.5321 2.61 SELECT u?lgq_k?_comments # 12 0x05872ECC22546540 21.7591 1.2% 70 0.3108 0.54 DELETE jos_session # 13 0x7481BC1F9F3D893B 17.3968 1.0% 70 0.2485 0.19 INSERT jos_session # 14 0xED95278A39C3E403 13.5517 0.8% 36 0.3764 0.03 SELECT lw?_session # 15 0x31935481E67173E2 12.7890 0.7% 4 3.1973 7.06 UPDATE jos_content # 16 0x25ED0A308EBE4C16 11.3791 0.6% 39 0.2918 0.69 UPDATE lw?_session # 17 0xC7491367E5334C98 10.2735 0.6% 24 0.4281 1.30 INSERT lw?_session # 18 0x9174EDDB77190BB8 9.7877 0.5% 6 1.6313 3.33 DELETE failures # 19 0x029F750F15BAF08D 8.4225 0.5% 5 1.6845 3.07 UPDATE u?lgq_k?_items # 20 0x8857E60478FD78A9 7.4776 0.4% 40 0.1869 0.04 INSERT ayk?j_session # MISC 0xMISC 105.9628 6.0% 490 0.2163 0.0 <118 ITEMS> # Query 1: 0.00 QPS, 0.00x concurrency, ID 0xFBC33BE3D16F31B6 at byte 3547866 # This item is included in the report because it matches --limit. # Scores: V/M = 0.07 # Time range: 2014-01-02 22:43:36 to 2014-01-05 21:09:52 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 11 803 # Exec time 21 375s 432ms 6s 467ms 477ms 183ms 433ms # Lock time 0 22ms 19us 88us 27us 36us 6us 25us # Rows sent 0 803 1 1 1 1 0 1 # Rows examine 93 48.49M 21.28k 138.29k 61.84k 136.54k 41.12k 59.57k # Query size 1 54.89k 70 70 70 70 0 70 # String: # Databases dbspma_innova # Hosts localhost # Users dbspma_innova # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_comments'\G # SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_comments`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT COUNT(*) FROM u9lgq_k2_comments WHERE itemID=25 AND published=1\G # Query 2: 0.01 QPS, 0.00x concurrency, ID 0x1E21092605FA81DF at byte 3219453 # This item is included in the report because it matches --limit. # Scores: V/M = 0.78 # Time range: 2014-01-02 22:59:01 to 2014-01-05 21:09:50 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 22 1529 # Exec time 15 282s 100ms 12s 185ms 339ms 381ms 122ms # Lock time 0 62ms 27us 137us 40us 54us 9us 36us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 1.49k 1 1 1 1 0 1 # Query size 42 1.83M 1.10k 1.47k 1.22k 1.39k 81.54 1.14k # String: # Databases panasyst_nueva # Hosts localhost # Users panasyst_2013 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # # Tables # SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G # SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G UPDATE `mvkhb_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388823472;s:18:\"session.timer.last\";i:1388823472;s:17:\"session.timer.now\";i:1388823472;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;i:1;}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8515db20aa0c3ba6fc181aaf20bfccea\";}' , `time` = '1388823473' WHERE `session_id` = '2ec3506232560615d0c01eba65d25589'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388823472;s:18:\"session.timer.last\";i:1388823472;s:17:\"session.timer.now\";i:1388823472;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;i:1;}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"8515db20aa0c3ba6fc181aaf20bfccea\";}' , `time` = '1388823473' from `mvkhb_session` where `session_id` = '2ec3506232560615d0c01eba65d25589'\G # Query 3: 0.00 QPS, 0.00x concurrency, ID 0x65792F8C7D00F1DA at byte 4858248 # This item is included in the report because it matches --limit. # Scores: V/M = 3.33 # Time range: 2014-01-02 22:45:36 to 2014-01-05 21:09:50 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 11 767 # Exec time 11 211s 100ms 20s 276ms 455ms 958ms 134ms # Lock time 0 15ms 11us 35us 19us 23us 2us 18us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 2 93.63k 125 125 125 125 0 125 # String: # Databases panasyst_nueva # Hosts localhost # Users panasyst_2013 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # # Tables # SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G # SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G INSERT INTO `mvkhb_session` (`session_id`, `client_id`, `time`) VALUES ('2b6851b69e972389ed66b9150cc86a31', 1, '1388909855')\G # Query 4: 0.00 QPS, 0.00x concurrency, ID 0x11F8C8E8FCD8E300 at byte 530866 # This item is included in the report because it matches --limit. # Scores: V/M = 0.54 # Time range: 2014-01-02 22:46:39 to 2014-01-05 21:09:55 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 16 1112 # Exec time 11 201s 100ms 7s 181ms 293ms 313ms 134ms # Lock time 0 45ms 21us 84us 40us 47us 5us 38us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 1.09k 1 1 1 1 0 1 # Query size 2 105.34k 97 97 97 97 0 97 # String: # Databases roundcube # Hosts localhost # Users roundcube # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `roundcube` LIKE 'session'\G # SHOW CREATE TABLE `roundcube`.`session`\G UPDATE session SET changed='2014-01-03 03:28:40' WHERE sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select changed='2014-01-03 03:28:40' from session where sess_id='e4ea4cffe4c4a98a977be4626997b6b6'\G # Query 5: 0.00 QPS, 0.00x concurrency, ID 0x566718AE69A06133 at byte 417279 # This item is included in the report because it matches --limit. # Scores: V/M = 2.49 # Time range: 2014-01-02 22:43:37 to 2014-01-05 20:59:15 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 8 601 # Exec time 9 163s 100ms 15s 271ms 455ms 821ms 141ms # Lock time 0 10ms 10us 49us 16us 19us 2us 15us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 861 1 22 1.43 2.90 1.01 0.99 # Query size 0 32.87k 56 56 56 56 0 56 # String: # Databases panasyst_nueva # Hosts localhost # Users panasyst_2013 # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # # Tables # SHOW TABLE STATUS FROM `panasyst_nueva` LIKE 'mvkhb_session'\G # SHOW CREATE TABLE `panasyst_nueva`.`mvkhb_session`\G DELETE FROM `mvkhb_session` WHERE `time` < '1388735299'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from `mvkhb_session` WHERE `time` < '1388735299'\G # Query 6: 0.00 QPS, 0.00x concurrency, ID 0x55563D0553F47299 at byte 3809058 # This item is included in the report because it matches --limit. # Scores: V/M = 0.06 # Time range: 2014-01-03 07:41:57 to 2014-01-05 18:44:59 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 9 640 # Exec time 5 106s 100ms 1s 166ms 308ms 96ms 141ms # Lock time 0 36ms 27us 93us 56us 69us 9us 54us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 640 1 1 1 1 0 1 # Query size 30 1.30M 1.15k 4.46k 2.08k 3.19k 583.02 1.86k # String: # Databases roundcube # Hosts localhost # Users roundcube # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `roundcube` LIKE 'session'\G # SHOW CREATE TABLE `roundcube`.`session`\G UPDATE session SET vars='bGFuZ3VhZ2V8czo1OiJlc19FUyI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp7aTowO2E6Mjp7aTowO3M6NjoiSU5CT1guIjtpOjE7czoxOiIuIjt9fXM6NToib3RoZXIiO047czo2OiJzaGFyZWQiO047czo2OiJwcmVmaXgiO3M6NjoiSU5CT1guIjt9aW1hcF9kZWxpbWl0ZXJ8czoxOiIuIjt1c2VyX2lkfHM6MjoiMzciO3VzZXJuYW1lfHM6MTc6ImdwaXR0aUB0dmJsYXN0LnR2IjtzdG9yYWdlX2hvc3R8czo5OiJsb2NhbGhvc3QiO3N0b3JhZ2VfcG9ydHxpOjE0MztzdG9yYWdlX3NzbHxOO3Bhc3N3b3JkfHM6NDQ6ImVVZFpJOFlIcEtGTmhpdmM3WEhqVjQwcEhzbkFtNEwxb25hUG96cDdhUzA9Ijtsb2dpbl90aW1lfGk6MTM4ODg1MDA4ODt0YXNrfHM6NDoibWFpbCI7aW1hcF9ob3N0fHM6OToibG9jYWxob3N0IjttYm94fHM6NToiSU5CT1giO3NvcnRfY29sfHM6NzoiYXJyaXZhbCI7c29ydF9vcmRlcnxzOjQ6IkRFU0MiO1NUT1JBR0VfVEhSRUFEfGE6Mzp7aTowO3M6MTA6IlJFRkVSRU5DRVMiO2k6MTtzOjQ6IlJFRlMiO2k6MjtzOjE0OiJPUkRFUkVEU1VCSkVDVCI7fVNUT1JBR0VfUVVPVEF8YjoxO1NUT1JBR0VfTElTVC1FWFRFTkRFRHxiOjE7cXVvdGFfZGlzcGxheXxzOjQ6InRleHQiO2xpc3RfYXR0cmlifGE6NTp7czo0OiJuYW1lIjtzOjg6Im1lc3NhZ2VzIjtzOjI6ImlkIjtzOjExOiJtZXNzYWdlbGlzdCI7czo1OiJjbGFzcyI7czoyNDoicmVjb3Jkcy10YWJsZSBzb3J0aGVhZGVyIjtzOjE1OiJvcHRpb25zbWVudWljb24iO3M6NDoidHJ1ZSI7czo3OiJjb2x1bW5zIjthOjM6e2k6MDtzOjc6InRocmVhZHMiO2k6MTtzOjc6InN1YmplY3QiO2k6MjtzOjQ6ImRhdGUiO319c2tpbl9wYXRofHM6MTE6InNraW5zL2xhcnJ5Ijtmb2xkZXJzfGE6MTp7czo1OiJJTkJPWCI7YToyOntzOjM6ImNudCI7aToxNDEzO3M6NjoibWF4dWlkIjtpOjE0MjE7fX1TVE9SQUdFX1NPUlR8YjoxO3Vuc2Vlbl9jb3VudHxhOjE6e3M6NToiSU5CT1giO2k6MDt9U1RPUkFHRV9BQ0x8YjowO3BsdWdpbnN8YToxOntzOjIyOiJmaWxlc3lzdGVtX2F0dGFjaG1lbnRzIjthOjA6e319', changed='2014-01-04 10:44:41' WHERE sess_id='168e572aed915730a65674ff809ce30b'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select vars='bGFuZ3VhZ2V8czo1OiJlc19FUyI7c2tpbnxzOjU6ImxhcnJ5IjtpbWFwX25hbWVzcGFjZXxhOjQ6e3M6ODoicGVyc29uYWwiO2E6MTp7aTowO2E6Mjp7aTowO3M6NjoiSU5CT1guIjtpOjE7czoxOiIuIjt9fXM6NToib3RoZXIiO047czo2OiJzaGFyZWQiO047czo2OiJwcmVmaXgiO3M6NjoiSU5CT1guIjt9aW1hcF9kZWxpbWl0ZXJ8czoxOiIuIjt1c2VyX2lkfHM6MjoiMzciO3VzZXJuYW1lfHM6MTc6ImdwaXR0aUB0dmJsYXN0LnR2IjtzdG9yYWdlX2hvc3R8czo5OiJsb2NhbGhvc3QiO3N0b3JhZ2VfcG9ydHxpOjE0MztzdG9yYWdlX3NzbHxOO3Bhc3N3b3JkfHM6NDQ6ImVVZFpJOFlIcEtGTmhpdmM3WEhqVjQwcEhzbkFtNEwxb25hUG96cDdhUzA9Ijtsb2dpbl90aW1lfGk6MTM4ODg1MDA4ODt0YXNrfHM6NDoibWFpbCI7aW1hcF9ob3N0fHM6OToibG9jYWxob3N0IjttYm94fHM6NToiSU5CT1giO3NvcnRfY29sfHM6NzoiYXJyaXZhbCI7c29ydF9vcmRlcnxzOjQ6IkRFU0MiO1NUT1JBR0VfVEhSRUFEfGE6Mzp7aTowO3M6MTA6IlJFRkVSRU5DRVMiO2k6MTtzOjQ6IlJFRlMiO2k6MjtzOjE0OiJPUkRFUkVEU1VCSkVDVCI7fVNUT1JBR0VfUVVPVEF8YjoxO1NUT1JBR0VfTElTVC1FWFRFTkRFRHxiOjE7cXVvdGFfZGlzcGxheXxzOjQ6InRleHQiO2xpc3RfYXR0cmlifGE6NTp7czo0OiJuYW1lIjtzOjg6Im1lc3NhZ2VzIjtzOjI6ImlkIjtzOjExOiJtZXNzYWdlbGlzdCI7czo1OiJjbGFzcyI7czoyNDoicmVjb3Jkcy10YWJsZSBzb3J0aGVhZGVyIjtzOjE1OiJvcHRpb25zbWVudWljb24iO3M6NDoidHJ1ZSI7czo3OiJjb2x1bW5zIjthOjM6e2k6MDtzOjc6InRocmVhZHMiO2k6MTtzOjc6InN1YmplY3QiO2k6MjtzOjQ6ImRhdGUiO319c2tpbl9wYXRofHM6MTE6InNraW5zL2xhcnJ5Ijtmb2xkZXJzfGE6MTp7czo1OiJJTkJPWCI7YToyOntzOjM6ImNudCI7aToxNDEzO3M6NjoibWF4dWlkIjtpOjE0MjE7fX1TVE9SQUdFX1NPUlR8YjoxO3Vuc2Vlbl9jb3VudHxhOjE6e3M6NToiSU5CT1giO2k6MDt9U1RPUkFHRV9BQ0x8YjowO3BsdWdpbnN8YToxOntzOjIyOiJmaWxlc3lzdGVtX2F0dGFjaG1lbnRzIjthOjA6e319', changed='2014-01-04 10:44:41' from session where sess_id='168e572aed915730a65674ff809ce30b'\G # Query 7: 0.00 QPS, 0.00x concurrency, ID 0x50B012B84A236154 at byte 4815293 # This item is included in the report because it matches --limit. # Scores: V/M = 0.31 # Time range: 2014-01-02 23:03:14 to 2014-01-05 21:10:40 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 3 255 # Exec time 3 68s 100ms 4s 267ms 526ms 287ms 198ms # Lock time 0 10ms 27us 101us 39us 54us 8us 36us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 255 1 1 1 1 0 1 # Query size 9 422.81k 497 2.17k 1.66k 2.06k 346.72 1.39k # String: # Databases phr_web # Hosts localhost # Users phr_web # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_session'\G # SHOW CREATE TABLE `phr_web`.`jos_session`\G UPDATE `jos_session` SET `time`='1388908327',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1388907485;s:18:\"session.timer.last\";i:1388908220;s:17:\"session.timer.now\";i:1388908248;s:22:\"session.client.browser\";s:128:\"Mozilla/5.0 (Linux; Android 4.2.2; SM-T311 Build/JDQ39) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.59 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:61:\"/home/phr/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}' WHERE session_id='c16a2001cbc646289f4a78d13906ca94'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select `time`='1388908327',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:7:{s:15:\"session.counter\";i:14;s:19:\"session.timer.start\";i:1388907485;s:18:\"session.timer.last\";i:1388908220;s:17:\"session.timer.now\";i:1388908248;s:22:\"session.client.browser\";s:128:\"Mozilla/5.0 (Linux; Android 4.2.2; SM-T311 Build/JDQ39) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.59 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:61:\"/home/phr/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}' from `jos_session` where session_id='c16a2001cbc646289f4a78d13906ca94'\G # Query 8: 0.00 QPS, 0.00x concurrency, ID 0xA916BBE720639679 at byte 175533 # This item is included in the report because it matches --limit. # Scores: V/M = 3.90 # Time range: 2014-01-03 02:05:58 to 2014-01-05 21:04:20 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 77 # Exec time 3 61s 107ms 11s 798ms 3s 2s 230ms # Lock time 0 2ms 16us 49us 26us 38us 7us 22us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 77 1 1 1 1 0 1 # Query size 0 4.28k 56 57 56.94 56.92 0.50 56.92 # String: # Databases phr_web # Hosts localhost # Users phr_web # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ###### # 10s+ # # Tables # SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_docman'\G # SHOW CREATE TABLE `phr_web`.`jos_docman`\G UPDATE jos_docman SET dmcounter=dmcounter+1 WHERE id=945\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select dmcounter=dmcounter+1 from jos_docman where id=945\G # Query 9: 0.00 QPS, 0.00x concurrency, ID 0x9AB0AEA4D3D3F693 at byte 3218309 # This item is included in the report because it matches --limit. # Scores: V/M = 7.04 # Time range: 2014-01-03 10:21:24 to 2014-01-05 02:35:13 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 19 # Exec time 2 41s 110ms 15s 2s 10s 4s 266ms # Lock time 0 386us 14us 44us 20us 25us 6us 18us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 2.32k 125 125 125 125 0 125 # String: # Databases dbspma_innova # Hosts localhost # Users dbspma_innova # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ############# # 10s+ ######### # Tables # SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_session'\G # SHOW CREATE TABLE `dbspma_innova`.`u9lgq_session`\G INSERT INTO `u9lgq_session` (`session_id`, `client_id`, `time`) VALUES ('b7fdeedad8ef279bcc236aa985b8cb56', 0, '1388823422')\G # Query 10: 0.00 QPS, 0.00x concurrency, ID 0xB1CEA974F1B8D5C4 at byte 368303 # This item is included in the report because it matches --limit. # Scores: V/M = 1.06 # Time range: 2014-01-03 02:03:20 to 2014-01-05 20:53:53 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 2 161 # Exec time 1 30s 100ms 6s 189ms 339ms 448ms 116ms # Lock time 0 7ms 29us 73us 42us 60us 10us 36us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 161 1 1 1 1 0 1 # Query size 4 210.35k 1.11k 1.58k 1.31k 1.39k 106.75 1.20k # String: # Databases hogarma_2013 # Hosts localhost # Users hogarma_jorge # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `hogarma_2013` LIKE 'ayk3j_session'\G # SHOW CREATE TABLE `hogarma_2013`.`ayk3j_session`\G UPDATE `ayk3j_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1388735402;s:18:\"session.timer.last\";i:1388735402;s:17:\"session.timer.now\";i:1388735406;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3ee293abb106436575850bfb13cdbf76\";}' , `time` = '1388735406' WHERE `session_id` = '0d0b38c0bb8e695270000432976a69c4'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1388735402;s:18:\"session.timer.last\";i:1388735402;s:17:\"session.timer.now\";i:1388735406;s:22:\"session.client.browser\";s:63:\"Opera/9.80 (Windows NT 6.1; U; ru) Presto/2.8.131 Version/11.10\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"3ee293abb106436575850bfb13cdbf76\";}' , `time` = '1388735406' from `ayk3j_session` where `session_id` = '0d0b38c0bb8e695270000432976a69c4'\G # Query 11: 0.00 QPS, 0.00x concurrency, ID 0x67A347A2812914DF at byte 4722204 # This item is included in the report because it matches --limit. # Scores: V/M = 2.61 # Time range: 2014-01-03 02:04:07 to 2014-01-05 04:14:54 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 42 # Exec time 1 22s 102ms 5s 532ms 945ms 1s 141ms # Lock time 0 0 0 0 0 0 0 0 # Rows sent 98 1.95M 2 427.84k 47.64k 233.54k 110.46k 1.09k # Rows examine 3 1.95M 2 427.84k 47.64k 233.54k 110.46k 1.09k # Query size 0 2.25k 47 71 54.76 65.89 5.95 51.63 # String: # Databases dxcrewco_2... (15/35%), computer_d... (8/19%)... 7 more # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s #### # 10s+ # Tables # SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_comments'\G # SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_comments`\G SELECT /*!40001 SQL_NO_CACHE */ * FROM `u9lgq_k2_comments`\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ SELECT /*!40001 SQL_NO_CACHE */ * FROM `u9lgq_k2_comments`\G # Query 12: 0.00 QPS, 0.00x concurrency, ID 0x05872ECC22546540 at byte 3239612 # This item is included in the report because it matches --limit. # Scores: V/M = 0.54 # Time range: 2014-01-03 02:10:11 to 2014-01-05 21:04:00 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 70 # Exec time 1 22s 102ms 2s 311ms 945ms 408ms 163ms # Lock time 0 1ms 13us 25us 16us 20us 1us 16us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 127 1 8 1.81 3.89 1.29 0.99 # Query size 0 3.62k 53 53 53 53 0 53 # String: # Databases phr_web # Hosts localhost # Users phr_web # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ### # 10s+ # Tables # SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_session'\G # SHOW CREATE TABLE `phr_web`.`jos_session`\G DELETE FROM jos_session WHERE ( time < '1388823115' )\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from jos_session WHERE ( time < '1388823115' )\G # Query 13: 0.00 QPS, 0.00x concurrency, ID 0x7481BC1F9F3D893B at byte 4505264 # This item is included in the report because it matches --limit. # Scores: V/M = 0.19 # Time range: 2014-01-03 00:55:15 to 2014-01-05 20:49:26 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 70 # Exec time 0 17s 100ms 2s 249ms 433ms 220ms 198ms # Lock time 1 158ms 15us 157ms 2ms 31us 18ms 20us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 10.94k 160 160 160 160 0 160 # String: # Databases phr_web # Hosts localhost # Users phr_web # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # # 10s+ # Tables # SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_session'\G # SHOW CREATE TABLE `phr_web`.`jos_session`\G INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '4d825234dd2d487cb75175c89d6dcb84','1388889379','','0','1','0' )\G # Query 14: 0.00 QPS, 0.00x concurrency, ID 0xED95278A39C3E403 at byte 3751720 # This item is included in the report because it matches --limit. # Scores: V/M = 0.03 # Time range: 2014-01-04 10:10:57 to 2014-01-05 11:13:31 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 36 # Exec time 0 14s 158ms 506ms 376ms 477ms 109ms 412ms # Lock time 75 9s 56ms 370ms 261ms 356ms 101ms 293ms # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 3.16k 90 90 90 90 0 90 # String: # Databases dxcrewco_2013 # Hosts localhost # Users dxcrewco_marco # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `dxcrewco_2013` LIKE 'lw532_session'\G # SHOW CREATE TABLE `dxcrewco_2013`.`lw532_session`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT `data` FROM `lw532_session` WHERE `session_id` = 'ee4393cd5b63cbc988eb35dd3af2a670'\G # Query 15: 0.00 QPS, 0.00x concurrency, ID 0x31935481E67173E2 at byte 175775 # This item is included in the report because it matches --limit. # Scores: V/M = 7.06 # Time range: 2014-01-03 02:05:58 to 2014-01-05 12:57:28 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 4 # Exec time 0 13s 207ms 11s 3s 11s 5s 6s # Lock time 0 98us 20us 32us 24us 31us 4us 22us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 4 1 1 1 1 0 1 # Query size 0 229 56 58 57.25 56.92 1 56.92 # String: # Databases phr_web # Hosts localhost # Users phr_web # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ ##################### # Tables # SHOW TABLE STATUS FROM `phr_web` LIKE 'jos_content'\G # SHOW CREATE TABLE `phr_web`.`jos_content`\G UPDATE jos_content SET hits = ( hits + 1 ) WHERE id='240'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select hits = ( hits + 1 ) from jos_content where id='240'\G # Query 16: 0.00 QPS, 0.00x concurrency, ID 0x25ED0A308EBE4C16 at byte 4503155 # This item is included in the report because it matches --limit. # Scores: V/M = 0.69 # Time range: 2014-01-02 23:03:39 to 2014-01-05 11:05:01 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 39 # Exec time 0 11s 100ms 2s 292ms 816ms 449ms 155ms # Lock time 0 90ms 23us 54ms 2ms 84us 10ms 52us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 39 1 1 1 1 0 1 # Query size 1 53.94k 1.06k 1.88k 1.38k 1.86k 251.11 1.39k # String: # Databases dxcrewco_2013 # Hosts localhost # Users dxcrewco_marco # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ### # 10s+ # Tables # SHOW TABLE STATUS FROM `dxcrewco_2013` LIKE 'lw532_session'\G # SHOW CREATE TABLE `dxcrewco_2013`.`lw532_session`\G UPDATE `lw532_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388889359;s:18:\"session.timer.last\";i:1388889359;s:17:\"session.timer.now\";i:1388889359;s:24:\"session.client.forwarded\";s:27:\"216.46.175.37, 10.160.107.8\";s:22:\"session.client.browser\";s:40:\"Google-HTTP-Java-Client/1.17.0-rc (gzip)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:3:{s:40:\"5e6f08c8332066551fce5eaba2cfb099a6dabd81\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/72-crysis-3-s-multiplayer-hunters-mode\";s:6:\"expiry\";i:1388889360;}s:40:\"f6adf5b0ccff78743bceffdf9702361438c195c4\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/71-final-fantasy-xiii-2\";s:6:\"expiry\";i:1388889360;}s:40:\"0106175a76338d72f176af1c6fa14fb9bf809021\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/67-little-big-planet-2-sackboy-returns\";s:6:\"expiry\";i:1388889360;}}}' , `time` = '1388889378' WHERE `session_id` = '5bcb45f186f687d7cadb8bcb5b18170a'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1388889359;s:18:\"session.timer.last\";i:1388889359;s:17:\"session.timer.now\";i:1388889359;s:24:\"session.client.forwarded\";s:27:\"216.46.175.37, 10.160.107.8\";s:22:\"session.client.browser\";s:40:\"Google-HTTP-Java-Client/1.17.0-rc (gzip)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:3:{s:40:\"5e6f08c8332066551fce5eaba2cfb099a6dabd81\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/72-crysis-3-s-multiplayer-hunters-mode\";s:6:\"expiry\";i:1388889360;}s:40:\"f6adf5b0ccff78743bceffdf9702361438c195c4\";O:8:\"stdClass\":2:{s:4:\"link\";s:100:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/71-final-fantasy-xiii-2\";s:6:\"expiry\";i:1388889360;}s:40:\"0106175a76338d72f176af1c6fa14fb9bf809021\";O:8:\"stdClass\":2:{s:4:\"link\";s:115:\"http://www.dxcrew507.com/index.php/component/content/article/32-demo-content/67-little-big-planet-2-sackboy-returns\";s:6:\"expiry\";i:1388889360;}}}' , `time` = '1388889378' from `lw532_session` where `session_id` = '5bcb45f186f687d7cadb8bcb5b18170a'\G # Query 17: 0.00 QPS, 0.00x concurrency, ID 0xC7491367E5334C98 at byte 4723187 # This item is included in the report because it matches --limit. # Scores: V/M = 1.30 # Time range: 2014-01-04 09:18:50 to 2014-01-05 21:01:28 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 24 # Exec time 0 10s 113ms 4s 428ms 455ms 745ms 241ms # Lock time 2 358ms 15us 357ms 15ms 30us 71ms 19us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 2.93k 125 125 125 125 0 125 # String: # Databases dxcrewco_2013 # Hosts localhost # Users dxcrewco_marco # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ##### # 10s+ # Tables # SHOW TABLE STATUS FROM `dxcrewco_2013` LIKE 'lw532_session'\G # SHOW CREATE TABLE `dxcrewco_2013`.`lw532_session`\G INSERT INTO `lw532_session` (`session_id`, `client_id`, `time`) VALUES ('9ea929a199c47e48648203a6233eaf34', 0, '1388905635')\G # Query 18: 0.00 QPS, 0.00x concurrency, ID 0x9174EDDB77190BB8 at byte 4789132 # This item is included in the report because it matches --limit. # Scores: V/M = 3.33 # Time range: 2014-01-03 12:29:51 to 2014-01-05 03:15:21 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 6 # Exec time 0 10s 109ms 7s 2s 7s 2s 1s # Lock time 0 216us 18us 53us 36us 52us 16us 50us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 356 1 182 59.33 174.84 77.70 81.24 # Query size 0 492 82 82 82 82 0 82 # String: # Databases eximstats # Hosts localhost # Users eximstats # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ################################ # 10s+ # Tables # SHOW TABLE STATUS FROM `eximstats` LIKE 'failures'\G # SHOW CREATE TABLE `eximstats`.`failures`\G delete from failures where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select * from failures where FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())-2592000) > mailtime\G # Query 19: 0.00 QPS, 0.00x concurrency, ID 0x029F750F15BAF08D at byte 3194699 # This item is included in the report because it matches --limit. # Scores: V/M = 3.07 # Time range: 2014-01-04 02:57:23 to 13:51:59 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 5 # Exec time 0 8s 101ms 6s 2s 6s 2s 230ms # Lock time 0 141us 25us 34us 28us 33us 3us 26us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 5 1 1 1 1 0 1 # Query size 0 315 63 63 63 63 0 63 # String: # Databases dbspma_innova # Hosts localhost # Users dbspma_innova # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s ########################################## # 10s+ # Tables # SHOW TABLE STATUS FROM `dbspma_innova` LIKE 'u9lgq_k2_items'\G # SHOW CREATE TABLE `dbspma_innova`.`u9lgq_k2_items`\G UPDATE u9lgq_k2_items SET `hits` = (`hits` + 1) WHERE id = '28'\G # Converted for EXPLAIN # EXPLAIN /*!50100 PARTITIONS*/ select `hits` = (`hits` + 1) from u9lgq_k2_items where id = '28'\G # Query 20: 0.00 QPS, 0.00x concurrency, ID 0x8857E60478FD78A9 at byte 426870 # This item is included in the report because it matches --limit. # Scores: V/M = 0.04 # Time range: 2014-01-03 00:47:43 to 2014-01-05 18:55:26 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 0 40 # Exec time 0 7s 102ms 529ms 187ms 374ms 90ms 148ms # Lock time 0 752us 14us 26us 18us 21us 2us 18us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Query size 0 4.88k 125 125 125 125 0 125 # String: # Databases hogarma_2013 # Hosts localhost # Users hogarma_jorge # Query_time distribution # 1us # 10us # 100us # 1ms # 10ms # 100ms ################################################################ # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `hogarma_2013` LIKE 'ayk3j_session'\G # SHOW CREATE TABLE `hogarma_2013`.`ayk3j_session`\G INSERT INTO `ayk3j_session` (`session_id`, `client_id`, `time`) VALUES ('efbc24d544b64850279466b735871b20', 1, '1388736312')\G0 -
should i add this tmp_table_size (> 16M) max_heap_table_size (> 16M) ? i dont see that in my config right now is missing what do u recommend me to do 0 -
This is my settings on the one of 32GB RAM, 2xSAS 15k HDD and 8 CPU cores server, hosting over 200 domains: [mysqld] innodb_file_per_table=1 open_files_limit=40000 max_allowed_packet = 32M max_connections = 1024 local-infile=0 large-pages innodb_use_sys_malloc = 0 innodb_buffer_pool_size=2G large_pages = true query_cache_size=32M join_buffer_size=1024K tmp_table_size=48M max_heap_table_size=48M key_buffer=64M thread_cache_size=32 table_cache=2000 table_definition_cache = 1024 this made significant improvement in performance and balanced overall load. However, I can't guarantee you'll experience same, as settings usually depend on many factors on the server. 0
Please sign in to leave a comment.
Comments
13 comments