You mean i need to download the the one at the bottom?

|
MasterZiv 2021-07-27 22:03:11
Deb_575 2021-07-27 21:50:27
Error in what sense? The command is working fine it’s just that the output is not being logged to the specified log file.
Something with redirecting the output it seesms

An error on the pircona Web page

svart 2021-07-28 01:07:07
Deb_575 2021-07-27 17:57:37
Can someone tell me how to redirect the output of a line of commands to a log file. I am doing this but the log file generated is not capturing anything instead the output is being displayed on the screen only.

./Xtrabackup –backup –databases=db1 –stream=tar | gzip -> /backupmountpoint/db1_bkp.tar.gz 2> /backupmountpoint/db1bkplog.txt

It’s is creating the backup gz file but it’s not logging the process in the log file.

This is for MySQL database backup job.

the problem here is that you redirect stderr of gzip which would be empty. you need to move “2>/path/to/file” to xtrabackup call, i.e. “xtraback ….. 2>log | gzip > file”. in addition to that I’d highly recommend to add “–parallel=N” option to speed up backup procedure. please consider reading xtrabackup manual. you can find there more options to use. plus instead of gzip you can use pigz to speed up compressing

Deb_575 2021-07-28 07:01:49
svart 2021-07-28 01:07:07
the problem here is that you redirect stderr of gzip which would be empty. you need to move “2>/path/to/file” to xtrabackup call, i.e. “xtraback ….. 2>log | gzip > file”. in addition to that I’d highly recommend to add “–parallel=N” option to speed up backup procedure. please consider reading xtrabackup manual. you can find there more options to use. plus instead of gzip you can use pigz to speed up compressing

I am having no issues with the backup
I have also tested the backup by restoring it and it is just fine.
My problem is I am not able to redirect the xtrabackup activity log to a log file it is being displayed on the command line only.
It’s not a xtrabackup thing I believe just linux thing.
Basically when I run the xtrabackup command it proceedes and display the output like
{ MySQL server identified
Connecting to data dir
Copying db1.table1
Streaming db1.table1} this output I need in a log file

svart 2021-07-28 08:15:33
Deb_575 2021-07-28 07:01:49
I am having no issues with the backup
I have also tested the backup by restoring it and it is just fine.
My problem is I am not able to redirect the xtrabackup activity log to a log file it is being displayed on the command line only.
It’s not a xtrabackup thing I believe just linux thing.
Basically when I run the xtrabackup command it proceedes and display the output like
{ MySQL server identified
Connecting to data dir
Copying db1.table1
Streaming db1.table1} this output I need in a log file

Seriously? Just tried what I proposed

Deb_575 2021-07-28 10:01:41
svart 2021-07-28 08:15:33
Seriously? Just tried what I proposed

Thanks a lot I made that change and it worked

Wenzell 2021-07-29 11:28:19
When installing MySql i get an error on Writing Configuration file. Error log is: Invalid server template. How to resolve this problem?
MasterZiv 2021-07-29 11:28:43
Wenzell 2021-07-29 11:28:19
When installing MySql i get an error on Writing Configuration file. Error log is: Invalid server template. How to resolve this problem?

use SUDO

Wenzell 2021-07-29 11:30:03
@MasterZiv what is SUDO? . Im using windows 10
MasterZiv 2021-07-29 11:32:14
Wenzell 2021-07-29 11:30:03
@MasterZiv what is SUDO? . Im using windows 10

Then install under an administrator account.

N K 2021-07-29 18:58:48
Hi, need assistance for mysql.can see few queries are taking more time run by system user in DB.
N K 2021-07-29 19:00:08
And queries stat says “wait for an event from coordinator”
N K 2021-07-29 19:00:34
Can anyone give idea if there is any issue with db
Wenzell 2021-07-29 21:09:55
MasterZiv 2021-07-29 11:32:14
Then install under an administrator account.

MySql installer doesnt give me the option to run as administrator

Wenzell 2021-07-29 22:21:15
mysql_en-11632.jpg

Wenzell 2021-07-29 22:21:15
mysql_en-11631.jpg
Any good samaritan that can help me get through this intallation fail. I have searched all over and i cannot get a solutio.
Deb_575 2021-07-29 22:24:02
is this a web installer ?
try the community installer
Wenzell 2021-07-29 22:33:07
Deb_575 2021-07-29 22:24:02
is this a web installer ?
try the community installer

mysql_en-11634.jpg
I downloaded the first(web) installer. You mean i need to download the the one at the bottom? They are both Community installers

Deb_575 2021-07-29 22:45:11
Yeah use the 2nd one
Wenzell 2021-07-29 22:45:36
Deb_575 2021-07-29 22:45:11
Yeah use the 2nd one

Thanks i will try

Deb_575 2021-07-29 22:46:07
Let us know if it works
That might come handy for others
Wenzell 2021-07-29 22:46:57
Deb_575 2021-07-29 22:46:07
Let us know if it works
That might come handy for others

Will do. Its very frustrating

MasterZiv 2021-07-29 23:10:58
Wenzell 2021-07-29 21:09:55
MySql installer doesnt give me the option to run as administrator

You must START it as an administrator.

MasterZiv 2021-07-29 23:12:15
Wenzell 2021-07-29 22:21:15
Any good samaritan that can help me get through this intallation fail. I have searched all over and i cannot get a solutio.

there are detailed step by step instructions on the MySQL site

read and install.

https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Wenzell 2021-07-30 05:59:48
MasterZiv 2021-07-29 23:12:15
there are detailed step by step instructions on the MySQL site

read and install.

https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

Seems the installation does not create the ‘my-template.ini’ file, hence it throws an error 😞

Wenzell 2021-07-30 06:06:05
MasterZiv 2021-07-29 23:12:15
there are detailed step by step instructions on the MySQL site

read and install.

https://dev.mysql.com/doc/refman/8.0/en/windows-installation.html

mysql_en-11648.jpg
This is the problem. How can i solve this?

MasterZiv 2021-07-30 08:54:05
Wenzell 2021-07-30 05:59:48
Seems the installation does not create the ‘my-template.ini’ file, hence it throws an error 😞

Report this to MySQL support

Yoga2369 2021-07-30 16:13:24
Any blog that can help me with the root password reset of MySQL 5.3 ?

I could see different procedures and for different versions on the internet.

Yoga2369 2021-07-30 16:13:44
Running on Unix platform
Deb_575 2021-07-30 16:44:44
There is no mysql 5.3

https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

ruydar 2021-07-31 19:53:09
MySQL Compatibility which os ?
Ishu Gupta 2021-08-01 06:13:52
I have one table in which daily 3millions record inserted on daily basis and I only keep one day data real-time data in it but when I fired select query on it it is taking around 30 minutes in execution created composite key on all columns which I am using in where clause. any one can help me how to improve efficiency of that query
Vinay_Vinay 2021-08-01 08:09:44
Ishu Gupta 2021-08-01 06:13:52
I have one table in which daily 3millions record inserted on daily basis and I only keep one day data real-time data in it but when I fired select query on it it is taking around 30 minutes in execution created composite key on all columns which I am using in where clause. any one can help me how to improve efficiency of that query

How is the index on those where clause columns?

Ishu Gupta 2021-08-01 08:13:05
Vinay_Vinay 2021-08-01 08:09:44
How is the index on those where clause columns?

Created composite index in the same order in which write those Columns in the query after where clause

Ishu Gupta 2021-08-01 08:22:37
Any WhatsApp group of Mysql DBA/ Developer please add me if have any
MasterZiv 2021-08-02 08:26:55
Ishu Gupta 2021-08-01 06:13:52
I have one table in which daily 3millions record inserted on daily basis and I only keep one day data real-time data in it but when I fired select query on it it is taking around 30 minutes in execution created composite key on all columns which I am using in where clause. any one can help me how to improve efficiency of that query

If you want help on a query, send:
DDL of tables
The query
Possibly query plan

As this can be a big text, send via pastebin.com or similar service.

|