Difference between revisions of "Lianja Cloud Admin Console"

From Lianjapedia
Jump to: navigation, search
(Dashboard)
(Databases)
Line 24: Line 24:
  
 
==Databases==
 
==Databases==
 +
The '''Databases''' tab displays a list of database tables with their file size, row count and last modification date.
 
[[{{ns:file}}:lcac_databases.png|800px|left|border|link={{filepath:lcac_databases.png}}|Databases]]
 
[[{{ns:file}}:lcac_databases.png|800px|left|border|link={{filepath:lcac_databases.png}}|Databases]]
 
<br clear=all>
 
<br clear=all>
 +
 +
Select a table by checking the box at the end of the row, then select a menu option to perform the following database operations.  You will be prompted to confirm that the operation should proceed.
 +
 +
{| class="wikitable" width="100%"
 +
!Menu||Description
 +
|-
 +
|Refresh||Refresh the list.
 +
|-
 +
|Snapshot||[[COPY DATABASE|Take a snapshot]] of the database.  Snapshots can be viewed and managed in the [[#Snapshots|Snapshots]] tab.
 +
|-
 +
|Optimize||Optimize the database.
 +
|-
 +
|Check||[[CHECK DATABASE|Check]] the integrity of the database.
 +
|-
 +
|Delete||[[DROP DATABASE|Delete]] the database.
 +
|-
 +
|}
 +
 +
Note: table information can be queried from the [[SYSTABLES|systables]] [[SQL System Tables|system table]].
  
 
==Snapshots==
 
==Snapshots==

Revision as of 12:04, 27 May 2020

See Also

Lianja Cloud Server, Lianja Server Manager on Linux, Lianja Server Manager on Mac, Lianja Server Manager on Windows, System Tables, TabView Sections,

Overview

The Lianja Admin Console for Lianja Cloud provides you with everything you need to administer your users, databases, packages, reports and - very importantly - forensics in the cloud. It also contains a real time dashboard that is dynamically updated. This monitors the users connected and the CPU, memory and disk usage. The Lianja Admin Console is a Lianja App so you can open it in the App Builder, study how it is implemented, modify it and enhance it and deploy it to your server.

Dashboard


Admin Console App

The Lianja Admin Console is a Lianja App so you can open it in the App Builder, study how it is implemented, modify it and enhance it and deploy it to your server.

App: lianjacloud_admin


Find it in the ADMIN tab in the Home workspace:

App: lianjacloud_admin


Dashboard

The Dashboard tab displays a System Overview, details of the Active Users and disk, memory and CPU usage.

Dashboard


Databases

The Databases tab displays a list of database tables with their file size, row count and last modification date.

Databases


Select a table by checking the box at the end of the row, then select a menu option to perform the following database operations. You will be prompted to confirm that the operation should proceed.

Menu Description
Refresh Refresh the list.
Snapshot Take a snapshot of the database. Snapshots can be viewed and managed in the Snapshots tab.
Optimize Optimize the database.
Check Check the integrity of the database.
Delete Delete the database.

Note: table information can be queried from the systables system table.

Snapshots

Snapshots


Users

Users


Packages

Packages


Apps

Apps


Reports

Reports


Forensics

Forensics