Wednesday, 27 August 2014
Monday, 4 August 2014
thread pooling in mysql
| Notes |
| |||
| 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 |
| |||
| OK, i will generate given new SR for server monitoring.thanks for help. can i download all conversation ? thanks | ||||
| Notes |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| Upload to TDS successful for the file mysqld_3aug_14.log. | ||||
| Notes |
| |||
| 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 |
| |||
| 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 |
| |||
| > 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 |
| |||
| Hi, I am waiting for your response. Thanks | ||||
| Update from Customer |
| |||
| 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 |
| |||
| 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 |
| |||
| Upload to TDS successful for the file mysqld_1august_14.log. | ||||
| Notes |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| Upload to TDS successful for the file my.cnf. | ||||
| Notes |
| |||
| 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 |
| |||
| 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 |
| |||
| 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 |
| |||
| Upload to TDS successful for the file mysqld.log. | ||||
| Notes |
| |||
| 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 |
| |||
| Upload to TDS successful for the file poolthreaderror.txt. | ||||
| ODM Action Plan |
| |||
| 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 |
| |||
| 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 | ||||
Subscribe to:
Posts (Atom)