Can anyone advice the tools to go for performance auditing?

|
madno 2021-08-07 21:05:22
svart 2021-08-07 21:00:41
It might sounds surprisingly, but gap locks used to lock a gap between two index values

Then how does READ COMMITTED avoids gap lock on index

svart 2021-08-07 21:22:05
Why do you think it avoids them? I’d suggest you to read again docs to refresh your knowledge
madno 2021-08-07 21:32:45
svart 2021-08-07 21:22:05
Why do you think it avoids them? I’d suggest you to read again docs to refresh your knowledge

Thanks , I’ll go through the docs

abc 2021-08-13 01:39:00
io io
abc 2021-08-13 01:39:07
oi oi 🙂
abc 2021-08-13 01:39:14
got a question
abc 2021-08-13 01:40:06
can anyone advice the tools to go for performance auditing ?
piterden 2021-08-13 01:44:06
abc 2021-08-13 01:40:06
can anyone advice the tools to go for performance auditing ?

Queries

abc 2021-08-13 01:44:50
queries of what ?
piterden 2021-08-13 01:45:07
Of data you need
abc 2021-08-13 01:45:47
hah, what data would be helpful for performance analysis ?
piterden 2021-08-13 01:46:22
abc 2021-08-13 01:45:47
hah, what data would be helpful for performance analysis ?

That’s you tell me

svart 2021-08-13 09:59:35
abc 2021-08-13 01:40:06
can anyone advice the tools to go for performance auditing ?

The best tool is your brains (as always). For the queries analysis you can use pt-query-digest. To find performance bottlenecks on os, instance levels you can use any monitoring tool

abc 2021-08-13 10:01:39
instance level is needed. docs says there is some performance schema which collects some useful data. Is it the way to go ?
svart 2021-08-13 16:54:23
Yes
Noname Dba 2021-08-13 18:19:32
Hi everyone

There are question about MySQL

Fatal error: cannot allocate memory for the buffer pool (32Gb in configuration)

Why? Who knows reasons and solution?

piterden 2021-08-13 18:22:26
Noname Dba 2021-08-13 18:19:32
Hi everyone

There are question about MySQL

Fatal error: cannot allocate memory for the buffer pool (32Gb in configuration)

Why? Who knows reasons and solution?

No one except you

Deb_575 2021-08-13 18:30:13
Noname Dba 2021-08-13 18:19:32
Hi everyone

There are question about MySQL

Fatal error: cannot allocate memory for the buffer pool (32Gb in configuration)

Why? Who knows reasons and solution?

Maybe because your buffer pool size is much bigger than the rmemory on the server

Njabu Coder 2021-08-13 19:33:37
MySQL
Pmat_apparel 2021-08-15 07:14:27
Hi everyone I’m an infant to My SQL software
Pmat_apparel 2021-08-15 07:18:01
Tried running a script, but I keep receiving a message that ” Error code 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server”. What does that mean?
piterden 2021-08-15 07:18:33
Pmat_apparel 2021-08-15 07:18:01
Tried running a script, but I keep receiving a message that ” Error code 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server”. What does that mean?

It means you have error in MySQL syntax

Pmat_apparel 2021-08-15 07:18:46
mysql_en-12017.jpg

piterden 2021-08-15 07:19:17
Pmat_apparel 2021-08-15 07:18:46

Post text

Pmat_apparel 2021-08-15 07:19:23
piterden 2021-08-15 07:18:33
It means you have error in MySQL syntax

Please how I solve this?

Pmat_apparel 2021-08-15 07:20:01
piterden 2021-08-15 07:19:17
Post text

That’s actually I’m working on…

piterden 2021-08-15 07:20:02
You need to write it correct
piterden 2021-08-15 07:20:44
I can’t guess what is displayed there.
piterden 2021-08-15 07:20:49
Post text
MasterZiv 2021-08-15 07:39:56
Pmat_apparel 2021-08-15 07:19:23
Please how I solve this?

There should not be comma after the table name

Liran 2021-08-15 10:33:51
how can I get Query Cache Hit Rate?
piterden 2021-08-15 10:34:17
Liran 2021-08-15 10:33:51
how can I get Query Cache Hit Rate?

What is it?

Liran 2021-08-15 10:35:11
piterden 2021-08-15 10:34:17
What is it?

i need a query to calculate this : Qcache_hits / (QCache_hits + Com_select)

Liran 2021-08-15 10:35:21
this will give the cache rate
Ishu Gupta 2021-08-15 11:02:11
Hi all I want to do oracle certification in Mysql DBA
|