Forum Activity for @soaringeagle

soaringeagle
@soaringeagle
10/22/15 01:00:54PM
3,304 posts

mariadb 10 compatability and issues?
Installation and Configuration

im using 10.0.12
maybe need to upgrade t 10.1
the cpu is now over 22.0
soaringeagle
@soaringeagle
10/22/15 12:45:47PM
3,304 posts

mariadb 10 compatability and issues?
Installation and Configuration

ok thnx i have mariadb techs caling me later to try to get it figured out
soaringeagle
@soaringeagle
10/22/15 12:24:20PM
3,304 posts

mariadb 10 compatability and issues?
Installation and Configuration

its still kinda out of control high not as high but pushing the limits
soaringeagle
@soaringeagle
10/22/15 12:04:52PM
3,304 posts

mariadb 10 compatability and issues?
Installation and Configuration

ok cpu is reasonable but way higher then at the same load level uning mysql
but its art a point that i can watch it and tune it every 24 hurs till i get it right...i hope
i kinda had to chop yurs to peices to get it to work since u had it set specificly for the jr servers had to remove everal chunks
the thread_concurrency = 10 should be 8 with 8 cores right
soaringeagle
@soaringeagle
10/22/15 11:26:42AM
3,304 posts

mariadb 10 compatability and issues?
Installation and Configuration

what settings do you suggest for 8 coresw 32 gigs ram
lots of tables

[root@server ~]# perl mysqltuner.pl
>> MySQLTuner 1.6.1 - Major Hayden <major@mhtx.net>
>> Bug reports, feature requests, and downloads at http://mysqltuner.com/
>> Run with '--help' for additional options and output filtering
[--] Skipped version check for MySQLTuner script
[OK] Currently running supported MySQL version 10.0.21-MariaDB
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
[--] Status: +ARCHIVE +Aria +BLACKHOLE +CSV +FEDERATED +InnoDB +MRG_MyISAM
[--] Data in MyISAM tables: 1G (Tables: 2350)
[--] Data in InnoDB tables: 1G (Tables: 257)
[!!] Total fragmented tables: 41

-------- Security Recommendations -------------------------------------------
[OK] There is no anonymous account in all database users
[OK] All database users have passwords assigned
[--] There is 605 basic passwords in the list.

-------- Performance Metrics -------------------------------------------------
[--] Up for: 3h 24m 46s (2M q [200.930 qps], 185K conn, TX: 12B, RX: 28B)
[--] Reads / Writes: 82% / 18%
[--] Binary logging is disabled
[--] Total buffers: 16.0G global + 60.5M per thread (151 max threads)
[OK] Maximum reached memory usage: 19.7G (63.06% of installed RAM)
[OK] Maximum possible memory usage: 24.9G (79.67% of installed RAM)
[OK] Slow queries: 0% (4/2M)
[OK] Highest usage of available connections: 41% (63/151)
[OK] Aborted connections: 0.03% (49/185353)
[OK] Query cache efficiency: 35.5% (928K cached / 2M selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (232 temp sorts / 127K sorts)
[OK] Temporary tables created on disk: 23% (18K on disk / 79K total)
[OK] Thread cache hit rate: 99% (63 created / 185K connections)
[OK] Table cache hit rate: 100% (3K open / 3K opened)
[OK] Open file limit used: 5% (4K/86K)
[OK] Table locks acquired immediately: 99% (1M immediate / 1M locks)

-------- MyISAM Metrics -----------------------------------------------------
[!!] Key buffer used: 20.9% (224M used / 1B cache)
[OK] Key buffer size / total MyISAM indexes: 1.0G/270.5M
[OK] Read Key buffer hit rate: 99.7% (12M cached / 38K reads)
[!!] Write Key buffer hit rate: 29.5% (1M cached / 1M writes)

-------- InnoDB Metrics -----------------------------------------------------
[--] InnoDB is enabled.
[OK] InnoDB buffer pool / data size: 8.9G/1.1G
[OK] InnoDB buffer pool instances: 8
[!!] InnoDB Used buffer: 9.40% (54700 used/ 582136 total)
[OK] InnoDB Read buffer efficiency: 100.00% (4516076531 hits/ 4516112296 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 35801 writes)

-------- AriaDB Metrics -----------------------------------------------------
[--] AriaDB 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
MySQL started within last 24 hours - recommendations may be inaccurate
[root@server ~]#



current my.cnf

[mysqld]
query_cache_size        = 2G
tmp_table_size       = 4G
max_heap_table_size  = 4G
sort_buffer_size = 30M
thread_cache_size = 160
table_open_cache = 42997
innodb_buffer_pool_size = 9096M
innodb_buffer_pool_instances =8
read_rnd_buffer_size = 30M
key_buffer =1G
soaringeagle
@soaringeagle
10/22/15 11:05:42AM
3,304 posts

mariadb 10 compatability and issues?
Installation and Configuration

ii upgraded from mysql to mariadb 10 last night
now the cpu use was all over the place but always many times higher then usual
router.php seemed to spawn way ore instances using more ram and cpu
everything seemed to use way more cpu it was often off the charts causing instability even ram and swap at 1 point for no explainable reason maxed out

mysql activity shows it doing the same repeating join sequence over and over
| 210888 | greentec_jam | localhost | greentec_jam | Query | 2 | Sending data | SELECT STRAIGHT_JOIN a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
JOIN jr_jrgallery_item_ke | 0.000 |
| 210956 | greentec_jam | localhost | greentec_jam | Sleep | 0 | | NULL | 0.000 |
| 210961 | greentec_jam | localhost | greentec_jam | Query | 2 | Sending data | SELECT STRAIGHT_JOIN a.`_item_id` AS _item_id FROM jr_jrgallery_item_key a
JOIN jr_jrgallery_item_ke | 0.000 |
| 210974 | root | localhost | NULL | Query | 0 | init | show processlist | 0.000 |
| 210988 | greentec_jam | localhost | greentec_jam | Query | 0 | Sending data | SELECT STRAIGHT_JOIN a.`_item_id` AS _item_id FROM jr_jrrating_item_key a
JOIN jr_jrrating_item_key | 0.000 |

updated by @soaringeagle: 01/23/16 04:40:02PM
soaringeagle
@soaringeagle
10/21/15 09:14:57AM
3,304 posts

problem with pagination...again (bug report)
Design and Skin Customization

ps can we have a bug reports forum section its always so hard to guess where a bug report should be posted
soaringeagle
@soaringeagle
10/21/15 07:55:48AM
3,304 posts

problem with pagination...again (bug report)
Design and Skin Customization

http://www.dreadlockssite.com/dreadlocks-forums/forum/dread-maintenance/38818/started-the-process-of-dreading-need-help/p=1
page 1 has no pagination to the left, as it should, page 2 (last page) has a pagination both ways, you can click paginate forever and search bots will get lost in endless loops of pagination to blank pages
think this was a problem in the asyt that's resurfaced since the latest updates
updated by @soaringeagle: 01/20/16 11:20:45AM
soaringeagle
@soaringeagle
10/15/15 08:54:27PM
3,304 posts

non closiv divs on front page only when logged in - updated
Ning To Jamroom

noticed it in the pages section of tye search too when searching dreadheadhq and knottyboy reviews https://www.dreadlockssite.com/search/results/all/1/4
the pages section had the same nesting
  139