I want to update some java?

piterden 2019-10-15 18:51:13
piterden 2019-10-16 02:59:22
How do you think I can help you?
piterden 2019-10-16 03:00:27
Manogna 2019-10-15 18:41:07
I want MySQL queries related to data analytics

Do you think I’m a telepath?

MasterZiv 2019-10-16 11:13:50
Manogna 2019-10-15 18:41:07
I want MySQL queries related to data analytics

select key, key2, key3, min(field1) , max(field2)
from MyDataTable
group by key, key2, key3
order by min(field1) , max(field2)

Abk135 2019-10-17 18:23:07
Hi i am new to mysql
Can i get some suggestions on learning mysql like in websites or YouTube sites
pavantp 2019-10-17 18:40:35
Codewithmosh sql tutorials
kiril_d1 2019-10-17 18:42:10
You can start from this

SQL TutorialW3Schools
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
Master Yoda 2019-10-19 16:05:11
MasterZiv 2019-10-08 13:09:39
Temp is full, please advise
1.how to find who is using it and
2.how to release space.

Thank you

You mean ibtmp1 file?

Master Yoda 2019-10-19 16:05:49
Master Yoda 2019-10-19 16:05:11
You mean ibtmp1 file?

If so you just restart mysqld and it will initiate to it’s default value

Master Yoda 2019-10-19 16:07:00
Master Yoda 2019-10-19 16:05:49
If so you just restart mysqld and it will initiate to it’s default value

Or alternatively you can set the limit on it’s size. I guess the server variable to set it’s size is innodb_temp_data_file_path

Master Yoda 2019-10-19 16:07:55
svraju2020 2019-10-08 13:13:07
Please advise how can I release without restart

Ok so it was without restart. Not possible

Master Yoda 2019-10-19 16:08:15
Perhaps optimize your long running queries, etc
piterden 2019-10-20 02:34:57
Raplication user unable to create
piterden 2019-10-20 02:34:57
User creation
piterden 2019-10-20 02:34:57
piterden 2019-10-20 02:34:57
Hi friends having issue on percona
SSH 2019-10-20 05:45:19
Error: Java::JavaSql::SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Exception: Sequel::DatabaseConnectionError
Stack: com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:110)
SSH 2019-10-20 05:45:49
iam unbale to comnnect mysql in logstash pls help me
piterden 2019-10-20 05:47:20
It’s Java related issue
SSH 2019-10-20 05:52:35
what to do ??
SSH 2019-10-20 05:52:52
i want to update some java ??
SSH 2019-10-20 05:53:00
SSH 2019-10-20 05:55:29
how to change my mysql connection in localhost into ip…
SSH 2019-10-20 05:56:06
iam using Vmware ..my ubuntu is not set any ip address ..
piterden 2019-10-20 06:39:59
Look, it’s the group about MySQL. Don’t know why do you ask about java and why do you need wmware. I don’t know java and don’t use wmware, especially for MySQL.
2019-10-20 16:27:31
Does anyone have a database for Hospital that is templated or created by you?
2019-10-22 22:29:28
Can anyone help me in determining or estimating “size of each index”
2019-10-22 22:29:55
What should be query
MasterZiv 2019-10-22 22:30:23
2019-10-22 22:29:28
Can anyone help me in determining or estimating “size of each index”

Why do you need it?

2019-10-22 22:32:28
Am in DB clean-up task, to make some additional space. So need to delete, indexes using high space.
2019-10-22 22:32:51
We have a query to find that
2019-10-22 22:33:12
Pls share.
2019-10-22 22:33:12
It will be in information_schema.tables
2019-10-22 22:33:21
All the tables stats will be there
2019-10-22 22:33:33
Please check the columns over that table
2019-10-22 22:33:41
Thats for all indexes in a table.
2019-10-22 22:34:01
I want for all individual indexes.
2019-10-22 22:39:36
And also for to check last usage of each table.
2019-10-22 22:40:24
Check the update_time on tables stat
2019-10-22 22:40:40
And for index size
2019-10-22 22:40:50
We don’t have any raw data query
2019-10-22 22:41:04
There is one table called statistics
2019-10-22 22:41:23
There we can get the cardinality of particular index
2019-10-22 22:41:27
2019-10-22 22:41:52
If the cardinality is more the size of the index will be more
2019-10-22 22:41:55
2019-10-22 22:42:14
Respective of the datatypes it may vary
2019-10-22 22:42:27
But we can roughly calculate like this
2019-10-22 22:42:37
Nowhere is update_time
2019-10-22 22:43:16
Information_schema. Tables