Which one is the best tool to monitor mariadb database performance?

what is an alternative to php?

Another one language

Java, python, go, node, ruby, rust

And so on

What is it?

use of mysql

Your code uses mysql incorrect. And config will not solve your issue. Check and optimize yourcode

Hi team,

Which one is the best tool to monitor mariadb database performance?

The best is a tool which you liked more than other

I mean ,we have lot of tools in market l, my requirement mentioned below. As per requirement which one is the good., my specifications are need to monitor query time, data connection count, deadlock and read/write looks.

i think that prometheus would be a good tool for your needs

Is it open source or paid tool?

Can anyone explain self join

OS

Rhel 7

I meant it’s open source

Ok thanks my friend ☺️👍

This is not MySQL who eats a lot of CPU, but Web server.

Can any one tell me how to connect PHP and mysql in localhost

Use server on your pc – ex. openserver

already solved, I put cloudflare and now the whole site is loaded into cache

It is same way as the DB would be on a remote host, but replace host name with ‘localhost’ or ‘127.0.0.1’

If you still have problems, send us details.

OKay thanks

Hi im new to IT , Can you please share the tutorials for mysql from the scratch.

On dev.mySQL.com you can find a lot of tutorials, I suppose.

But to do it really from scratch, probably, it is better to read some findings books on relational DBMS, such as Kodd, or Ulman or similar.

Thankyou, if possible can you share any links.

Hi guys..Which public cloud you use gcp or AWS for any personal learning or testing?.
Actually I want to test xtradb cluster . Installing VMs in my personal laptop takes time and slows down my machine

For the first time I suppose sqlfiddle will be ok for you

I am facing an issue with a stored function in mysql db..

Its working fine with db A. But its not working in db B.. both A & B are similar one… what will be the issue?? Anybody plz help me

Where can I get SQL application???

Can anyone share in this grp? The setup as well as the exe?

Provide more details about your problem

What do you mean? Which SQL application?

Uhh

Iam asking u the app

I m using a function to find out one id’s ancestor ids which is in hierarchical level… it is working fine in some DBs.. but,ina a particular db its not working.. it got hanged..

Is data the same?

Yes

https://stackoverflow.com/questions/44127790/q-get-ancestors-with-a-node-in-mysql

The same issue

Are you getting some error message?

No… its just hanged…

As says in stackflow

Like this

SELECT id FROM table_name WHERE find_in_set(’45’, getAncestry(id))<>0;

This is the query i m using

I hv tried
SELECT getAncestry(’45’) FROM table_name;