few days, say.
Do I have the correct understanding of the situation? And how do people usually
deal with this error?
Thanks so much! I apologize for the newb-level question and really appreciate
your help.
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
> Pete wrote:
> > Hi folks --
> >
> > What would be the right approach in MySql 5.0?
> >
> > My table, USERS, has columns NAME and IP. Associated
> with each user is also a collection of from 0 to 50 INTs.
> What's a reasonable way to put these 50 I
an OK
approach?
I have to manipulate these INTs in my CGI code.
Thanks!
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2. I understand there are problems in storing photos in the db. Can one
overcome these problems somehow?
Thanks!
-- Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
r indexing) and also
the readable representation (just for debugging/problem-solving)? (Well, of
course I know what the cost is: it's 12 bytes, plus overhead, per row.)
It all depends, but in general, would you call that too costly, given the
benefit?
-- Pete Wilson
http://www.pwilso
be interested in the answer, though, from someone with experience.
-- Pete Wilson
http://www.pwilson.net/
--- On Thu, 5/14/09, Jim Lyons wrote:
> From: Jim Lyons
> Subject: Re: MAC address as primary key - BIGINT or CHAR(12)
> To: "Ilia KATZ"
> Cc: mysql@lists.mysql.
http://www.kionic.com
I've been a very active and heavy customer for years and very satisfied.
-- Pete Wilson
http://www.pwilson.net/
--- On Sun, 4/19/09, Cameron Rogers wrote:
> From: Cameron Rogers
> Subject: A good US Hosting Site?
> To: mysql@lists.mysql.com
to usrs(usr,email) values(\"pete\", \"p...@pwilson.net\");" );
I can imagine this happening when the connector is running in real life. So:
What is the correct and reasonable way for a running connector to deal with
this error intelligently?
Thanks!
-- Pete Wilson
h
all to mysql_query(select ...) must always in
these circumstances return success.
Thanks!
-- Pete Wilson
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
join t2 on ...
left join t3 on ...
where ...
> MySQL's optimizer cannot reorder the joins because it has the potential
> to change the result of the query.
Do have an example in mind?
Thanks,
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
#x27;d use a function besides fprintf altogether.
Otherwise, if your r["content"] happens to return a string that
contains "%s" or some other thing that causes fprintf to look for more
data on the stack, you'll get output you weren't expecting.
--Pete
On Thu, Aug 02
you have set up their permissions correctly.
E.g., a user says, "I tried to do X but it wouldn't let me," and you
go in as them, repeat the problem behavior, fix it, test your fix, and
let them know it is fixed.
(Or, similarly, verify for yourself that their user is unable to do
Perhaps the "expire_logs_days" variable does what you're looking for.
--Pete
On Thu, Apr 26, 2007 at 09:01:58PM -0400, Tim Lucia wrote:
> # cat /etc/cron.mysql/20-purgemasterlogs
> #!/bin/sh
> /usr/bin/mysql --defaults-file=/root/.my.cnf -e 'show master logs; purge
eval2;
If datetimeval is cast to a date in the where clause, the row is
returned in both versions.
--Pete
--
Pete Harlan
ArtSelect, Inc.
[EMAIL PROTECTED]
http://www.artselect.com
ArtSelect is a subsidiary of a21, Inc.
--
MySQL General Mailing List
For list ar
rhaps someday MySQL will work that way, but until they
say it does you can't count on any specific behavior.
I suppose that means:
begin transaction
update tbl set tmp=col1, col2=col1
update tbl set col1=tmp
commit
--Pete
--
MySQL General Mailing List
manually install the later glibc's (2.3.5 or 2.3.6)
from testing/sid, or just update the whole kit and kaboodle.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> It is rather strange for me; they normally should have disappeared after
> 28800s of inactivity.
>
> Could you give me a clue?
>
> Marc.
Perhaps it's this:
http://bugs.mysql.com/bug.php?id=16995
That's when using NPTL ("Native Posix Thread Library&quo
et
is small and static enough, this can be a good solution too in the
right situation, and one that avoids the mathematical hackery of
nested sets.
--Pete
> Jochen Kaechelin wrote:
> > I have the following table:
> >
> >
Agreed. OTOH, I would recommend 4.1.15 until they solve the problem
with updates in 4.1.16 apparently not using index prefixes.
--Pete
On Sun, Jan 15, 2006 at 05:07:08PM +, Jocelyn Fournier wrote:
> Hi,
>
> Excepted if he found a bug in an older version of MySQL, it's of c
wanted to send a message
on the list in case someone is having trouble with 4.1.16 and doesn't
know why, or is thinking of upgrading and might want to wait, or knows
a solution to this problem besides downgrading.
[Linux, MySQL-compiled x86_64 binary, InnoDB or MyISAM tables.]
--Pete
--
My
> > select ( select max(c.idrow)+1 from provasql c ) , 'This is only a test';
Does changing "max(c.idrow)+1" to "coalesce(max(c.idrow),0)+1" solve
your problem?
--Pete
On Fri, Nov 04, 2005 at 04:56:26PM +0100, AESYS S.p.A. [Enzo Arlati] wrote:
>
>
&
he memory as
soon as they're done with it or hold onto it for (probable) future
use. If I had to guess from reading that page, I'd say they probably
free it, but if I had to guess from the memory use of our db server,
I'd say they don't.
--Pete
> Pete Harlan <[EMAIL PROTE
s the, e.g.,
sort, is finished, then I only have to figure out how many threads are
likely to need a sort_buffer at any given time.
I looked through the manual, various online documentation, and the
source, but haven't been able to determine an answer.
Thanks,
--
Pete Harlan
[EMAIL PRO
UPDATE
for the column location that will do something like:
update fooloc set location = geomfromtext('point(lat lon)');
Is there a way to do this with a single update ?
tia
-pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsub
I've been surfing the list / google but can't find what to do
I have a tab sep file, where there are empty fields i.e.
the fields are associated with a mysql table integer type.
how do I get the empty fields to become NULL instead of
0 (zero) with a warning ?
Thanks,
-pete
On Mon, May 23, 2005 at 11:52:50PM -0700, Kevin Burton wrote:
> Pete Harlan wrote:
>
> >In addition to failing the tests, I deployed the server on Machine 1
> >for a while and it failed quickly, with a simple insert hanging up and
> >"kill " being unable to
ine 1
for a while and it failed quickly, with a simple insert hanging up and
"kill " being unable to kill it. (The thread's state was
"Killed", but it didn't go away and continued to block other threads
from accessing the (MyISAM) table.)
Any help would be appre
Thanks Michael,
This way works fine anyway was just interested if there was a better way of
doing it.
Pete
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 4:07 PM
To: Pete Moran
Cc: mysql@lists.mysql.com
Subject: Re: DateTime Select
Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 11:43 AM
To: Pete Moran
Cc: mysql@lists.mysql.com
Subject: RE: DateTime Select optimised
I would investigate a partial index perhaps on the date only? You could
index on just the date eg.
ALTER TABLE ADD INDEX (date(10));
I don't ha
The table is indexed on the date field, doing a 'like' results in a table
scan, is there another way similar principal but would allow the indexes to
be used ?
-Original Message-
From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED]
Sent: Monday, 21 March 2005 11:24 A
Hi All,
Is there a simpler way of doing a select for a given date, for instance if I
have a datetime field called date
And so its populated with a load of values such as
2005-01-07 09:00
2005-01-07 10:00
2005-01-07 11:00
2005-01-07 12:00
If I wanted all records which fall on 200
To me what is more important is where this is leading,
http://www.distlab.dk/badger/Publications/exec_summary.pdf
a true parallel database cluster, with the end goal of this
work being a parallel MySQL.
My cluster waits ..
-pete
On Mon, 2005-02-28 at 14:04, Greg Whalin wrote:
> Just fo
You need to do a join on the tables,
Simplest way is
Select * from gardens a, state b where a.state_id = b.id
Assuming id in the state table is actually what your planning on joining on.
Try to do it on the mysql command line before doing in code to make sure you
actually have the data you need
If I needed a brute force DB on an x86 platform would
using Version 3 vs 4 buy me any performance today ?
90% inserts, 5% simple selects, 5% other.
Sorry if a lame question
-pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
A monitoring solution which can monitor mysql as well as pretty much any
service on nix and win platforms is zabbix (http://www.zabbix.com), its very
easy to setup and personally I think its excellent. It may be overkill if
you just want to check a db is up though
-Original Message-
F
I recently had a similar problem, however you may find that its more of a
case of correctly indexing your tables.
Yyou should look for the tables which need indexing, I enabled the
slow-query-log as well as enabling of logging of queries which didn’t use
indexes and found some which did some very
` is NULL.
FWIW, IFNULL() does the same thing, with a clearer (to me) name, e.g.,
IFNULL(sum(qty), 0).
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
export CC=gcc-3.4
./configure --prefix=/usr/local/mysql \
--exec-prefix=/usr/local/mysql \
--with-mysqld-ldflags=-all-static \
--disable-shared --enable-thread-safe-client \
--with-extra-charsets=all
====
#x27;s the answer I got when I asked a similar question a few
weeks ago.
HTH,
--Pete
Egor Egorov <[EMAIL PROTECTED]> writes:
> The section of your manual describing what some of the glibc
> problems are is helpful; do you know if the linuxthreads-2.2.2 patch
> made it into glibc
3.2 (on Debian Testing).
We're moving to 64-bit soon, primarily to be able to run MySQL with
more RAM.
Thanks,
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
It might help if you say what version of MySQL you're using, give the
table schema, etc. I couldn't reproduce the behavior you describe
here.
--Pete
On Mon, Jul 19, 2004 at 12:13:47PM -0500, Deepak Vishwanathan wrote:
> Hi,
>
>
>
> I have a table with a colum
On Thursday, July 15, 2004, 9:10:43 AM, matt wrote:
mr> Justin Swanhart wrote:
>>Indexes can generate vast amounts of random i/o.
>>Because of rotational latency, random i/o can really
>>slow you down, especially if you are using IDE or SATA
>>disks because they can't do tagged queueing like SCS
group by route
order by rating
As others have pointed out, your ratings aren't something MySQL will
know how to order. That's a separate problem (and more difficult to
solve), but the between syntax is also one.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
in my experience you shouldn't be
*that* worried about compiling it yourself. (Of course, if you have
problems and expect any help with it, paying for support sounds like a
good idea.)
--Pete
> So if you need rock stability on Linux and still need to have a
> custom built binary
On Friday, June 11, 2004, 7:00:39 AM, Csongor wrote:
FC> Hi,
FC> I have a table that has a few short text fields [text(4000), text(1000)]
FC> I would like to index. Do you think it is a good idea to index them
FC> "simply", or is it better if I create auxilary fields which hold the MD5
FC> for th
On Thursday, June 10, 2004, 1:20:03 PM, Mark wrote:
MvB> Hi,
MvB> For a project I'm creating a search function, the deal is this, a select
MvB> query must be submitted and in this query a check must be done to confirm a
MvB> previously found and accepted item is not shown anymore, a short version
On Thursday, June 3, 2004, 8:14:00 AM, Victor wrote:
VP> If you choose to copy the files I would ensure that you are getting the
VP> innodb binary logs as well if they do not exists in the mysql data
VP> directory. The innodb backup tool or even mysqldump may provide a more
VP> consistent snapshot
At 01:30 PM 5/5/2004, Daniel Clark wrote:
I wonder if mysql isn't trying to process
where GMTBase > DATE_SUB(CURRENT_DATE, INTERVAL 2 DAY)
What about doing this date subtracting in PHP and adding the result to the
SQL statement.
Nice try - but it's not the problem. Replacing the equation with a c
Hello folks,
I'm usinng MySQL 4.0.17.
I have a table something like:
RuleID int,
GMTBase datetime,
Credited bigint,
...
I have an index built on GMTBase.
I have rougly 8 million rows.
GMTBase stores a datetime for the top of the hour on a given date.
I want to build a summary of the last 2 days
The 2GB (not 2 Mb) file size limitation on Linux went away years ago.
Unless your distribution is very old you won't have a problem.
--Pete
On Tue, Apr 06, 2004 at 05:05:59PM -0300, Ronan Lucio wrote:
> Hi All,
>
> I always worked with MySQL on FreeBSD systems.
>
> Now
ield name, for example.)
So I doubt it will happen, but not because it couldn't be done.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
8 hours to
reindex
-pete
-Original Message-
From: Richard Davey [mailto:[EMAIL PROTECTED]
Sent: Monday, March 29, 2004 10:12 AM
To: [EMAIL PROTECTED]
Subject: Re: Creating index on very large table
Hello Jeffrey,
Monday, March 29, 2004, 7:05:27 PM, you wrote:
JH> I've got a problem
My two cents: Just upgrade. We hammer on it pretty hard and the
transition has not only been smooth, it's been a delight. The query
cache, on our load, handles 60% of the queries, which I never imagined
would happen.
4.0.18 feels as boringly stable as most released MySQLs :)
--Pete
O
me.
4.0.1 isn't the latest, so I assume you're using something later.
Regardless, I wouldn't expect the performance on the two machines to
be so different unless the one has so much ram that everything is
running from memory while the other has to thrash the disk.
--Pete
On Su
Hello,
Personally, I think it's a matter of choosing the best tool for the job.
For myself and my team, Java is the work horse particularly - suited for
rapid application development and when there is a strong cross platform
requirement. This means that Java tends to dominate our utilities and
by mysqld has
so far not gone above 1 GB (both resident, and requested).
-pete
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 17, 2004 10:47 AM
To: Lancashire, Pete
Cc: [EMAIL PROTECTED]
Subject: Re: what can i change in my.cnf/mysqld to get better perf
I'm doing some tests on a small Sun server, a 280R to demo
MySQL vs. Oracle. For the demo I using a subset of a test table.
The destination server will be a Sun 880 with 8 1.2 GHz CPU's,
16 GB RAM, Sun T3+ RAID Array.
Any suggestions on settings or other changes would be helpful.
Also what woul
In this case it might be easier for you to just modify the MySQL
source to disable looking for the socket, and treat localhost as
127.0.0.1.
--Pete
On Fri, Jan 30, 2004 at 06:33:22AM -0800, [EMAIL PROTECTED] wrote:
> --- [EMAIL PROTECTED] wrote ---
> > i've never set up tunnels
Kind MySQL List,
I need your help.
I have an installation of replicated MySQL servers.
I am migrating to new servers and upgraded MySQL software.
My previous servers were RH8, MySQL 4.0.14. (A, B)
My new servers are Fedora, MySQL 4.0.17. (C, D)
Most of my critical data is built using INNODB tables.
r occurs and the script stops. The mysql server remains
responsive to queries before and after the operation. No errors are
reported in the .err file.)
Thanks again in advance!
_M
Pete McNeil (Madscientist)
President, MicroNeil Research Corporation
Chief SortMonster, www.SortMonster.com
VOX: 70
should tell you
which machines they are coming from and which users, and that should
help you track down who's holding connections open.
--Pete
On Wed, Nov 12, 2003 at 01:15:54AM +0100, Henrik Skotth wrote:
> Hello!
>
> I have tested this now, and that isn't the cas
cking the pages in a type of
cache. (Hopefully OSs are smart enough not to further cache ramdisk
pages.)
I haven't used a ramdisk in a db server yet; I don't have any one
table that simply MUST be read out of memory every time, and the OS
does a pretty good job of managing things. YMMV.
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
an.
Cheers,
--Pete
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
happily write much larger files.
The 2GB filesize limit was due to glibc and the linux kernel, not the
ext2 filesystem. Any linux distro from the past year or so should be
able to handle >2GB files on any filesystem.
Hardware raid is invisible to Linux, so won't affect the maximum
usable fi
limit -u 500" before launching mysqld?
--Pete
On Sun, Oct 12, 2003 at 01:44:39PM +0200, Stefano - 3000 Staff wrote:
> Hi all,
>
>
> I'm running a debian woody with mysql 4.0.12 . Sometimes i get error 11 '
> can't create new thead etc '
>
> I
y
"... as number, tableName.* from ...".
HTH,
--Pete
On Tue, Sep 23, 2003 at 04:54:03PM +0300, Director General: NEFACOMP wrote:
> Can you run this query and tell me if it works on your machine?
> SELECT (@var := @var + 1) AS Number, * FROM any_table_with_
At 03:30 PM 8/20/2003 -0700, Scott Haneda wrote:
What would be a good way to deal with the following...
I have a form that has 5 checkboxes on it, lets say the checkboxes are for
categories, and more than one can be selected.
For example:
please tell is what brochure you want
[] car
[] boat
[] tru
t you started.
Hope this helps,
_M
Pete McNeil (Madscientist)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I couldn't believe it so I looked.
When I load the manual page I _do not_ see any such thing.
Something else must be going on.
_M
At 11:43 PM 7/10/2003 -0400, C. Reeve wrote:
Hi,
I have noticed recently that every time I go to the MySQL manual page I
get prompted to install Gator spyware. If MySQL
On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote:
...
> 4.0.13 has better diagnostics. Please upgrade to it if you are not using
> MySQL replication.
Is there something wrong with 4.0.13's replication, or does it not
replicate properly with 4.0.12?
--Pete
--
MySQL Gene
to another packaged version, but
clearly the problems aren't at the database end of things. Good work.
Thanks again,
--
Pete Harlan
harlan @artselect.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
g more elegant than
> >> SELECT FROM ... WHERE 0=1; ?
> >>
> >> I need this because PHP throws an error when an empty statement
> >> (or just a ';') is passed to MySQL.
> >
> >SELECT 1;
> >
> >?
> >--
>
> That returns a row,
ed by
ANALYZE TABLE is done (and stored) when creating a non-unique index,
but not when creating a unique one.
Tested in 4.0.12 and 3.23.56.
I have a simple test case if needed. (There's way too much data in
the test case to present it here.)
--Pete
On Thu, Mar 27, 2003 at 08:39:41PM -06
27;s
slow, create it non-unique and it's fast. The EXPLAINs look the same
for both.
Is this to be expected under some circumstances, or do I get to
isolate this messy situation (it's an ugly query) for a bug report?
MySQL-3.23.55, Linux, MyISAM.
Thanks,
--Pete
--
MySQL General
ich is what
bit us. You specify a port in the DBI->connect() routine as something
like ';host=localhost;port=2000' and it's silently ignored there too.
I'm very glad that ssh no longer (as of three years ago!) forwards
externally-connected-to ports by default.
--Pete
--
anyway; I didn't try it
elsewhere).
That's potentially dangerous and not completely obvious side-effect of
tunneling SSH ports.
SSH doesn't allow tunneling sockets unfortunately.
--Pete
-
Before posting, please che
#x27;t help you there but I'm
sure someone can).
--Pete
On Tue, Mar 04, 2003 at 09:04:20PM -0500, Gary Huntress wrote:
> Greetings,
>
> I've been running a public MySQL server for a couple of years that now
> supports several thousand users. I used to run this on a lowly
Hello,
Can anyone recommend a script to analyze a mysql server general query log.
My goal is to determine which users are putting the most load on the server.
Any other methods to achieve this same goal would be appreciated as well.
Thank you.
__
has to put the results in an array of some kind
I believe those numbers are unknown when generating the row values.
--
Pete Harlan, who doesn't speak for the MySQL developers of course.
[EMAIL PROTECTED]
-
Before posting, pl
n that 'case' it was a standard sql reserved word iirc.)
I don't have any fields named "force", but surely someone does.
Just a thought. Thanks for the great "sql, database" :)
--Pete
-
Befo
Hi,
I hope this message is not out of place, but I have not been able to solve
this problem. I need to rebuild the latest MySQL rpm's for use
on some RedHat 6.1/6.2 machines and have been having quite a few problems.
I've made sure I have :
autoconf-2.52
automake-1.5
libtool-1.4.3
which I beli
Hi,
In regard to my previous message - I would also be interested if anyone is
aware of a general source for MySQL rpm's built for 6.1/6.2. I would prefer
to build my own but if I do not succeed I would also be interested in anyone
else's. I assume that there are no MySQL supplied rpm's for 6.1
What I'm looking for are some suggestions on ./configure
options and potentially GCC options.
Thanks in advance,
-pete
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
the RAID arrays were built at RAID-0
90% of the time the db's will be doing only selects, the
db's will be updated nightly.
-pete
Well I opened my big mouth and now have to do a demo
of MySQL on an old server that was destined for the
dumpster.
It has 4 Pentium III, 512 MB of m
pplication is
written, that could lead to unpleasant race conditions that would be
easily avoided by simply not reusing key values at all.
--Pete
sql, db
-
Before posting, please check:
http://www.mysql.com/manual.php (the
ich, if
either, arguments are fields or constants.
(It might not use your indexes there, or be the best way to do it...
The below looks better to me, or use a join table to do it really
properly. But in answer to your question, the 'reverse' of LIKE is
LIKE with its arguments reversed.)
though, one per file. Maybe they're
not used during the operation of the db...? I don't know about that.
--Pete
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
directory.
('ls' slows down for reasons besides reading the directory; it usually
sorts its output, and it's often set up to guess file type for each of
the files. Turn those off and it usually goes quite quickly.)
--Pete
--
with the MySQL binaries happened with either
table type.
Good luck,
--Pete
On Wed, Sep 25, 2002 at 09:24:02AM -0700, Andrew Maltsev wrote:
> On Wed, Sep 25, 2002 at 10:02:52AM -0500, Philip Molter wrote:
> > On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote:
> > : A
X |
| us-penguin | root | |
| localhost | | |
| us-penguin | | |
++--+--+
-
Any ideas ?
-pete
--
If you're using InnoDB tables, replication stops the slaves from
running. Heikki said he'd try to get this fixed for 3.23.52.
--Pete
On Mon, Aug 12, 2002 at 04:05:11PM +0200, Lutz Maibach wrote:
> Hi,
>
> today I noticed a strange behaviour in MySQL 3.23.49a-Replication I
was just finished being written to. (Because its
modification time was the previous minute, while the next (zeroth) log
file was now the active one.)
I know without a repeatable test case, there's not much you can do.
If I get more information I'll let you know. It helps to hear that
t
f a small measure of recoverability in the unlikely event
of a crash.)
[Is there a way to set that variable with 3.23.51 without shutting
down the server? I couldn't find a way.]
Thanks,
--Pete
sql,query
-
Before
a separate disk?
Alternately, is there a way to trigger this action at night, so we can
avoid it happening during the day? It shut us down for about five
minutes today.
Details follow. Many thanks,
--Pete Harlan
[EMAIL PROTECTED]
Possibly relevant details:
1. Binary mysql-max-3.23.51-pc-linux-gnu
> >p.s. PLEASE can you put a [mysql] tag on the list???
> Please not, it wastes space on the screen.
not a lot of space - and does have the great advantage that we
can then filter out the mysql stuff into a separate mailbox whihc
(on standard UNIX mail) isnt possible without it.
-pcf.
---
> Is it possible to use MySQL with a chinese charset (utf8) ?
You need to use BLOB or TEXT types and do a little bit of work yourself
to manage them, but basically it does work fine. mySQL just treats it
as binary data.
-pcf.
-
rename table foobar to foo;
rollback;
the rename is done anyway, and seen by other clients immediately after
the rename command. Is this normal?
Thanks for any help,
--Pete
-
Before posting, please check:
http://w
> You need to create a new user and group for mysql.
> Open your OSX manuals and start reading.
Additional hint - nidump and niload will do the trick (assuming
it works like alll other NeXT systems, which it seems to).
-pcf.
-
> am running mysql 3.44 at RHL7.2, how can i setup up mysql to store/show
> characters of language such as hebrew/arabic?
My best suggestion would be to store all your test in Unicode UTF-8 format
and use the type BLOB in the table in order to store it. We do this
and can quite happily mix
> We are discussing the 'mysql' client which is often used to write
> scripts that run under the
> UNIX shell.
...
> If you write a script that has two semi-colons in a row, the second one
> is ignored and no error message is given.
Err, not true (in amysql script anyway)
I think you are tryi
1 - 100 of 160 matches
Mail list logo
