At 06:55 PM 6/24/2006, Santiago del Castillo wrote:
Hi, is usual to have a lot of HD writing on a MySQL server where (according
to mytop) there are between 800 and 1200 queries per second? my MRTG is
showing a lot of HD Writing and i wanted to know if it's usual. The database
is growing about 11
Hi, is usual to have a lot of HD writing on a MySQL server where (according
to mytop) there are between 800 and 1200 queries per second? my MRTG is
showing a lot of HD Writing and i wanted to know if it's usual. The database
is growing about 11 MB every 3 minutes.
FYI, I don't have any log-type (
>I need the query to select the data from table1 on db1 and then
select the
>data from table1 on db2 and return a result of where if a field
data value
>is found in both tables that matches on name for example, it would
count the
>occurrences.
Not entirely clear. Do you mean ...
SELECT
Hello List!
Does anybody know how to select and build a result set from two or more
databases with the same table structures that are on the same server.
I need the query to select the data from table1 on db1 and then select the
data from table1 on db2 and return a result of where if a field dat
Hi all i am compiling mysql 4.1.20 with he following options:
export CFLAGS="-O3 -fomit-frame-pointer -march=nocona -msse3"
export CXXFLAGS="-O3 -fomit-frame-pointer -felide-constructors
-march=nocona -msse3"
./configure --prefix=/opt/.mysql-4.1.20 --enable-assembler
--with-mysqld-ldflags=-al
i don't know the proper place to send this and i didn't see any
mention of it in the list archives. there is a really small problem
with the configure script in 5.1.11 (and other versions, perhaps, but
i haven't looked) that prevents building with openssl support. patch
below.
thanks,
2006/6/24, Asif Lodhi <[EMAIL PROTECTED]>:
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
mathematically speaking, there no such number like 5.0.5 anyway...
5.05 perhaps...
MySQL are numbered according to a X.Y.Z release number.
X : is the major version, where major
Hi,
The table has ~2 million records and has 3 columns one of which is a text
field which on an average has 2000 characters(English alphabets, space are
there for now, but if required can be eliminated).
eg: "adfastsdfasgadfdfdsaffagdasfd adfsadfadsgdsfdfsdfsgsdfdsg fg adfafg
adfddfgadsfdsgfghfg
John Hicks wrote:
Karl Larsen wrote:
I and a friend have written SQL to big Oracle DB but not much to
MySQL on our own computers. I find that there is a QUERY in the list
for MySQL but it does nothing much. Also I was glancing through the
mamouth MySQL reference manual and saw there are a b
H - try adding a "group by b.zipcode" to the end ...
Dan
Scott Haneda wrote:
Scott, I think you want something like this, then, assuming you still
want to limit by radius from a given ZIP.
SELECT b.zipcode,
sum( b.inc_level1 ), sum( b.inc_level2 ),
FROM zipcodes a, zipcodes b
WHE
Karl Larsen wrote:
I and a friend have written SQL to big Oracle DB but not much to
MySQL on our own computers. I find that there is a QUERY in the list for
MySQL but it does nothing much. Also I was glancing through the mamouth
MySQL reference manual and saw there are a bunch of tools that
the thing with JOINs are you gotta JOIN a table ON another table where
something matches something else (in most cases). I tried to clean this up a
bit but im rather new to mysql.
SELECT DISTINCT
(td.td_id),
td.venue_id as ven_id,
td.td_date as td_date,
art.NAME as art_name,
art.WEB as art_url,
a
Duncan Hill wrote:
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
/etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start
the system. But it has to be done every time I turn on the computer. I
do not understa
On Saturday 24 June 2006 12:50, Asif Lodhi wrote:
> Hi,
>
> Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
> Is that correct? Or 5.0.5 came first and then came 5.0.22?
After. 5 < 22.
Major.Minor.Release
--
Scanned by iCritical.
--
MySQL General Mailing List
For list a
On Saturday 24 June 2006 12:49, Karl Larsen wrote:
> Hi Joerg, I'm using Ferdora Core 4 of Red Hat and I have in
> /etc/rc.d/init/ a file mysqld which when I use ./mysqld start does start
> the system. But it has to be done every time I turn on the computer. I
> do not understand your patch. I
Hi,
I am replying to my own post to clarify my query. Actually, I have
5.0.22 installed and I want to use the BIT data-type on InnoDB Engine.
Can I do it or do I have to install 5.0.5 version (which is not
stable) ?
--
TIA
Asif
On 6/24/06, Asif Lodhi <[EMAIL PROTECTED]> wrote:
Hi,
Mathemat
Hi,
Mathematically speaking, the 5.0.22 I am using came _before_ 5.0.5.
Is that correct? Or 5.0.5 came first and then came 5.0.22?
--
Asif
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Joerg Bruehe wrote:
Hi Fredrik, all!
Fredrik Andersson wrote:
Hi all
I have problems getting MySQL autoboot on my RedHat installation.
[[...]]
In addition to permissions (see the other posts), there is another
possible problem:
Depending on how your environment is set up, the MySQL server
> Scott, I think you want something like this, then, assuming you still
> want to limit by radius from a given ZIP.
>
> SELECT b.zipcode,
> sum( b.inc_level1 ), sum( b.inc_level2 ),
> FROM zipcodes a, zipcodes b
> WHERE a.zipcode = "94949"
> AND (3956 * (2 *
> ASIN(SQRT(POWER(SIN(((
19 matches
Mail list logo
