Hi, is there any group for MYSQL Experts in English?

|
2019-10-22 22:43:27
In these table there will be a columj
2019-10-22 22:44:36
Got it.
2019-10-22 22:54:36
Any solution for individual index size
2019-10-22 22:54:59
There is no raw data
2019-10-22 22:56:31
By any way, can we calculate, quickly. Like no. Of pages used or any other way.
2019-10-22 23:15:49
Not sure
2019-10-22 23:16:12
If you get anything, please share ur knowledge
2019-10-22 23:16:30
Sure
iosuser1 2019-10-23 08:19:45
My
Mysql phpmyadmin is very slow
Can anyone help me to tune it?
svraju2020 2019-10-23 08:46:59
Master Yoda 2019-10-19 16:08:15
Perhaps optimize your long running queries, etc

Thank you.
Yes ,it was ibtmp1 I did restart to release space.

Dmacharla 2019-10-23 19:05:44
Hi guys am new to mysql need suggestions in performance tuning on inserting and selecting data
Dmacharla 2019-10-23 19:06:34
Installed db with default parameters
Dmacharla 2019-10-23 19:07:23
Currently load test is going on and we need to tune the system for better performance on select and inserting data
MasterZiv 2019-10-23 23:03:11
Dmacharla 2019-10-23 19:05:44
Hi guys am new to mysql need suggestions in performance tuning on inserting and selecting data

Use SSD for DB files!

Dmacharla 2019-10-25 21:05:17
Yes we are using ssd but still wait/io/tables value is high while select statement
MasterZiv 2019-10-25 21:45:51
Dmacharla 2019-10-25 21:05:17
Yes we are using ssd but still wait/io/tables value is high while select statement

View plans, create indices!

Dmacharla 2019-10-25 22:20:16
After checking explain plan we saw that its using primary index
Dmacharla 2019-10-25 22:20:25
So we created normal index
Dmacharla 2019-10-25 22:20:34
But still its taking time
MasterZiv 2019-10-26 00:07:42
Dmacharla 2019-10-25 22:20:34
But still its taking time

Every thing takes time…

piterden 2019-10-26 01:18:16
9 women in a month will not give birth to a baby
SSH 2019-10-26 16:30:49
Hello guy’s… I am getting error on MySQL …In date field “00 00 0000” all are coming zero while importing CSV file .. my date format is DDMMYYYY HH:MM:SS..????
SSH 2019-10-26 16:32:03
I can’t change date format .. IAM getting bulk data from other source . Pls tell me how to solve
Asif9601 2019-10-26 18:22:06
SQL
MasterZiv 2019-10-27 00:43:26
SSH 2019-10-26 16:32:03
I can’t change date format .. IAM getting bulk data from other source . Pls tell me how to solve

What to solve?
It is error in data, so find it and prevent

sivarishi 2019-10-31 14:05:37
Hi all,
sivarishi 2019-10-31 14:06:14
How to take full backup and incremental backup database in Innodb cluster setup
MasterZiv 2019-10-31 14:21:16
sivarishi 2019-10-31 14:06:14
How to take full backup and incremental backup database in Innodb cluster setup

mysqldump — for full

MasterZiv 2019-10-31 14:21:40
sivarishi 2019-10-31 14:06:14
How to take full backup and incremental backup database in Innodb cluster setup

what do you mean by “incremental backup”?

sivarishi 2019-10-31 14:23:03
MasterZiv 2019-10-31 14:21:16
mysqldump — for full

Then we need to take cluster meta data backup also everyday

sivarishi 2019-10-31 14:24:11
MasterZiv 2019-10-31 14:21:40
what do you mean by “incremental backup”?

For example if we took full backup on Sunday then from monday to Saturday will be incremental backup

MasterZiv 2019-10-31 14:41:34
sivarishi 2019-10-31 14:24:11
For example if we took full backup on Sunday then from monday to Saturday will be incremental backup

Afaik there is no such possibility

2019-10-31 19:46:10
Anybody knows meaning of
“Sliding window copy” method.
What it is?
piterden 2019-10-31 20:47:17
https://www.dataapplab.com/event/knowledge-about-two-pointers-and-sliding-window-2/

Live Webinar: Knowledge about Two Pointers & Sliding Window Copy – Data Application LabData Application Lab
从2019年4月13日起,数据应用学院为大家准备了计算机技术求职,神奇的技术面试系列,通过八节课的时间,我们带大家深入浅出搞懂算法&数据结构要怎么搞定!
piterden 2019-10-31 20:49:33
https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3012590/

Acquired genomic copy number aberrations and survival in adult acute myelogenous leukemiaPubMed Central (PMC)
Genomic aberrations are of predominant importance to the biology and clinical outcome of patients with acute myelogenous leukemia (AML), and conventional karyotype-based risk classifications are routinely used in clinical decision making in AML. One of …
2019-10-31 21:27:38
piterden 2019-10-31 20:47:17
https://www.dataapplab.com/event/knowledge-about-two-pointers-and-sliding-window-2/

That was live event. Any recording available of the event

sivarishi 2019-11-08 16:08:40
Hi team
sivarishi 2019-11-08 16:09:13
I changed port no in my.cnf file in MySQL 8.0.17 version
sivarishi 2019-11-08 16:09:27
But it will not change port no
sivarishi 2019-11-08 16:09:44
Also mysql running without my.cnf file
sivarishi 2019-11-08 16:09:54
How it is running
Asif9601 2019-11-08 16:10:44
Any ETL tester ??
Asif9601 2019-11-08 16:10:56
Or any known group for that
pani123456 2019-11-10 21:06:41
Hi, is there any group for MYSQL Experts in English ? Please let me know. Thank you.
smlkw 2019-11-10 21:08:03
pani123456 2019-11-10 21:06:41
Hi, is there any group for MYSQL Experts in English ? Please let me know. Thank you.

You’re already in such a group.

2019-11-10 21:19:03
Hii i have a problem in my db actually i have pulled data from data base into dropdown list from one table and i want to display the selected value into data base
MasterZiv 2019-11-10 21:20:22
pani123456 2019-11-10 21:06:41
Hi, is there any group for MYSQL Experts in English ? Please let me know. Thank you.

This group, no?

MasterZiv 2019-11-10 21:23:04
2019-11-10 21:19:03
Hii i have a problem in my db actually i have pulled data from data base into dropdown list from one table and i want to display the selected value into data base

And what is the problem?

2019-11-10 21:25:22
Data selected by users which is pulled by data base in dropdown list is not displaying in table
MasterZiv 2019-11-11 06:55:19
2019-11-10 21:25:22
Data selected by users which is pulled by data base in dropdown list is not displaying in table

This is not a database problem, this is problem of the database client application, the problem is not related to MySQL.

|