this is php slow log:
[0x00007f8b18c14f90] getRelationshipFromMethod() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:529
[0x00007f8b18c14f10] getRelationValue() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:454
[0x00007f8b18c14ea0] getAttribute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:2226
[0x00007f8b18c14e30] __get() /www/wwwroot/eg.mlameh.com/app/CentralLogics/helpers.php:271
[0x00007f8b18c14cc0] product_data_formatting() /www/wwwroot/eg.mlameh.com/app/Http/Controllers/Api/V1/CategoryController.php:215
[0x00007f8b18c14be0] get_featured_category_products() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
[0x00007f8b18c14b60] callAction() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
[04-Jun-2024 22:45:13] [pool www] pid 690836
script_filename = /www/wwwroot/eg.mlameh.com/index.php
[0x00007f8b18c159d0] execute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428
[0x00007f8b18c15930] Illuminate\Database{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:816
[0x00007f8b18c15880] runQueryCallback() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:783
[0x00007f8b18c157a0] run() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414
[0x00007f8b18c15710] select() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2751
[0x00007f8b18c156a0] runSelect() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2740
[0x00007f8b18c155c0] Illuminate\Database\Query{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3294
[0x00007f8b18c15520] onceWithColumns() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2739
[0x00007f8b18c15440] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:738
[0x00007f8b18c15310] getModels() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:722
[0x00007f8b18c15210] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:333
[0x00007f8b18c151a0] first() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasOne.php:29
[0x00007f8b18c15130] getResults() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:591
[0x00007f8b18c15020] getRelationshipFromMethod() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:529
[0x00007f8b18c14fa0] getRelationValue() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:454
[0x00007f8b18c14f30] getAttribute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:2226
[0x00007f8b18c14ec0] __get() /www/wwwroot/eg.mlameh.com/app/CentralLogics/helpers.php:1319
[0x00007f8b18c14e30] get_store_discount() /www/wwwroot/eg.mlameh.com/app/CentralLogics/helpers.php:256
[0x00007f8b18c14cc0] product_data_formatting() /www/wwwroot/eg.mlameh.com/app/Http/Controllers/Api/V1/CategoryController.php:215
[0x00007f8b18c14be0] get_featured_category_products() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
[04-Jun-2024 22:45:13] [pool www] pid 690838
script_filename = /www/wwwroot/eg.mlameh.com/index.php
[0x00007f8b18c15c80] prepare() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:423
[0x00007f8b18c15b60] Illuminate\Database{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:816
[0x00007f8b18c15ab0] runQueryCallback() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:783
[0x00007f8b18c159d0] run() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414
[0x00007f8b18c15940] select() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:401
[0x00007f8b18c158c0] selectFromWriteConnection() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Schema/MySqlBuilder.php:41
[0x00007f8b18c157f0] getTables() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Schema/Builder.php:165
[0x00007f8b18c15730] hasTable() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:355
[0x00007f8b18c15690] __callStatic() /www/wwwroot/eg.mlameh.com/app/Models/StoreConfig.php:17
[0x00007f8b18c15620] __construct() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:601
[0x00007f8b18c15590] newInstance() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:1538
[0x00007f8b18c15520] newModelInstance() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:408
[0x00007f8b18c15490] hydrate() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
[0x00007f8b18c153b0] forwardCallTo() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:2334
[0x00007f8b18c152f0] __call() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:737
[0x00007f8b18c15280] getModels() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:722
[0x00007f8b18c15180] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:333
[0x00007f8b18c15110] first() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Relations/HasOne.php:29
[0x00007f8b18c150a0] getResults() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:591
[0x00007f8b18c14f90] getRelationshipFromMethod() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:529
[04-Jun-2024 22:45:13] [pool www] pid 690807
script_filename = /www/wwwroot/eg.mlameh.com/index.php
[0x00007f8b18c15660] execute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428
[0x00007f8b18c155c0] Illuminate\Database{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:816
[0x00007f8b18c15510] runQueryCallback() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:783
[0x00007f8b18c15430] run() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414
[0x00007f8b18c153a0] select() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2751
[0x00007f8b18c15330] runSelect() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2740
[0x00007f8b18c15250] Illuminate\Database\Query{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3294
[0x00007f8b18c151b0] onceWithColumns() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2739
[0x00007f8b18c150d0] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:738
[0x00007f8b18c14fa0] getModels() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:722
[0x00007f8b18c14ea0] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:333
[0x00007f8b18c14e30] first() /www/wwwroot/eg.mlameh.com/app/CentralLogics/helpers.php:251
[0x00007f8b18c14cc0] product_data_formatting() /www/wwwroot/eg.mlameh.com/app/Http/Controllers/Api/V1/CategoryController.php:215
[0x00007f8b18c14be0] get_featured_category_products() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
[0x00007f8b18c14b60] callAction() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
[0x00007f8b18c14ac0] dispatch() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
[0x00007f8b18c14a60] runController() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/Route.php:205
[0x00007f8b18c149e0] run() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Routing/Router.php:806
[0x00007f8b18c148e0] Illuminate\Routing{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:144
[0x00007f8b18c14850] Illuminate\Pipeline{closure}() /www/wwwroot/eg.mlameh.com/app/Http/Middleware/ModuleCheckMiddleware.php:49
[04-Jun-2024 22:45:13] [pool www] pid 690798
script_filename = /www/wwwroot/eg.mlameh.com/index.php
[0x00007f8b18c159b0] execute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:428
[0x00007f8b18c15910] Illuminate\Database{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:816
[0x00007f8b18c15860] runQueryCallback() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:783
[0x00007f8b18c15780] run() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Connection.php:414
[0x00007f8b18c156f0] select() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2751
[0x00007f8b18c15680] runSelect() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2740
[0x00007f8b18c155a0] Illuminate\Database\Query{closure}() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:3294
[0x00007f8b18c15500] onceWithColumns() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:2739
[0x00007f8b18c15420] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:738
[0x00007f8b18c152f0] getModels() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:722
[0x00007f8b18c151f0] get() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Concerns/BuildsQueries.php:333
[0x00007f8b18c15180] first() /www/wwwroot/eg.mlameh.com/app/CentralLogics/helpers.php:52
[0x00007f8b18c15110] schedule_order() /www/wwwroot/eg.mlameh.com/app/Models/Store.php:338
[0x00007f8b18c15090] getScheduleOrderAttribute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:658
[0x00007f8b18c15000] mutateAttribute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:2120
[0x00007f8b18c14f80] transformModelValue() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:489
[0x00007f8b18c14f10] getAttributeValue() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Concerns/HasAttributes.php:443
[0x00007f8b18c14ea0] getAttribute() /www/wwwroot/eg.mlameh.com/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Model.php:2226
[0x00007f8b18c14e30] __get() /www/wwwroot/eg.mlameh.com/app/CentralLogics/helpers.php:257
[0x00007f8b18c14cc0] product_data_formatting() /www/wwwroot/eg.mlameh.com/app/Http/Controllers/Api/V1/CategoryController.php:215
and mysql slow log:
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.001200 Lock_time: 0.000015 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.001136 Lock_time: 0.000016 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52877 Schema: mlameh QC_hit: No
Query_time: 0.000214 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 2
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select * from flash_sale_items
where status
= 1 and exists (select * from items
where flash_sale_items
.item_id
= items
.id
and exists (select * from stores
where items
.store_id
= stores
.id
and status
= 1)) and exists (select * from flash_sales
where flash_sale_items
.flash_sale_id
= flash_sales
.id
and is_publish
= 1 and start_date
<= '2024-06-05 13:41:45' and end_date
>= '2024-06-05 13:41:45') and (item_id
= 558) limit 1;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000902 Lock_time: 0.000016 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52877 Schema: mlameh QC_hit: No
Query_time: 0.001303 Lock_time: 0.000012 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000162 Lock_time: 0.000023 Rows_sent: 0 Rows_examined: 2
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select * from flash_sale_items
where status
= 1 and exists (select * from items
where flash_sale_items
.item_id
= items
.id
and exists (select * from stores
where items
.store_id
= stores
.id
and status
= 1)) and exists (select * from flash_sales
where flash_sale_items
.flash_sale_id
= flash_sales
.id
and is_publish
= 1 and start_date
<= '2024-06-05 13:41:45' and end_date
>= '2024-06-05 13:41:45') and (item_id
= 354) limit 1;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52877 Schema: mlameh QC_hit: No
Query_time: 0.002022 Lock_time: 0.000040 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000883 Lock_time: 0.000011 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000914 Lock_time: 0.000011 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52877 Schema: mlameh QC_hit: No
Query_time: 0.001400 Lock_time: 0.000017 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000845 Lock_time: 0.000011 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000146 Lock_time: 0.000022 Rows_sent: 0 Rows_examined: 2
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select * from flash_sale_items
where status
= 1 and exists (select * from items
where flash_sale_items
.item_id
= items
.id
and exists (select * from stores
where items
.store_id
= stores
.id
and status
= 1)) and exists (select * from flash_sales
where flash_sale_items
.flash_sale_id
= flash_sales
.id
and is_publish
= 1 and start_date
<= '2024-06-05 13:41:45' and end_date
>= '2024-06-05 13:41:45') and (item_id
= 318) limit 1;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52877 Schema: mlameh QC_hit: No
Query_time: 0.000212 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 2
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select * from flash_sale_items
where status
= 1 and exists (select * from items
where flash_sale_items
.item_id
= items
.id
and exists (select * from stores
where items
.store_id
= stores
.id
and status
= 1)) and exists (select * from flash_sales
where flash_sale_items
.flash_sale_id
= flash_sales
.id
and is_publish
= 1 and start_date
<= '2024-06-05 13:41:45' and end_date
>= '2024-06-05 13:41:45') and (item_id
= 557) limit 1;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000835 Lock_time: 0.000011 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52877 Schema: mlameh QC_hit: No
Query_time: 0.001218 Lock_time: 0.000011 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;
User@Host: root[root] @ localhost [127.0.0.1]
Thread_id: 52802 Schema: mlameh QC_hit: No
Query_time: 0.000995 Lock_time: 0.000010 Rows_sent: 110 Rows_examined: 220
Rows_affected: 0 Bytes_sent: 0
SET timestamp=1717584105;
select table_name as name
, (data_length + index_length) as size
, table_comment as comment
, engine as engine
, table_collation as collation
from information_schema.tables where table_schema = 'mlameh' and table_type in ('BASE TABLE', 'SYSTEM VERSIONED') order by table_name;