Swoole high performance in memory database use and configuration tutorial

Usage environment ：thinkphp6.* + think-swoolev4.0

explain
because PHP The language does not support multithreading , therefore Swoole Use multiprocess mode , There is process memory isolation in multi process mode , Modify... In the course of work global Global variables and super global variables , Invalid in other processes .
The corresponding solutions are ：

1. Use Redis database 、 Relational database Mysql
2. Memory files /dev/shm
   First of all, the operation of the database involves IOD Waiting time , Therefore, it is recommended to use Table

Attribute specification

size Get the maximum number of rows in the table

Swoole\Table->size;
memorySize

Get the size of the actual memory used , The unit is byte
You can use the property to get the current occupied memory , It is conducive to adjusting the configuration . Avoid appearing ：Unable to allocate memory error

Swoole\Table->memorySize;

To configure

file location ：config/swoole.php

return [
    'tables' => [
        // High performance in memory database     
        'user' => [        
            'size' => 20480, // Specify the database memory size       
             'columns' => [           
                 ['name' => 'fd', 'type' => Table::TYPE_INT],// Built in fields , Set it up by yourself         
                 ['name' => 'type', 'type' => Table::TYPE_INT],          
                 ['name' => 'uid', 'type' => Table::TYPE_INT,'size'=>1024],           
                 ['name' => 'to_uid', 'type' => Table::TYPE_INT],          
                 ['name' => 'tourist', 'type' => Table::TYPE_INT]       
            ]  
        ]
    ],
];

The above configuration... Needs to be added to the configuration file ：user Is the name of the watch ,size Is the database size ,columns For database fields
You can add multiple databases
matters needing attention ：
size The generation size of needs to be determined according to its own use , Too small to expand automatically . Need to restart service .
To modify the memory database, you must restart swoole To take effect

Use scenarios

1. socket Communication records fd Binding relationship with users
2. Read record data globally as a cache
3. It can be used as a counter , Atomic level . There will be no problem of concurrency. How to use... In the framework

use think\swoole\Table;
use Swoole\Table as SwooleTable;

// Get the instantiated table object 
$make = app()->make(Table::class);
// obtain user Example 
[ Add link description ](https://q.crmeb.com)/** @var SwooleTable $table **/
$table = $make->get('user');

// Set up the data 
$table->set('1',['fd'=>123,'type'=>1,'uid'=>1,'to_uid'=>0,'tourist'=>0]);

// Read key=1 The data of 
$table->get('1');

foreach ($table as $key => $value) {
    
    
    var_dump($key);// Set up key
    var_dump($value);// Set up value data 
        
}

Last
If you think this article is useful to you , Please give our open source project a little bit star:http://github.crmeb.net/u/defu Thank you for ！

Get the source code address for free ：http://www.crmeb.com

PHP Learning manual ：https://doc.crmeb.com

Technical exchange forum ：https://q.crmeb.com