On May 20, 2010 09:55:41 pm Tim Gustafson wrote:
> > Use postgres, you can assign tablespaces to a partition
> > of the size you want. When it gets full, writes are
> > refused. I'm not sure how nicely that is handled ( in
> > terms of error output ) but the advantage is that Pg is
> > ACID compli
On May 20, 2010 08:32:56 pm Noel Butler wrote:
> On Thu, 2010-05-20 at 16:27 -0700, Tim Gustafson wrote:
> > Hi,
> >
> > I'm not sure if this is already an open issue or not - a Google search
> > resulted in various discussions but I didn't find any open
> > support/feature request.
> >
> > It w
On May 20, 2010 11:35:32 am John G. Heim wrote:
> Right now I have the spamassassin bayesian rules database in mysql myisam
> tables on our mail server. I want to move it to our database server.
> Mysqltuner tells me that the read/write ratio is 10/90. 90% writes.
>
> Given a database that is doi
How recent is your source tree? It looks like it may be a recent issue, so
going back 6 months or so
might solve it.
The bug report you noted doesn't seem to have a work-around, though I would
guess you could look at
the source and probably fix the issue quite easily. It looks like you have do
t; be a security issue as the vast majority of simple PHP-based SQL
> injection attacks only work on servers that allow multiple statements.
>
> I haven't been deep in PHP land for a little while, but I think you
> will find the default driver/config is expressly preventing you fr
Seriously...
I found the answer in the first result.
http://lmgtfy.com/?q=mysqli+multiple+insert+statements
Assuming mysqli, if you are using a different driver, then google that
Colin
On April 11, 2010 10:36:41 pm viraj wrote:
> is it mysqli query or 'multi_query'?
>
> http://php.net/manual/e
Yeah, its just a shell script that acts as a wrapper around the mysql processes
on debian systems(
maybe others, I'm not sure)
You can read it at 'less /usr/bin/mysqld_safe'
Colin
On March 29, 2010 11:51:36 am Glyn Astill wrote:
> --- On Mon, 29/3/10, Brown, Charles wrote:
> > Hello All. wh
what everyone else said... also, is there a longer version of the error? or is
it literally error 2
or error 22?
Colin
On February 1, 2010 06:38:08 pm kebede teferi wrote:
> Hi, I'm very new to this and I need help.
>
> What I want to do is to execute a source command statement from cmd to
>
I agree with Walter, a filesystem is far better suited for this.
That said, mysql does have the ability to do what you are saying, you would
just store it as a
binary blob which is well documented and quite easy to use.
See: http://dev.mysql.com/doc/refman/5.0/en/blob.html
Colin
On January 3
On January 18, 2010 01:34:15 pm Tompkins Neil wrote:
> Hi
>
> I'm in the process of designing a login system to a secure web page using
> MySQL. One of the features is we need to record and ensure that the user
> password is different from any of the last four passwords he/she has used.
> I was
On December 13, 2009 01:36:41 pm Richard Reina wrote:
> I was wondering if someone could lend a hand with the following query. I
> have table.
>
> SEARCHES
>
> |ID |trans_no|comp_id|result
>
> 13 | 455| 675| o
> 15 | 302| 675| o
> 16 | 455| 675| o
> 12 | 225|
On September 26, 2009 05:10:23 am bharani kumar wrote:
> courier_id consignor_name consignor_address consignor_destination
> consignor_phone
> consignee_name consignee_address consignee_destination consignee_phone
> s_date s_date_mm s_date_ss r_date r_date_mm r_date_ss
> consignment_description no_
On Friday 04 September 2009 08:15:35 pm muhammad subair wrote:
> On Sat, Sep 5, 2009 at 5:10 AM, mos wrote:
> > At 11:48 AM 9/4/2009, you wrote:
> >> One of my potential clients want to migrate their application to web
> >> based (PHP & MySQL), estimates of the data size is 24GB and growth per
> >
What sort of data? Is it currently stored in a database? If so, how many
tables?
24GB of text data in a single table is quite a bit, but manageable if
maintained properly.
24 GB of binary data on the other hand, is not very much at all.
Colin
On Friday 04 September 2009 12:48:18 pm muhammad
Because these are two quite distinct queries, I don't see an immediate way of
joining them that would make them more efficient. Something that comes to mind
are sub-select statements for example, but that would make this more complex
than it needs to be.
Like Robert said, you aren't giving us
On Thursday 27 August 2009 03:35:19 am Sameh Attia wrote:
> Hi,
>Part of our road map is to use an open source database besides
> commercial databases (oracle and sql server), we need to select an open
> source database to build the necessary skills fo
I know this is a mysql mailing list, but
LIKE '%,8,%' ?
Probably not as elegant as you were looking for, but it works :)
Colin
On Monday 06 July 2009 21:31:51 Highviews wrote:
> Hi,
> I have numbers separated with commas saved into a TEXT Field, for example:
>
> ROW1: 10,5,2,8,
> ROW2: 2,7,9,65
> ROW3: 99,100,55,10,88,
> etc...
>
>
>
17 matches
Mail list logo
