Monday, 4 August 2014

thread pooling in mysql

Notes
Oracle Support- 04-Aug-2014 16:42 (4 mins ago)
Hello,

>i will generate given new SR for server monitoring.thanks for help.
>
Thanks for this.

>can i download all conversation ?
>
Yes, there is a "printable view" that shows you the whole SR text in one page. You can get it by clicking the small printer icon on the right hand side of the SR title.

Kind Regards,
Leandro Morgado

Senior MySQL Support Engineer
Oracle Corporation
http://www.mysql.com/
------------
Attend MySQL Central @ OpenWorld, Sept 28 - Oct 2, San Francisco.
Learn about the latest developments directly from Oracle's MySQL engineers,
boost your skills & share experiences with your peers.
Register Now! www.oracle.com/openworld/mysql
------------
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 04-Aug-2014 16:05 (41 mins ago)
OK,

i will generate given new SR for server monitoring.thanks for help.
can i download all conversation ?

thanks
Notes
Oracle Support- 04-Aug-2014 15:58 (47 mins ago)
Hi,

>i want to do one more thing related to MySQL server monitoring tool , how we will install that tool?
>
The install instructions are here:
http://dev.mysql.com/doc/mysql-monitor/3.0/en/mem-installing.html

Note however, that this Service Request is already pretty long and deals with a different problem than MySQL Enterprise Monitor (MEM) install. We typically try to handle different problems on different SRs. This approach gives both you and us several advantages; for instance, by having a new SR, we can concentrate better on the new issue and it also helps us in speeding up the review time (and hence the response time) needed in case a new engineer take ownership of a SR, should the previous owner be not available. Keeping one problem per SR thus leads to shorter, easier to read tickets which are easier to classify and refer back to. For this reason, can I request that you open a new Service Request in case you need further assistance with MEM installation?

Kind Regards,
Leandro Morgado

Senior MySQL Support Engineer
Oracle Corporation
http://www.mysql.com/
------------
Attend MySQL Central @ OpenWorld, Sept 28 - Oct 2, San Francisco.
Learn about the latest developments directly from Oracle's MySQL engineers,
boost your skills & share experiences with your peers.
Register Now! www.oracle.com/openworld/mysql
------------
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 04-Aug-2014 15:11 (1+ hour ago)
Hi,
Ok,Thanks for help .

i want to do one more thing related to MySQL server monitoring tool , how we will install that tool?

Thanks

Notes
Oracle Support- 04-Aug-2014 14:25 (2+ hours ago)
Hi,

> can i increase or decease digit which is provide above MySQL variables?
You can modify those default values in the my.cnf to make them permanent or some of those variables are dynamic so they can be changed while the server is running. It is important you have some way to measure that you are getting better performance from your application when making changes.
http://dev.mysql.com/doc/refman/5.6/en/thread-pool-tuning.html

> above parameters will be use whole database OR only Innodb table type?
Overall configuration of the thread pool, so the whole database, all database engines, MyISAM or Innodb or others.

Regards,

--
Roger Nay
MySQL - Senior Technical Support Engineer
Oracle Italy
------------
Attend MySQL Central @ OpenWorld, Sept 28 - Oct 2, San Francisco.
Learn about the latest developments directly from Oracle's MySQL engineers,
boost your skills & share experiences with your peers.
Register Now! www.oracle.com/openworld/mysql
------------
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 04-Aug-2014 13:04 (3+ hours ago)
Hi,

ok,


Thread pool plugin started successfully with parameters:
thread_pool_size = 16,
thread_pool_algorithm = Low Concurrency Algorithm
thread_pool_stall_limit = 6
thread_pool_prio_kickup_timer = 1000
thread_pool_max_unused_threads = 0
thread_pool_high_priority_connection = 0

can i increase or decease digit which is provide above MySQL variables?

above parameters will be use whole database OR only Innodb table type?

Thanks

Notes
Oracle Support- 04-Aug-2014 12:48 (3+ hours ago)
Hi,

To set buffer pool in my.cnf, edit the my.cnf and under the [mysqld] section add this:

innodb_buffer_pool_size=128M


The size is currently 128M which is the default value. Change it as necessary, depending on how much memory you have free and
how much innodb data there is. Restart of mysqld is required for the change to take effect.


regards,
--
Shane Bester, MySQL Principle Technical Support Engineer
Oracle Corporation
http://dev.mysql.com/
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 04-Aug-2014 12:15 (4+ hours ago)
Hi,

How i can set buffer pool size in my.cnf.

buffer pool install in MySQL server or not ? i already sent MySQL log file.


Thanks
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 03-Aug-2014 23:10 (17+ hours ago)
Upload to TDS successful for the file mysqld_3aug_14.log.
Notes
Oracle Support- 03-Aug-2014 11:32 (Sunday)
Recommended steps (require MySQL resttart):

1. add following parameter to [mysqld_safe] section of my.cnf :

plugin-dir=/usr/lib64/mysql/plugin

2. add following parameter to [mysqld] section of my.cnf :

plugin-dir=/usr/lib64/mysql/plugin

3. Restart MySQL Server, observe output of "show plugins;" . If still no luck - send us error log and modified my.cnf
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 03-Aug-2014 11:06 (Sunday)
Hi,
Using of commands which is provided by you result is below:-

MySQL-shared-compat-advanced-5.6.18-1.el6.x86_64
MySQL-embedded-advanced-5.6.18-1.el6.x86_64
MySQL-server-advanced-5.6.18-1.el6.x86_64
MySQL-devel-advanced-5.6.18-1.el6.x86_64
php-mysql-5.3.3-27.el6_5.x86_64
MySQL-client-advanced-5.6.18-1.el6.x86_64
mysql-community-release-el6-5.noarch
MySQL-test-advanced-5.6.18-1.el6.x86_64
MySQL-shared-advanced-5.6.18-1.el6.x86_64
[root@INDB-05 ~]# cat /etc/*release
CentOS release 6.3 (Final)
CentOS release 6.3 (Final)
CentOS release 6.3 (Final)
[root@INDB-05 ~]# find / 2> /dev/null |grep thread_pool.so
/usr/lib64/mysql/plugin/debug/thread_pool.so
/usr/lib64/mysql/plugin/thread_pool.so
[root@INDB-05 ~]#

Thanks
Notes
Oracle Support- 03-Aug-2014 10:48 (Sunday)
> I searched in MySQL server but there is no thread_pool.so file available .

In order to assist with exact folder where thread_pool.so should be located, we need to know what exact packages you did install.
E.g. could you execute following Linux shell commands:

rpm -qa |grep -i mysql
cat /etc/*release


Or consider searching for file on all disks using command below (may take some time):

find / 2> /dev/null |grep thread_pool.so
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 03-Aug-2014 10:37 (Sunday)
Hi,

I am waiting for your response.

Thanks
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 01-Aug-2014 14:47 (Friday)
Hi,

I searched in MySQL server but there is no thread_pool.so file available .
please suggest me where i can find particular file?

Thanks
Notes
Oracle Support- 01-Aug-2014 14:08 (Friday)
Hi Manoj,

And this is the error which stops the thread pool plugin from starting.

2014-08-01 12:36:11 19801 [ERROR] Can't open shared library '/var/lib/mysql/plugin/thread_pool.so' (errno: 0 /var/lib/mysql/plugin/thread_pool.so: cannot open shared object file: No such file or directory)

seems the thread_pool.so file is not present in the plugin_dir /var/lib/mysql/plugin , please search the file on the server and point the plugin_dir to the directory where the .so file resides. Else, copy the .so file to the /var/lib/mysql/plugin dir.


Thanks
Anand
MySQL Support Engineer.

------------
Attend MySQL Central @ OpenWorld, Sept 28 - Oct 2, San Francisco.
Learn about the latest developments directly from Oracle's MySQL engineers,
boost your skills & share experiences with your peers.
Register Now! www.oracle.com/openworld/mysql
------------
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 01-Aug-2014 12:42 (Friday)
Upload to TDS successful for the file mysqld_1august_14.log.
Notes
Oracle Support- 31-Jul-2014 13:19 (Thursday)
Hello Manoj -

Please send us the latest mysql error log to check further.

Thanks
Anand
MySQL Support Engineer.

------------
Attend MySQL Central @ OpenWorld, Sept 28 - Oct 2, San Francisco.
Learn about the latest developments directly from Oracle's MySQL engineers,
boost your skills & share experiences with your peers.
Register Now! www.oracle.com/openworld/mysql
------------
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 31-Jul-2014 13:16 (Thursday)
show plugins;
+----------------------------+----------+--------------------+---------+-------------+
| Name | Status | Type | Library | License |
+----------------------------+----------+--------------------+---------+-------------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | PROPRIETARY |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | PROPRIETARY |
| sha256_password | ACTIVE | AUTHENTICATION | NULL | PROPRIETARY |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| CSV | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | PROPRIETARY |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| partition | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
+----------------------------+----------+--------------------+---------+-------------+
42 rows in set (0.00 sec)
comment which is suggest by you above stat showing.
Notes
Oracle Support- 31-Jul-2014 13:10 (Thursday)
Hello Manoj -

May I ask you to comment the below line from config file, and restart the service.

plugin-load=thread_pool=thread_pool.so;tp_thread_state=thread_pool.so;tp_thread_group_state=thread_pool.so;tp_thread_group_stats=thread_pool.so

after restart, get us the output of "show plugins;"


Thanks
Anand
MySQL Support Engineer.

------------
Attend MySQL Central @ OpenWorld, Sept 28 - Oct 2, San Francisco.
Learn about the latest developments directly from Oracle's MySQL engineers,
boost your skills & share experiences with your peers.
Register Now! www.oracle.com/openworld/mysql
------------
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 31-Jul-2014 12:55 (Thursday)
Upload to TDS successful for the file my.cnf.
Notes
Oracle Support- 31-Jul-2014 12:48 (Thursday)
Hi Manoj

To install Thread Pool plugin ,you just need put "plugin-load=thread_pool.so"
under "[mysqld]" in your my.cnf file,usually MySQL option file location will be /etc/my.cnf :

So you need edit this file like below :

[mysqld]
#any other options
#any other options
plugin-load=thread_pool.so

Which is equivalent to loading all thread pool plugins by naming them individually:

[mysqld]
plugin-load=thread_pool.so
plugin-load=thread_pool=thread_pool.so;tp_thread_state=thread_pool.so;tp_thread_group_state=thread_pool.so;tp_thread_group_stats=thread_pool.so

Then restart MySQL server and check plugins status with "show plugins"

Please have a look below link for details :

8.11.6.1 Thread Pool Components and Installation
http://dev.mysql.com/doc/refman/5.5/en/thread-pool-installation.html

And let us know if you have any questions .

Regards,

Dachao Gao
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 31-Jul-2014 12:04 (Thursday)
SHOW PLUGINS;
+----------------------------+----------+--------------------+---------+-------------+
| Name | Status | Type | Library | License |
+----------------------------+----------+--------------------+---------+-------------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| mysql_native_password | ACTIVE | AUTHENTICATION | NULL | PROPRIETARY |
| mysql_old_password | ACTIVE | AUTHENTICATION | NULL | PROPRIETARY |
| sha256_password | ACTIVE | AUTHENTICATION | NULL | PROPRIETARY |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| CSV | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| FEDERATED | DISABLED | STORAGE ENGINE | NULL | PROPRIETARY |
| InnoDB | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| INNODB_TRX | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_LOCKS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_LOCK_WAITS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP_RESET | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMPMEM | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMPMEM_RESET | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP_PER_INDEX | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_CMP_PER_INDEX_RESET | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_BUFFER_PAGE | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_BUFFER_PAGE_LRU | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_BUFFER_POOL_STATS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_METRICS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_BEING_DELETED | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_CONFIG | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_INDEX_CACHE | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_FT_INDEX_TABLE | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_TABLES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_TABLESTATS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_INDEXES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_COLUMNS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_FIELDS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_FOREIGN | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_FOREIGN_COLS | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_TABLESPACES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| INNODB_SYS_DATAFILES | ACTIVE | INFORMATION SCHEMA | NULL | PROPRIETARY |
| ARCHIVE | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| BLACKHOLE | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
| partition | ACTIVE | STORAGE ENGINE | NULL | PROPRIETARY |
+----------------------------+----------+--------------------+---------+-------------+
42 rows in set (0.00 sec)

Hi, i want to instal thread buffer pool.how i will?
ODM Action Plan
Oracle Support- 31-Jul-2014 06:05 (Thursday)
Hi Manoj,
So after reviewing the mysqld.log file you uploaded, it shows the following:
.....
2014-07-30 18:25:35 14709 [Note] Event Scheduler: Loaded 0 events
2014-07-30 18:25:35 14709 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.6.18-enterprise-commercial-advanced' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (Commercial)

Which seems to indicate that you are back up and running again.
Can you confirm what plugins are being used at this time by running the following command:

mysql> SHOW PLUGINS;

Kind regards
Jonathon
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 30-Jul-2014 18:30 (Wednesday)
Upload to TDS successful for the file mysqld.log.
Notes
Oracle Support- 30-Jul-2014 18:01 (Wednesday)
Hi,

Message "[ERROR] InnoDB: Unable to lock ./ibdata1, error: 11" most often indicates that MySQL Server wasn't shutdown properly.

Could you try following steps:

1. shutdown MySQL Server
2. Make sure that mysqld process doesn't appear in output of top :

top -b -n 1 |grep mysqld

3. Start MySQL Server and send us error log


If at step #2 you see that mysqld process is still hanging around, please collect several outputs of command below and send us for review:


gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)
gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)
gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)
gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)
gdb -ex "set pagination 0" -ex "thread apply all bt" --batch -p $(pidof mysqld)

Regards,
Andrii Nikitin
MySQL Support
Update from Customer
MANOJ.TIWARI@INFOTELGROUP.IN- 30-Jul-2014 17:51 (Wednesday)
Upload to TDS successful for the file poolthreaderror.txt.
ODM Action Plan
Oracle Support- 30-Jul-2014 15:43 (Wednesday)
Hi Manoj,
Thank you for contacting MySQL Support regarding your questions on the MySQL Thread Pool feature and monitoring the threads.

The installation instructions are located in the manual at: http://dev.mysql.com/doc/refman/5.6/en/thread-pool-installation.html
The simplest method is to change your my.cnf configuration with the lines:

[mysqld]
plugin-load=thread_pool.so
plugin-load=thread_pool=thread_pool.so;tp_thread_state=thread_pool.so;tp_thread_group_state=thread_pool.so;tp_thread_group_stats=thread_pool.so

Once the above changes are made, please restart the mysqld service.

Note that the second line loads all the plugins required to have the thread information in the information_schema tables.

Kind regards
Jonathon Coombes
MySQL Principal Technical Support Engineer
Customer Problem Description
MANOJ.TIWARI@INFOTELGROUP.IN- 30-Jul-2014 12:50 (Wednesday)
Customer Problem Description
---------------------------------------------------

Problem Summary
---------------------------------------------------
How to install MySQL Enterprise version with thread pooling with server monitoring ?

Problem Description
---------------------------------------------------
Hi,

I want to install MySQL Enterprise version with thread pooling , server monitoring tool ?please help me.
i am sending my LINUX server configuration.

Linux version 2.6.32-279.el6.x86_64 (mockbuild@c6b9.bsys.dev.centos.org) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Fri Jun 22 12:19:21 UTC 2012

Error Codes
---------------------------------------------------


Problem Category/Subcategory
---------------------------------------------------
MySQL Server General Issues/MySQL Server Installation and Upgrading

Uploaded Files
---------------------------------------------------


Template Question Responses
---------------------------------------------------
1) Operating System
Linux version 2.6.32-279.el6.x86_64 (mockbuild@c6b9.bsys.dev.centos.org) (gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) ) #1 SMP Fri Jun 22 12:19:21 UTC 2012

2) Architecture
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 26
model name : Intel(R) Xeon(R) CPU E5506 @ 2.13GHz
stepping : 5
cpu MHz : 1596.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
apicid : 0
initial apicid : 0
fpu : yes
fpu_exception : yes
cpuid level : 11
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm dca sse4_1 sse4_2 popcnt lahf_lm dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 4266.88
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:

processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 26
model name : Intel(R) Xeon(R) CPU E5506 @ 2.13GHz
stepping : 5
cpu MHz : 1596.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
apicid : 2
initial apicid : 2
fpu : yes
fpu_exception : yes
cpuid level : 11
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm dca sse4_1 sse4_2 popcnt lahf_lm dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 4266.88
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:

processor : 2
vendor_id : GenuineIntel
cpu family : 6
model : 26
model name : Intel(R) Xeon(R) CPU E5506 @ 2.13GHz
stepping : 5
cpu MHz : 1596.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
apicid : 4
initial apicid : 4
fpu : yes
fpu_exception : yes
cpuid level : 11
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm dca sse4_1 sse4_2 popcnt lahf_lm dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 4266.88
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:

processor : 3
vendor_id : GenuineIntel
cpu family : 6
model : 26
model name : Intel(R) Xeon(R) CPU E5506 @ 2.13GHz
stepping : 5
cpu MHz : 1596.000
cache size : 4096 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
apicid : 6
initial apicid : 6
fpu : yes
fpu_exception : yes
cpuid level : 11
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts rep_good xtopology nonstop_tsc aperfmperf pni dtes64 monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr pdcm dca sse4_1 sse4_2 popcnt lahf_lm dts tpr_shadow vnmi flexpriority ept vpid
bogomips : 4266.88
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:

3) MySQL Server version
MySQL 5.6
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)