Which ver MySQL is stable?

|
alexsandro_matias 2020-10-01 20:24:07
alexsandro_matias 2020-10-01 12:06:05
result sets I must put in a file

On Linux, if I should want do that, it should be this way:

ls -la >> file.txt

alexsandro_matias 2020-10-01 20:24:24
Master Yoda 2020-10-01 20:02:12
mysql -u username -p password -e “select * from TBL ;” > /path/to/file . ? Will this do?

I’ll try

ruydar 2020-10-01 20:26:43
Which ver MySQL is stable ?
piterden 2020-10-01 20:27:13
ruydar 2020-10-01 20:26:43
Which ver MySQL is stable ?

Stable

alexsandro_matias 2020-10-01 20:27:29
Master Yoda 2020-10-01 20:02:12
mysql -u username -p password -e “select * from TBL ;” > /path/to/file . ? Will this do?

I did. But the file was empty

ruydar 2020-10-01 20:27:59
I need download mysql community
piterden 2020-10-01 20:28:11
alexsandro_matias 2020-10-01 20:27:29
I did. But the file was empty

And what about output?

ruydar 2020-10-01 20:28:28
Which version is good ?
ruydar 2020-10-01 20:28:48
piterden 2020-10-01 20:28:11
And what about output?

For Java web application

piterden 2020-10-01 20:29:58
ruydar 2020-10-01 20:28:48
For Java web application

What OS do you use?

ruydar 2020-10-01 20:30:47
For windows 10 and 7 64bit
piterden 2020-10-01 20:31:06
https://dev.mysql.com/downloads/windows/installer/8.0.html
Gnation88 2020-10-01 20:31:45
Hi All, I’m getting below error in audit log. 20201001 13:44:54,myhostname,,myhostip,8845,0,FAILED_CONNECT,,,1129

Username is blank in logs.

piterden 2020-10-01 20:32:39
Gnation88 2020-10-01 20:31:45
Hi All, I’m getting below error in audit log. 20201001 13:44:54,myhostname,,myhostip,8845,0,FAILED_CONNECT,,,1129

Username is blank in logs.

Keep us udated

ruydar 2020-10-01 20:32:47
MySQL 8.0.21 ?
Gnation88 2020-10-01 20:32:54
Version mariadb 10.3
piterden 2020-10-01 20:33:46
ruydar 2020-10-01 20:32:47
MySQL 8.0.21 ?

Do you see more?

ruydar 2020-10-01 20:34:10
Yes but this version supposed windows 7
piterden 2020-10-01 20:34:31
Gnation88 2020-10-01 20:31:45
Hi All, I’m getting below error in audit log. 20201001 13:44:54,myhostname,,myhostip,8845,0,FAILED_CONNECT,,,1129

Username is blank in logs.

It is telling me nothing. What exactly do you do?

piterden 2020-10-01 20:35:12
ruydar 2020-10-01 20:34:10
Yes but this version supposed windows 7

I don’t use windows, sorry IDK

Master Yoda 2020-10-01 20:35:42
alexsandro_matias 2020-10-01 05:12:54
Load data local infile ‘/home/matias/automatizacao-mysql/tpch-dbgen/data/customer.tbl’ INTO TABLE CUSTOMER FIELDS TERMINATED BY ‘|’;

You want to load query results from a file to db?

alexsandro_matias 2020-10-01 20:36:09
Master Yoda 2020-10-01 20:02:12
mysql -u username -p password -e “select * from TBL ;” > /path/to/file . ? Will this do?

It was fix, but the file doesn’t the querie’s time

ruydar 2020-10-01 20:36:35
piterden 2020-10-01 20:35:12
I don’t use windows, sorry IDK

Windows 7 and 10
Both

Master Yoda 2020-10-01 20:36:57
alexsandro_matias 2020-10-01 20:36:09
It was fix, but the file doesn’t the querie’s time

I didn’t get you. Query time? And file what?

Gnation88 2020-10-01 20:37:57
piterden 2020-10-01 20:34:31
It is telling me nothing. What exactly do you do?

I have enabled audit logs on mariadb db.
I’m getting error code 1129. But unable to identify the source, which application or script is connecting.

Master Yoda 2020-10-01 20:37:58
Master Yoda 2020-10-01 20:02:12
mysql -u username -p password -e “select * from TBL ;” > /path/to/file . ? Will this do?

Path/to/filename. txt

alexsandro_matias 2020-10-01 20:38:30
I made a script for reapeat the same query, and then, meansure the time
alexsandro_matias 2020-10-01 20:38:56
mysql –database=TPCH -u matias -p -e “source /home/matias/automatizacao-mysql/loops.sql;” > testeSelect.txt
alexsandro_matias 2020-10-01 20:40:03
the file about loop
alexsandro_matias 2020-10-01 20:40:29
Master Yoda 2020-10-01 20:37:58
Path/to/filename. txt

Did you get now ???

alexsandro_matias 2020-10-01 20:41:10
I pretend measure the avg the time of a query
alexsandro_matias 2020-10-01 20:41:35
for that, I need reapeat the same query several times
Master Yoda 2020-10-01 20:41:57
alexsandro_matias 2020-10-01 20:41:35
for that, I need reapeat the same query several times

Mysqlslap tool would be better

Master Yoda 2020-10-01 20:42:20
It can simulate connections , iterations and give avg time for query
alexsandro_matias 2020-10-01 20:44:21
Master Yoda 2020-10-01 20:42:20
It can simulate connections , iterations and give avg time for query

Is it hard ???

Master Yoda 2020-10-01 20:45:24
alexsandro_matias 2020-10-01 20:38:56
mysql –database=TPCH -u matias -p -e “source /home/matias/automatizacao-mysql/loops.sql;” > testeSelect.txt

I think this is not correct. Because source will just need path. But you are redirecting source command to testeselect. txt. Never tried this myself. Is it possible to do that with source command?

Master Yoda 2020-10-01 20:45:35
alexsandro_matias 2020-10-01 20:44:21
Is it hard ???

No. Not at all.

Master Yoda 2020-10-01 20:47:47
But first check if it is installed
Master Yoda 2020-10-01 20:47:55
A dummy snippet would be
alexsandro_matias 2020-10-01 20:49:31
Master Yoda 2020-10-01 20:45:24
I think this is not correct. Because source will just need path. But you are redirecting source command to testeselect. txt. Never tried this myself. Is it possible to do that with source command?

I safe the file on /home

alexsandro_matias 2020-10-01 20:49:41
Master Yoda 2020-10-01 20:45:35
No. Not at all.

https://www.youtube.com/watch?v=XcKzG2SVifs

MYSQLSLAP EASY STEP BY STEPYouTube
Easy steps on how to use mysqlslap to perform stress/load test.If the tutorial was helpful, please like my facebook page: http://www.facebook.com/Likeasoftwa…
alexsandro_matias 2020-10-01 20:49:54
I saw the doc
alexsandro_matias 2020-10-01 20:51:13
┌─[matias]@[alexsandro]:~
└──> $ man mysqls
mysqlshow mysqlslap
┌─[matias]@[alexsandro]:~
└──> $ man mysqls
Master Yoda 2020-10-01 20:51:15
alexsandro_matias 2020-10-01 20:49:41
https://www.youtube.com/watch?v=XcKzG2SVifs

https://www.google.com/amp/s/www.digitalocean.com/community/tutorials/how-to-measure-mysql-query-performance-with-mysqlslap.amp

How To Measure MySQL Query Performance with mysqlslap | DigitalOceanDigitalOcean
mysqlslap is a diagnostic tool that can help you measure the performance of MySQL queries. This tutorial shows you how to perform tests of varying complexity, including a test that’s practical for production environments with unknown queries.
Master Yoda 2020-10-01 20:51:51
You can customise it and put your own query in command and specify database and iterations and connections, etc
Master Yoda 2020-10-01 20:52:33
Very easy and effective than what you are trying to do
alexsandro_matias 2020-10-01 20:59:32
Really
Master Yoda 2020-10-01 23:22:25
alexsandro_matias 2020-10-01 20:59:32
Really

Did you get it to work for you?

2020-10-03 09:54:05
i need a help to learn sql sub queries
2020-10-03 09:54:29
which resources are the best for learning it? eg-: sql subqueries with INSERT statement, UPDATE statement, and DELETE statement?
|