Hi wultsch,
Thanks a lot.
Every thing is going fine. I am only concerned with duplicate index, as it
is using disk space.
Is there any solution so that i can ignore duplicate index by altering the
table design. OR i have to end up with duplicate index.
Thanks,
Krishna Chandra Prajapati
On
I just did a quick look at the documentation on the mysql spatial
extension and it seems like over kill for what you are looking for. An
easy way to approximate the search for all points a given distance from
another is to simply use a bounding box. An index on the X and Y
coordinates of the
Krishna Chandra Prajapati schrieb:
Hi All,
Below is the table design on mysql server.
CREATE TABLE `coupon_per_course` (
`coupon_id` int(10) unsigned NOT NULL default '0',
`course_id` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`coupon_id`,`course_id`),
KEY
Hmmm...
no more ideas or suggestions anybody? :(
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Michael wrote:
Has anyone successfully called the C API routines for MySQL from COBOL?
Dude, April 1 was, like, a month ago now.
You may have better luck finding an ODBC bridge for your COBOL
environment, which let you access MySQL indirectly.
--
MySQL General Mailing List
For list
The first question that occurs to me is, Why on earth would you want an app
to display 2500 rows? You must have one incredible monitor with a resolution
beyond my wildest dreams! I would look into the LIMIT predicate and use it
to grab say 50 rows at a time, or fewer, and post a marker so you know
Hi, I am using zabbix (monitoring software) with mysql. zabbix goes
zombie and complains with messages suggesting that Database cache
perhaps is corrupted. How can I check and fix it? I am using Centos
5.1, cpu Intel(R) Xeon(R) CPU and 1 Gb of RAM.
my.cnf is as follows:
[client]
port
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add a 64bit slave
Mike wrote:
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of documentation on migration or anything
else regarding 64bit MySQL.
My current setup consists of one master and two slaves (all using 32bit and
MySQL 5.0). I am looking to add
On Fri, 25 Apr 2008, B. Keith Murphy [EMAIL PROTECTED] wrote:
I would just dump the database from the 32-bit platform and import it
into the 64-bit server.
By dump do you mean mysqldump, or some other process?
--
Tim McDaniel, n00b, [EMAIL PROTECTED]
--
MySQL General Mailing List
For list
As long as you use dumps to restore your databases on the new 64bit system
(instead of the binary files) you should be fine
Olaf
On 4/25/08 11:23 AM, Mike [EMAIL PROTECTED] wrote:
I would like to move from 32-bit to 64-bit MySQL within the next year.
Unfortunately, there is not a lot of
On Fri, Apr 25, 2008 at 12:27 AM, Chris W [EMAIL PROTECTED] wrote:
I just did a quick look at the documentation on the mysql spatial extension
and it seems like over kill for what you are looking for. An easy way to
approximate the search for all points a given distance from another is to
On Fri, Apr 25, 2008 at 11:45 AM, Olaf Stein
[EMAIL PROTECTED] wrote:
As long as you use dumps to restore your databases on the new 64bit system
(instead of the binary files) you should be fine
Olaf
I have so much data that we can't take a mysqldump of our database. The
directory tared is
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add more 64 slaves.
Olaf Stein wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try it.
Why cant you take a dump, you can do it table by table, you will have some
downtime though.
One option might be to use a 64bit slave and make that the master and then
add
Mike wrote:
I have so much data that we can't take a mysqldump of our database. The
directory tared is about 18GB.
Worst-case expansion for SQL data from binary to text format is about
5:1, which applies mainly to numeric data, not text. That's only 90 GB;
I carry a bigger hard drive in my
Every statement should be executed on the slave from the masters binary log
so in my opinion you should be ok
On 4/25/08 12:20 PM, Mike [EMAIL PROTECTED] wrote:
That what I want to do, but I'm not sure if the data will propagate right.
Because of lack of documentation for 64bit.
On Fri,
That what I want to do, but I'm not sure if the data will propagate right.
Because of lack of documentation for 64bit.
On Fri, Apr 25, 2008 at 12:03 PM, Olaf Stein
[EMAIL PROTECTED] wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns but I
would not try
On Fri, Apr 25, 2008 at 12:08 PM, B. Keith Murphy [EMAIL PROTECTED]
wrote:
Olaf Stein wrote:
Probably not
AFAIK it should work in theory if you have no floating point columns but
I
would not try it.
Why cant you take a dump, you can do it table by table, you will have
some
I am in process of planning 32 to 64 migration as well. I googled the
following, but it could be only relevant to a specific application:
It should be noted that, when switching between 32bit and 64bit server
using
the same data-files, all the current major storage engines
(with one
Hi all, I've got a problem. A client of ours changed ip addresses on
their mysql server, and I believe MySL was set up to listen on the old
ip address. How can I see what ip address mysql is set to listen on,
and how can I change it?
Thanks!
Jim
--
MySQL General Mailing List
For list
Mike wrote:
I not sure
what you mean by binary copy. Can you please explain?
A binary copy means copying the MySQL data directory directly, rather
than do a mysqldump, which converts the data to text format. The text
dump is converted back to binary format for disk storage on loading it
boll wrote:
I would like to know the correct way to move the mysql data directory to
a different disk partition, so that the data can be accessed by mysql
under linux or windows. I'm using Ubuntu 7.1 and Windows XP.
I wrote these steps for 4.0, I think they should work for you
Hi,
I have 4 tables and need to use 1 query for displaying :
prodbarcode,prod_description,stock_on_hand,qty, (qty-stock_on_hand) Variance,
cost_price, (Variance*cost_price) Var_Amount for a specific store in StCount.
StCount contains several sessionid for 1 store.
C_Sess contains all the
24 matches
Mail list logo