verifying jrforums causes mysql too manyconnections and unresponsive site
Installation and Configuration
max request workers also incresed to 250 from 150
Forum Activity for @soaringeagle
Installation and Configuration
max request workers also incresed to 250 from 150
verifying jrforums causes mysql too manyconnections and unresponsive site
Installation and Configuration
everytime i run integreity check i get too many mysql connections, even after increasiing connections and timeouts dramaticly
i did also recently increase max apasche spare workers start workers etc to what i found recomended for a dedicated server...
in mysql processes i see a ton of 'waitingfor table lock insert into jrcore_cache etc statements
my current mysql settings
[mysqld]
tmp_table_size = 2G
max_heap_table_size = 2G
max_connections = 600
wait_timeout = 200000
interactive_timeout = 200000
key_buffer = 1000M
max_allowed_packet=268435456
thread_cache_size = 8
table_open_cache = 45368
join_buffer_size=2000M
table_cache = 86258
table_definition_cache = 46258
low_priority_updates=1
concurrent_insert=ALWAYS
# * Query Cache Configuration
#
query_cache_limit = 16M
query_cache_size = 128M
table_cache = 2536
# for a 2 Gig RAM droplet
tmp_table_size = 2048M
max_heap_table_size = 2048M
innodb_buffer_pool_size = 4096M
innodb_flush_method = O_DIRECT
open_files_limit=44000
default-storage-engine=MyISAM
innodb_file_per_table=1
table_open_cache=5000
since copying this
low_priority_updates starement was disabled asa test
i believe i ran the integrety check since changing apachy workers but cant be certain
start servers increased from 5 to 25 min spare servers increased from 5 to 25 max spareserervers increased from 10 to 50
updated by @soaringeagle: 07/20/15 10:12:04PM
Trying to change header
Design and Skin Customization
ps, u might need to add some padding. margins, etc to get the look the way you want, maybe widths on the divs as well
on mobile you might want the h1 above the h3
while on desktop you want the h1 to take up say 60% of the left the h3 40% of the right
add a height and a top bottom left andright margin and/pr paddingto get thepositionings just right
because the codes in both desktop and mobile sectionsu can customize the look to each, maybe display:none on the h3 div on mobile to hide it completely...
play around see what works best for ya
but my template should get u close enough for a starrt thenfinetune from therer
Trying to change header
Design and Skin Customization
without trying this out heres the default header template code
{jrCore_include template="meta.tpl"}
<body>
{if jrCore_is_mobile_device()}
{jrCore_include template="header_menu_mobile.tpl"}
{/if}
<div id="header">
<div id="header_content">
{* Logo *}
{if jrCore_is_mobile_device()}
<div id="main_logo">
{jrCore_image id="mmt" skin="jrNingja" image="menu.png" alt="menu"}
{jrCore_image image="logo.png" width="170" height="40" class="jlogo" alt=$_conf.jrCore_system_name custom="logo"}
</div>
{else}
<div id="main_logo">
<a href="{$jamroom_url}">{jrCore_image image="logo.png" width=180 height=50 alt=$_conf.jrCore_system_name custom="logo"}</a>
</div>
{jrCore_include template="header_menu_desktop.tpl"}
{/if}
</div>
</div>
{if !jrCore_is_mobile_device()}
<div class="spacer"></div>{/if}
<div id="wrapper">
<div id="content">
<noscript>
<div class="item error center" style="margin:12px">
This site requires Javascript to function properly - please enable Javascript in your browser
</div>
</noscript>
<!-- end header.tpl -->now ififd have to guess you wan t sometthing simular to this
{jrCore_include template="meta.tpl"}
<body>
{if jrCore_is_mobile_device()}
{jrCore_include template="header_menu_mobile.tpl"}
{/if}
<div id="header">
<div id="header_content" style="background-color:black;">
{* Logo *}
{if jrCore_is_mobile_device()}
<div id="main_logo">
{jrCore_image id="mmt" skin="jrNingja" image="menu.png" alt="menu"}
<div style="float:left;"><h1 style="color:red;">The news talkers</h1></div><div style="float:right;"><h3 style="color:red;">speak your mind</h3></div>
</div>
{else}
<div id="main_logo"> <div style="float:left;"><a href="{$jamroom_url}"><h1 style="color:red;">The news talkers</h1></a></div><div style="float:right;"><h3 style="color:red;">speak your mind</h3></div>
</div>
{jrCore_include template="header_menu_desktop.tpl"}
{/if}
</div>
</div>
{if !jrCore_is_mobile_device()}
<div class="spacer"></div>{/if}
<div id="wrapper">
<div id="content">
<noscript>
<div class="item error center" style="margin:12px">
This site requires Javascript to function properly - please enable Javascript in your browser
</div>
</noscript>
<!-- end header.tpl -->Trying to change header
Design and Skin Customization
you can remove the logo code from the template, and replace it with text an h1 tag or something theres no need todo it in filerzilla unless your createinga custom temolate instead simply edit the existing template in the skin template editor
Trying to change header
Design and Skin Customization
u go into skin settingsd . images upload the new logo save check the checkbox, save
if you want additional text to the right of the image find the liogo code in header.tpl add add text here
you might need to play around with it see how it looks on mobile, maybe even hide it on mobile
sitemap crawler no longer listing videos
Design and Skin Customization
when i run my inspyder sitemap creator it stopped listing vids, funny thing is last run it listed 1... in a discussion that had 2 vids in the same comment
maybe i ran the system update in the middle and it changed something so it bno longer lists my vids?
updated by @soaringeagle: 07/08/15 11:19:59PM
