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
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
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 of
n 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 bi
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
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 dbNa
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 co
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 / x86
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 c
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 t
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
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
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) F
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 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 see
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 that
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 ra
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 sig
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 con
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 bac
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 mult
On Wednesday 05 Dec 2001 09:30, Emil Rasmussen wrote:
> > CREADE INDEX myDateField_Index
> > ON tblTabel
> > (
> > DATE_FORMAT(myDateField,'%Y%m%d')
> > );
> >
> > This may or may not work, but it's worth a shot, if you prefer your query
>
> in
>
> > the format it was in before.
>
> It did not wor
> > 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 pro
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 fi
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 ta
On Saturday 01 Dec 2001 21:29, Ady Wicaksono wrote:
> How to get an advantage from Dual ProcessorMachine when i'm using MySQL,
> should i recompile MySQL what option should be activated ?
You need to run more than one query at a time, for a start.
I am not sure about how good SMP support for va
> 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
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/met
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. RA
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
On Wednesday 28 Nov 2001 10:37, Sergei Golubchik wrote:
> Just added:
>
> % ./ft_dump
>
> Use: ./ft_dump [-dscvh]
>
> -d dump index (incl. data offsets and word weights)
> -s report global stats
> -c calculate per-word stats (counts and global weights)
> -v be verbose
> -h
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
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
> > ORDE
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 sear
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
I
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 e
> 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 o
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
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 provid
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:
http://www.m
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
unders
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
named
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
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 this
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
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 pr
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
48 matches
Mail list logo
