Institutional
Test "wiki" page
Test to see if updates on content are sent to all member...
First update by jinanatman
Second update by jinanatman
- 55 reads
International Yoga Day Celebrations in Nepal
- 533 reads
Yoga Teachers Training Intensive in Bangkok
- 632 reads
Yoga Teachers Training Seminar in Davao
- 717 reads
Yoga Teachers Training in Brazil
- 716 reads
DB Tuning
| Threads Created | Connections | Thread Cache Size | Hit Ratio | Warnings |
| 8 | 127220 | 286 | 0% | The ideal situation is to get Threads Created as close as possible to Thread Cache Size. So no new connections are having to wait for new thread allocation. Stay as close to a 99% hit ratio as you can as this will reduce bottlenecks in your caching. Adjust your Thread Cache Size until this is achieved. You can set your Thread Cache Size on the fly by doing "SET GLOBAL thread_cache_size=N". Where N is the desired size of your Thread Cache. For additional information on the SET command please read SET Syntax |
| Table Cache | Open Tables | Opened Tables | Warnings | |
| 1024 | 465 | 1381 | Your MySQL server has not been running long enough to make a quality assessment of the performance of your table cache. Put some traffic on there and come back soon! | Uptime: 1664015 |
| Query Cache Ratio | 0.09 | |
| Query Cache Inserts | 2170407 | |
| Query Cache Hits | 25151187 | |
| Query Cache Available? | YES | |
| Query Cache Size | 16777216 | |
| Query Cache Type | ON | |
| Query Cache Free Memory | 6101416 | |
| Query Cache Free Blocks | 2121 | If your Query Cache has a lot of free blocks in it. This can indicate fragmentation in your Query Cache. This can decrease performance and generally just be a waste of resoures. Fix this problem by issuing a 'FLUSH QUERY CACHE' command. Read more about query cache maintenance here. |
| Query Cache Prunes | 1186234 | |
| Query Cache Limit | 1048576 | |
| Queries Not Cached | 464065 |
| This number is a calculation of the maximum amount of memory your mySQL instance will consume on your server . It is a sum of all the caches and buffers that would benefit by not using swap or not having to goto the HD. Having a number larger than your total available amount of memory will result in swapping. |
| Variable Name | Current Value | Warnings |
| Select_full_join | 21596 | A high value here means that MySQL is not using indexes and is therefore taking longer to build a result set. The problem can be fixed by indexing important fields of the join.Enable the Slow Query Log and use Explain to examine your queries. |
| Select_scan | 103214 | A high value here can be an indication of bottlenecks in your server optimization. This happens because Mysql is not using the indexes for the tables and so is having to do extra work for inefficient queries. Enable the Slow Query Log and use Explain to examine your queries. |
- 294 reads
Formatting your articles
Here is a cheat sheet for formatting in use on this web-site.
(Not yet finished)
| Description | You type | You get |
|---|---|---|
| applies everywhere | ||
| Italic text | *italic* | italic |
| Bold text | **bold** | |