Re: Ssd vs mix of ssd and spinning disk
Am 08.05.2017 um 19:53 schrieb Shain Miley: Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc. I am wondering if going forward we should simply put all of the data on the ssd drives. Does anyone have any information on whether or not we would see any significant performance increase if we made this switch? I have been thinking about using 4 ssd drives (Raid-10) going forward…and wondering if we should expect to see any improvement in the database performance. Any thoughts? http://www.tansi.org/hybrid/ CAUTION: only works for RAID1 - not for linux RAID10 if i only woul dhave knwen that 10 years ago i would have my setups with 4 disks on two RAID1 with a RAID0 on top... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Ssd vs mix of ssd and spinning disk
Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc. I am wondering if going forward we should simply put all of the data on the ssd drives. Does anyone have any information on whether or not we would see any significant performance increase if we made this switch? I have been thinking about using 4 ssd drives (Raid-10) going forward…and wondering if we should expect to see any improvement in the database performance. Any thoughts? Thanks in advance, Shain
Re: tcmalloc mysql 5.7.14
I upgraded my mysql on my laptop to the MariaDB which is using the jemmalloc as you stated and that seems to work well. However on the servers it is running the Percona mysql 5.7.14 and there are no specific malloc libraries configured. >From what I understood , this then uses the normal OS malloc libraries , but this has proven to be problematic. So even if I can setup jemmalloc as a test to see if it makes a difference, that would help, however I am not sure how to enable / install it on percona mysql 5.7.14 though so this is where I need some help. I would really appreciate any help here. Regards On Mon, May 8, 2017 1:56 pm, Reindl Harald wrote: > > > Am 08.05.2017 um 13:51 schrieb Machiel Richards: > >> We are having an issue with memory allocations on mysql 5.7.14 whereby >> mysql is not releasing the memory that is being allocated during >> mysqldump processes. >> >> This has been logged as a bug with mysql dev team however they do not >> see this as a bug and suggested we test using another malloc library such >> as tcmalloc. >> >> However from what I can see, this is no longer included in mysql 5.7 >> and thus I am trying to find out if anyone can tell me how to enable / >> install this and how to tell mysql to use this library. > > does the oracle stuff not support "jemalloc" like MariaDB > > MariaDB even suppports "-DWITH_JEMALLOC=system" because it's not the job > of random software ship and build random library sources in their tarballs > which usually don't get much attention in case of updates (others than > system packages) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: tcmalloc mysql 5.7.14
Am 08.05.2017 um 13:51 schrieb Machiel Richards: We are having an issue with memory allocations on mysql 5.7.14 whereby mysql is not releasing the memory that is being allocated during mysqldump processes. This has been logged as a bug with mysql dev team however they do not see this as a bug and suggested we test using another malloc library such as tcmalloc. However from what I can see, this is no longer included in mysql 5.7 and thus I am trying to find out if anyone can tell me how to enable / install this and how to tell mysql to use this library. does the oracle stuff not support "jemalloc" like MariaDB MariaDB even suppports "-DWITH_JEMALLOC=system" because it's not the job of random software ship and build random library sources in their tarballs which usually don't get much attention in case of updates (others than system packages) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
tcmalloc mysql 5.7.14
Hi Guys I hope this mail finds everyone well. We are having an issue with memory allocations on mysql 5.7.14 whereby mysql is not releasing the memory that is being allocated during mysqldump processes. This has been logged as a bug with mysql dev team however they do not see this as a bug and suggested we test using another malloc library such as tcmalloc. However from what I can see, this is no longer included in mysql 5.7 and thus I am trying to find out if anyone can tell me how to enable / install this and how to tell mysql to use this library. I need to do some tests in order to see if this will resolve the memory issues. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql