What would been faster, watch a movie using stream or download it directly?

|
MasterZiv 2020-04-29 11:30:04
kutasior 2020-04-29 11:23:05
how to fix this problem ??

You must check if this collation is among supported on your ver. of MySQL

MasterZiv 2020-04-29 11:31:04
Details are here https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html
kutasior 2020-04-29 12:56:21
how to update mysql in phpmyadmin?
MasterZiv 2020-04-29 13:51:38
kutasior 2020-04-29 12:56:21
how to update mysql in phpmyadmin?

Tell us more, what do you mean by “update”?

iosuser1 2020-04-29 16:31:11
Unable to connect to any of the specified MySQL hosts
iosuser1 2020-04-29 16:31:36
can you help me to resolve this issues
iosuser1 2020-04-29 16:33:27
even though host % is allowed in phpmyadmin
iosuser1 2020-04-29 16:40:14
????????????
Manejandodatos 2020-04-29 17:06:28
Is anyone using MySQL 8.0.x ? How can i create a connectionstring for connecting from ASP classic?
kutasior 2020-04-29 17:20:17
MasterZiv 2020-04-29 13:51:38
Tell us more, what do you mean by “update”?

update mysql from 5.7 to 8.0

kutasior 2020-04-29 17:20:39
I only have access to phpmyadnin and cpanel
kutasior 2020-04-29 17:21:06
There is no option to update mysql in cpanel
MasterZiv 2020-04-29 17:22:05
kutasior 2020-04-29 17:20:17
update mysql from 5.7 to 8.0

this is not a task for phpmyadmin.
this is done by means of other tools.
Package managers or installers.

MasterZiv 2020-04-29 17:22:30
kutasior 2020-04-29 17:21:06
There is no option to update mysql in cpanel

then you just cannot upgrade this host

soysau 2020-05-03 20:09:59
One question. What is faster.
1. Dump mysql to a .sql file and then send it to the other host and the import it.
2. Dump mysql and pipe it directly to the other host.
soysau 2020-05-03 20:10:06
I think it will be the second one right?
piterden 2020-05-03 20:10:40
There is nothing faster
piterden 2020-05-03 20:14:19
What would been faster, watch a movie using stream or download it directly?
piterden 2020-05-03 20:16:05
And what would it been if you don’t have Internet?
MasterZiv 2020-05-04 10:51:02
soysau 2020-05-03 20:09:59
One question. What is faster.
1. Dump mysql to a .sql file and then send it to the other host and the import it.
2. Dump mysql and pipe it directly to the other host.

Piping is always faster, because you save too much IO .

Master Yoda 2020-05-04 20:16:55
MasterZiv 2020-05-04 10:51:02
Piping is always faster, because you save too much IO .

But it could saturate the network?

MasterZiv 2020-05-04 20:59:44
Master Yoda 2020-05-04 20:16:55
But it could saturate the network?

Ehm… You gonna pass the data over the network anyway, are you?

MasterZiv 2020-05-04 21:01:52
Master Yoda 2020-05-04 20:16:55
But it could saturate the network?

Yes, this will definitely lead to some Network io, some significant load of it, but I thought it it’s unavoidable.

MasterZiv 2020-05-04 21:03:18
Master Yoda 2020-05-04 20:16:55
But it could saturate the network?

You can carry your data on an flash drive, but you will not be able to organize a pipe from the data then.

smlkw 2020-05-04 22:33:38
thx
Master Yoda 2020-05-06 17:43:56
MasterZiv 2020-05-04 21:03:18
You can carry your data on an flash drive, but you will not be able to organize a pipe from the data then.

Maybe you are right😁

Gnation88 2020-05-07 12:23:25
Any alternative to backup backup large data. Apart from mysqldump
Gnation88 2020-05-07 12:23:41
3 TB
Master Yoda 2020-05-08 08:28:22
Gnation88 2020-05-07 12:23:25
Any alternative to backup backup large data. Apart from mysqldump

Xtrabackup

AleHerz 2020-05-08 18:29:40
mysql_en-2865.jpg
UPDATE lock rows and other queries go into timeout because they’re not unlocked, how can I fix it? I’m using only SELECT/UPDATE/INSERT/DELETE, not LOCK
Thanks!
Master Yoda 2020-05-08 18:42:58
Are you using transactions?
Master Yoda 2020-05-08 18:43:33
With exclusive locks? Like ‘for update’
Master Yoda 2020-05-08 18:44:14
AleHerz 2020-05-08 18:29:40
UPDATE lock rows and other queries go into timeout because they’re not unlocked, how can I fix it? I’m using only SELECT/UPDATE/INSERT/DELETE, not LOCK
Thanks!

Show full PROCESSLIST can be helpful. Which other queries on same table is running

AleHerz 2020-05-08 18:51:59
Master Yoda 2020-05-08 18:44:14
Show full PROCESSLIST can be helpful. Which other queries on same table is running

mysql_en-2869.jpg
i’m using mariadb and a connection pool

Master Yoda 2020-05-08 18:55:58
Are you sure no other queries for the sams table is running?
Master Yoda 2020-05-08 18:56:03
Only that update one is?
AleHerz 2020-05-08 18:59:20
Master Yoda 2020-05-08 18:55:58
Are you sure no other queries for the sams table is running?

the script do this

conn = get_conn_from_pool()
SELECT * FROM users WHERE id=%s LIMIT 1
UPDATE users SET in_group=%(in_group)s, username=%(username)s WHERE id=%(user_id)s
conn.commit()
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT t_u.* FROM users u INNER JOIN twitch_users t_u ON u.twitch_id = t_u.twitch_id WHERE u.id=%s LIMIT 1
UPDATE users SET in_group=%s WHERE id=%s
conn.commit()
SELECT * FROM users WHERE id=%s LIMIT 1
SELECT * FROM users WHERE id=%s LIMIT 1
conn.close()
….
conn = get_conn_from_pool()
UPDATE users SET in_group=%(in_group)s, username=%(username)s WHERE id=%(user_id)s
TIMEOUT

ID is everytime the same in this case and with every query I open and close a cursor

Master Yoda 2020-05-08 19:06:15
Run this query to get list of locker tables
Master Yoda 2020-05-08 19:06:18
show open tables WHERE In_use > 0
AleHerz 2020-05-08 21:16:11
Master Yoda 2020-05-08 19:06:15
Run this query to get list of locker tables

Before or after the query that generates the timeout?

Master Yoda 2020-05-08 21:16:35
AleHerz 2020-05-08 21:16:11
Before or after the query that generates the timeout?

Before

Master Yoda 2020-05-08 21:16:41
After both
AleHerz 2020-05-08 21:24:53
Master Yoda 2020-05-08 21:16:41
After both

Before the query in_use == 0, after query execution in_use == 1, after timeout in_use == 1

Master Yoda 2020-05-08 21:27:23
Do one thing
Master Yoda 2020-05-08 21:27:35
Try flush table tablename
Master Yoda 2020-05-08 21:27:40
And run the query
AleHerz 2020-05-08 21:44:10
Master Yoda 2020-05-08 21:27:35
Try flush table tablename

i try FLUSH TABLE users;

the query goes in timeout

Master Yoda 2020-05-08 21:46:18
AleHerz 2020-05-08 21:44:10
i try FLUSH TABLE users;

the query goes in timeout

I can’t say without looking at several things. Maybe increase timeout limit for now?

AleHerz 2020-05-08 22:02:23
Master Yoda 2020-05-08 21:46:18
I can’t say without looking at several things. Maybe increase timeout limit for now?

Okay, thanks anyway! I think it’s a dedlock problem, but it’s weird.

Gnation88 2020-05-08 23:02:46
Master Yoda 2020-05-08 08:28:22
Xtrabackup

Thanks, any other suggestions

|