Hello I have a decent amount of experience in as a SQL developer in Microsoft SQL but little to no experience as a DBA and I'm just starting to learn MySQL. Basically I have a scheduled stored procedure that runs…
I run the below 'is null' condition query on the postgres - 11.9 version and it takes almost 1500-2000 ms for each run. I changed the default statistics to 1000 for the database and executed reindex,vacuum and analyze on the…
I'm trying to come up with a function to verify the object identifier name. Like in Oracle, if a given identifier associated with any sql object (tables, functions, views,... ) It returns the name as it is else error out.…
transaction id data type's possible values= 2^32= ~ 4 billion, then why does postgres declares a transaction wraparound and shuts down database at 2~31 2 billion transactions.
Using MySQL 5.7, I have a table of urls containing url_title, url_description, url_keywords Sometimes I just need to look in url_title, but sometimes look for something in all columns. Is it better to just create one index containing all 3…
I have a table where it stores the types of discounts that a user can have. Some users will get the standard discount, but some will get a bigger and better discount. For users who have the biggest and best…
I installed MySQL server 8.0 in my ubuntu 20.04 EC2 instance and also did the secure installation using $ sudo mysql_secure_installation where I set the password for the root user. I also disabled login into MySQL through anonymous users. I…
I installed Postgresql 13 to Centos 8 VM, trying to learn how to make connections secure with ssl. Though completing most of the steps and creating server and client certificates, i can't connect to my database remotely via PgAdmin with…
I have encountered a strange error with MySQL service. I can not start it due to the problem related to ports. I have checked my error logs: 2021-03-18T10:02:22.507114Z 0 [ERROR] [MY-010262] [Server] Can't start server: Bind on TCP/IP port: Cannot…
With Oracle SQL-Developer I'm able to connect to my VMware CentOS 7 Oracle database ORCL. if I try to connect with SQLPlus I'm told the realm doesn't exist. Any idea as to why I can connect with Oracle SQL-Developer and…