Just to clarify - are you asking for suggestions regarding avoiding
re-seeding the slave or regarding what is likely to have gone wrong?
Generally, a newer slave can cope with an older master, but not the other
way around. If you updated the master while slave was out of date, you may
be out
On Wed, 13 Jun 2007, David Scott wrote:
I am trying to update the column CreditCode in a table extract using data
from another table CreditCodes, which has columns CreditCode and
Consumer_No.
I have been given the following sql which works on another database (not
sure which and it is
On Tue, 12 Jun 2007, Ian P. Christian wrote:
Ian P. Christian wrote:
I upgraded my slave server a few weeks ago, and the slave failed, with
an error similar to the one shown below.
I have figured out what happened here now - and I'm part of the way
though fixing it.
It turned
Hi,
I'm trying to build the RPMs with ICC, but I'm not having a lot of luck. I
saw the documentation for what paremeters are used to combile the tar
balled binaries, but can anyone give me some guidance on how to get the
RPMs to build?
The distributions I want to build for are CentOS 5.0 /
On Mon, 11 Jun 2007, Dave Shariff Yadallee - System Administrator a.k.a. The
Root of the Problem wrote:
REcently my mysql server has been overload with a lot
of connections; in fact losing the mysql.user table and
one whole database.
Define losing. You lost access, or the tables got
On Mon, 11 Jun 2007, Mahmoud Badreddine wrote:
Hello,
I am trying to revoke all privileges from a user on a certain table in a
database.
I want the user to continue to have all his/her privileges intact for the
other tables though.
I used the statement REVOKE ALL PRIVILEGES on
Oh dear... Without getting into any religious arguments, if you have to
use it, PHP already provides a perfectly good interface for preventing
any SQL injections - ever. Use MySQLi and bound parameters. And if
somebody manages to invent some quasi-valid reason for not using MySQLi
(e.g. version of
not to work, or am I just unlucky enough to be the first
one to try it?
Gordan
Gordan Bobic wrote:
Hi,
I'm trying to build the RPMs with ICC, but I'm not having a lot of luck. I
saw the documentation for what paremeters are used to combile the tar
balled binaries, but can anyone give me some
I think MySQL has a little ways to go yet before I would subjectively
call it best.
I posted twice to the list with questions about porting my application
that
runs on (SQL Server, Oracle, PostgreSQL, Sybase SQL Anywhere, MS Access,
and
DB2) to MySQL. No one on the mysql list, or the internals
Jay Blanchard wrote:
[snip]
The issue with timestamp is this:
You can only have one timestamp with a default of the current date.
My app has two fields in one table
Created_datedatetime default now()
Last_update datetime default now()
This doesn't work with timestamp because
Jay Blanchard wrote:
[snip]
Well, George, you never mentioned that this was your problem. And you
would run into the same problem, given your definition above,
regardless
of database (unless the database product has a hack to account for it,
I am not aware of any).
Not true. PostgreSQL
It would appear that LOAD DATA FROM MASTER processes databases and
tables alphabetically. When a merge table is being copied, and it's name
is alphabetically before some/any/all of it's components, the process
fails with a 1017 couldn't find file error.
Has this been fixed? If so, as of which
Hi!
1.1) Full Text Search can, according to the manual, be performed without
the FTS index, but it is slower.
1.2) MySQL can only use 1 index per join per table.
= This means that if I specify the USE INDEX (some_non_fulltext_index),
the FTS will be performed without the index, and
On Fri, 18 Jan 2002, Markus Lervik wrote:
Hello all!
We've requested a database from different companies, and specifically
said we wanted MySQL or PostgreSQL because of the open source angle
and we're a library.
One company offered MS SQL as the platform and said that they can later on
Hi.
I thought it would be useful to share my findings. They all relate to the
4.0.1 release. It would be nice to have some clarification on whether this is
expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted
index, etc), and what you guys think could be causing it.
1.1)
On Thursday 27 Dec 2001 23:31, Billy Reed wrote:
I am new to MySQL and am trying to convert :
SELECT SUM(DistKm) AS Distance FROM (SELECT TOP 5 DistKm FROM XCLeague
WHERE LoginID='billyreed' AND HGPG='PG' ORDER BY DistKm DESC)
Can anyone suggest how this is done in MySQL. It doesnt seem to
Hi.
Just wondering if this is something that has been planned for MySQL...
If MERGE table are used, from the documentation, my understanding is that
they are searched in sequence when a SELECT is issued. However, would it not
be reasonably easy to implement a parallel search algorythm, so
On Monday 24 Dec 2001 06:37, Michael Widenius wrote:
- A Query cache to cache results for SELECT statements. This should
give a major speed improvement for queries on read-intensive tables.
More information can be found at:
http://www.mysql.com/doc/Q/u/Query_Cache.html
This is a
On Saturday 22 Dec 2001 19:42, Gary Huntress wrote:
I've just checked my IDE parameters for one of my linux mysql servers.
Using hdparm -c -d I've discovered that I'm running at the default 16 bit
non DMA. I'm assuming that enabling both of these should increase
performance, possibly
On Tuesday 13 Nov 2001 17:05, René Fournier wrote:
And concerning database connections, my ISP asks that I always close a
MySQL connection with a mysql_close()--which I can understand.
They probably use persistent database connections for Apache. If that is the
case, if you keep opening
On Thursday 13 Dec 2001 03:42, Jack A. Fobel wrote:
Hello,
Coming from an ASP world, I'm trying to learn how to break the browser from
caching. I am using variables and their values in the querystring to
update a mysql database with perl. I am also re-querying the database to
pull back the
On Monday 10 Dec 2001 14:08, Etienne Marcotte wrote:
PLEASE
can everybody use a descriptive subject?
I've got an additional idea - how about configuring the mailing list remailer
to put something like [MySQL-General] or [MySQL-Internals] in the subject
line? For some of us who are on
On Tuesday 04 Dec 2001 13:49, Emil Rasmussen wrote:
Hey
Does anyone have some optimization tips for this query:
SELECT count(id) FROM tblTabel WHERE fieldName != '' AND
DATE_FORMAT(myDateField,'%Y%m%d') = 20011120;
It does not use the index i have created, so it scans the entire table,
On Tuesday 04 Dec 2001 14:58, Emil Rasmussen wrote:
SELECT count(id)
FROM tblTabel
WHERE fieldName != '' AND
(
myDateField = 2001112000 AND
myDateField 2001113000
);
Thank you, that was defiantly part of the solution!
I had created an index on both fieldName og
Does anyone have some optimization tips for this query:
SELECT count(id) FROM tblTabel WHERE fieldName != '' AND
DATE_FORMAT(myDateField,'%Y%m%d') = 20011120;
It does not use the index i have created, so it scans the entire table,
which is a bit to slow.
The problem off course
On Saturday 01 Dec 2001 10:41, Ovanes Manucharyan wrote:
I have lots of text documents archived in a mysql database. I need
to compare these documents to see which ones are similar (either they
may have a small formatting difference or have a word or two different).
Is there a function/method
We are currently using MySQL for our database driven website. Currently,
we have about 100,000 users. In January, we will be getting 2 million
new registered users on our website.
Yes, but how many hits are you expecting, and what sort of queries will be
ran?
We're buying a $50,000 Sun box
On Friday 30 Nov 2001 16:33, Jason Burfield wrote:
First of all, the idea of data loss because one disk has gone bad on RAID-5
is not possible. RAID-5 specifically allows you to loose up to 1 disk at any
one time, and stay active.
The reason why RAID-5 is not recommended for MySQL is speed.
On Thursday 29 Nov 2001 16:18, Fabien R. wrote:
I saw somewhere that this comparaison existed but I can't remember
where.
Does it talk to anyone ?
I haven't seen one between InterBase and MySQL, but I do remember seeing one
between PostgreSQL and InterBase. Allegedly, they thought that
On Wednesday 28 Nov 2001 10:37, Sergei Golubchik wrote:
Just added:
% ./ft_dump
Use: ./ft_dump [-dscvh] table_name index_no
-d dump index (incl. data offsets and word weights)
-s report global stats
-c calculate per-word stats (counts and global weights)
-v be
On Tuesday 27 Nov 2001 20:17, Mike Wexler wrote:
The query
SELECT * FROM table
WHERE MATCH (description) AGAINST (+A +really +nice +toy IN BOOLEAN
MODE) ORDER BY MATCH (description) AGAINST (+A +really +nice +toy IN
BOOLEAN MODE) LIMIT 10
will abort the search when it
On Tuesday 27 Nov 2001 23:28, Sergei Golubchik wrote:
Another question - is there a way to acquire a list of words in the FTS
index? Someting like
SELECT Word,
count(*) AS Frequency
FROMFTSIndex
GROUP BYWord
ORDER BY
On Tuesday 27 Nov 2001 23:33, you wrote:
gcc version 3.0.2
It would appear that you tried compiling using the GCC 3.0.2 compiler. Try
downgrading to 2.95.3 (the last stable release) and try again.
Regards.
Gordan
-
Before
Second - probably it's a bug. I cannot say much as the code used by this
query was removed from MySQL source tree. It was replaced by completely
new boolean search engine written from scratch. Unfortunately it was
done several days _after_ 4.0.0 release.
Wait for 4.0.1 - it should be out in
On Monday 26 Nov 2001 20:00, Neil Zanella wrote:
Now there is one thing that we must be aware of. There are things that
mysql does not support (yet). These include foreign keys, views,
subselects, triggers, and procedural SQL, and I can't remember
if mySQL supports transaction processing
On Tuesday 27 Nov 2001 04:11, Ady Wicaksono wrote:
gcc 2.96 has bugs that affect MySQL, what bug ?
A number of bugs, and they don't just affect MySQL - there is a number of
packages that break when compiled using GCC-2.96. Some examples that I
presonally ran into at some point are:
mPlayer
On Friday 23 Nov 2001 11:27, you wrote:
Hi,
I have some doubts regarding MySql on Linux
environment.
I'd like to install MySql on linux -redhat 6.x and
above.
Could you please guide me how to proceed.
I did not find a specific document on redhat 6.x and
above in the documentations
Hi.
How do I get the query execution time from Perl/DBD? MySQL client returns
this in the console window. Is this value available through the Perl DBD
interface?
Thanks.
Gordan
-
Before posting, please check:
On Wednesday 21 Nov 2001 12:11, Christian Andersson wrote:
The obvious way to do this would be to get the time before and after the
execution and then make a simple diff (after - before) I guess that is how
the mysql client does it (butI'm not sure)
I do not think that mysql itself provides
Hi.
How can I make FTS index single-character words? I have tried changing the
ft_* values in my.cnf and rebuilding the tables/indices, but I still seem to
be unable to get indexing of single-character words to work.
For example, if I need to index occurences of c++, it doesn't work. I
Hi.
What do I need to do to make FTS index things like c++? I have tried setting
ft_min_word_len=0
and
ft_min_word_len=1
in /etc/my.cnf.
Restarted the mysqld and did a RENAME on the table followed by a new CREATE
TABLE and an INSERT ... SELECT to import the data back into the correctly
On Saturday 10 Nov 2001 21:00, Franklin Schmidt wrote:
The worst thing any development tool can do is silent unwanted favors.
Java and C don't do unwanted favors which is why they are great.
Javascript and most Microsoft tools do lots of unwanted favors which is
why I hate them. This is a
On Friday 09 Nov 2001 03:36, DownloadFAST.com wrote:
Mr. Bobic,
[snip]
The only thing that matters is that every time you respond on the list, you
are only making a fool of yourself in the eyes of the many people who are
lurking. They can see right thru your motives in sending this post
On Friday 09 Nov 2001 12:11, DownloadFAST.com wrote:
Considering the features you want (IIRC you only mentioned the
default values in tables) - why don't you try PostgreSQL instead?
My understanding is it is much slower.
That is what I am hoping for. Or rather, I am hoping that MySQL proves
On Friday 09 Nov 2001 12:08, you wrote:
MySQL
On Friday 09 Nov 2001 11:37, you wrote:
Note on what is going on here...
The paragraph below was from a private email I sent to Gordon. And now
Gordon just responded to it on the public list.
Gordon, I was strongly hinting to you in
Hi.
I've just set up my prototype so I can benchmark comparatively tthe profmance
between PostgreSQL and MySQL.
There's good news, and there's bad news.
The good news is - MySQL is faster by about 2 times.
The bad news is - MySQL is ONLY faster by about 2 times.
Now, I DO understand that
46 matches
Mail list logo