locking the queries mysql ibatis

[deligeli]

hi,

i am hosting my application on shared hosting.

i have about 1GB of data (around 600000 records in a table).

according to the host services, i lock the queries in mysql and overload their service.

how could it happen? i use regular ibatis queries + caching.

is there a way not to lock it? what does it actually mean?

[Clinton Begin]

You're going to have to analyze the situation.  The iBATIS list can't answer this question for you.

However, if your hosting service is the one complaining, it's probably not literally locking, you're probably just overloading the IO on their servers.  

Clinton  

On Sun, Oct 25, 2009 at 8:49 PM, deligeli <odelya@...> wrote:

hi,

i am hosting my application on shared hosting.

i have about 1GB of data (around 600000 records in a table).

according to the host services, i lock the queries in mysql and overload
their service.

how could it happen? i use regular ibatis queries + caching.

is there a way not to lock it? what does it actually mean?
--
View this message in context: http://www.nabble.com/locking-the-queries-mysql-ibatis-tp26054041p26054041.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@...
For additional commands, e-mail: user-java-help@...

[nmaves]

If they were trying to tell you that you have database locking issues you should start to read here http://en.wikipedia.org/wiki/Lock_(database). 

As Clinton states we can't debug your application for you.  If you come to this community with a specific ibatis issue we will gladly help.

Get some more information from your hosting company and narrow down your issue.

Nathan

On Sun, Oct 25, 2009 at 9:09 PM, Clinton Begin <clinton.begin@...> wrote:

You're going to have to analyze the situation.  The iBATIS list can't answer this question for you.

However, if your hosting service is the one complaining, it's probably not literally locking, you're probably just overloading the IO on their servers.  

Clinton  

On Sun, Oct 25, 2009 at 8:49 PM, deligeli <odelya@...> wrote:

hi,

i am hosting my application on shared hosting.

i have about 1GB of data (around 600000 records in a table).

according to the host services, i lock the queries in mysql and overload
their service.

how could it happen? i use regular ibatis queries + caching.

is there a way not to lock it? what does it actually mean?
--
View this message in context: http://www.nabble.com/locking-the-queries-mysql-ibatis-tp26054041p26054041.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@...
For additional commands, e-mail: user-java-help@...

[deligeli]

so you mean that once i switch to VPS it will be fine?

my queries are declared like this:

<settings cacheModelsEnabled="true" />
        <transactionManager type="JDBC" commitRequired="false">
                <dataSource type="SIMPLE">
                        <property value="${driver}" name="JDBC.Driver" />
                        <property value="${url}" name="JDBC.ConnectionURL" />
                        <property value="${username}" name="JDBC.Username" />
                        <property value="${password}" name="JDBC.Password" />
                </dataSource>
        </transactionManager>

is there any parameter that i can add to it?

Clinton Begin wrote:

You're going to have to analyze the situation.  The iBATIS list can't answer
this question for you.

However, if your hosting service is the one complaining, it's probably not
literally locking, you're probably just overloading the IO on their servers.


Clinton



On Sun, Oct 25, 2009 at 8:49 PM, deligeli <[e-mail]> wrote:

>
> hi,
>
> i am hosting my application on shared hosting.
>
> i have about 1GB of data (around 600000 records in a table).
>
> according to the host services, i lock the queries in mysql and overload
> their service.
>
> how could it happen? i use regular ibatis queries + caching.
>
> is there a way not to lock it? what does it actually mean?
> --
> View this message in context:
> http://www.nabble.com/locking-the-queries-mysql-ibatis-tp26054041p26054041.html
> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [e-mail]
> For additional commands, e-mail: [e-mail]
>
>