Sid Lane wrote:
stupid non-technical ?:
does anyone know what the registration fee is going to be for the 2008
conference? my mgr needs a # today to put in next yr's budget & I couldn't
find it on the conference site. if it's not been finalized could someone
tell me what it was last year?
Hi
Frank-
I've had the exact same issue crop up in our prod servers - it was very
frustrating, as it was intermittent and would affect some of our slaves,
but not all.
We had a lot of back and forth with MySQL support without really being
able to consistently pin down or reproduce the issue.
Ultima
Baron,
Thanks for the quick response. I do have the binlogs still on the
master, so I should be able to do that - however I saw a post somewhere
(lost the link at this time) saying that resetting the slave will drop
any temporary tables which could cause issues. I'm not sure at this
point if
Frank,
Frank Bottone wrote:
I've been having trouble with my master/slave server - recently I was
having a few repeated issues where the mysql slave would stop due to
"invalid sql syntax", but the queries executed fine on the master. I
would have to manually dig through the logs and then find
I've been having trouble with my master/slave server - recently I was
having a few repeated issues where the mysql slave would stop due to
"invalid sql syntax", but the queries executed fine on the master. I
would have to manually dig through the logs and then find the query to
manually execute
stupid non-technical ?:
does anyone know what the registration fee is going to be for the 2008
conference? my mgr needs a # today to put in next yr's budget & I couldn't
find it on the conference site. if it's not been finalized could someone
tell me what it was last year?
thx!
On Sat, 06 Oct 2007 00:25:04 -0700, Werner Van Belle <[EMAIL PROTECTED]>
wrote:
Hello,
On Friday 05 October 2007 01:11:35 James Card wrote:
The application I'm working on uses MySQL 5.0.41 and we also need to
retrieve some data from a SQL-Server database in another department.
SQL-Server
In the last episode (Oct 08), Ace said:
> On 10/7/07, Dan Nelson <[EMAIL PROTECTED]> wrote:
> > In the last episode (Oct 06), Ace said:
> > > You all know the size problems with ibdata and log files. We plan
> > > to move those files to SAN to have maximum storage possible. We
> > > did so with con
I had a server crash over the weekend and discovered that I don't know
as much about MySQL error logging as I thought. The error logs were
empty because of FLUSH LOGS.
What I learned today is if I specify the log-errors parameter in
/etc/mysql/my.cnf, every time there's a FLUSH LOGS (or mysql
Hello guys,
I would like to get some registers on my database that are older than 90
days, and after delete it because the table is very larger:
mysql> select count(*) from max_ecardsent;
+--+
| count(*) |
+--+
| 1172330 |
+--+
1 row in set (0.01 sec)
But I'm confusing
Rajan,
I believe you are talking about a NAS setup, which is different from
the SAN configuration I was referring to. Check out
http://www.nas-san.com/differ.html for a quick comparison.
With NFS volumes, your adding several layers of overhead when
accessing the disks which has a drastic effe
On table it is! :-D
Thanks to all of you who helped me with my "problem".
-afan
John Meyer wrote:
> Afan Pasalic wrote:
>> hi,
>> I have a employees table (first name, last_name, address, city,
>> state, zip, phone,...).
>> though, I got a requested to add additional info about people, like
>
Yes Scott! Only thing that confused and still confusing me is the following
note on mysql site -
"*Note*
It is not a good idea to configure InnoDB to use datafiles or logfiles on
NFS volumes. Otherwise, the files might be locked by other processes and
become unavailable for use by MySQL. "
http:/
Rajan,
In a SAN configuration, the lun/volume should appear just like a
locally attached physical disk on your server. MySQL will not need any
special configurations to access it, just poiint the datadir to the SAN
disk.
Regards,
Scott Tanner
On Mon, 2007-10-08 at 11:06 +0530, Ace wrote:
> Tha
Hi,
> I tried this :
> CREATE TRIGGER username_check AFTER UPDATE ON `users`
> FOR EACH ROW
> UPDATE users SET users.username = concat(users.firstname,"
> ",users.lastname) where users.id=NEW.id;
> END
> ;
>
> But it throws the error:
>
> "Can't update table 'users' in stored function/trigger
15 matches
Mail list logo
