Jed Reynolds wrote:
I'm seeing errors in my application where I'm getting from simple
selects every few hours:
I do a flush table activity_profiles; check table activity_profiles;
and the table seems to have fixed itself.
Any thots?
Thanks for the thots, guys. It turns out one of my
I have always used this for de-duplicating...
ALTER IGNORE TABLE mytbl ADD UNIQUE KEY ( myField1, myField1 ) ;
It works a treat, hope it helps
Roger
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: 20 November 2008 00:35
To: jean claude babin
Cc:
As a sidenote, your strings should be enclosed by single quotes, as per
SQL standard, not double quotes, those are reserved for delimited
identifiers.
Hmmm. I've sort-of carried that over from the way I do PHP. I tend to use
single quotes for strings that have no variables in them, so I use
Tompkins Neil wrote:
Hi
We are looking to upgrade our version of mySQL to the latest version of
mySQL 5. One of the main features we are going to think about using is
replication for our website data. Basically we have 2 websites located in
the UK and US which share similar information, and we
Chris,
I might be being an idiot.
Yes, you are :-)
-122.1529 is between -121.148 and -121.1575
This is not true!
-122.something cannot be between -121.somethingother and -121.somethingelse
-121.1529 is between -121.148 and -121.1575
Regards,
--
Jigal van Hemert.
--
MySQL General
Hi,
Yesterday i encounter a very strange problem, i found some data on a
replication db differ from that on the master.
master:
+-+++-+-++
| id | date | uid| type_id | report_type | amount |
Hi,
I installed MySQL-5.0.67_1.
When I execute CHECK TABLE information_schema.COLUMNS FOR UPGRADE I
get the message:
++---+--++
| Table | Op|
Ok...based on the responses that I received so far...it seems like maybe
I should be leaning toward a non virtualized solution.
What I am wondering now is...
1)would it be better to have one MySQL instance running and have the
developers each have their own DB inside that one instance?
Check out Giuseppe Maxia's MySQL Sandbox program. It is a very easy way
to run however many MySQL servers you want with separate config files
and such .. heck..even separate versions if you want (one 5.0, one 5.1,
one 6.0). It is available here: https://launchpad.net/mysql-sandbox
Will take
Hi Shain, all!
Shain Miley wrote:
Ok...based on the responses that I received so far...it seems like maybe
I should be leaning toward a non virtualized solution.
Virtualization includes overhead.
It is fine as long as your application can tolerate that, but if your
performance demands grow
[snip]
Virtualization includes overhead.
It is fine as long as your application can tolerate that, but if your
performance demands grow there will be a point where a DB server in a
virtual machine will cause trouble but the same HW as a real machine
would still suffice.
[/snip]
We run MySQL in
quote
we are going to be
setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2
slaves-ro)...each having 16 to 32 GB of RAM.
quote
If it is still true what you wrote you need different installations.
Of course master and slave on the same host has the only use of an
online
Hi,
Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
Is it better from source or can it be from yum?
I do prefer yum because it's easier for upgrades, but I don't know if
the available package was compiled for that.
Thank you,
Ronan
--
MySQL General Mailing List
For
We are using MySQL 5.0.22 on CENTOS/redhat linux. The table and database
character-sets are all utf8.
We have a database supporting numerous languages. Of course, full-text works
beautifully with most of the languages.
But Chinese and Japanese are giving us problems, and there is NO reason
Have you tried in boolean mode?
Santino Cusimano
At 16:30 -0500 20-11-2008, Little, Timothy wrote:
We are using MySQL 5.0.22 on CENTOS/redhat
linux. The table and database character-sets
are all utf8.
We have a database supporting numerous
languages. Of course, full-text works
Aha! I get it! I *was* being an idiot. The longitude of @g1 is 12*2*, not 121...
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio [EMAIL PROTECTED] wrote:
Hi,
Does anybody has a tip to install a MySQL Cluster in a Linux CentOS-5?
Is it better from source or can it be from yum?
You may execute mysql_fix_privileges_table script to upgrade all of your
mysqld.
On Thu, Nov 20, 2008 at 7:54 PM, Ronan Lucio [EMAIL PROTECTED] wrote:
Hi,
I installed MySQL-5.0.67_1.
When I execute CHECK TABLE information_schema.COLUMNS FOR UPGRADE I get
the message:
I had done many instances on one machine before, the most important thing
is about the my.cnf.
And there are many individual my.cnf, which belonged to their own instance.
Since your total memory is 32GB, you can assign them properly.
On Fri, Nov 21, 2008 at 3:40 AM, Claudio Nanni [EMAIL
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using
LOCK TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got error 1
from storage engine (1030)
mysqldump: Couldn't execute 'show create table `Autor`': Got error 1
from
How can I determine if a temporary table exists? Normally I use something like:
create temporary table Tablex like Table1;
show tables like Tablex;
but the Show Tables never displays any rows for a temporary table even
though the temporary Tablex exists. (All in same thread).
So is there a
Try drop table if exists Tablex;
On Fri, Nov 21, 2008 at 9:53 AM, mos [EMAIL PROTECTED] wrote:
How can I determine if a temporary table exists? Normally I use something
like:
create temporary table Tablex like Table1;
show tables like Tablex;
but the Show Tables never displays any rows
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got
What is your storage engine used?
On Fri, Nov 21, 2008 at 8:59 AM, Marten Lehmann [EMAIL PROTECTED] wrote:
Hello,
what do these errors mean:
mysqldump: Got error: 1030: Got error 1 from storage engine when using LOCK
TABLES
mysqldump: Couldn't execute 'show create table `Antrag`': Got
Hello Moon's Father,
That would be great..if it was in english ;)
Hi.
Here are some of my tests on Centos 5.0.
http://blog.chinaunix.net/u/29134/article_71956.html
On Fri, Nov 21, 2008 at 3:49 AM, Ronan Lucio [EMAIL PROTECTED]
wrote:
Hi,
Does anybody has a tip to install a MySQL
Thanks for advice.
There're no environment for me to test the cluster again right now. Hope the
chance chooses me, then the english version will be done.
:)
On Fri, Nov 21, 2008 at 10:48 AM, steve grosz [EMAIL PROTECTED]wrote:
Hello Moon's Father,
That would be great..if it was in
At 08:02 PM 11/20/2008, you wrote:
Try drop table if exists Tablex;
Ahhh, I don't necessarily want to drop the table if it already exists. :)
If the table already exists then I'll add new rows to it (and keep the
existing rows). If the table doesn't exist, then I'll create it.
I suppose
In the last episode (Nov 20), mos said:
At 08:02 PM 11/20/2008, you wrote:
Try drop table if exists Tablex;
Ahhh, I don't necessarily want to drop the table if it already
exists. :) If the table already exists then I'll add new rows to it
(and keep the existing rows). If the table doesn't
28 matches
Mail list logo