ot
> it?
>
Give their account different GRANTs on the master than on the slave(s)
and make sure that GRANTs (the `mysql` database) are not replicated from
the master to the slaves.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
ctly what you want to be
different between slaves and master.
> Is there another way?
>
Not that I know of. I just looked at the startup options but couldn't
find anything for this purpose.
Regards,
Fred.
> - Original Message -
> From: "Fred van Engen"
the linefeed as it is:
INSERT INTO support_files (session_id,file_type,file_body) VALUES (123,456,'\0\0\'abc
x');
Your mail reader may mess things up, but there is a single line-break in
the example, just after abc.
Regards,
Fred.
--
Fred van Engen
ed when the
table was created. The BINARY attribute means that column values are
sorted and compared in case-sensitive fashion according to the ASCII
order of the machine where the MySQL server is running. BINARY doesn't
affect how the column is stored or retrieved."
(http://www.mysql.com/d
t to save a few
CPU cycles and already know the length. Look at the implementation of
mysql_query:
int STDCALL
mysql_query(MYSQL *mysql, const char *query)
{
return mysql_real_query(mysql,query, (uint) strlen(query));
}
> Well, whatever the reason, I guess this is what API gu
or timestamps than a
signed int.
Also note that the range for timestamps is 1970 until 2038 (or 2106? for
unsigned ints), where DATE and DATETIME have a much greater range. Using
a UNIX timestamp for birthdays might not be appropriate.
Regards,
Fred.
--
Fred van Engen
l get in trouble if you have long running selects. These will
delay all following selects on the slave when an update is waiting for
the long query to end.
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36
l? Especially the third set is important.
Mysqld probably runs under an account (mysql) that is not yourself or in
your group, so the file needs to be world-readable. Use 'ls -l' to show
these permissions.
Also, did the copying or renaming change the case of the filename, e.g.
because you a
ith this table only.
>
Your records don't have a fixed size because of a text column. I believe
this triggers MySQL to use a variable size for each column, converting
char to varchar. Functionally, it shouldn't make a difference I guess?
Regards,
Fred.
--
Fred van Engen
n x m combinations, with n and m the number of records in table1 and
table2. You really want to do this for small tables only.
Consider an additional table to hold each of your 1, 3, 4, 6, ...
values together with the unique id of a record in table1.
Regards,
Fred.
--
Fred van Engen
> in this area:
> `affiliate_website aw WHERE aw.siteid = 1000`
>
A bit before that.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax:
new every day.
>
How about the 'help' command? You'll learn even more ;)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax:
ERT_ID() because some other process
may have inserted another record in the mean time.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 3
tabase operations.
>
If the primary goes down, how do you know that the database is in a good
state, even if the filesystem itself is consistent? I don't think MyISAM
gives you any guarantees in that regard. The secondary would need to run
myisamcheck on the tables be
er
clients to do some work. In an interactive application, your users will
love you for this :)
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fa
ter_id = $row['register_id'];
> echo $register_id = At this time the value is blank when I print the value
>
}
}
}
}
>
> Please, If someone know how to print the record value and Select function in php
> send to me.
>
Read the manual, c
t; command that I just did??
>
Sorry, you'll need a backup. If your backup is not recent enough and you
have a binary log (e.g. for replication), you can use that log to restore
the database state.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
it would be useless in multi-user cases. It gives you
information on what you just inserted, not what someone else did with
another connection.
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#IDX1362
Regards,
Fred.
--
Fred van Engen
--+
1 row in set (0.00 sec)
mysql> select (5 | 7) & ~(5 & 7);
++
| (5 | 7) & ~(5 & 7) |
++
| 2 |
+--------+
1 row in set (0.00 sec)
mysql>
Regards,
Fred.
--
Fred van Engen
databases to
> MS SQL databases. It would be highly appreciated if you could send me the
> details at the earliest.
>
Sorry, but I have no experience with this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Te
version for the right syntax to use near
> '[EMAIL PROTECTED] IDENTIFIED BY 'update'' at line 1
> mysql>
>
Try [EMAIL PROTECTED] instead. UPDATE is a reserved word in SQL.
Regards,
Fred.
--
Fred van Engen XB Netwo
ach page. Any help would be appreciated.
mysql> pager /usr/bin/less
mysql> tee somefile.log
I guess this is documented somewhere, or try:
mysql> help
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]
the
> Funds_Recd table?
>
I guess you want to use a GROUP BY because the SUM makes no sense
without it. You seem to want results for unique combinations of Job,
Sub and Task. This means:
GROUP BY Jobs.Job, Jobs.Sub, Jobs.Task;
Regards,
Fred.
--
Fred van Engen XB
the first alpha release in august 1999 (few people would
use that)
I see no dates for 3.21.x, but it should have been the production
release in the beginning of 1999 and was probably supported for a while
after 3.22.x was the production release in march.
--
Fred van En
ically, on unices at least.
Check the mysql error log to find out if it crashed.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
.0.13.
mysql> select version();
If you use an earlier version than 4.0.13, you could try to upgrade.
> InnoDB: We intentionally generate a memory trap.
> InnoDB: Send a detailed bug report to [EMAIL PROTECTED]
Well, you did that now :)
I don't use InnoDB currently, so maybe som
for the additional index.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
--
MySQL G
On Sat, Jul 05, 2003 at 03:16:11PM +0200, Fred van Engen wrote:
> On Sat, Jul 05, 2003 at 01:03:17PM +, James Yang wrote:
> > I have a MYISAM table, which is about 2.2G and 19,000,000 records. When I
> > create indexs for it, I couldn't finish after 4 hours.
>
> You
mp table.
It probably allows for NULLs in some fields in your temp table as well.
Not much you can do about it, but just to make sure you're aware of this.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://li
t of your tables, so
you want to try this with real-world data.
If the optimizer chooses the wrong index, you can tell it from which
indexes to choose by using 'USE (myindex)'. Use this e.g. to force it to
use the same index as for an ORDER BY. If it decides to use NO index, I
think you
ery should work, with 'level < 3' of course.
SELECT uid FROM members WHERE level < 3 AND name between 'a' and 'b',
> but it does not work
>
Show us your sample data (SELECT uid, level, name FROM members) and the
results you get for the q
ror().
> $result = mysql_query($sql, $conn);
> while ($record = mysql_fetch_assoc($result)){
> while (list($fieldvalue) = each ($record))
> echo $fieldname.;
I'm not sure what the point (.) is doing here.
Check for error messages in the webserv
define foreign
> key constraints to guard the integrity of your data."
>
TYPE = InnoDB only works if MySQL is compiled with InnoDB support,
which is the default in binaries from MySQL. If you compile it yourself
you need to configure --with-innodb .
Regards,
Fred.
--
Fred van Engen
e
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/opt/mysql-3.23.56/libexec/mysqld: ready for connections
So, look for something similar in your log. If it is there, then make
sure that you have innodb configured in my.cnf.
Regards
(\u)Use another database. Takes database name as argument.
Connection id: 171359 (Can be used with mysqladmin kill)
mysql>
So it looks like you could try the 'source' command. Copying the query
through your clipboard is another option.
Regards,
Fred.
--
Fred van Engen
bining records from multiple tables, which is not
what you seem to want to do.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
hese, which are more specific:
SELECT * FROM table WHERE Name = 'Author\\\'s'
SELECT * FROM table WHERE Name = "Author\\'s"
You need to escape the \ because it is the escape character and you need
to escape the ' in the first case because it is a string termin
T USE INDEX (...).
Sometimes adding (redundant) fields containing a calculated value will
allow you to create a good index (at the cost of making sure that the
added field will remain consistent). There are lots of possibilities.
Hope this helps.
Regards,
Fred.
--
Fred van Engen
PRIMARY KEY
| DROP INDEX index_name
| DISABLE KEYS
| ENABLE KEYS
| RENAME [TO] new_tbl_name
| ORDER BY col
| table_options
So what it clearly tells you, is to use this (note the 'ADD'):
mysql> ALTER TABLE EMPLOYEE
-> ADD FOREIGN KEY (SUPERSSN) REFERENCES EMPLOYEE(S
ocal/mysql/sql-bench' directory
> make: *** [install-recursive] error 1
> [EMAIL PROTECTED] mysql]#
>
It seems like you are (compiling and) installing _from_ /usr/local/mysql
and also _to_ /usr/local/mysql. You should compile and install from any
directory you choose, but it
rrect dates anyway? Probably because some user typed them. And
what are you going to tell the user when you get a generic MySQL error
for an INSERT with many values? 'Oops, something went wrong'?
Just check the values in your application, like you should do for any
v
to decrease
slave_net_timeout ; see section 4.5.7.4 SHOW VARIABLES.
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication_Features
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [
On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
> Fred van Engen wrote:
> > On Fri, Aug 22, 2003 at 01:16:48AM -0500, Hans van Harten wrote:
> >> that comes with neither warnings nor errors reported ...
> > Error reports would have been nice, but w
On Sat, Aug 23, 2003 at 02:07:36PM +0200, Hans van Harten wrote:
> Fred van Engen wrote:
> > On Sat, Aug 23, 2003 at 10:54:32AM +0200, Hans van Harten wrote:
> >> My checks might not match those of (the next version of) MySQL and
> >> at that time the difference in t
rt is shown. I assume its then possible to remotely connect to the
> database? BUt how do i know where to connect to? Thats my doubt? By domain
> name? By ip? Nothing seems to work.
>
The server should be the same as the one running your website. You are
probably being blocked by their
2 SET Table2.jobname=Table1.jobname WHERE
> Table2.jobid=Table1.jobid;
>
Not in 3.23.xx.
You would need to do this from a programming language or possibly by
creative use of temporary tables (SELECT INTO temp ...; REPLACE INTO
`Table 2`(...) SELECT * FROM temp; with appropriate locking).
R
g the update
> query might somehow effect the first one that is used in the outer loop.
>
You need to make a separate connection to MySQL for the outer query to
prevent the inner query from messing up the outer query's result set.
See the PHP manual for obtaining the connect
Antony,
On Thu, Aug 28, 2003 at 06:29:54PM +0400, Antony Dovgal wrote:
> On Thu, 28 Aug 2003 16:23:35 +0200
> Fred van Engen <[EMAIL PROTECTED]> wrote:
>
> > You need to make a separate connection to MySQL for the outer query to
> > prevent the inner query from m
Antony,
On Thu, Aug 28, 2003 at 06:45:27PM +0400, Antony Dovgal wrote:
> On Thu, 28 Aug 2003 16:37:41 +0200
> Fred van Engen <[EMAIL PROTECTED]> wrote:
>
> > Please elaborate.
>
> I've already answered:
>
On the list I just saw your 'bad advice' me
the manual. Make sure your fields are
unsigned ints.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The N
ry and connect through mysql client(DBTools) on remote PC I get the
> 'access denied for user: [EMAIL PROTECTED]' (using password:yes).
>
This suggest you tried to log on with a username 'user%' instead of
'user'.
Regards,
Fred.
--
Fred van Engen
ia dreamweaver's
> "test" window) all don't show any slashes in the data,
> but 'export' in phpMyadmin adds slashes to the text it
> outputs.
> magic_quotes_gpc is On
> magic_quotes_runtime is Off
> magic_quotes_sybase is
- note the last binlog file and size on the active server
- UNLOCK TABLES on the active server
- move the copy to the HS
- update the HS's master.info with the active server's binlog file and
size
- restart MySQL on the HS
Maybe there's an easier way, but this is (from memory) wha
On Wed, Oct 08, 2003 at 11:16:03AM +0200, Bob Brands wrote:
> What is the correct syntax for using a Exponentiation operator in MySQL?
>
It's not an operator but a function. Look at EXP and POW in the docs:
http://www.mysql.com/doc/en/Mathematical_functions.html
Regards,
Fred.
-
eldname (or tablename) by putting
backticks around it:
alter table tbl_name change `IN` NEW mediumtext;
> Pl. suggest how to rename particular "field name" for all the tables in
> a database
>
Repeat the alter table for each table. :/
Regards,
Fred.
--
Fred van Engen
rations with the current date and
time. If you have multiple TIMESTAMP columns, only the first one is
updated automatically. "
Use DATETIME instead of TIMESTAMP if you don't want this to happen.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAI
, but is used to group
several rows (apples and pears) together. In that case, you can use:
SELECT id, SUM(price) FROM mytable WHERE id = 2 GROUP BY id;
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]T
A'),category);
Only problem is that it won't optimize, so use this on small tables only.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
x27;s right. It has the same problem regarding optimization and it
gives you another column in your result set (which you may or may not
want).
Regards,
Fred.
> Fred van Engen wrote:
> >On Tue, Dec 10, 2002 at 03:32:13PM +0500, Tariq Murtaza wrote:
> >
> >>I want to ach
D]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php
instead of the
> value, this causes a difference in my 2 databases.
>
In my 3.23.52 binlog I see this before each time related update:
SET TIMESTAMP=1039489014;
Each time with the current timestamp of course. I haven't checked
if it is actually used by the slave however.
Regards,
Remi, Michael,
On Fri, Jan 03, 2003 at 11:39:44AM -0500, Michael T. Babcock wrote:
> Fred van Engen wrote:
>
> >SET TIMESTAMP=1039489014;
> >
> >Each time with the current timestamp of course. I haven't checked
> >if it is actually used by the slave however.
&
field='somevalue' ...
> > >
> > > The key to the problem is not the replace into, but the fact that we
> > > are connected to one database and working on another.
>
>
>
>
> -
w.python.org/topics/database/
http://www.python.org/topics/database/modules.html
http://sourceforge.net/projects/mysql-python
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
'%apple%'
> and loop against the items in the set?
>
I never worked with sets, but you could try something like this:
select
sum(sign(find_in_set('apple', favourite_fruits))) as apples,
sum(sign(find_in_set('pear', favourite_fruits))) as pears
from Kids;
This would
InnoDB_consistent_read.html
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
permissions ?
>
Securing a table with a password or even using encryption would make
things more difficult for your "users" but by no means impossible.
You give them the application that contains the password or encryption
key. They just need to find it in your application then, w
' (Using password: YES)
Use FLUSH PRIVILEGES after updating the mysql tables directly.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400
list, not a newsgroup.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 3
L,
Trips.TripID,
Trips.Mileage
FROM Trips
INNER JOIN Cars ON Trips.CarID = Cars.CarID
INNER JOIN Users ON Cars.UserID = Users.UserID
WHERE Users.UserId='2')
ORDER BY 'Cars!2!CarID!hide',
'User!1!UserID!hide',
Tag
;
Rega
On Thu, Mar 20, 2003 at 10:32:07AM -0600, Dan Nelson wrote:
> In the last episode (Mar 20), Fred van Engen said:
> > > See msg 135092 for sample script if you want to see a physical example.
> >
> > Which message is 135092? I'm reading a mailing list, not a new
ss.
>
In other cases than above, e.g. network problems, the replication should
start again automatically. Again, you would see this in the error log.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Tele
't find file: './mysql/host.frm' (errno: 13)
> 030326 14:35:47 mysqld ended
>
> how do I correct this
You don't seem to have setup the privilege tables.
See http://www.mysql.com/doc/en/mysql_install_db.html for details.
Regards,
Fred.
--
Fred van Engen
m to have setup the privilege tables.
See http://www.mysql.com/doc/en/mysql_install_db.html for details.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
e ID I just inserted?
>
Yes. The last inserted id is kept per connection. So unless YOU insert
another record using the same connection, the last_insert_id isn't
changed. Also, last_insert_id in a new connection will give you NULL,
regardless of what you did in a previous connection.
R
- It's always darkest before the dawn. So if you are going to
> >steal the neighbor's newspaper, that's the time to do it.
> > (53kr33t w0rdz: sql table query)
> >
> >
> > --
> > MySQL General Mailing List
>
swamp my
> network. I would like to identify the source and understand the cause.
>
My guess is that you're showing only packets sent by herzegbol and not
packets received by herzegbol and that shelbyville is really trying to
connect. What is your tcpdump line and wh
gt;
[snip] :)
> Unless I discover something else, I'm going to assume this is not a mysql
> problem.
>
This all happens at the level of the TCP stack, so MySQL couldn't be
involved I guess. Could you try running tcpdump -n to make sure the
DNS or host tables aren't goof
ality in 4.0.x and it was never added to
3.23.x. Be careful with the online manual, because it is for the latest
version of MySQL.
Regards,
Fred.
--
Fred van Engen XB Networks B.V.
email: [EMAIL PROTECTED]Televisieweg 2
tel: +31 36
Tanggal : $tanggal\n
> Nama file: $namafile\n
> ";
>}
> echo "Akhir baris.\n";
>
> } else echo "Gagal konek.\n";
> mysql_close($konek);
> ?>
>
> Thank you ve
applet alert asking if I
> really want to xyz, then it gives an error in MyPHPAdmin)
>
> delete * from 'item' where 'quantity_of_item_in_stock' <= 10;
>
Yes, this is incorrect syntax.
Regards,
Fred.
--
Fred van Engen
hould be at the end of the query.
Also use addslashes() to properly escape quotes in your variables.
> $result=mysql_query($sql,$db);
>
> if($result) {
> echo ("Data$nome, registro nº$nid was
> successfully updated.");
>
or
>
Hi, you just mailed your root password to an open mailing list.
Take care. You might want to change your password now.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400
SULT ... instead of
SELECT ... . Note that SELECT SQL_BIG_RESULT doesn't work in 3.22.x,
though it is accepted by the parser. You don't mention which version
you use. 'set SQL_BIG_TABLES' works fine in 3.22.x.
Note that if I'm correct, you're using a very o
ent column of type 'tiny int'. This allows
values between -128 and 127. You should choose a different column type.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisiewe
; don't use dashes, fixing the SQL parser.
>
Or use quotes around the hostname:
grant all on *.* to "my-user"@"my-host.com";
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36
y problems.
Regards,
Fred.
The stupid filter needs sql,query
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424
rement columns.
Regards,
Fred.
PS: filter, filter, are you there? (sql, query)
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 A
their latest auto_increment ID. I believe there is also a
command you can use to reset the auto_increment ID, but you would
still need to take care to not insert negative values.
Regards,
Fred.
> > -Original Message-
> > From: Fred van Engen [mailto:[EMAIL PROTECTED]]
> >
however still insist on having unique values for
> all of the four columns...
>
> MySQL said:
> Duplicate entry '127-30-127-1' for key 2
>
Did you check with a SELECT if there really is a duplicate 127.30.127.1 ?
Regards,
Fred.
--
Fred van Engen
p with -A
>
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 2 to server version: 3.23.32
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer
>
> mysql>
>
Correct. You told the mysql cl
d type:
> grant all on *.* to root@localhost;
And restart your MySQL daemon again. I never tried this, but I guess
it should work.
Good luck!
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400
; which seems to
indicate an empty table (or some error condition).
This makes me wonder if it's 'allowed' to update the tables
that make up a merge table.
MySQL is running on Solaris 7 for SPARC.
Any help on this will be greatly appreciated.
Fred.
--
Fred van Engen
ong) 1L << 31) -1L);
return;
}
void make_scrambled_password(char *to,const char *password)
{
ulong hash_res[2];
hash_password(hash_res,password);
sprintf(to,"%08lx%08lx",hash_res[0],hash_res[1]);
}
Hope this helps.
Fred.
--
Fred van Engen
ses of the same version but from
different data directories.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
To add to this, I'm running 3.23.32 (on Solaris). I really like
the concept of merge tables, but without the ability to insert
new records in underlying tables, it's far less useful for my
needs.
Thanks.
Fred.
On Tue, Feb 13, 2001 at 12:44:25AM +0100, Fred van Engen wrote:
> H
e in its data (.../var) directory which it
checks for when starting again. If you have separate data directories,
each will contain one .pid file and it works fine.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisi
select count(*), max(id), max(auth_time) from authentication;
It seems to be some race-condition so there's no guaranteed reproduction
but it gives incorrect results once every 5 or 10 times in my case.
>Fix:
Unknown
>Submitter-Id:<[EMAIL P
might wait for the query that mysqld is working on).
When the cause is still not clear to you, then post the output of the
'show processlist' to the mailing list. Maybe we can help then.
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTE
1 - 100 of 177 matches
Mail list logo
