MySQL is claiming all of my memory when it’s only using a few gigs

So, I have been having an issue with memory being "buffered" or "active", it seems my MariaDB installation is just marking all the memory on my system as it’s own? I don’t know for sure what is going on but it will show that I have almost no memory free but 24Gb available on free -wh ? I need to know if this is an issue and if yes please tell me what settings I need to change.

My system has 32GB of RAM and it’s constantly having to use SWAP because of this memory being buffered/active (swappiness is set to 1). Please check my server/mariadb settings below.

free -wh
mariadb.conf
smem -p
innodb engine status
cat /proc/meminfo
htop

how can i show only the parents in owl-carousel?

I have this code that shows all the posts in my post type (parents and children). the php is:

<div class="owl-carousel owl-theme">             <?php             $  c=0;             $  q2=new WP_Query(array('post_type'=> array( 'post', 'book' ),'post_status'=> 'publish','orderby'=>'modified','order'=>'desc'));             while($  q2->have_posts()) {                 $  c++;                 $  q2->the_post();                 ?>                 <li class="item">                     <a href="<?php the_permalink(); ?>">                         <?php the_post_thumbnail(); ?>                         <div class="metaitem">                             <ul>                                 <li><?php the_title(); ?></li>                                 <li><?php the_excerpt(); ?></li>                             </ul>                         </div>                     </a>                 </li>                 <?php             }             wp_reset_postdata();             ?>         </div> 

now what array i can use to show only the parents and don’t show the children? i have used 'parent' => 0 but it didn’t work!

Google Sitemap XML isn’t showing About Page, Contact Page, Etc, only

My google sitemap has been uploaded to Google Search Console using mywebsite.com/sitemap_index.xml When I click to the page in google search console ‘sitemaps read:’ I can only see the following:
website.com/author-sitemap.xml
website.com/category-sitemap.xml
website.com/e-landing-page-sitemap.xml
website.com/page-sitemap.xml
website.com/post-sitemap.xml

The actual pages my site consists of are: website.com/about
website.com/work
website.com/services
website.com/contact

Should the about/work/services pages be listed in Google Search Console when I click into the sitemap_index.xml file? Or have I done the xml file incorrectly?

I am using a Child Theme on Elementor on WordPress. The only thing in my robots.txt file is the following
User-agent: *
Disallow: /wp-admin/
Allow: /wp-admin/admin-ajax.php
I do have a devoted page website.com/sitemap with all my pages listed out

[![my active sitemap on Google Search Console][1]][1] [1]: https://i.stack.imgur.com/Vnaju.jpg

Best SSD Linux Reseller Web Hosting only @ $5 /M – Hostpoco.com !

Hostpoco.com is an Affordable Shared Hosting, Reseller Hosting, and VPS Server provider serving worldwide for the last 4 years.
We have USA, EU, and UK Based Servers and In-House Support Staff to provide the best and Fastest Support to our clients. Our support staffs are available ALL THE TIME to promptly assist any customer and any problem. We own our web servers, which helps to resolve problems for our customers the fastest possible and at any level of management. We can also instantly install custom software if requested by customers. If you are looking for a long-term, reliable, and professional Reseller hosting server, do give us a try. We have the 30-day money-back policy applied to all customers. You are absolutely safe when signing up with us.

We offer High Config & Best Featured SSD Linux Reseller Hosting. Just Sign up and be online within 2 minutes with our instant & free setup!

Some reasons to host with us:

– We have a 99.99% uptime guarantee.
– Anti-DDoS Protection.
– Based on Cloud Clustered Solution.
– Pure SSD Raid Protected Storage(For SSD Plans)
– You can use Free SSL certificates on any shared hosting plan.
– We allow unlimited features and overselling too
– We use advanced mail filters against SPAM emails.
– We use the popular cPanel control panel for all its features and to make it easy to migrate your website to our services.
– We take a nightly backup of all accounts, and store them on a different network, off-site and cloud environment – no way we lose your important files.
– We take more security measures to protect backup files as we use data vaults.
– We are using the latest technology based on CloudLinux OS.
– We run the latest PHP version and available to select from version 5.x to 7.x.
– We run the latest Perl, CGI, PHP, Python, and Ruby.
– We run the latest MariaDB database.
– We are happy to help you to migrate your website to our services.
– We offer a full 30 days money-back guarantee

Order now: https://www.hostpoco.com/best-ssd-linux-…osting.php

#Hostpoco.com: cheap reseller hosting | 5 dollar SSD reseller | whm Cpanel reseller | money back reseller | best-configured reseller | highly featured reseller | Linux reseller hosting | cheap reseller hosting

Have any questions?
Do not hesitate to drop us a support email at sales@hostpoco.com OR visit our page to chat with our Live Chat Support
www.hostpoco.com

Is there a RAW way to allow the PCs to recover only some of their spell slots etc?

My party were rather foolhardy and have got themselves knocked out and captured. Their captors want to keep them alive for a bit to question and then to sacrifice.

The party expended pretty much all their resources in the battle and so without a long rest are not going to have much chance of escape. However, it also feels wrong to say "you spend the night tied up in a stable and now you have all your spells and HP back". Which would make escape probably quite easy and anticlimactic.

Is there a way to reflect that they got some rest, but not a good night’s sleep?