How are you trying to connect to mysql server?

|
Kirubiel 2019-09-09 13:41:20
finally an english version
smlkw 2019-09-09 13:42:46
Yup
smlkw 2019-09-09 16:49:18
do you have any questions realted to MySQL?
2019-09-09 17:52:58
Yes,
Regarding InnoDB: page cleaner values.
2019-09-09 17:54:53
How to calculate optimum value for a server which keeps showing warning as “settings might not be optimal”.
2019-09-09 17:55:39
Can any one help me out by throwing some light.
2019-09-09 17:59:08
Another log/error
1000ms intened loop took 6953ms.
How to rectify it.
piterden 2019-09-09 22:38:20
I propose to make a group stickerpack
smlkw 2019-09-09 22:38:35
Help that guy first 😊
piterden 2019-09-09 22:39:09
I don’t understand what he want
smlkw 2019-09-09 22:44:39
2019-09-09 17:59:08
Another log/error
1000ms intened loop took 6953ms.
How to rectify it.

Please, clarify your needs more detailed

2019-09-09 22:48:27
In the error log file of server, getting warning many times saying ” Innodb: page_cleaner : 1000ms intened loop took 6953ms. Settings might not be optimal.”
How to rectify it. How to get optimum settings value.
2019-09-09 22:49:22
Value of 6953 keeps changing but remains more than 5000.
MasterZiv 2019-09-10 01:03:24
2019-09-09 17:52:58
Yes,
Regarding InnoDB: page cleaner values.

I think there must be one cleaner per buffer pool slice or what ever it called

2019-09-10 01:06:55
I have 4 cleaner & 8 buffer pool and that’s recommend by MySql RDS
MasterZiv 2019-09-10 01:07:38
2019-09-09 22:48:27
In the error log file of server, getting warning many times saying ” Innodb: page_cleaner : 1000ms intened loop took 6953ms. Settings might not be optimal.”
How to rectify it. How to get optimum settings value.

Ah, this one…
I think this must be saying that dirty pages cleaning takes too much time, that is , there is to many dirty pages and maybe to little buffer pool slices.

But im not sure this is only a guess

MasterZiv 2019-09-10 01:08:43
2019-09-10 01:06:55
I have 4 cleaner & 8 buffer pool and that’s recommend by MySql RDS

Did you read that article at Percona site?

2019-09-10 01:09:06
Which article
2019-09-10 01:09:40
I have gone through RDS documents only.
MasterZiv 2019-09-10 01:12:15
Mo
2019-09-10 01:12:17
Will read up that article also.
2019-09-10 01:13:17
Oops, the link is gone. Can you post it again
MasterZiv 2019-09-10 01:15:43
2019-09-10 01:13:17
Oops, the link is gone. Can you post it again

It was a wrong one

MasterZiv 2019-09-10 01:16:14
2019-09-10 01:13:17
Oops, the link is gone. Can you post it again

This is an article explaining the situation.

https://stackoverflow.com/q/41134785

How to solve mysql warning: “InnoDB: page_cleaner: 1000ms intended loop took XXX ms. The settings might not be optimal “?Stack Overflow
I ran a mysql import mysql dummyctrad < dumpfile.sql on server and its taking too long to complete. The dump file is about 5G. The server is a Centos 6, memory=16G and 8core processors, mysql v …
smlkw 2019-09-10 01:17:21
MasterZiv 2019-09-10 01:16:14
This is an article explaining the situation.

https://stackoverflow.com/q/41134785

Are you building a house? 😁

2019-09-10 01:17:55
Nopes
MasterZiv 2019-09-10 01:17:58
2019-09-10 01:13:17
Oops, the link is gone. Can you post it again

About one I saw on Percona site, will send you tomorrow

MasterZiv 2019-09-10 01:18:10
smlkw 2019-09-10 01:17:21
Are you building a house? 😁

Kinda

2019-09-10 01:18:55
MasterZiv 2019-09-10 01:17:58
About one I saw on Percona site, will send you tomorrow

Ok

2019-09-10 01:20:17
In the meantime, will go through other docs.
MasterZiv 2019-09-10 01:21:39
MasterZiv 2019-09-10 01:16:14
This is an article explaining the situation.

https://stackoverflow.com/q/41134785

This so article explains a lot, so read it

MasterZiv 2019-09-10 01:21:56
2019-09-10 01:20:17
In the meantime, will go through other docs.

4

MasterZiv 2019-09-10 09:50:06
Hi guys how to install MySQL in ubuntu PC … and how to like with docker …please guide me ..
MasterZiv 2019-09-10 09:50:58
MasterZiv 2019-09-10 09:50:06
Hi guys how to install MySQL in ubuntu PC … and how to like with docker …please guide me ..

It can be installed from g Ubuntu repository, from packages.

Man apt

MasterZiv 2019-09-10 09:51:21
MasterZiv 2019-09-10 09:50:06
Hi guys how to install MySQL in ubuntu PC … and how to like with docker …please guide me ..

apt install mysqld

MasterZiv 2019-09-10 09:51:36
Or mysql-server
MasterZiv 2019-09-10 09:51:43
Don’t remember
MasterZiv 2019-09-11 09:22:30
This is not MySQL problem.
SSH 2019-09-11 17:27:44
Hi i download and install MySQL ver 8 on window 10 PC … installation successful..after I to create instance, database, table ?
SSH 2019-09-11 17:28:39
I open MySQL tray to connect MySQL broswer …
SSH 2019-09-11 17:28:59
IAM getting mysql error 1251
kiril_d1 2019-09-11 18:11:25
How are you trying to connect to mysql server? Do you have the same client and server versions?
kiril_d1 2019-09-11 18:17:39
https://dev.mysql.com/doc/refman/8.0/en/windows-postinstallation.html
MasterZiv 2019-09-11 18:56:55
SSH 2019-09-11 17:27:44
Hi i download and install MySQL ver 8 on window 10 PC … installation successful..after I to create instance, database, table ?

Not instance, it is created normally during install.

But databases, tables — yes

MasterZiv 2019-09-12 11:01:03
pankaj pathak:
Thanks much Ramesh

Hi all
Waiting for table flush in the process list, during restore
Restore seems stuck
Inputs please

It’s 2.1 tb db restore

2019-09-12 11:06:57
MasterZiv 2019-09-12 11:01:03
pankaj pathak:
Thanks much Ramesh

Hi all
Waiting for table flush in the process list, during restore
Restore seems stuck
Inputs please

It’s 2.1 tb db restore

Can someone please help me on this

smlkw 2019-09-12 11:07:46
2019-09-12 11:06:57
Can someone please help me on this

Your question isn’t informative. Explain your problem more precisely.

2019-09-12 11:11:09
smlkw 2019-09-12 11:07:46
Your question isn’t informative. Explain your problem more precisely.

Ok,

I’m restoring the backup on a slave

And db size is ~2 TB, after almost 1.6 TB of data has been restored, I’m getting

Waiting for flush table

Message in show process list output

And restore process seems stuck at certain insert statement

2019-09-12 11:12:07
Just time column of show process list output is gets increasing
MasterZiv 2019-09-12 11:12:56
2019-09-12 11:12:07
Just time column of show process list output is gets increasing

For how long does it wait?

|