Web Hosting Forum | Lunarpages


*
Welcome, Guest. Please login or register.
Did you miss your activation email?



Login with username, password and session length
May 24, 2012, 11:50:29 AM

Pages: [1]   Go Down
  Print  
Author Topic: InnoDB tables  (Read 2321 times)
Gav-Aus
Trekkie
**
Offline Offline

Posts: 12


WWW
« on: March 20, 2007, 11:54:47 PM »

G Day Guy's,

I did a search to see where Lunar was at with regards to InnoDB tables and the lastest post found was late 2006. All I wanted to know was if these tables were allowed as yet or under sonsideration?

I left for a provided who allows InnoDB tables as this is a must for one of my sites, was not keen to move on and whilst service is good and support great I would love to be able to return to Lunar.

Cheers
Gavin
Logged
RandyT
Guest
« Reply #1 on: March 21, 2007, 12:15:33 AM »

Hey Gav-Aus, thanks for your interest in coming back to Lunarpages !

Unfortunately we cannot support the InnoDB table type on our shared servers
due to the overhead in memory and processor time it uses. Currently MyISAM is only allowed. If you need  InnoDB, you would need to have a dedicated server.

I hope this was helpful,
RandyT
Logged
Lupine1647
Berserker Poster
*****
Offline Offline

Posts: 10868


« Reply #2 on: March 21, 2007, 08:44:22 AM »

I also wanted to make a note that you would have the ability to use InnoDB on our VPS servers as well.
Logged
Gav-Aus
Trekkie
**
Offline Offline

Posts: 12


WWW
« Reply #3 on: December 10, 2009, 08:41:17 PM »

Really really old post,

I ended up relocating for some time as this was not available and am now looking to return, as such I ask if this has change since my original post or still remains as noted.
Logged
katrina1
Guest
« Reply #4 on: December 10, 2009, 11:44:52 PM »

Hi. Yes it has changed. We have designed our own control panel, LPCP, which all new accounts are now placed on. LPCP uses a separate Mysql server which allows us to now offer support for Innodb.
Logged
findch2
Newbie
*
Offline Offline

Posts: 4


« Reply #5 on: November 01, 2010, 05:09:46 AM »

I know there is table locking for MySQL It works in your MySQL database.

lock tables temp write;
unlock tables;

But it is too costly in my case. I would prefer row locking. I successfully created a table with ENGINE=InnoDB, however, when I tried row locking by using:

SELECT ... LOCK IN SHARE MODE;
SELECT ... FOR UPDATE;

They both error out.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 2

Do you know how I can do row locking in MySQL?

Thanks,

Xiaotian
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: