Activity log for bug #1538040

Date Who What changed Old value New value Message
2016-01-26 08:42:07 Valerio bug added bug
2016-01-26 15:16:23 Launchpad Janitor linux-lts-wily (Ubuntu): status New Confirmed
2016-02-22 22:32:49 Viacheslav Semykrasov bug added subscriber Viacheslav Semykrasov
2016-03-06 22:28:02 penalvch affects linux-lts-wily (Ubuntu) linux (Ubuntu)
2016-03-06 22:28:02 penalvch linux (Ubuntu): importance Undecided Low
2016-03-06 22:28:02 penalvch linux (Ubuntu): status Confirmed Incomplete
2016-03-06 22:39:52 Valerio tags amd64 apport-bug ext4 sata trusty amd64 apport-bug apport-collected ext4 sata trusty
2016-03-06 22:39:53 Valerio description I have a brand new laptop (Asus N551VW, i7-6700HQ, 16 Gb ram) on which i installed Ubuntu 14.04 64bit and a new Samsung SSD 850 PRO 512Gb (latest firmware). I installed the default MySql 5.6.27 on the machine but I noticed a very VERY slow performance of the database (just creating a db and executing some migrations without any data takes around 33 seconds while on lower-hardware co-workers notebooks it takes like 3 seconds). Every sql statement seems to spend most time in "system lock" state, as i could see with a SHOW PROCESSLIST. I thought it to be an hard drive issue, but executing the hard drive benchmark in Ubuntu gives 500 Mb/s read and 350 Mb/s write speed, which looks mostly normal. I also tried updating to the new 4.2 kernel, but the issue still there. To make an experiment, i cloned the ssd on a normal hard drive, switched it in and connected the SSD externally with an usb box. I moved mysql data directory to the external disk, and retried the db creation: it took only 2.5 seconds. Just out of curiosity i tried the same operation on an internal non-ssd disk: when the hd is plugged inside the laptop with sata, the database creation takes more than 2 minutes, while with the data dir on external usb (with the same physical disk) it took less than 10 seconds. To make it short, after some research, adding barrier=0 to the mount options of the root drive with no other modification caused the same script to take 1.5 seconds instead of 33, with a 22x increase in performance. I have opened his bug on askubuntu (http://askubuntu.com/questions/725182/ssd-extremely-slow-when-connected-with-internal-sata-ok-with-external-usb ) and it was suggested that this coud be an issue of the controller firmware/driver. The problem is present both in trusty's default kernel (3.19.0-47.53) and in the 4.2 (4.2.0-25.30). Let me know if you need more informations! ProblemType: Bug DistroRelease: Ubuntu 14.04 Package: linux-image-4.2.0-25-generic 4.2.0-25.30~14.04.1 ProcVersionSignature: Ubuntu 4.2.0-25.30~14.04.1-generic 4.2.6 Uname: Linux 4.2.0-25-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.14.1-0ubuntu3.19 Architecture: amd64 Date: Tue Jan 26 09:25:04 2016 InstallationDate: Installed on 2016-01-06 (19 days ago) InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805) ProcEnviron: TERM=xterm PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: linux-lts-wily UpgradeStatus: No upgrade log present (probably fresh install) I have a brand new laptop (Asus N551VW, i7-6700HQ, 16 Gb ram) on which i installed Ubuntu 14.04 64bit and a new Samsung SSD 850 PRO 512Gb (latest firmware). I installed the default MySql 5.6.27 on the machine but I noticed a very VERY slow performance of the database (just creating a db and executing some migrations without any data takes around 33 seconds while on lower-hardware co-workers notebooks it takes like 3 seconds). Every sql statement seems to spend most time in "system lock" state, as i could see with a SHOW PROCESSLIST. I thought it to be an hard drive issue, but executing the hard drive benchmark in Ubuntu gives 500 Mb/s read and 350 Mb/s write speed, which looks mostly normal. I also tried updating to the new 4.2 kernel, but the issue still there. To make an experiment, i cloned the ssd on a normal hard drive, switched it in and connected the SSD externally with an usb box. I moved mysql data directory to the external disk, and retried the db creation: it took only 2.5 seconds. Just out of curiosity i tried the same operation on an internal non-ssd disk: when the hd is plugged inside the laptop with sata, the database creation takes more than 2 minutes, while with the data dir on external usb (with the same physical disk) it took less than 10 seconds. To make it short, after some research, adding barrier=0 to the mount options of the root drive with no other modification caused the same script to take 1.5 seconds instead of 33, with a 22x increase in performance. I have opened his bug on askubuntu (http://askubuntu.com/questions/725182/ssd-extremely-slow-when-connected-with-internal-sata-ok-with-external-usb ) and it was suggested that this coud be an issue of the controller firmware/driver. The problem is present both in trusty's default kernel (3.19.0-47.53) and in the 4.2 (4.2.0-25.30). Let me know if you need more informations! ProblemType: Bug DistroRelease: Ubuntu 14.04 Package: linux-image-4.2.0-25-generic 4.2.0-25.30~14.04.1 ProcVersionSignature: Ubuntu 4.2.0-25.30~14.04.1-generic 4.2.6 Uname: Linux 4.2.0-25-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.14.1-0ubuntu3.19 Architecture: amd64 Date: Tue Jan 26 09:25:04 2016 InstallationDate: Installed on 2016-01-06 (19 days ago) InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805) ProcEnviron: TERM=xterm PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: linux-lts-wily UpgradeStatus: No upgrade log present (probably fresh install) --- ApportVersion: 2.14.1-0ubuntu3.19 Architecture: amd64 AudioDevicesInUse: USER PID ACCESS COMMAND /dev/snd/controlC0: valerio 2776 F.... pulseaudio DistroRelease: Ubuntu 14.04 HibernationDevice: RESUME=UUID=e5eee076-9bfc-4547-bf85-0208b98b57a8 InstallationDate: Installed on 2016-01-06 (60 days ago) InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805) Lsusb: Bus 002 Device 001: ID 1d6b:0003 Linux Foundation 3.0 root hub Bus 001 Device 003: ID 8087:0a2a Intel Corp. Bus 001 Device 002: ID 04f2:b3fd Chicony Electronics Co., Ltd Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub MachineType: ASUSTeK COMPUTER INC. N551VW NonfreeKernelModules: nvidia Package: linux (not installed) ProcEnviron: TERM=xterm PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash ProcFB: 0 inteldrmfb ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-4.2.0-30-generic root=UUID=5231fd09-180d-4fd2-bad5-e989207b11e7 ro quiet splash elevator=deadline vt.handoff=7 ProcVersionSignature: Ubuntu 4.2.0-30.36~14.04.1-generic 4.2.8-ckt3 PulseList: Error: command ['pacmd', 'list'] failed with exit code 1: No PulseAudio daemon running, or not running as session daemon. RelatedPackageVersions: linux-restricted-modules-4.2.0-30-generic N/A linux-backports-modules-4.2.0-30-generic N/A linux-firmware 1.127.20 Tags: trusty Uname: Linux 4.2.0-30-generic x86_64 UpgradeStatus: No upgrade log present (probably fresh install) UserGroups: _MarkForUpload: True dmi.bios.date: 11/13/2015 dmi.bios.vendor: American Megatrends Inc. dmi.bios.version: N551VW.205 dmi.board.asset.tag: ATN12345678901234567 dmi.board.name: N551VW dmi.board.vendor: ASUSTeK COMPUTER INC. dmi.board.version: 1.0 dmi.chassis.asset.tag: ATN12345678901234567 dmi.chassis.type: 10 dmi.chassis.vendor: ASUSTeK COMPUTER INC. dmi.chassis.version: 1.0 dmi.modalias: dmi:bvnAmericanMegatrendsInc.:bvrN551VW.205:bd11/13/2015:svnASUSTeKCOMPUTERINC.:pnN551VW:pvr1.0:rvnASUSTeKCOMPUTERINC.:rnN551VW:rvr1.0:cvnASUSTeKCOMPUTERINC.:ct10:cvr1.0: dmi.product.name: N551VW dmi.product.version: 1.0 dmi.sys.vendor: ASUSTeK COMPUTER INC.
2016-03-06 22:39:54 Valerio attachment added AlsaInfo.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590958/+files/AlsaInfo.txt
2016-03-06 22:39:56 Valerio attachment added BootDmesg.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590959/+files/BootDmesg.txt
2016-03-06 22:39:57 Valerio attachment added CRDA.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590960/+files/CRDA.txt
2016-03-06 22:39:58 Valerio attachment added CurrentDmesg.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590961/+files/CurrentDmesg.txt
2016-03-06 22:40:01 Valerio attachment added IwConfig.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590962/+files/IwConfig.txt
2016-03-06 22:40:02 Valerio attachment added Lspci.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590963/+files/Lspci.txt
2016-03-06 22:40:04 Valerio attachment added ProcCpuinfo.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590964/+files/ProcCpuinfo.txt
2016-03-06 22:40:05 Valerio attachment added ProcInterrupts.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590965/+files/ProcInterrupts.txt
2016-03-06 22:40:06 Valerio attachment added ProcModules.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590966/+files/ProcModules.txt
2016-03-06 22:40:07 Valerio attachment added RfKill.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590967/+files/RfKill.txt
2016-03-06 22:40:09 Valerio attachment added UdevDb.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590968/+files/UdevDb.txt
2016-03-06 22:40:11 Valerio attachment added UdevLog.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590969/+files/UdevLog.txt
2016-03-06 22:40:13 Valerio attachment added WifiSyslog.txt https://bugs.launchpad.net/bugs/1538040/+attachment/4590970/+files/WifiSyslog.txt
2016-03-06 23:58:52 penalvch tags amd64 apport-bug apport-collected ext4 sata trusty amd64 apport-bug apport-collected latest-bios-205 trusty
2016-03-06 23:59:59 penalvch description I have a brand new laptop (Asus N551VW, i7-6700HQ, 16 Gb ram) on which i installed Ubuntu 14.04 64bit and a new Samsung SSD 850 PRO 512Gb (latest firmware). I installed the default MySql 5.6.27 on the machine but I noticed a very VERY slow performance of the database (just creating a db and executing some migrations without any data takes around 33 seconds while on lower-hardware co-workers notebooks it takes like 3 seconds). Every sql statement seems to spend most time in "system lock" state, as i could see with a SHOW PROCESSLIST. I thought it to be an hard drive issue, but executing the hard drive benchmark in Ubuntu gives 500 Mb/s read and 350 Mb/s write speed, which looks mostly normal. I also tried updating to the new 4.2 kernel, but the issue still there. To make an experiment, i cloned the ssd on a normal hard drive, switched it in and connected the SSD externally with an usb box. I moved mysql data directory to the external disk, and retried the db creation: it took only 2.5 seconds. Just out of curiosity i tried the same operation on an internal non-ssd disk: when the hd is plugged inside the laptop with sata, the database creation takes more than 2 minutes, while with the data dir on external usb (with the same physical disk) it took less than 10 seconds. To make it short, after some research, adding barrier=0 to the mount options of the root drive with no other modification caused the same script to take 1.5 seconds instead of 33, with a 22x increase in performance. I have opened his bug on askubuntu (http://askubuntu.com/questions/725182/ssd-extremely-slow-when-connected-with-internal-sata-ok-with-external-usb ) and it was suggested that this coud be an issue of the controller firmware/driver. The problem is present both in trusty's default kernel (3.19.0-47.53) and in the 4.2 (4.2.0-25.30). Let me know if you need more informations! ProblemType: Bug DistroRelease: Ubuntu 14.04 Package: linux-image-4.2.0-25-generic 4.2.0-25.30~14.04.1 ProcVersionSignature: Ubuntu 4.2.0-25.30~14.04.1-generic 4.2.6 Uname: Linux 4.2.0-25-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.14.1-0ubuntu3.19 Architecture: amd64 Date: Tue Jan 26 09:25:04 2016 InstallationDate: Installed on 2016-01-06 (19 days ago) InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805) ProcEnviron: TERM=xterm PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash SourcePackage: linux-lts-wily UpgradeStatus: No upgrade log present (probably fresh install) --- ApportVersion: 2.14.1-0ubuntu3.19 Architecture: amd64 AudioDevicesInUse: USER PID ACCESS COMMAND /dev/snd/controlC0: valerio 2776 F.... pulseaudio DistroRelease: Ubuntu 14.04 HibernationDevice: RESUME=UUID=e5eee076-9bfc-4547-bf85-0208b98b57a8 InstallationDate: Installed on 2016-01-06 (60 days ago) InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805) Lsusb: Bus 002 Device 001: ID 1d6b:0003 Linux Foundation 3.0 root hub Bus 001 Device 003: ID 8087:0a2a Intel Corp. Bus 001 Device 002: ID 04f2:b3fd Chicony Electronics Co., Ltd Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub MachineType: ASUSTeK COMPUTER INC. N551VW NonfreeKernelModules: nvidia Package: linux (not installed) ProcEnviron: TERM=xterm PATH=(custom, no user) LANG=en_US.UTF-8 SHELL=/bin/bash ProcFB: 0 inteldrmfb ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-4.2.0-30-generic root=UUID=5231fd09-180d-4fd2-bad5-e989207b11e7 ro quiet splash elevator=deadline vt.handoff=7 ProcVersionSignature: Ubuntu 4.2.0-30.36~14.04.1-generic 4.2.8-ckt3 PulseList: Error: command ['pacmd', 'list'] failed with exit code 1: No PulseAudio daemon running, or not running as session daemon. RelatedPackageVersions: linux-restricted-modules-4.2.0-30-generic N/A linux-backports-modules-4.2.0-30-generic N/A linux-firmware 1.127.20 Tags: trusty Uname: Linux 4.2.0-30-generic x86_64 UpgradeStatus: No upgrade log present (probably fresh install) UserGroups: _MarkForUpload: True dmi.bios.date: 11/13/2015 dmi.bios.vendor: American Megatrends Inc. dmi.bios.version: N551VW.205 dmi.board.asset.tag: ATN12345678901234567 dmi.board.name: N551VW dmi.board.vendor: ASUSTeK COMPUTER INC. dmi.board.version: 1.0 dmi.chassis.asset.tag: ATN12345678901234567 dmi.chassis.type: 10 dmi.chassis.vendor: ASUSTeK COMPUTER INC. dmi.chassis.version: 1.0 dmi.modalias: dmi:bvnAmericanMegatrendsInc.:bvrN551VW.205:bd11/13/2015:svnASUSTeKCOMPUTERINC.:pnN551VW:pvr1.0:rvnASUSTeKCOMPUTERINC.:rnN551VW:rvr1.0:cvnASUSTeKCOMPUTERINC.:ct10:cvr1.0: dmi.product.name: N551VW dmi.product.version: 1.0 dmi.sys.vendor: ASUSTeK COMPUTER INC. I have a brand new laptop (Asus N551VW, i7-6700HQ, 16 Gb ram) on which i installed Ubuntu 14.04 64bit and a new Samsung SSD 850 PRO 512Gb (latest firmware). I installed the default MySql 5.6.27 on the machine but I noticed a very VERY slow performance of the database (just creating a db and executing some migrations without any data takes around 33 seconds while on lower-hardware co-workers notebooks it takes like 3 seconds). Every sql statement seems to spend most time in "system lock" state, as i could see with a SHOW PROCESSLIST. I thought it to be an hard drive issue, but executing the hard drive benchmark in Ubuntu gives 500 Mb/s read and 350 Mb/s write speed, which looks mostly normal. I also tried updating to the new 4.2 kernel, but the issue still there. To make an experiment, i cloned the ssd on a normal hard drive, switched it in and connected the SSD externally with an usb box. I moved mysql data directory to the external disk, and retried the db creation: it took only 2.5 seconds. Just out of curiosity i tried the same operation on an internal non-ssd disk: when the hd is plugged inside the laptop with sata, the database creation takes more than 2 minutes, while with the data dir on external usb (with the same physical disk) it took less than 10 seconds. WORKAROUND: Add barrier=0 to root drive mount options with no other modification caused the same script to take 1.5 seconds instead of 33, with a 22x increase in performance. I have opened his bug on askubuntu (http://askubuntu.com/questions/725182/ssd-extremely-slow-when-connected-with-internal-sata-ok-with-external-usb ) and it was suggested that this coud be an issue of the controller firmware/driver. The problem is present both in trusty's default kernel (3.19.0-47.53) and in the 4.2 (4.2.0-25.30). --- ApportVersion: 2.14.1-0ubuntu3.19 Architecture: amd64 AudioDevicesInUse:  USER PID ACCESS COMMAND  /dev/snd/controlC0: valerio 2776 F.... pulseaudio DistroRelease: Ubuntu 14.04 HibernationDevice: RESUME=UUID=e5eee076-9bfc-4547-bf85-0208b98b57a8 InstallationDate: Installed on 2016-01-06 (60 days ago) InstallationMedia: Ubuntu 14.04.3 LTS "Trusty Tahr" - Beta amd64 (20150805) Lsusb:  Bus 002 Device 001: ID 1d6b:0003 Linux Foundation 3.0 root hub  Bus 001 Device 003: ID 8087:0a2a Intel Corp.  Bus 001 Device 002: ID 04f2:b3fd Chicony Electronics Co., Ltd  Bus 001 Device 001: ID 1d6b:0002 Linux Foundation 2.0 root hub MachineType: ASUSTeK COMPUTER INC. N551VW NonfreeKernelModules: nvidia Package: linux (not installed) ProcEnviron:  TERM=xterm  PATH=(custom, no user)  LANG=en_US.UTF-8  SHELL=/bin/bash ProcFB: 0 inteldrmfb ProcKernelCmdLine: BOOT_IMAGE=/boot/vmlinuz-4.2.0-30-generic root=UUID=5231fd09-180d-4fd2-bad5-e989207b11e7 ro quiet splash elevator=deadline vt.handoff=7 ProcVersionSignature: Ubuntu 4.2.0-30.36~14.04.1-generic 4.2.8-ckt3 PulseList: Error: command ['pacmd', 'list'] failed with exit code 1: No PulseAudio daemon running, or not running as session daemon. RelatedPackageVersions:  linux-restricted-modules-4.2.0-30-generic N/A  linux-backports-modules-4.2.0-30-generic N/A  linux-firmware 1.127.20 Tags: trusty Uname: Linux 4.2.0-30-generic x86_64 UpgradeStatus: No upgrade log present (probably fresh install) UserGroups: _MarkForUpload: True dmi.bios.date: 11/13/2015 dmi.bios.vendor: American Megatrends Inc. dmi.bios.version: N551VW.205 dmi.board.asset.tag: ATN12345678901234567 dmi.board.name: N551VW dmi.board.vendor: ASUSTeK COMPUTER INC. dmi.board.version: 1.0 dmi.chassis.asset.tag: ATN12345678901234567 dmi.chassis.type: 10 dmi.chassis.vendor: ASUSTeK COMPUTER INC. dmi.chassis.version: 1.0 dmi.modalias: dmi:bvnAmericanMegatrendsInc.:bvrN551VW.205:bd11/13/2015:svnASUSTeKCOMPUTERINC.:pnN551VW:pvr1.0:rvnASUSTeKCOMPUTERINC.:rnN551VW:rvr1.0:cvnASUSTeKCOMPUTERINC.:ct10:cvr1.0: dmi.product.name: N551VW dmi.product.version: 1.0 dmi.sys.vendor: ASUSTeK COMPUTER INC.
2016-03-07 22:19:01 Valerio tags amd64 apport-bug apport-collected latest-bios-205 trusty amd64 apport-bug apport-collected kernel-bug-exists-upstream kernel-bug-exists-upstream-4.5-rc7 latest-bios-205 trusty
2016-03-07 22:28:51 Valerio linux (Ubuntu): status Incomplete Confirmed
2016-03-08 03:24:41 penalvch linux (Ubuntu): importance Low Medium
2016-03-08 03:24:41 penalvch linux (Ubuntu): status Confirmed Triaged