← Back to team overview

kernel-packages team mailing list archive

[Bug 1538040] Re: Internal Hard drive extremely slow unless using barrier=0 on ext4

 

Valerio, in order to allow additional upstream developers to examine the issue, at your earliest convenience, could you please test the latest upstream kernel available from http://kernel.ubuntu.com/~kernel-ppa/mainline/?C=N;O=D ? Please keep in mind the following:
1) The one to test is at the very top line at the top of the page (not the daily folder).
2) The release names are irrelevant.
3) The folder time stamps aren't indicative of when the kernel actually was released upstream.
4) Install instructions are available at https://wiki.ubuntu.com/Kernel/MainlineBuilds .

If testing on your main install would be inconvenient, one may:
1) Install Ubuntu to a different partition and then test this there.
2) Backup, or clone the primary install.

If the latest kernel did not allow you to test to the issue (ex. you couldn't boot into the OS) please make a comment in your report about this, and continue to test the next most recent kernel version until you can test to the issue. Once you've tested the upstream kernel, please comment on which kernel version specifically you tested. If this issue is fixed in the mainline kernel, please add the following tags by clicking on the yellow circle with a black pencil icon, next to the word Tags, located at the bottom of the report description:
kernel-fixed-upstream
kernel-fixed-upstream-X.Y-rcZ

Where X, and Y are the first two numbers of the kernel version, and Z is
the release candidate number if it exists.

If the mainline kernel does not fix the issue, please add the following tags:
kernel-bug-exists-upstream
kernel-bug-exists-upstream-X.Y-rcZ

Please note, an error to install the kernel does not fit the criteria of
kernel-bug-exists-upstream.

Also, you don't need to apport-collect further unless specifically
requested to do so.

Once testing of the latest upstream kernel is complete, please mark this
report Status Confirmed. Please let us know your results.

Thank you for your understanding.

** Tags removed: ext4 sata
** Tags added: latest-bios-205

** Description changed:

  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.
+ 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).
  
- 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
+  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
+  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
+  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
+  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.

-- 
You received this bug notification because you are a member of Kernel
Packages, which is subscribed to linux in Ubuntu.
https://bugs.launchpad.net/bugs/1538040

Title:
  Internal Hard drive extremely slow unless using barrier=0 on ext4

Status in linux package in Ubuntu:
  Incomplete

Bug 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.

  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.

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/linux/+bug/1538040/+subscriptions