On Fri, Apr 15, 2005 at 07:11:44AM +0300, Alex Behar wrote:
> Hi Miki,
> in linux there is still no way for the user to chose the CPU a process is to
> be ran on; no way for the user to chose the affinity of the process. The
> scheduler takes care of that (quite well if I might add).
sched_setaf
Hi Miki,
in linux there is still no way for the user to chose the CPU a process is to
be ran on; no way for the user to chose the affinity of the process. The
scheduler takes care of that (quite well if I might add).
Single process cannot run at the same time on more then one CPU, that is where
Hi there. I'm running a bioinformatics server with RH 9.0 on a dual-xeon
machine with a mobo intel 7505 motherboard on 2 GB RAM. mysql refuses to
use both CPUs at once for any given process, and even if I run 2 mysql
queries at once, both are run on the same CPU. I've googled for this and
couldn't
Eli Kara wrote:
firebird is developed under Unix, and have Unix,Linux,Windows,SunOS
(Solrais -> also a unix) ports that work the same way on all of them.
When I was commenting on the lack of Win32 support I was referring to
PostgreSQL which is in beta for Win32 (running it under CYGWIN is not
nea
>
> firebird is developed under Unix, and have Unix,Linux,Windows,SunOS
> (Solrais -> also a unix) ports that work the same way on all of them.
>
When I was commenting on the lack of Win32 support I was referring to
PostgreSQL which is in beta for Win32 (running it under CYGWIN is not
nearly clo
Voguemaster wrote:
PostgresQL seems to have something like this, see:
http://www.sql.org/sql-database/postgresql/manual/arrays.html
(for those who need yet another reason to switch :-) )
Interbase/Firebird (firebird is open source based on interbase) also have arrays.
It's very fast ad very light,
Eli Kara wrote:
create table foo ( serial bar primary key, ...
That does NOT work on my PostgreSQL 7.4.3. What DOES work is:
(assuming you have table foo)
ALTER TABLE foo ADD COLUMN id int;// create an 'id' field, integer
CREATE SEQUENCE foo_id_seq; // create an auto-incremen
> create table foo ( serial bar primary key, ...
>
That does NOT work on my PostgreSQL 7.4.3. What DOES work is:
(assuming you have table foo)
ALTER TABLE foo ADD COLUMN id int;// create an 'id' field, integer
CREATE SEQUENCE foo_id_seq; // create an auto-incrementing seq.
ALTE
Voguemaster wrote:
Yes, PostgreSQL is a fine DB and there is every good reason to switch :-)
It only suffers from two main problems that I can see:
1. It's annoying to create a table with an auto-incremented field
(i.e: serial int)
For some reason you have to issue 4 commands... go figure their de
PostgresQL seems to have something like this, see:
http://www.sql.org/sql-database/postgresql/manual/arrays.html
(for those who need yet another reason to switch :-) )
Yes, PostgreSQL is a fine DB and there is every good reason to switch :-)
It only suffers from two main problems that I can see:
1
Omer Zak wrote:
Daniel Feiglin wrote:
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
booint,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really
Ido Kanner wrote:
Hi,
I guess no one will like my suggustion, but here it goes:
Use Firebird (http://www.firebirdsql.org), it does support arrays, but to use
them you need to write things like stored-procedures or UDF (an extention).
Hello folks!
I have a problem with SQL for MySQL (and pre4sumabl
Daniel Feiglin wrote:
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
booint,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really thrilled about
Daniel Feiglin wrote:
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
booint,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really thrilled about
Hello folks!
I have a problem with SQL for MySQL (and pre4sumably any other kind):
Can anone offer a RTFM do do something like this:
create table foo (
boo int,
bar varchar;
baz array[0..9] of int, # illegal, but needed!
...
);
I'm not really thrilled about stuff
-linux.org.il+AD4-
Sent: Thursday, August 24, 2000 9:46 PM
Subject: MySQL question
+AD4- Hi.
+AD4-
+AD4- According to the docs, MySQL listens for outside connections. I'm going to
+AD4- use MySQL from the localhost, and I don't want it to bind to the eth
+AD4- interface. Is there a way to restrict
AJ>> According to the docs, MySQL listens for outside connections.
AJ>> I'm going to use MySQL from the localhost, and I don't want it
AJ>> to bind to the eth interface. Is there a way to restrict it to
AJ>> the loopback interface?
In /etc/my.cnf:
[mysqld]
skip-networking
Prevents mysql from li
Hi.
According to the docs, MySQL listens for outside connections. I'm going to
use MySQL from the localhost, and I don't want it to bind to the eth
interface. Is there a way to restrict it to the loopback interface?
Yes, I know I can block it via ipchains, and don't worry, I will. However, I
wou
18 matches
Mail list logo
