Re: [Maria-developers] MariaDB 5.5.35
Hi, Using a tmpfs directory as the tmpdir has its interest, changing it only because of warnings issued for temporaries InnoDB tables doesn't seems to be a solution. Anyway there is no point on using O_DIRECT on a filesystem in ram (on its normal usage at least). Issuing the warning once when the server starts and check the tmpdir could be enough. Regards. On 03/02/2014 19:09, Reindl Harald wrote: Am 03.02.2014 18:08, schrieb ImperialNetwork: I started to notice this on my error log since i upgraded from 5.5.34 to 5.5.35: 140203 5:26:25 InnoDB: Failed to set O_DIRECT on file /dev/shm/#sql7e8f6_1a94bc_10.ibd: CREATE: Invalid argument, continuing anyway 140203 5:26:25 InnoDB: O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662 I never seen this error/warning until 5.5.35. Should this be normal? output of /usr/bin/df -hT would be a good idea if you heave /tmp as tmpfs like more and more linux distributions set tmpdir in my.cnf somewhere else, O_DIRECT can not work on tmpfs by definition and that there was before no warning don't mean that it ever worked before there where many warnings in the past 6 months about config options which are deprecated or not work as someone may think the difference is works not silent or not silent in most cases ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Re: [Maria-developers] MariaDB 5.5.35
Am 04.02.2014 10:01, schrieb Jean Weisbuch: Using a tmpfs directory as the tmpdir has its interest especially if it leads to swap or is not large enough for a temp-table for a random operation leading to errors keep in mind that innodb_buffer_pool and other processes are fighting for the same RAM changing it only because of warnings issued for temporaries InnoDB tables doesn't seems to be a solution it's the solution for exactly the mentioned problem the other one is not using O_DIRECT O_DIRECT don't work on tmpfs by definition On 03/02/2014 19:09, Reindl Harald wrote: Am 03.02.2014 18:08, schrieb ImperialNetwork: I started to notice this on my error log since i upgraded from 5.5.34 to 5.5.35: 140203 5:26:25 InnoDB: Failed to set O_DIRECT on file /dev/shm/#sql7e8f6_1a94bc_10.ibd: CREATE: Invalid argument, continuing anyway 140203 5:26:25 InnoDB: O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662 I never seen this error/warning until 5.5.35. Should this be normal? output of /usr/bin/df -hT would be a good idea if you heave /tmp as tmpfs like more and more linux distributions set tmpdir in my.cnf somewhere else, O_DIRECT can not work on tmpfs by definition and that there was before no warning don't mean that it ever worked before there where many warnings in the past 6 months about config options which are deprecated or not work as someone may think the difference is works not silent or not silent in most cases signature.asc Description: OpenPGP digital signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
[Maria-developers] MariaDB 5.5.35
Hi, I started to notice this on my error log since i upgraded from 5.5.34 to 5.5.35: 140203 5:26:25 InnoDB: Failed to set O_DIRECT on file /dev/shm/#sql7e8f6_1a94bc_10.ibd: CREATE: Invalid argument, continuing anyway 140203 5:26:25 InnoDB: O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662 I never seen this error/warning until 5.5.35. Should this be normal ? Thank you in advance. Alex ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Re: [Maria-developers] MariaDB 5.5.35
Am 03.02.2014 18:08, schrieb ImperialNetwork: I started to notice this on my error log since i upgraded from 5.5.34 to 5.5.35: 140203 5:26:25 InnoDB: Failed to set O_DIRECT on file /dev/shm/#sql7e8f6_1a94bc_10.ibd: CREATE: Invalid argument, continuing anyway 140203 5:26:25 InnoDB: O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662 I never seen this error/warning until 5.5.35. Should this be normal? output of /usr/bin/df -hT would be a good idea if you heave /tmp as tmpfs like more and more linux distributions set tmpdir in my.cnf somewhere else, O_DIRECT can not work on tmpfs by definition and that there was before no warning don't mean that it ever worked before there where many warnings in the past 6 months about config options which are deprecated or not work as someone may think the difference is works not silent or not silent in most cases signature.asc Description: OpenPGP digital signature ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
[Maria-developers] MariaDB 5.5.35 Release Prep
All, I've begun the prep work for the MariaDB 5.5.35 release. The draft changelog and release notes are here: - https://mariadb.com/kb/en/mariadb-5535-changelog/ - https://mariadb.com/kb/en/mariadb-5535-release-notes/ Please let me know ASAP if there's anything that needs to be mentioned/highlighted/removed/etc... The release is still building in buildbot. If all goes well, the plan is to begin uploading the files to the mirrors later today and then to activate the release as soon as most mirrors have picked up the files. Thanks. -- Daniel Bartholomew MariaDB ___ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
