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 Thu,
David Perron schrieb:
Hi Sebastian-
Wanted to follow up on this. I figured out the problem. You actually
have to use the LEAST & GREATEST operators when comparing multiple
values, this statement works perfectly.
LEAST(EndDays,Q2EndDays) - GREATEST(Q2StartDays,StartDays) as DaysInQ2,
Thank
D Hill schrieb:
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number
of slow queries. Perhaps it is because of some additional indexes
needed. As soon as I enabled the option
'log_queries_no
Hi all,
I have one table as following
AccessDetails
DateTimeUserName
SiteName StatusVirus_Category
|2008-04-23 | 14:27:38 | 172.16.1.40|
en.wikipedia.org | A | unclassified |
| 2008-04-23
JW wrote:
Hello,
We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
server.
Specs are:
OS: Linux Debian 4.0/Etch
RAID 5 on 4x U320 15k rpm drives
(uses a perc-raid 3/DC hardware raid controller)
16GB of RAM
4 3.0 Ghz Xeon processors - I think they're dual core, in /p
Velen wrote:
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it's a
I have been storing points in mysql without use of the spatial
extension. I do not forsee the need to ever store more than points,
and am wondering if the spatial extensions would offer any significant
advantages. I have looked a bit for tutorials, etc... and have not
found much.
One feature that
Did you "FLUSH PRIVILEGES"?
I'd also check that the username and passwords are the same for each
host entry, I've had problems if passwords were different for a shared
username from different hosts.
On Apr 24, 2008, at 8:58 AM, Adam Gerson wrote:
I set up a user and entered % for the host.
I think what we need to know is more stuff about the database itself.
How big is it? I assume if you were able to serve it from a Mac Mini it
can't be all that big.
16GB should be big enough to contain all the data and serve it up quickly.
And while 4-disk RAID 5 isn't all that great, it's cert
Hi,
May be it's not the right forum i'm posting to.
I have a Mysql Query : Select a.code,b.description,
b.other_details,a.qty,a.price from xyz a, bcd b where a.code=b.code and
a.id='5' order by a.id
This is running fine but when using VB6 to display it in a Msflexgrid, it's a
nightmare! It w
Hi,
On Thu, Apr 24, 2008 at 12:20 PM, Jeremy Cole <[EMAIL PROTECTED]> wrote:
> Hi,
>
> >
> > > Someone suggested I try the -amd64 kernels which provide 64 bit but
> when I try
> > > to boot it I get various errors about "this CPU does not support long
> > > (something) please use a 32-bit OS" -
Hi,
Someone suggested I try the -amd64 kernels which provide 64 bit but when I try
to boot it I get various errors about "this CPU does not support long
(something) please use a 32-bit OS" - the 64 bit install CD says the same
message. So I assume these are not 64 bit CPUs.
They almost cer
Hi,
On Wed, Apr 23, 2008 at 11:07 PM, JW <[EMAIL PROTECTED]> wrote:
> Hello,
>
> We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
> server.
>
> Specs are:
> OS: Linux Debian 4.0/Etch
> RAID 5 on 4x U320 15k rpm drives
> (uses a perc-raid 3/DC hardware raid control
On Thu, Apr 24, 2008 at 6:40 AM, Krishna Chandra Prajapati
<[EMAIL PROTECTED]> wrote:
> 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',
> P
On Thu, 24 Apr 2008 at 10:16 -0400, [EMAIL PROTECTED] confabulated:
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
IMHO not in this case, cause it is just a simple "WHERE field IN ()"
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't us
Hello,
We recently purchased a Dell PowerEdge 6650 thinking it would be a real fast
server.
Specs are:
OS: Linux Debian 4.0/Etch
RAID 5 on 4x U320 15k rpm drives
(uses a perc-raid 3/DC hardware raid controller)
16GB of RAM
4 3.0 Ghz Xeon processors - I think they're dual core, in /proc/cpuinfo i
>-Original Message-
>From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
>Sent: Thursday, April 24, 2008 10:01 AM
>To: 'Padiyath Sreekumaran'; mysql@lists.mysql.com
>Subject: RE: Php-mssql connection problems on Windows XP
>
>When using odbc_connect, you don't use the DSN you've previously
>crea
On Thu, Apr 24, 2008 at 2:54 AM, Sebastian Mendel
<[EMAIL PROTECTED]> wrote:
> IMHO not in this case, cause it is just a simple "WHERE field IN ()"
I'm pretty sure that just looks like a bunch of ORs to MySQL. If it
didn't use the index with OR, it won't use it with IN.
What usually works is to
On Thu, 24 Apr 2008 at 08:58 +0200, [EMAIL PROTECTED] confabulated:
D Hill schrieb:
I have something I am trying to resolve with an over abundant number of
slow queries. Perhaps it is because of some additional indexes needed. As
soon as I enabled the option 'log_queries_not_using_indexes =
When using odbc_connect, you don't use the DSN you've previously created.
You use the complete definition of the connection. Here's an example of
connecting to an MS Access database:
define('ODBC_CONNECT',
'DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=server\\a
I set up a user and entered % for the host. I am not able to connect.
However, if I change the host value to my FQDN it works fine. Shouldn't
the wildcard allow me to connect from any host?
Thanks,
Adam
--
Adam Gerson
Assistant Director of Technology
Apple Certified System Administrator (ACSA
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 `idx_coupon_per_course` (`coupon_id`),
KEY `idx_coupon_
Padiyath Sreekumaran schrieb:
Hello Sebastian,
Thanks for your mail. But I donot see any difference in my $username and yours
except
'(").
what surprise, yes, thats it!
you have to use no quotes at all (or doublequotes) around variables, RTMF is
this case the one from PHP
but what has thi
Padiyath Sreekumaran schrieb:
I got the following error when I execute the previous script:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC
SQL Server Driver][SQL Server]Login failed for user '$username'., SQL state
28000 in SQLConnect in C:\xampplite\htdocs\scri
Hello,
I can connect to a SQL server in the following way from my windows OS machine:
Start --> control Panel --> Administrative tools ---> Data Sources(ODBC)
and provide the necessary input. This works for me without problems.
I have installed xamp sw on this window machine. The SW version is
Hi,
I guessed it was something like it and that is why I wanted to make sure how
it should be done. Using the ALTER TABLE table DISCARD TABLESPACE doesn't
seem to work as expected - I succeeded to crash the test server twice. See
the mysql log details below.
What I did was the following:
- cre
Mark,
When you try to log-in to the new instance, are you specifying the new
port number to the client? If you don't give it the new port number,
then it will connect to the default port, which is presumably your
4.0.20 instance.
Mark-E wrote:
I have a Solaris box where MySQL 4.0.20 instanc
Hi,
The changelogs for MySQL Cluster have been consolidated and can now be found
here: http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news.html
They're now arranged by NDB version number:
http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-news-6-3.html
http://dev.mysql.com/doc/refman
28 matches
Mail list logo
