Different default value for thread_stack on Percona Server

Bug #1543994 reported by Hrvoje Matijakovic
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Status tracked in 5.7
5.5
New
Undecided
Unassigned
5.6
New
Undecided
Unassigned
5.7
New
Undecided
Unassigned

Bug Description

Compared to upstream MySQL, Percona Server has a different default value for thread_stack (https://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_thread_stack). PS has a default for 32-bit systems instead of 64-bit

Confirmed on: wheezy, jessie, and trusty

Default value is correct/confirmed on:CentOS: 5, 6, 7, wily, vivid, squeeze, precise

Percona Server:
mysql> select @@thread_stack;
+----------------+
| @@thread_stack |
+----------------+
| 196608 |
+----------------+
1 row in set (0.00 sec)

mysql> select @@version;
+-------------+
| @@version |
+-------------+
| 5.5.47-37.7 |
+-------------+
1 row in set (0.00 sec)

MySQL 5.5.48:
mysql> select @@thread_stack;
+----------------+
| @@thread_stack |
+----------------+
| 262144 |
+----------------+
1 row in set (0.00 sec)

mysql> select @@VERSION;
+-----------+
| @@VERSION |
+-----------+
| 5.5.48 |
+-----------+
1 row in set (0.00 sec)

Tags: pkg
Revision history for this message
Hrvoje Matijakovic (hrvojem) wrote :

This is happening because thread_stack is specified in my.cnf on affected distros:

root@wheezy:~# grep thread_stack /etc/mysql/my.cnf
thread_stack = 192K

root@jessie:~# grep thread_stack /etc/mysql/my.cnf
thread_stack = 192K

root@trusty:~# grep thread_stack /etc/mysql/my.cnf
thread_stack = 192K

Other distributions either don't have it specified to that value or not at all.

summary: - Different default value for thread_stack on PS 5.5
+ Different default value for thread_stack on Percona Server
description: updated
tags: added: pkg
Revision history for this message
Tomislav Plavcic (tplavcic) wrote :

This is happening because we don't provide our my.cnf on those distributions but use the one from system mysql-common package. There are several options
#1 try to just replace the my.cnf on installation with our copy (add it into percona-server-common package and put "Replaces: mysql-common" into package metadata)
#2 provide our own mysql-common package with my.cnf (not sure if this can break something)
#3 do some sed thing to remove this option just on installation

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3378

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.