Re: Table creation fail

Correct, a primary key is used to uniquely identify each row in a table. It can either be part of the actual record itself , or it can be an artificial field (one that has nothing to do with the actual record). A primary key can consist of one or more fields on a table. When multiple fields are use

Re: Altering database size to add more space

There is 2 way to check databases size : A. OS level, you can do *#du -hs *of data dir , it will show current usages of you database size at File system level. B. You can also check on Database level check details here

Re: selecting data for computation

Hrmm, something didn't work quite right. Here's the actual query: select x, y, zoom from map_images where image_data_size = 0 and get_lock(concat(x, ',', y, ',', zoom), 0) = 1 order by zoom , sqrt(pow(x, 2) + pow(y, 2)) limit 1 I've added the image_data_size column and indexed it, and set its cu

Re: selecting data for computation

> select * from work_packets where work_data is null and get_lock(id,0)=1 > limit 1; Sorry, I should have said that my example was pseudo-code that I was typing from memory. The query you've suggested is certainly an improvement - I don't know why I though that the get_lock needed to be in a subq

Re: selecting data for computation

In the last episode (Jun 24), Tim Gustafson said: > I'm working on a compute job that queries mySQL for work packets, > processes the work packet and then updates the row in mySQL with the > results of the job. > > Currently, from each compute instance I'm doing something like: > > select * from

selecting data for computation

I'm working on a compute job that queries mySQL for work packets, processes the work packet and then updates the row in mySQL with the results of the job. Currently, from each compute instance I'm doing something like: select * from work_packets where work_data is null order by rand() limit 1; T

Re: Altering database size to add more space

What do you mean "time to increase"? What tells you that? A database's size is determined by the amount of available diskspace. If you need more than the filesystem that it is currently on has, then you can either move the entire schema (which is synonymous to "database") to another filesystem a

Re: Altering database size to add more space

what is the innodb file size that u have specified in my.cnf. If the last file is autoextend, that this will grow to the size of the disk space avaliable. regards anandkl On Thu, Jun 24, 2010 at 7:43 PM, Sarkis Karayan wrote: > I feel like I am missing something, because I am not able to find t

Altering database size to add more space

I feel like I am missing something, because I am not able to find the answer to this simple question. How can I increase the size of a database? I am using the following query to check the available space and notice that it is time to increase. SELECT table_schema AS 'Db Name', Round( Sum( d

MySQL Cluster Out of fragment records (increase MaxNoOfOrderedIndexes)

Dear All,   I want to add one column in my existing NDB table. While adding column in to the table I am getting this error:-    | Level | Code | Message                                                                           Error | 1296 | Got error 904 'Out of fragment records (increase MaxNoOfO

Re: [Spam][78.6%] Re: Differences between 2 MySQL instances

and select found_rows() but it is much slower than a simple select(*). Thanks. Octavian __ Information from ESET NOD32 Antivirus, version of virus signature database 5224 (20100624) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com -- MySQL Gener

Re: MySQL Replication

2010/6/24 Tompkins Neil : > Hi > > Regarding two-way replication what do you mean by "very > controlled environment" ?  What things do I need to consider ? Control at application level that you are not going to insert/update/delete the same record on the two servers. Even if MySQL gives some suppo

Re: Differences between 2 MySQL instances

Hi! Octavian Rasnita wrote: > I have tried, but with no difference. > > I have changed some indexes and made the queries run faster, but I still > found a problem: > > I use a module that does paging and it makes a select(*) and this query takes > a very long time. > > I have also tried to d

Re: Table creation fail

Hi David, all! David Stoltz wrote: > Actually, > > > > That table isn't supposed to have a PK, so I removed that, and it > works...same effect you suggested. Even if you currently don't need a primary key in that table, IMO you should still define one. Use some 'id_testresult' column with an

Re: MySQL Replication

You could have a look at the more recent 5.1 releases, those support semi-synchronous replication iirc. On Thu, Jun 24, 2010 at 10:50 AM, Tompkins Neil < neil.tompk...@googlemail.com> wrote: > Thanks for your quick response. > > Basically our need for replication is because our websites access a

Re: MySQL Replication

Hi Regarding two-way replication what do you mean by "very controlled environment" ? What things do I need to consider ? Cheers Neil 2010/6/24 Jaime Crespo Rincón > 2010/6/24 Tompkins Neil : > > HI, > > > > We have set-up MySQL Community Server 5.1.46 with Master to Slave > > replication and

Re: MySQL Replication

Thanks for your quick response. Basically our need for replication is because our websites access a local MySQL database - which is fine. In our remote office, we also need to access this MySQL database too however the connect time/ query speed is very slow. At the moment the application in the

Re: MySQL Replication

On 24/06/2010 09:18, Tompkins Neil wrote: HI, We have set-up MySQL Community Server 5.1.46 with Master to Slave replication and everything appears to be working correctly, however I have a couple of questions which I hope somebody can shed some light. (1) When the network connection goes down b

Re: MySQL Replication

2010/6/24 Tompkins Neil : > HI, > > We have set-up MySQL Community Server 5.1.46 with Master to Slave > replication and everything appears to be working correctly, however I have a > couple of questions which I hope somebody can shed some light. > > (1) When the network connection goes down between

MySQL Replication

HI, We have set-up MySQL Community Server 5.1.46 with Master to Slave replication and everything appears to be working correctly, however I have a couple of questions which I hope somebody can shed some light. (1) When the network connection goes down between the master and slave servers, it woul

Re: MySQL Replication - Master-Slave crash

Dear Nilnandan,   Thanks for the quick reply.    But this particular variable is not working in only one proc call...but rest all procedures creating temporary tables, does not affect my replication slaves.   So I am not able to identify the problem.   Here's the snapshot of my procedure which is