# Why pt-align discard first line automatically?

**URL:** https://forums.percona.com/t/why-pt-align-discard-first-line-automatically/3955
**Category:** Percona Toolkit
**Created:** [December 18, 2014, 1:40am UTC](https://forums.percona.com/t/why-pt-align-discard-first-line-automatically/3955 "2014-12-18T01:40:55Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![leafonsword](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@leafonsword](https://forums.percona.com/u/leafonsword)
#### Post date: [December 18, 2014, 1:40am UTC](https://forums.percona.com/t/why-pt-align-discard-first-line-automatically/3955/1 "2014-12-18T01:40:55Z")

</div>

When I type following commands:

```auto
gf&#64;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:

```auto
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:

```auto
gf&#64;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

```auto
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?

---

<div class="post-metadata">

### Author: ![wagnerbianchi](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/wagnerbianchi/32/802_2.png) [@wagnerbianchi](https://forums.percona.com/u/wagnerbianchi)
#### Post date: [December 22, 2014, 7:43am UTC](https://forums.percona.com/t/why-pt-align-discard-first-line-automatically/3955/2 "2014-12-22T07:43:50Z")

</div>

Reading the description of the tool, I am wondering about that below:

[QUOTE]  
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).

---

<div class="post-metadata">

### Author: ![leafonsword](https://avatars.discourse-cdn.com/v4/letter/l/85f322/32.png) [@leafonsword](https://forums.percona.com/u/leafonsword)
#### Post date: [December 24, 2014, 2:11am UTC](https://forums.percona.com/t/why-pt-align-discard-first-line-automatically/3955/3 "2014-12-24T02:11:48Z")

</div>

> [@wagnerbianchi;28882](#):
>
> 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~
