I have the following scenario: I need to update in a MySQL database ( innodb ) ~5-10 million records / day For each record i update or insert i need to run ~10 read queries, then I split the record in ~4 tables. Problem is right now I'm limited to ~3 million records / day, and i don't know what i should upgrade, CPU, ram or drives. The server right now its an Intel E-2388G CPU @ 3.20GHz, 64GB ram, 2xNVME 1TB in raid 1. I was thinking switching to a 128-256gb ram and 4xNVME TB in raid 10. Entire scope of the server is to read data from text files and break them into various tables in a large database and at the end exporting an sql dump. Thanks.

Greetings to all users from a newcomer to this platform. I am facing the following situation: - I have successfully installed MySQL Server 8.0 & MySQL Workbench on my work computer (which is of course managed by my employer company and hence local admin privileges were required for the installation); for the time being my scope of use is quite limited and thus one and the same machine will both host the server and act as the client - I have also proceeded to create my first database together with an initial table, which is currently empty; so far everything went smooth - the problem appeared though upon attempting to run LOAD DATA INFILE in order to upload a locally prepared csv file in the above-mentioned table: running the LOAD DATA script produces the following: Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. - Inspecting the secure-file-priv variable revealed however that I had placed the respective csv file in the *correct* place - the path to the dedicated upload folder specified by this variable - and *I have also made sure* that I am referencing this correct path in the LOAD DATA script. Nevertheless, the script will not execute: it appears as though for some reason the Server is oblivious of the actual location of the csv file and raises an error it should not! I suspect this has a great deal to do with the fact that the computer is company managed and perhaps the server has insufficient local folder access privileges (?!). If anyone of the more experienced users has encountered similar situations and could enlighten me on how to solve the above issue, I would be very grateful. Thank you for your time!

I have noticed there are two SQL Servers installed on the same box, which are 2014 and 2019; however, when I log into SSMS and type select @@version, it is showing 2014, and the instance name is showing as servername\sqlexpress. I am wondering how I can find the instance name of SQL 2019.

In this file monitoring this will check if the files are recieved or not in the shared paths and if recieved then what's the extension of the file recieved if .pro then the file is processed and if .error then the file is errored out and its size and everything will be then monitored.

I have 3 tables on serverA that I want to clone over to serverB. Right now I need to connect to a VPN to access serverA and another VPN to access serverB and they don't have connections to eachother. What is the easiest way to clone this tables?

unfortunately I did not create a 'dump' file with the backup (Data Export) process on MySQL Workbench 8.0.26. When I copy the old database files to the new Data directory, the server fails to start with the message:

Could not connect to MySQL: Can't connect to MySQL server on 'localhost' (10061) (code 2003)

Tried to do a clean install of MySQL Server 8.0.26 and Workbench 8.0.26 on Windows Web Server 2008 R2. Which after that install the MySQL Server works fine. But then when I stop the server and copy the old Database files into the new Data directory, the MySQL Server fails to start after that. Although I have read that this is not the usual way to 'backup' and restore a MySQL Database, though I wasn't aware of that before. Is there any way to convert the old database files into a 'dump' file outside of MySQL Workbench? Or is there some way to import the old MySQL database files into the new database without the MySQL Server failing to startup again? Thank you.

I have accidentaly restored a very old version of my database and have this .bak standard file from 3 days ago. But I found this "Backup Timeline" in MSSQL that actually points out several backups that I didnt even know that happened. Yet, when I select one of them to restore they simply claim the file doesnt exist (and it doesn't at all in the standard backup folder). What should I do?? I lost a bunch of important data!!

I have to test how application responds if the mysql server takes some time(like 1 minute). So, i would like the mysql to wait for a minute before processing the request. I have check mysql configuration but none seems to be doing what i needed.

As you can see in the title, SQL-server is not very clear when it comes down to naming their objects. My situation is: I have two logins, "SQLExpress" and "SQLExpress01", and I want to add a third one "SQLExpress02". I tried using "Microsoft SQL Server Management Studio" but I didn't find a way to get it done (I remember needing another program instead of the Management Studio, but which one). So I tried "SQL Server Configuration Manager". This, however, gives me the opportunity to view the "SQL Server"s, but not to add one, as you can see in this screenshot: So I looked a bit further and I found the "SQL Server Installation Center". But when I tried adding a simple "SQLExpress02", I got the request to add the CD with the installation file. **??? I just want to add a "login", not perform an entire installation.** Obviously you can say "*You're an idiot! SQLExpress and SQLExpress01 are not logins, but SQL Servers.*" This part I have already understood, but honestly I don't care about the correct naming, I just want to know how to add one. Does anybody have an idea? **Edit, trying to give more explanation:** Some people refer to the term *instance*, which seems to mean that an installation, like an image.iso or setup.exe or something might be required. This is not the case: When I started working here, there was an SQLEXPRESS "login" present, and one of my colleagues used a different tool than the SQL-Server Management studio to add SQLEXPRESS01 "login". (I'm placing the word "login" between brackets because I know it's not the correct name). While searching on my computer for other SQL-Server related programs, I found the "SQL Server Configuration Manager", where SQLEXPRESS and SQLEXPRESS01 are mentioned as "SQL Server" objects (whatever that might mean). That "SQL Server Configuration Manager" gives the possibility to view those "things", but not to add a new one, which is exactly what I would like to do. I can't ask that colleague anymore, he has left the company, so I need to find it myself, hence this question here. If your reaction is "*Dude, you call something a "login", a "SQL Server", a "thing" and an "object" at the same time, you have no idea what you're doing, right?*", I can only confirm that: I have a past in dBase3, Oracle, Progress and MySQL but SQL-Server is completely new to me. Thanks in advance