Categories
Database

How to Obtain the Start and End Time of MySQL Binlogs?

In our last post, we talked about how to check the storage engine of a table in MySQL. Toaday, let's see how to obtain the start and end time of mysql binlogs. When restoring a MySQL database to a specific point in time, we need to use a combination of a MySQL full backup, optional incremental backups, […]

Categories
Database

How to Check the Storage Engine of a Table in MySQL?

In our last post, we discussed how to check the Oracle client version on Windows/Linux. Today, let’s see how to check the storage engine of a table in MySQL. How can you check the storage engine of a single table in MySQL and how can you check which tables in an entire database use a […]

Categories
Database

How to Check the Oracle Client Version on Windows/Linux?

In our last post, we talked about how SQL server determines which sessions/connections are long connections. Today, let's talk about how to check the oracle client version on Windows and Linux. In practical work, there are often situations where you need to check or verify the Oracle client version, as a server may have multiple Oracle client […]

Categories
Database

How Does SQL Server Determine Which Sessions/Connections Are Long Connections?

In our last post, we discussed the advantages and disadvantages of SQL Server stored procedures. Today, let’s see how SQL server determine which sessions/connections are long connections. How Does SQL Server Determine Which Sessions/Connections Are Long Connections? In a database, there can be both long connections and short connections. A long connection refers to maintaining the […]

Categories
Database

Advantages and Disadvantages of SQL Server Stored Procedures

In our last post, we discussed how to access object storage using the S3 API in Python. Today, let’s discuss the advantages and disadvantages of SQL Server stored procedures. SQL Server stored procedures are a set of SQL statements compiled and stored in the database to perform specific functions. Stored procedures can accept parameters, execute […]

Categories
AWS

How to Access Object Storage Using the S3 API in Python?

In our last post, we discussed how to bulk rename files in AWS S3 using Python. Today, let’s talk about how to access object storage using the S3 API in Python. To access object storage using the S3 API in Python, the demo code is as follows. How to use boto3 to connect to S3?   […]

Categories
AWS

How to Bulk Rename Files in AWS S3 Using Python?

In our last post, we have discussed how to run python scripts in AWS. Today, let's see how to bulk rename files in AWS S3 Using Python. Since AWS S3 currently does not have a direct renaming interface, we can achieve renaming by first copying the file with a new name and then deleting the […]

Categories
AWS

How to Get the Object Count in An AWS S3 Bucket?

In my last post, we talked about how to increase the speed of copying files from an S3 bucket to the local machine. Today let's talk about how to get the object count in an AWS S3 bucket. Background AWS S3 does not provide a direct API to get the number of objects in a […]

Categories
AWS

How to Increase the Speed of Copying Files from an S3 Bucket to the Local Machine?

In my last post, we talked about the reasons for slow file copying speed on EC2. Today, let's discuss how to speed up file transfers when using AWS S3. You can refer to this AWS document for the underlying principles. How to increase the speed of copying files from an S3 bucket to the local […]

Categories
AWS

5 Reasons for Slow File Copying Speed on EC2 and Solutions

In my last post, we talked about how to transfer files from a website to AWS S3, and today let's talk about how to fix the slow file copying speed on AWS EC2. The slow file copying speed on EC2 may be caused by 5 factors: 1. Network Bandwidth Limitations: EC2 instances have limited network […]