Have you moved files to that path?

Google it

Ok

Preparing

Hello everyone i had a column value in a table as
C:volsharedetailinfobofaarchivebbpmcmgr
I need a sql query to extract data between 2nd and 3rd forward slash()

and i need a sql query to extract data after last slash().

Remember here data and number of slashes might change for every record.

Can you guys gelp me with the above usecases

use regular expressions…

Spam?

Will be banned with report instantly

I changed the path to the mysql datadir database in my.conf and now he doesn’t want to start the MySQL service.

Have you moved files to that path?

Check the error message in MySql error log

Also check the folder/file permissions that you have moved.

Is the directory owned by mysql?

What was the reason to change the directory?
I propose you tho change it back and make a link if you like to move files physically.

Can we create My SQL table based on python List

You are able to create any table you wish

I can make questions about MariaDB?

Yes

I’m using Java (HikariCP) with MariaDB Database to get and set some data. After two connections the database stop respoding.. For example: I make two connections with a delay of ~1 seconds with same or different query string, both of them successfully execute and retrieve data. At the third connection the MariaDB stop respoding and cause system crash.

Anybody knows why?

(I’m using HikariCP with MySQL driver)

I suspect this is not a MySQL problem, but the configured size of your connection pool to the database.

Anyway, you must check are the connections really made to the database and what exactly it’s done in the database, or else this is not a DB problem

I set the MaximumPoolSize to 50 and still nothing

How I can check that? I’m working with the app and the database in localhost

select * from information_schema.processlist;

or

show processlist

Fixed. There was a problem with the Thread System

I am new to mysql how to use it

Why do you think you should?

I use this for store data for example IPs of my players(Game Server), logout location and many more. MySQL Is faster than JSON file on large dimension scale

What game do you have?

Minecraft

Oh)) I thought it is your game

I have chess

chees?

Learn things 2+ years, then use.
Simple.

Just 2+? I Thought you should learn it about 8+ years before you can start using it.

two plus…
Up to eternity

Team, we have started supporting MySQL databases recently. Can you somework share the adminstration point of view tasks and commands to understand and practice more on mysql. Thanks in advance.

There is not a blog. You may write here anytime you would need to get a quick help suggestion or advice…

There are too much blogs in the Internet

Hello guys, when partitioning BY RANGE it is possible set a specific TABLESPACE , for example, to parallelize access to disks. Is it possible do that in KEY or HASH type partitions?

No, because hash partitioning doesn’t have partition definition

I believe so

anyone experienced MTS with GTID mode ?

what;s the advantage between multithreded replicaition without GTID and with GTID ? does Logical_Clock need GTID to function ?

I need query for question 5&6, can anyone solve this?

Above image not clear, so posted structure again and I needs following queries –

Query 5: Management needs to know the candidates who haven’t been successfully placed into employment with any of the companies. These identified candidates will then be contacted and encouraged to enroll into courses that will help provide the required qualifications and improve the candidates’ chances of a successful placement. List these candidates and the recommended courses that they should be encouraged to enroll in.
VII. Query 6: For each of the identified candidates that require further education, management will need to inform each student of the courses, when each course will start, the respective cost of each course and the total cost of the required courses. The list is to be ordered by the candidate’s last name in ascending order.
VIII. Query 7: Management needs a list of all the candidates who are currently pursuing studies and the respective qualifications that they are studying. For qualifications that require multiple courses, management needs to know how many courses each student has completed/enrolled in.
IX. Query 8: To help finalise financial records for the 1st quarter of the year, management needs to know candidates who have not paid their fees in order to contact them.
X. Query 9: For each opening, management will need to determine the most suitable candidate/s. Each potential candidate will then be further evaluated to ensure maximum suitability. List all the
companies that have current openings and the details, qualifications and number of successful placements of candidates that could be shortlisted for these openings.
XI. Query 10: Marketing department needs three of the most successful candidates and three of the most successful companies to feature in the latest edition of TE’s newsletter and website.
XII. Query 11: To help determine the average pay rate based on qualifications for the respective companies, management needs a list of all the companies,   the qualifications they are requesting for the openings and the average pay for openings by each company.