dbqp.py needs better naming for shared memory symlinks

[Patrick Crews]

Need better naming / management of shared memory working directories we create.

[Patrick Crews (patrick-crews)]

Preparing branch that will create directories named dbqp_workdir_$username.
This will help prevent issues with permissions / user-user collisions.
Will need to investigate build-thread or other options later.

[Stewart Smith (stewart)]

On Fri, 28 Jan 2011 20:12:07 -0000, Patrick Crews <email address hidden> wrote:
> Preparing branch that will create directories named dbqp_workdir_$username.
> This will help prevent issues with permissions / user-user collisions.
> Will need to investigate build-thread or other options later.

Why not completely skip it and just use libeatmydata? We can even
preload it on OSX (if we get the foo correct, but it is possible). I
have not seen any situation where in any practical sense a tmpfs is
faster than libeatmydata (at least on Linux, and who cares about
anything else... besides, tmpfs is harder to find on others :).

--
Stewart Smith

[Patrick Crews (patrick-crews)]

libeatmydata is definitely on my radar. However, there are currently
several moving parts that we're still polishing / testing and using tmpfs
was simply quicker to have up and running : )

Since the code has been refactored, it won't be difficult to add
libeatmydata later on, but at the moment, we are going for what works with
minimal effort and thought to get the big picture better set.

On Fri, Jan 28, 2011 at 7:53 PM, Stewart Smith <email address hidden>wrote:

> On Fri, 28 Jan 2011 20:12:07 -0000, Patrick Crews <
> <email address hidden>> wrote:
> > Preparing branch that will create directories named
> dbqp_workdir_$username.
> > This will help prevent issues with permissions / user-user collisions.
> > Will need to investigate build-thread or other options later.
>
> Why not completely skip it and just use libeatmydata? We can even
> preload it on OSX (if we get the foo correct, but it is possible). I
> have not seen any situation where in any practical sense a tmpfs is
> faster than libeatmydata (at least on Linux, and who cares about
> anything else... besides, tmpfs is harder to find on others :).
>
> --
> Stewart Smith
>
> --
> You received this bug notification because you are a direct subscriber
> of the bug.
> https://bugs.launchpad.net/bugs/708865
>
> Title:
> dbqp.py needs better naming for shared memory symlinks
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications:
> Fix Released
> Status in Drizzle elliott series:
> Fix Released
>
> Bug description:
> Need better naming / management of shared memory working directories
> we create.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/708865/+subscribe
>