It's possible. You have to fiddle with the mysql.ini and put the data dir on /run/shm. Runs very fast.
On Thu, 17 Mar 2016 12:19 Jeremy Evans, <[email protected]> wrote: > On Wednesday, March 16, 2016 at 1:30:26 PM UTC-7, Denny Wang wrote: >> >> I am new to Sequel so I may miss something. I am looking an in-memory >> database to for testing as we can't connect to a real database. The >> production database is MySql. I planned to use sqlite3 but there some >> syntax differences between them (like unsigned, type default and so on). I >> don't want to change these syntax for purpose of testing. I wonder is there >> a in memory database I can use for testing mysql2? >> >> In another hand, Mock database doing well on most cases unless it failed >> to get a column id on eager. Though eager_graph is fine but it's more >> expensive. >> > > There may be a way to setup a MySQL database using an in memory file > system. I haven't done that before, but I assume it is possible. If that > interests you, you may want to ask in a MySQL specific forum how to do so. > > I don't think there is a way to run MySQL in process memory like you can > with SQLite. > > Thanks, > Jeremy > > -- > You received this message because you are subscribed to the Google Groups > "sequel-talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sequel-talk. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sequel-talk. For more options, visit https://groups.google.com/d/optout.
