This article demonstrates how to check the size of MySQL databases and tables. You can do this by using the phpMyAdmin web interface or by using the command-line mysql program.To watch a video that demonstrates the following procedures, please click below: ...
For OCP 3, refer toHow to defrag Etcd to decrease DB size in OpenShift 3. In Red Hat OpenShift 4, etcd is compacted every 5 minutes, and starting with OpenShift 4.9, etcd data is automatically defragmented by the etcd Operator as explained inautomatic defragmentation for etcd data. Refer...
sudo mysqlcheck -o [schema] [table] -u [username] -p [password]Copy For example, to perform the check on a schema namedtest_dband a table namedtest_tableusing therootuser credentials, run: sudo mysqlcheck -o test_db test_table -u root -pCopy Provide the password when prompted. Note...
#!/bin/sh DB_NAME=$(drush status --fields=db-name --field-labels=0 | tr -d '\r\n ') drush sqlq "SELECT table_name AS 'Tables', round(((data_length + index_length) / 1024 / 1024), 2) 'Size in MB' FROM information_schema.TABLES WHERE table_schema = \"${DB_NAME}\" OR...
When I enter a wrong password in the definition of my destination it becomes more tricky for the UI developer to find the root cause of this error. This is because you will get the same popup when testing the destination with the check connection button as you would get i...
--This is another variation used to document a large database for conversion (Edited to --remove static columns) SELECT o.Name as Table_Name , c.Name as Field_Name , t.Name as Data_Type , t.length as Length_Size , t.prec as Precision_ FROM syscolumns c INNER JOIN sysobjects o ON...
Hi...I have set the DB_CACHE_SIZE(1g), but when I run an ADDM report when the customer is complaining of slowness, the report shows says I have an Undersized Buffer Cache and the value is always different(for example, one run says the value is 672m and t
Please check system load during re-index: CPU utilization (if it's below 50%, then you might benefit from tuning) Disk utilization (if it's below 70%, then you might benefit from tuning) DB utilization (check with your DBA if you have capacity there) increase DB pool size if r...
Peter wrote a post a while ago about choosing a good InnoDB log file size. Not to pick on Peter, but the post actually kind of talks about a lot of things and then doesn’t tell you how to choose a good log file size! So I thought I’d clarify it a little. The basic point is...
As everybody pointed out you can check size if the db easily, to find out the size of the cube you can make use of the AMO, in AMO also as I checked you cannot starightway get the size of the cube but you can get size of the measure group. You need to sum up the size of ...