Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
Tag: maintenance
Postgresql maintainenace queries fail with foreignkey violation
Question : I maintain a Django app with a postgresql backend, where users post interesting URLs (links) and then either […]
Role of Database Administrators
Question : I am currently working as an application developer on a project which involves the creation of a new […]
How full is my innodb shared table space?
Question : How can I find out how much data is in the innodb shared table space. I have a […]
How to make stored procedures more readable without harming performance
Question : I come from OOP background, and I need to write and maintain huge stored procedures. Naturally, the sprocs […]
Database design with different user roles connected by different relationships to one organizaiton table
Question : An user is connected to an organization by some role. Lets say there are 2 roles freelancer and […]
How can I detect which indexes are being rebuilt offline and how long?
Question : The rebuild of indexes takes appr. the same 55 min. with both “Do not rebuild indexes and “Rebuild […]
Ola Hallengren maintenance solution
Question : When I am executing the below query: EXECUTE dbo.IndexOptimize @Databases = ‘USER_DATABASES’, @FragmentationLow = NULL, @FragmentationMedium = NULL, […]
Locks caused by async stats update
Question : SQL Server has an option for statistics to autoupdate asynchronously (AUTO_UPDATE_STATISTICS_ASYNC). But, even if this option is ON, […]
shrink ibdata1 in Galera Cluster
Question : I’m having a Galera cluster (3 nodes, but currently using only one), MariaDB 10.0 Galera. However, my ibdata1 […]