I want to update some java?

:+1:

How do you think I can help you?

Do you think I’m a telepath?

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

Hi i am new to mysql
Can i get some suggestions on learning mysql like in websites or YouTube sites

Codewithmosh sql tutorials

You can start from this
https://www.w3schools.com/SQL/

You mean ibtmp1 file?

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

Ok so it was without restart. Not possible

Perhaps optimize your long running queries, etc

Raplication user unable to create

User creation

Cluster

Hi friends having issue on percona

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)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:97)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:89)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:63)
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(com/mysql/cj/jdbc/exceptions/SQLError.java:73)
com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(com/mysql/cj/jdbc/ConnectionImpl.java:906)
com.mysql.cj.jdbc.ConnectionImpl.createNewIO(com/mysql/cj/jdbc/ConnectionImpl.java:831)
com.mysql.cj.jdbc.ConnectionImpl.<init>(com/mysql/cj/jdbc/ConnectionImpl.java:456)
com.mysql.cj.jdbc.ConnectionImpl.getInstance(com/mysql/cj/jdbc/ConnectionImpl.java:246)
com.mysql.cj.jdbc.NonRegisteringDriver.connect(com/mysql/cj/jdbc/NonRegisteringDriver.java:199)
java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498)
org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:470)
org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:328)
usr.share.logstash.vendor.bundle.jruby.$2_dot_5_dot_0.gems.sequel_minus_5_dot_23_dot_0.lib.sequel.adapters.jdbc.connect(/usr/share/logstash/vendor/bundle/jruby/2.5.0/gems/sequel-5.23.0/lib/sequel/adapters/jdbc.rb:221)

iam unbale to comnnect mysql in logstash pls help me

It’s Java related issue

what to do ??

i want to update some java ??

funcation

how to change my mysql connection in localhost into ip…

iam using Vmware ..my ubuntu is not set any ip address ..

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.

Hi
Does anyone have a database for Hospital that is templated or created by you?

Can anyone help me in determining or estimating “size of each index”
??

What should be query

Why do you need it?

Am in DB clean-up task, to make some additional space. So need to delete, indexes using high space.

We have a query to find that

Pls share.

It will be in information_schema.tables

All the tables stats will be there

Please check the columns over that table

Thats for all indexes in a table.

I want for all individual indexes.

And also for to check last usage of each table.

Check the update_time on tables stat

And for index size

We don’t have any raw data query

There is one table called statistics

There we can get the cardinality of particular index

So

If the cardinality is more the size of the index will be more

Logically

Respective of the datatypes it may vary

But we can roughly calculate like this

Nowhere is update_time

Information_schema. Tables