Step-by-Step Tutorial: How to Setup Your Own e-Commerce Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) in Amazon AWS Cloud

[Turritopsis Dohrnii Teo En Ming]

Good morning from Singapore,


You can read my step-by-step tutorial on How to Setup Your Own e-Commerce 
Online Store using WooCommerce 3.4.5, Wordpress 4.9.8, and CentOS 1805 (LAMP) 
in Amazon AWS Cloud at any one of my two redundant blogs. My blogs were 
configured in RAID 1 mirroring array.


https://tdtemcerts.wordpress.com/2018/09/29/step-by-step-tutorial-how-to-setup-your-own-e-commerce-online-store-using-woocommerce-3-4-5-wordpress-4-9-8-and-centos-1805-lamp-in-amazon-aws-cloud/


https://tdtemcerts.blogspot.com/2018/09/step-by-step-tutorial-how-to-setup-your.html


Thanks for reading! If there are any mistakes, please do let me know!





===BEGIN SIGNATURE===

Turritopsis Dohrnii Teo En Ming's Academic Qualifications as at 30 Oct 2017

[1] https://tdtemcerts.wordpress.com/

[2] http://tdtemcerts.blogspot.sg/

[3] 
https://www.scribd.com/user/270125049/Teo-En-Ming

===END SIGNATURE===

Re: info on open tables

[Halaasz Saandor]

2018/09/28 07:48 ... Machiel Richards:

   During the times when it experiences issues, I found that there is always about 
4-5 processes on mysql that gets stuck on "closing table" state and once the 
software (opensips) is restarted due to a sigfault, then these queries are killed as well.


   Based on information found we added grafana graphs and did notice that 
the table_open_cache is fully used during the time of the sigfaults and the 
queries getting stuck so we tested by increasing the table_open_cache.


  This did however not resolve the issue as we simply saw table_open_cache 
using the full value of 3000 and once again the same behaviour.



  When running "Show open tables" though, we find that the amount of open 
tables is only 283 and a count of all tables returned that there is only 381 tables on 
the server.


 However when running "Show global status like 'open_tables' we get a value 
of 2900.


 So my questions are as follows :


  1. Why is the table_open_cache used up if there are not even that many 
tables.

  2. Why does these values differ so much? or do they provide different 
info.



These occur to me:

"If you have no privileges for a table, it does not show up in the 
output from SHOW OPEN TABLES."


If an table is kept open, but there is no action, does it stay in the cache?

One shows really only the tables, the other shows a table with its user.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

info on open tables

[Machiel Richards]

Hi all


I am hoping this mail finds all well.


I have a question about mysql open tables and open_table_cache which I do 
not seem to be finding the answer to on the internet.


 We are busy investigating an issue on a server where we have erattic 
behaviour.


  During the times when it experiences issues, I found that there is always 
about 4-5 processes on mysql that gets stuck on "closing table" state and once 
the software (opensips) is restarted due to a sigfault, then these queries are 
killed as well.


  Based on information found we added grafana graphs and did notice that 
the table_open_cache is fully used during the time of the sigfaults and the 
queries getting stuck so we tested by increasing the table_open_cache.


 This did however not resolve the issue as we simply saw table_open_cache 
using the full value of 3000 and once again the same behaviour.



 When running "Show open tables" though, we find that the amount of open 
tables is only 283 and a count of all tables returned that there is only 381 
tables on the server.


However when running "Show global status like 'open_tables' we get a value 
of 2900.


So my questions are as follows :


 1. Why is the table_open_cache used up if there are not even that many 
tables.

 2. Why does these values differ so much? or do they provide different info.

 3. What other reasons can there be for a query to get stuck on "closing 
table" state.


   From what I could see , the moment the queries get stuck in this state, the 
load on the server increases to more than the amount of cores available and 
that is then when the opensips software errors out with a sigfault complaining 
about mysql being unavailable.



   Any suggestions would be greatly appreciated.



Regards

[ANN] Mroonga 8.07 - Fast fulltext search for all languages on MySQL

[Masafumi Yokoyama]

Hi,

Mroonga 8.07 has been released!

Mroonga is a MySQL storage engine that supports fast fulltext search
and geolocation search.  It is CJK ready. It uses Groonga as a storage
and fulltext search engine.

Document:
   http://mroonga.org/docs/

How to install: Install Guide
   http://mroonga.org/docs/install.html

How to upgrade: Upgrade Guide
   http://mroonga.org/docs/upgrade.html

Blog:
   http://mroonga.org/en/blog/2018/09/29/mroonga-8.07.html

Changes:
   http://mroonga.org/docs/news.html#release-8.07

Here are some topics in this release.

  * Tokenizer off option is now deprecated, use none instead
  * MariaDB 10.1.36 has been supported

## Tokenizer off option is now deprecated, use none instead

In this release, tokenizer off option is deprecated. Use tokenizer
none instead.

Before:

  FULLTEXT INDEX (content) COMMENT 'tokenizer "off"'

After:

  FULLTEXT INDEX (content) COMMENT 'tokenizer "none"'

To keep consistency with normalizer option and PGroonga, off option
has been deprecated.

## MariaDB 10.1.36 has been supported

In this release, MariaDB 10.1.36 has been supported.

To support MariaDB 10.1.36 changes, Mroonga has dropped support for
MariaDB 10.2.2 (Shipped at Sep 27, 2016) and older MariaDB 10.2
series.


Regards,
--
Masafumi Yokoyama 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql