Perform CRUD TO WHAT?

Hii I m newbie I want to use MySql with Node Js I shall use community server or workbench

Like what’s the difference

And which will be better

Workbench is the gui for managing MySQL databases

So will I be able to perform CRUD to it

Yes

A great help to learn

Can you explain your question?

Perform CRUD TO WHAT?

I mean create tables edit tables delete…but I got clear now

This chat is not for job search.

But for loose your job )))

Pls msg as per group.
“Ads/Vacancies aren’t allowed.” is mentioned in group description. Do follow that.
On should not put irrelevant posts and irritate others (.)

How can we find reasons for replication lag and read replica lag?

Your help is very much appreciated

https://thoughts.t37.net/fixing-a-very-lagging-mysql-replication-db6eb5a6e15d

Check out this site for news and articles about mysql and other topics. Newsfeedxtra.com has worldwide coverage with over 30 million sources

Spammers ))

Not spam.

mysql transactions go through many wait_events like wait/io/table/sql/handler, wait/io/file/innodb/innodb_log_fileany many other. My question is there any link or book or any other resource where its meaning/details can be found?
I have searched the dev.mysql.com but did not found any thing relevant.

Any help ????

This is helpful thank you so much

wait/synch/sxlock/innodb/btr_search_latch
can anybody tell what it means?

Ask full , detailed, questions, please.

am getting wait_event “wait/synch/sxlock/innodb/btr_search_latch” in logs & query result, but don’t know what does that mean. So looking for some help.

You’d better solve some more practical problems, understanding this doesn’t move you very far on the way to solve the whole query performance problem

a query completes in 2 hrs daily, but today its been 4 hrs, but nt completed yet. on looking further into the system, found it having “wait/synch/sxlock/innodb/btr_search_latch”. so trying to understand it what it means and where it could be originating.

So look at the query plan, used indices, create some index if the query lacks some.

query doesn’t lack any index, as usually it completes in 2 hrs. Its a big reporting query.

2h query can’t be optimal….
I don’t believe in it

its a procedure, so a group of queries, not a single query.

Check out articles and news on newsfeedxtra.com

@Samxtu
this is knowledge sharing group, not for publicity.

Is there any difference between where isNull(attribute) and
Where attribute is null?

Of course. That’s why they are two not one thing

The ISNULL will return 1 where the argument is NULL and 0 if not.

SELECT ISNULL(NULL) will return 1

SELECT ISNULL(16) will return 0

Whereas SELECT * FROM tbl WHERE phone_number IS NULL ….will return records where phone_number is NULL. Similarly ‘IS NOT NULL’ in WHERE Clause will return records that don’t have NULL values in column phone_number

This is a function

Actually there is no difference except the fact that IS NULL is a comparison operation but ISNULL() is a built in function.

I personally didn’t even know about ISNULL function, I don’t know why , for what purpose, it was created.

I suppose it is completely useless as you always have CASE expressions.

Ohh okay got it now thanks

Even a IF function exists 🙂

Yes, that is what I know well…

need to check history of monitor for IO CPU in os, thread_running ,sql running in mysql and innodb rows for read, insert, update,delete and show engine innodb status for redo log changing, latch and rw_lock, compare the different between today and before

If this mysql is not a master and can be crashed, when the latch is appear, the command pstack $mysqld_pid can trace all thread stack in mysqld, which is a way to find what’s happening in mysqld and which thread are block your thread. Basing on trace log, you can read and change the mysql server source code to fix the problems

Will compare and check differences.
I didn’t got the part “”can be crashed “”

pstack is a dangerous gdb command
. It will cause mysqld crash or hung. It is last way to find the problem. Pstack can be unsafe for production due missed signals & interrupts if you get unlucky.