Not the answer you need?
Register and ask your own question!

Why pt-align discard first line automatically?

leafonswordleafonsword ContributorInactive User Role Beginner
When I type following commands:
gf@li741-164 ~> mysql -uroot -h 127.0.0.1 -Be "select * from mysql.user limit 2"
The result contains one column name title line and two host line:
Host User Password Select_priv Insert_priv Update_priv Delete_priv Create_priv Drop_priv Reload_priv Shutdown_priv Process_priv File_priv Grant_priv References_priv Index_priv Alter_priv Show_db_priv Super_priv Create_tmp_table_priv Lock_tables_priv Execute_priv Repl_slave_priv Repl_client_priv Create_view_priv Show_view_priv Create_routine_priv Alter_routine_priv Create_user_priv Event_priv Trigger_priv Create_tablespace_priv ssl_type ssl_cipher x509_issuer x509_subjectmax_questions max_updates max_connections max_user_connections plugin authentication_string password_expired
localhost root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y YY Y Y Y Y Y 0 0 0 0 N
li741-164.members.linode.com root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y YY Y Y Y Y Y Y Y 0 0 0 0 N

But after using pt-align:
gf@li741-164 ~> mysql -uroot -h 127.0.0.1 -Be "select * from mysql.user limit 2" | pt-align
first column name title line is ignored,just left two host lines
localhost                    root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0 N
li741-164.members.linode.com root Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0 N

Why this happens?

Comments

  • wagnerbianchiwagnerbianchi Remote DBA Current User Role Patron
    Reading the description of the tool, I am wondering about that below:
    pt-align

    Can you test if all the mysql.user columns have a value? Maybe the columns ssl_type, ssl_chipher, x509_issuer, x509_subject, and plugin have not a value what makes it hard do what pt-align does (check the tool's description again).
  • leafonswordleafonsword Contributor Inactive User Role Beginner
    Reading the description of the tool, I am wondering about that below:



    Can you test if all the mysql.user columns have a value? Maybe the columns ssl_type, ssl_chipher, x509_issuer, x509_subject, and plugin have not a value what makes it hard do what pt-align does (check the tool's description again).

    Thanks,but if could pt-toolkit document bold some important sentence like you show above, for non-English speaking country people, it will helpful for them~
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.