The original message was received at Thu, 11 Nov 2004 07:43:36 +0100
from natur.cuni.cz [167.249.38.145]
- The following addresses had permanent fatal errors -
<[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://l
I want to make a small simple database that searches
by state or zip code for jobs. I would enter just a
job description, job position and job id #. so 3
fields display. I want to enter in the information by
an admin area but not a big deal. How hard would this
be to create. Help please. Thanks
Ah, I see now. That makes sense. Sorry to have been so dense.
Michael
Paul DuBois wrote:
At 21:37 -0500 11/10/04, Michael Stassen wrote:
Paul DuBois wrote:
At 21:11 -0500 11/10/04, Michael Stassen wrote:
Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL
valu
I have three tables:
reviews
users
movies
I am trying to select the latest 4 reviews for DIFFERENT movies.
I can use the following query:
SELECT reviews.movies_id, movies.movie_title, users.name,
reviews.rating, reviews.post_d FROM reviews, users, movies WHERE
reviews.user_id = users.user_id a
Heikki,
I can think of another explanation. Are you sure that all your tables
really are in .ibd files? Maybe some older tables are actually in the
ibdata files?
Yes I'm sure they're all in .ibd files (and I've just checked just in case
- they are indeed).
Please use the innodb_tablespace_monito
At 21:37 -0500 11/10/04, Michael Stassen wrote:
Paul DuBois wrote:
At 21:11 -0500 11/10/04, Michael Stassen wrote:
Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL
values. Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result t
Heikki,
the output shows that there are no dangling transactions, and purge is
not lagging behind.
Yes, that's what I thought... weird, huh :/
If you update a secondary index column, that requires purge to clean up
the index.
The tables have structure similar to the following:
create table table1
Paul DuBois wrote:
At 21:11 -0500 11/10/04, Michael Stassen wrote:
Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL
values. Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result that can be used as a properly
escaped data val
Hi mike,
as i have mentioned in my previous mail
the table structure which i am using is as fallows,
CREATE TABLE IND_KAR_BNG_Metallica_PS_RT_4
(
gan_id INTEGER NOT NULL,
bsc_id INTEGER NOT NULL,
bts_id INTEGER NOT NULL,
bd_type VARCHAR(10) NOT NULL,
bd_i
i was mistaking before, query is more like :
SELECT MyField, count(id) from MyRec where string_field="somestring"
group by field;
and it's explain is :
+-+--+---++-+++-+
| table | type | possible_keys | key| key_len | ref
At 21:11 -0500 11/10/04, Michael Stassen wrote:
Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL
values. Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result that can be used as a properly
escaped data value in an SQL stateme
Paul DuBois wrote:
At 11:35 +1300 11/11/04, Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL values.
Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result that can be used as a properly
escaped data value in an SQL statement.
Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL values.
Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result that can be used as a properly
escaped data value in an SQL statement. The string is returned
surrounded by single
What does
EXPLAIN SELECT * from rec where string_field='somestring';
say?
Michael
Dan Sashko wrote:
hi i have a recordset of about 4 mil records,
SELECT * from rec where string_field="somestring"
takes very long time (30+ sec). string_field is indexed MUL. Is there way to
make it faster?
--
M
hi i have a recordset of about 4 mil records,
SELECT * from rec where string_field="somestring"
takes very long time (30+ sec). string_field is indexed MUL. Is there way to
make it faster?
At 15:19 -0500 11/10/04, Kirti S. Bajwa wrote:
Hello List:
System: RH9, MySQL 4.1.7
I am in the process of re-setting up (I have test setup 4-5 times) a data
server with the above software. This server consists of 2-CPU (Intel)
RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250
Hi Mark,
The system in question has 1GB of RAM in it. As far
as I can tell, the box does not get stuck swapping
when the system has a query (or several) in this
state. If I log in via the command line client and
kill the query, the system continues on it's way like
nothing was wrong in the first
Hello List:
System: RH9, MySQL 4.1.7
I am in the process of re-setting up (I have test setup 4-5 times) a data
server with the above software. This server consists of 2-CPU (Intel)
RAID-1, 1-40GB IDE HDD for O/S & 2-250GB IDE HDD for storing data. 250 GB
IDE HDD are mirrored (RAID-1).
Previously
First echo out the SQL and verify it is what you are expecting. If it
isn't try changing it to:
$sql =
'SELECT F.IDArea,
C.IDArea,
C.Name,
C.Pop,
C.Nationality,
C.NationalityPlural,
C.NationalityAdjective
FROM cia_people C, famarea2 F
WHERE (C.Nati
In my experience, inserting into a table with a unique key and more than
5 million records can be very slow because (AFAIK) it has to scan the
entire index to check if the new record is unique from the PRIMARY KEY's
point of view. (I think)
If you don't have much ram (your 128 meg key buffer sugge
Here's the whole the query, table structure, table
length and show variables output:
mysql> desc summary;
+-+--+--+-+-++
| Field | Type | Null |
Key | Default | Extra
John,
I can think of another explanation. Are you sure that all your tables really
are in .ibd files? Maybe some older tables are actually in the ibdata files?
Please use the innodb_tablespace_monitor to print the contents of the ibdata
files.
Do like this:
mysql> create table innodb_tablespace
At 11:35 +1300 11/11/04, Toro Hill wrote:
Hi all.
I have question about how the function quote() works with NULL
values. Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result that can be used as a properly
escaped data value in an SQL statement. The string is retur
John,
the output shows that there are no dangling transactions, and purge is not
lagging behind.
If you update a secondary index column, that requires purge to clean up the
index.
Please shut down mysqld, remove
innodb_file_per_table
from my.cnf, and restart mysqld. Then do
CREATE TABLE test.t(
String operations with null values always result in null.
(none)> select 'tacos' = null;
++
| 'tacos' = null |
++
| NULL |
++
1 row in set (0.00 sec)
-Eric
On Thu, 11 Nov 2004 11:35:58 +1300, Toro Hill <[EMAIL PROTECTED]> wrote:
> Hi all
The parts I am interested in:
(I won't bore you with the fields not relevant to this problem )
CREATE TABLE events (
e_id int(15) NOT NULL auto_increment,
e_owner int(15) NOT NULL default '0',
e_time int(15) NOT NULL default '0',
other junk omitted
PRIMARY KEY (e_id)
) TYPE=MyISA
Hi all.
I have question about how the function quote() works with
NULL values. Here is what the mysql manual say:
---
QUOTE(str)
Quotes a string to produce a result that can be used as a
properly escaped data value in an SQL statement. The string
is returned surrounded by single quotes and with
It's not translating your vars to their respective values.
I didn't look to see why...
But MySQL doesn't know what
$_POST['order']
is.
David Blomstrom wrote:
This may be a purely PHP problem, but the error
message says "SQL syntax. Check the manual that
corresponds to your MySQL server version.
Hi,
If I set the table cache to 2 how much memory will it consume? And
how much latency is there when mysql has to open a table before
executing a query?
Some background:
I have a database with around 1000 tables. I'll have roughly 20
concurrent connections to the DB. And in my queries I'll
Please include the full query you're running, the table structure, and
the number of rows in the table. A dump of 'show variables;' would be
helpful too.
On Wed, 2004-11-10 at 21:44, foo bar wrote:
> Hi Everyone,
>
> I've been Googling unsuccessfully for specific issues
> relating to queries run
This may be a purely PHP problem, but the error
message says "SQL syntax. Check the manual that
corresponds to your MySQL server version..."
More important, I haven't been able to find a solution
on any PHP forums. :)
This is the complete error message:
Failed to run SELECT F.IDArea, C.IDArea, C
In message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes
It's a shorthand way to say that I wanted to group on the first two
columns of my select statement.
Here's a quote from the manual:
http://dev.mysql.com/doc/mysql/en/SELECT.html
Columns selected for output can be referred to in ORDER BY an
Hi Everyone,
I've been Googling unsuccessfully for specific issues
relating to queries run on MySQL version 4.0.16
against "tmp" tables. I have witnessed several
occurrences where queries running on various platforms
hang in a "Copying to tmp table" state for hours or
days at a time. When the sa
It's a shorthand way to say that I wanted to group on the first two
columns of my select statement.
Here's a quote from the manual:
http://dev.mysql.com/doc/mysql/en/SELECT.html
>>>
Columns selected for output can be referred to in ORDER BY and GROUP BY
clauses using column names, column alia
Try something like this:
SELECT Events.ID, Events.ownerID, Owners.ownerID
FROM Events
LEFT JOIN Events AS Owners
ON Events.ownerID=Owners.ownerID AND Events.eventData> 3 months ago
WHERE Owners.ownerID IS NULL
I know you want to do a delete, but play with SELECT first to make sure
it's doing what
In message
<[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes
Change one of your INNER JOINS to a LEFT JOIN. (The comma separated
list of table names is actually a sneaky way to declare INNER JOINS).
That way you will see all of the _objectives records whether or not
they appear in _iso or any of the
If you post the table structure (SHOW CREATE TABLE tablename\G) we could
help you write this statement.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Gerald Taylor <[EMAIL PROTECTED]> wrote on 11/10/2004 11:52:35 AM:
> I have this table of events. Each event has an owner
>
Change one of your INNER JOINS to a LEFT JOIN. (The comma separated list
of table names is actually a sneaky way to declare INNER JOINS). That way
you will see all of the _objectives records whether or not they appear in
_iso or any of the other tables.
SELECT_objectives.id,
_objectives
Hi All,
InnoDB tables as the solution is incorrect.
I've been running some fairly large InnoDB databases,
and crashes using InnoDB are probably ALOT worse than
with MyIsam tables.
InnoDB tables tend to corrupt very easily on such things
as power outages, with corrupted page data error which means
Just so it is known, repl_user, the replication account, has full access
on the master database to do everything from any host '%'.
Here is my log output on server2:
041110 8:59:01 Slave SQL thread initialized, starting replication in
log 'server1-bin.054' at position 3646268, relay log
'./se
At 01:36 AM 11/9/2004, you wrote:
25 lakh records..
What is "lakh"? Thousand? Million?
What does your query look like?
Did you put "Explain" in front of your query to determine which indexes are
being used?
How many rows is the query returning?
Mike
--
MySQL General Mailing List
For list archives
Hi,
The following select returns how many times an id from table _objectives
is used in table _iso which it does fine but I need it to return
_objectives.id that are not used in table _iso.
SELECT
_objectives.id,
_objectives.name,
COUNT(go._iso._objective_id)
FROM
go._objectives, go._subjectHead
Turns out to be 4.1.7
This suggestion fixed my query, thanks.
I'd tried that approach yesterday, but it was on an older
version of MySQL (on our non-production server; I wasn't paying attention
to the versions of MySQL betw. our test and production servers) - so my
previous attempts with this syn
Hi there,
I need to use the mysql.h library in an AIX
version 5.2 machine.
First, I tried downloading the precompiled binaries
for AIX, but when I tried to compile a simple .c file,
I got the following errror:
cc mysql_test.c -o mysql_test
-I/usr/local/include/mysql -lmysqlclient
ld: 07
Lana,
> You have been asking this question for quite a while now. I think that you
> do not have a satisfactory answer yet because I do not believe there is an
> EXCEPT operator in the MySQL vocabulary. If you could post a link to the
> page from the MySQL manual that shows this operator, we can
Starting with 4.0, when you do a LOAD DATA INFILE on the
master, it actually writes the full insert in the binary
log, which the slave then reproduces.
And if any gurus are listening, I /believe/ that setting
max_allowed_packet on the master and slave to the same value
prevents any "Packet too larg
In the last episode (Nov 10), Dave Dyer said:
> I have a family of applications which use the C api to access mysql.
>
> I found by doing a test upgrade to 4.1 that all of these applications
> crash, apparently because the structures passed between my
> applications and libmysql.dll are incompatib
The directory mysql is a symbolic link to one of the other dirs.
If mysql points to old one rename it and make a new one:
mv mysql mysqlold
ls -s mysql-max-4.1.7-apple-darwin7.5.0-powerpc mysql
Do not remove
mysql-max-4.0.20-apple-darwin7.3.0-powerpc/data
it contains your old databases!!!
Santino
I provided the list below for our programmers, who also are dealing with
a switch from 3.23 to 4.1. Perhaps it would be of some help for you.
Cheers,
--V
-
We've already hit a couple of API-related problems with the new version
of MySQL. To try to make things a little easier, and b
Hi,
Is there anything your mysql errog log? Did MySQL crashed or stopped
unexpectedly while the script was running? I guess it is probably something
with your memory usage configuration - please send your my.cnf file and on
what machine you are running your MySQL server.
--
Dobromir Velev
[EMA
Did you upgrade to 4.0.17 or 4.1.7? In 4.1, you have to use the alias
between FROM and USING:
DELETE FROM rls USING rsrc_linx_specialty rls,...
This is documented at the bottom of the manual page you referenced.
Michael
[EMAIL PROTECTED] wrote:
I had a working query that suddenly doesn't work
Two possibilities:
1) mysqld could not create /tmp/mysql.sock because it is already there,
which would mean mysqld is already running. It appears you've ruled this out.
2) User mysql does not have permission to write to /tmp. In Mac OS X, /tmp
is a symlink to /private/tmp, so this really means
I had a working query that suddenly doesn't work anymore.
It follows the syntax found in the documentation at
http://dev.mysql.com/doc/mysql/en/DELETE.html
specifically,
DELETE FROM t1, t2 USING t1, t2, t3 WHERE t1.id=t2.id AND t2.id=t3.id;
my query is:
DELETE FROM rsrc_linx_specialty USING rsrc_
I have a family of applications which use the C api to access mysql.
I found by doing a test upgrade to 4.1 that all of these applications
crash, apparently because the structures passed between my applications
and libmysql.dll are incompatible. Recompiling the applications fixes
the problem, b
I have this table of events. Each event has an owner
id and the time that it happened.
What I want to do is delete all events
more than three months old but only if the owner does not own
any newer events.
The coolest would just be a single DELETE query.
Can this be done?
Mysql 4.0.18
--
MySQL G
Thanks you for your answer.
I have just tried what you said.
It doesn't work.
I type :
Raspoutine3:/usr/local/mysql/bin admin$ sudo ./mysqld_safe --user=mysql --log
Starting mysqld daemon with databases from /usr/local/mysql/data
041110 20:33:42 mysqld ended
Here are the line in the file
'Raspo
I'm kind of new to the SSL scene.
I've read all I can find on MySQL.org about setting up and using SSL.
I'm on MySLQ 4.20 and have built mysql after configuring with --use-vio
and --use-openssl. HAVE_OPENSSL = YES. I can handle setting up the
user talbe and GRANTS to require SSL for users and con
Hello.
Remove coma from 'POINT(1,1)', instead use 'POINT(1 1)';
See:
http://dev.mysql.com/doc/mysql/en/Populating_spatial_columns.html
>I installed mySQL server from Wizard and then i create table:
>create table geom ( g POINT) ENGINE = MYISAM;
>but i can't add any object to the table
Hello.
To search for `\', specify it as `' (the backslashes are stripped once by
the parser and another time when the pattern match is done, leaving a single
backslash to be matched).
Steve Buehler <[EMAIL PROTECTED]> wrote:
> I am trying to find everything in a column that has a backs
Hi.
As Shawn Green said:
"I read through every TODO listed in the manual and didn't see it there. I also
queried the Bugs list looking for any other issue or feature requests that were
similar but didn't find any others. So, I assume that the problem is still in
the analysis phase (or is s
Hello.
Check if another copy of mysqld process is running
(may be it runs with lost mysql.sock file?).
Check also permissions for .err file. And be sure you are starting MySQL as
root, because it will suid to the user you have specified.
See:
http://dev.mysql.com/doc/mysql/en/Startin
Yes, there can be a small lag in data updates, in fact
I believe the lag time will be less than a second
considering our architecture.
We have been considering replication as a solution but
have been hesitant to do so because I have heard there
are problems with data inserted through a LOAD DATA
I was running ver 4.0.15 and just upgraded to the latest version of 4.1.7. In
between I had done an upgrade to ver. 4.0.20. I can get the server to start and
stop via the Preferences panel but before and after any upgrade it indicates
that 4.0.15 is running. In Navicat which I use as the gui fro
TRUE and FALSE are the integers 1 and 0, respectively. ENUMs hold strings
which are assigned numbers starting with 1. That means that
WHERE enum_col = TRUE
will match rows whose enum_col has the *first* value defined in the ENUM list.
Also, every ENUM has the special error value '' in positio
I think you started with good advice then took a strange turn.
Chris Blackwell wrote:
If you want an enum to have the possible values of NULL or 1
alter table `Associate` modify `Active` enum('1');
from the mysql manual
http://dev.mysql.com/doc/mysql/en/ENUM.html
If an ENUM column is declared to a
I am setting up a master-master replication.
I have the masters set up correctly (I guess), and they update their
position when changes occur. 'show slave status' and 'show master
status' both show the correct positions between each server.
However. Although the slave position increments to matc
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] writes:
> I would suggest that if you want to compare against FALSE that you make
> that one of your enumerated values. I would also make FALSE your default
> value and the field not nullable. That way you don't have 3 possible
> values to compa
I got it made, Active enum('1') works. Thanks everyone!
I had to import old database into MySQL with '1','0' as default. I wanted to
enumerate it so that I can easily use False/true without altering anything
in the current database configurations.
-Original Message-
From: Jay Blanchard [m
Can there be a small lag between servers? If a second or two
is acceptable, this sounds like a perfect environment for
replication:
http://dev.mysql.com/doc/mysql/en/Replication.html
Basically, when the master writes something to the database,
it also logs the transaction to a log file. The slave s
You could use the IF() function and key off of the id value like this:
SELECT if(id=0, null, id) as id, if(id=0,null, field2) as field2, if(id=0,
null, field3) as field3
FROM tablename
However, if you don't want any rows with 0 as an ID, you take care of that
in the WHERE clause
SELECT id
FROM
[snip]
mysql> select count(*) from Associate where Active=FALSE;
mysql> select count(*) from Associate where Active=TRUE;
[/snip]
Why don't you set enum('TRUE','FALSE')? I ask this because normally you
would query, when using NULL (all caps), WHERE Active IS NULL or IS NOT
NULL.
I believe that yo
- Original Message -
From: "Martin Rytz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 10, 2004 9:45 AM
Subject: Suppress the 0 value
> Hi MySQL-Users
>
> I have a simple select statement like 'select id from table'. The result
is
> 0, becaues the id field is 0 (
I would suggest that if you want to compare against FALSE that you make
that one of your enumerated values. I would also make FALSE your default
value and the field not nullable. That way you don't have 3 possible
values to compare against in your field (null, empty string, and 1). If
you need
If you want an enum to have the possible values of NULL or 1
alter table `Associate` modify `Active` enum('1');
from the mysql manual
http://dev.mysql.com/doc/mysql/en/ENUM.html
If an ENUM column is declared to allow NULL, the NULL value is a legal
value for the column, and the default value is
It sounds to me like they want two databases (they probably need to be on
two separate servers) and that your logging application may need to pull
double duty. You are being asked to keep an OLTP database in sync with an
OLAP database in real time. That means that you probably need to commit
ch
Made changes, now the problem has reversed:
mysql> select count(*) from Associate where Active=FALSE;
+--+
| count(*) |
+--+
| 2611 |
+--+
1 row in set (0.01 sec)
mysql> select count(*) from Associate where Active=TRUE;
+--+
| count(*) |
+--+
|
From: Mike Johnson [mailto:[EMAIL PROTECTED]
> From: Martin Rytz [mailto:[EMAIL PROTECTED]
>
> > Hi MySQL-Users
> >
> > I have a simple select statement like 'select id from table'.
> > The result is 0, becaues the id field is 0 (int-field).
> >
> > My problem is now how to suppress the 0
From: Martin Rytz [mailto:[EMAIL PROTECTED]
> Hi MySQL-Users
>
> I have a simple select statement like 'select id from table'.
> The result is 0, becaues the id field is 0 (int-field).
>
> My problem is now how to suppress the 0 and give NULL instead
> of 0 as the result (i.E. everytime the
Hi MySQL-Users
I have a simple select statement like 'select id from table'. The result is
0, becaues the id field is 0 (int-field).
My problem is now how to suppress the 0 and give NULL instead of 0 as the
result (i.E. everytime the result from the select is 0 it should be NULL).
How can thi
Lana,
You have been asking this question for quite a while now. I think that you
do not have a satisfactory answer yet because I do not believe there is an
EXCEPT operator in the MySQL vocabulary. If you could post a link to the
page from the MySQL manual that shows this operator, we can help
[snip]
I'm trying to figure out how to make Active's null as FALSE and '1' as
TRUE,
in enum point of view
| Active | enum('','1') | YES | | NULL|
|
[/snip]
I have not tested this but have you tried enum('NULL', '1') ?
--
MySQL General Mailing List
For list archives: http://
Selon Harald Fuchs <[EMAIL PROTECTED]>:
> In article <[EMAIL PROTECTED]>,
> Julien ALLANOS <[EMAIL PROTECTED]> writes:
>
> > Well, I've tried the following scenario:
>
> > 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
> > 2/ User B: SET GLOBAL TRANSACTION ISOLATION LEVEL READ C
I am trying to find everything in a column that has a backslash in it and
the select statement that I am trying to use doesn't find any of them. My
statement is:
SELECT * FROM `team` WHERE `name` LIKE '%\%'
I have also tried:
SELECT * FROM `team` WHERE `name` LIKE '%\\%'
Any idea how to search
I'm trying to figure out how to make Active's null as FALSE and '1' as TRUE,
in enum point of view
Can anyone help me out here, trying to learn enum's phenomenon? I'm not sure
I understood document quite clear -- as of yet :(
mysql> desc Associate;
+--+--+
I agree that using a reserved word for any purpose than that for which it
is reserved is a poor design choice. I also strongly encourage you to
change the name of that field and any others that conflict with the
reserved words list (the field name "desc" is another name that frequently
causes t
With all possible respect, what you posted aren't tables, those are lists.
At a minimum, tables have names and one or more fields; each field will
have a data type. Please post your table structure(s) and we can suggest
methods you can use to generate the output you desire.
Shawn Green
Databa
In article <[EMAIL PROTECTED]>,
"Rafal K." <[EMAIL PROTECTED]> writes:
> I installed mySQL server from Wizard and then i create table:
> create table geom ( g POINT) ENGINE = MYISAM;
> but i can't add any object to the table. I wrote:
> insert into geom values(PointFromText('POINT(1,1)'));
> and t
Jochem van Dieten wrote:
On Wed, 10 Nov 2004 07:42:29 +, Stephen Moretti (cfmaster) wrote:
Why is this list reply to sender and not reply to list?
Why don't you read the FAQ?
Ah right. I see - a 2 year old article -
http://www.unicom.com/pw/reply-to-harmful.html
Completely disagree
In article <[EMAIL PROTECTED]>,
Julien ALLANOS <[EMAIL PROTECTED]> writes:
> Well, I've tried the following scenario:
> 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
> 2/ User B: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
> 3/ User A: START TRANSACTION;
> 4/ User B
Selon Harald Fuchs <[EMAIL PROTECTED]>:
> In article <[EMAIL PROTECTED]>,
> Julien ALLANOS <[EMAIL PROTECTED]> writes:
>
> > Thanks, I've already read these pages.
>
> > Here is a test example I've done:
>
> > 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
> > 2/ User B: SET GLO
The socket file is created by mysqld when it starts, and goes away when
mysqld shuts down. That is, you have no socket file because mysqld is not
running, not the other way around.
You appear to be trying to start mysqld as OS user admin. Normally, only
root has the power make the switch to u
>
> That's because there's nothing particularly remarkable about
> dumping BLOB
> values. Possibly you could have problems if they're really large.
>
> However, I take it from your message that you're trying to
> dump a table
> with BLOB columns and not having success? If so, it'd be a
> goo
As I understand it...
The SQL must be executed in sequence, otherwise you'll end up with
incosistency between master and slave.
an example: If thread 1 is inserting data, and thread 2 is running
updates based on the inserted data then you could end up with different
results on the slave than on th
On Wed, 10 Nov 2004 07:42:29 +, Stephen Moretti (cfmaster) wrote:
> Why is this list reply to sender and not reply to list?
Why don't you read the FAQ?
Jochem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROT
Hello,
OS : macos X 10.3
mysql version 4.0.21, for apple-darwin6.8 (powerpc)
it's seems that after my last crash,
the socket of mysql '/tmp/mysql.sock' has
been deleted
(and i have read afterwards that it should have
been protected with a sticky bit)
i thought that restarting mysql daemon wou
I installed mySQL server from Wizard and then i create table:
create table geom ( g POINT) ENGINE = MYISAM;
but i can't add any object to the table. I wrote:
insert into geom values(PointFromText('POINT(1,1)'));
and then i saw in the table NULL values:
SELECT AsText(g) FROM geom;
| g
Hi Chums,
Can any body tell me if the following case is possible ?
Actually , I have Oracle Server , and I want to replicate the data across
the other servers, but at the other end ( replicated servers) , I want to have
MySQL Database Server too, and
What all I wanna know is if it is p
Hello,
I understand that the slave executes the sqls from binlog in sequence, but
are there any plans to make it multi-threaded so that it executes multiple
sqls from binlog.
Thanks
Arvind.
-Original Message-
From: Gleb Paharenko [mailto:[EMAIL PROTECTED]
Sent: 08 November 2004 13:02
To:
Hello Gleb,
thanks for your hint - I will try this workaround to get the replication
up and running.
Is there a point on your TODO-List that sounds like 'splitting binary
logs per database to enable replicating a single database instead of
transfering Gigs of traffic and using only few bytes of
In article <[EMAIL PROTECTED]>,
Julien ALLANOS <[EMAIL PROTECTED]> writes:
> Thanks, I've already read these pages.
> Here is a test example I've done:
> 1/ User A: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
> 2/ User B: SET GLOBAL TRANSACTION ISOLATION LEVEL READ COMMITTED;
> 3/ Use
1 - 100 of 103 matches
Mail list logo
