 | | | MySQL General | | Hi all
What do you know about the effect of conflicting slave server IDs on
the master in general? And specifically are you aware of any issues
with MySQL 5.0.27?
Your help is very much appreWhil Hentzen wrote
> Baron Schwartz wrote
> > Whil Hentzen wrote
> > > Michael Dykman wrote
> > > > if you see no errors check your config... are you sure InnoDB is
> > > > enabled ?
> > >
> > > I can creatI suspect that your problem is that you are converting your date field to a
string before sorting. You shouldn 't use the same name for the alias as you
do for the field. Try
$result mysql_query( "SEL > $result mysql_query( "SELECT date_format(date '%d/%m/%Y ') as date title
> id display FROM news ORDER BY date DESC ")
>
> I have the query above the problem is oders them like so
>
> 30/05/2007May I suggest
SELECT date_format(date '%d/%m/%Y ') as mydate title
id display FROM news ORDER BY date DESC
changing the alias of your formatted date to mydate the raw value of
date is now avail$result mysql_query( "SELECT date_format(date '%d/%m/%Y ') as date title
id display FROM news ORDER BY date DESC ")
I have the query above the problem is oders them like so
30/05/2007
29/07/200Some processes on a server (64-bit Gentoo Linux with MySQL 5.0.44)
which seemed to be related to I/O on LVM volumes hung and it was
necessary to force reboot it. The mysql data was not on an LVM vo
> > I have a table with a PRIMARY KEY on id field whos
> > evalue is populated usin auto_increment.
> >
> >
> > CREATE TABLE `key` (
> > `id` int(10) unsigned NOT NULL AUTO_INCREMENT
> > `sid` smHi
> I have a table with a PRIMARY KEY on id field whos
> evalue is populated usin auto_increment.
>
>
> CREATE TABLE `key` (
> `id` int(10) unsigned NOT NULL AUTO_INCREMENT
> `sid` smallint(4) Hi All
I have a table with a PRIMARY KEY on id field whos
evalue is populated usin auto_increment.
CREATE TABLE `key` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT
`sid` smallint(4) unsignedVladimir
I have tried to recompile MySQL 5.1.21 as you
suggested but unfortunately I got the same error.
Is it possible that some other define needs to be set
?
Thanks in advance for your help
Hi All
I would like to be able to use MySQL 5.1.21 with
the PBXT engine.
I have compiled MySQL 5.1.21 64 bits on Debian 4.0
with linux 2.6 with the options specified in the
README that comes with thI have a server that has several hundred table in a few different databases
comprising almost a gig of data all running on a rather old (3.23) version
of mysql. I have used the slow query log to ideHailiang Ji wrote
> Folks
>
> A help needed. My manager 's pushed me to optimize the tables that I
> created in distributed in several DBs. I have tried best to explain to him
> that I have followedYou should read up on the "show status " and "show variables " output.
That will give you a start as to perhaps some obvious issues. For
instances your opened_tables and threads_created should not When I try to email to this list my email is reject with the following message?
Error 552 Mail with no Date header not accepted here
My Mail has a date header in it...?Baron Schwartz wrote
> Whil Hentzen wrote
> > Michael Dykman wrote
> > > if you see no errors check your config... are you sure InnoDB is
> > > enabled ?
> >
> > I can create a new database and add InnWhil Hentzen wrote
> Michael Dykman wrote
> > if you see no errors check your config... are you sure InnoDB is
> > enabled ?
>
> I can create a new database and add InnoDB tables to it without proMichael Dykman wrote
> if you see no errors check your config... are you sure InnoDB is enabled ?
I can create a new database and add InnoDB tables to it without problems.
Ack I lied. No error iHi gang
After reading through two years of 'how do I back up my database '
threads I 'm trying out the various backup mechanisms offered up.
I 've read through these steps
http //dev.mysql.com/dalso when it hits a dupl. and i skip the record and continue slave it
hits another duplicate entry almost instantly when i then drop the
table on the slave and recreate it manually and set it to myBaron Schwartz wrote
> Chris Hemmings wrote
> > Chris Hemmings wrote
> > > Baron Schwartz wrote
> > > > Hi Chris
> > > >
> > > > Chris Hemmings wrote
> > > > > Dan Buettner wrote
> > > > > > Chris a couple of thouThe results of an EXPLAIN have a lot to do with the data which is
actually on the system. In this case it seems to hinge on the
distribution of your 'price ' attribute.. how many records on your
syChris Hemmings wrote
> Chris Hemmings wrote
> > Baron Schwartz wrote
> > > Hi Chris
> > >
> > > Chris Hemmings wrote
> > > > Dan Buettner wrote
> > > > > Chris a couple of thoughts -
> > > > >
> > > > > First your Chris Hemmings wrote
> Baron Schwartz wrote
> > Hi Chris
> >
> > Chris Hemmings wrote
> > > Dan Buettner wrote
> > > > Chris a couple of thoughts -
> > > >
> > > > First your index on the section is doing yoFan Wellington wrote
> > > Given MySQL 4.0.12 I need to implement a pageview log with a
> > > resolution of 1 day.
If you want to brute-force it I think I would go this route
create table hits > > Given MySQL 4.0.12 I need to implement a pageview log with a
> > resolution of 1 day.
......
>
> Would the "REPLACE " method work?
>
> David
Hmmm...as I read the docs the "LOCK IN SHARED MODEThing 1 your auto_increment key MUST be your primary key.
Thing 2 the timestamp field will be updated with the current epochal
timestamp which only increments every second.. as you have a
timestW00ps forgot to update subject of my email
WiNK / Rob wrote
> Hi
>
> I think i might have hit a bug posted on forums.mysql.com but
> apparently nobody really reads that i think.
>
> my table
>Hi
I think i might have hit a bug posted on forums.mysql.com but
apparently nobody really reads that i think.
my table
CREATE TABLE `clog` ( `cID` int(20) NOT NULL auto_increment `lID`
int(1 |
|
|
