User Gaius

15 votes

Accepted

How do you tune MySQL for a heavy InnoDB workload?

answered Jan 15, 2011 at 17:23

6 votes

Why is there automatic failover for HA and manual failover for DR?

answered Oct 20, 2020 at 9:01

0 votes

Is Oracle DBLink Vulnerable?

answered Aug 28, 2019 at 14:07

1 vote

Create Role or Create user

answered Feb 24, 2019 at 8:44

1 vote

innodb_page_size is not present in [mysqld] section in my.ini file in MySQL Server 8.0?

answered Dec 19, 2018 at 11:24

0 votes

Group data by non-unique keys by distinct time range

answered Feb 18, 2011 at 22:34

3 votes

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

answered Oct 28, 2018 at 11:01

0 votes

Accepted

pg_ctl: server did not promote in time

answered Jun 12, 2018 at 15:57

-1 votes

View the final query executed by PostgreSQL Function

answered May 11, 2018 at 17:03

3 votes

archive command is not working

answered May 11, 2018 at 9:04

6 votes

Best situation to use READ UNCOMMITTED isolation level

answered May 11, 2018 at 13:13

0 votes

Postgresql large transaction OOM killer

answered May 11, 2018 at 7:19

1 vote

Postgres 10.3 : table grows in size after delete-insert

answered May 10, 2018 at 14:04

1 vote

MariaDB/mySQL is there a way to limit a user to SELECT and SHOW queries?

answered May 10, 2018 at 13:38

2 votes

Accepted

How do I uninstall the old version of Postgres on CentOS 7?

answered May 8, 2018 at 20:27

5 votes

Accepted

SQL Server Processor affinity with trace flag 8002 ON

answered May 3, 2018 at 16:37

1 vote

Log plans for queries that never finish

answered Apr 29, 2018 at 17:10

3 votes

Restoring MSSQL back-ups to Oracle 12c

answered Nov 29, 2017 at 8:31

0 votes

How to sync MySQL's time with system time without mysql restart?

answered Oct 29, 2017 at 9:05

4 votes

Postgres cost of large volume of inserts in many tables in a single transaction

answered Sep 7, 2017 at 16:07

0 votes

postgres database disk issue

answered Aug 29, 2017 at 11:20

1 vote

Master/Master Master/Slave

answered Sep 24, 2016 at 9:54

-3 votes

Why SQL server does not have column-level locking?

answered Aug 18, 2016 at 11:06

0 votes

Cannot install Oracle Grid on Oracle Linux 6.4

answered Mar 9, 2015 at 12:33

1 vote

Full table scan even after adding index

answered Jul 6, 2014 at 9:54

2 votes

How many database servers do I need?

answered Jul 6, 2014 at 9:42

19 votes

What are the arguments against or for putting application logic in the database layer?

answered Sep 18, 2011 at 14:49

2 votes

oracle tablespace extending

answered Aug 2, 2013 at 17:09

4 votes

Read ancient Oracle database into current Oracle version

answered Jun 26, 2013 at 8:18

2 votes

Accepted

Protocol used by Oracle RMAN to communicate with auxiliary

answered Jun 13, 2013 at 11:59

Stack Exchange Network

191 Answers

How do you tune MySQL for a heavy InnoDB workload?

Why is there automatic failover for HA and manual failover for DR?

Is Oracle DBLink Vulnerable?

Create Role or Create user

innodb_page_size is not present in [mysqld] section in my.ini file in MySQL Server 8.0?

Group data by non-unique keys by distinct time range

What is purpose of `ALLOW_CONNECTIONS` being set so no one can connect to the new Postgres database?

pg_ctl: server did not promote in time

View the final query executed by PostgreSQL Function

archive command is not working

Best situation to use READ UNCOMMITTED isolation level

Postgresql large transaction OOM killer

Postgres 10.3 : table grows in size after delete-insert

MariaDB/mySQL is there a way to limit a user to SELECT and SHOW queries?

How do I uninstall the old version of Postgres on CentOS 7?

SQL Server Processor affinity with trace flag 8002 ON

Log plans for queries that never finish

Restoring MSSQL back-ups to Oracle 12c

How to sync MySQL's time with system time without mysql restart?

Postgres cost of large volume of inserts in many tables in a single transaction

postgres database disk issue

Master/Master Master/Slave

Why SQL server does not have column-level locking?

Cannot install Oracle Grid on Oracle Linux 6.4

Full table scan even after adding index

How many database servers do I need?

What are the arguments against or for putting application logic in the database layer?

oracle tablespace extending

Read ancient Oracle database into current Oracle version

Protocol used by Oracle RMAN to communicate with auxiliary