Hi Dan,
that's exactly what I do. But it's not that fast, I missed 2 '0''s, the
table has 1 rows (which is still not big, I think), but zip is only
index. The procedure takes over a second, and that (that's the point) for
every user and every query.
But now I think it's the only way.
jan
Hi all...
I am adding a record to a table and then immediately trying to search
it with the id(primary key). I can not find it when I search with:
SELECT * FROM TABLE WHERE id=2;
Mysql finds no records. But when I flush tables then try to search
the record Mysql finds it. In other tables I
Hi all,
I'm running a MySQL server v 3.23.39 on Linux Debian. The server has 500
MB RAM. I have a table called sender with 18 columns (only integers
and varchars, no blobs) and with 3 indexes. The table has about 15000
records. Now I need to add one more column to the table with alter table
Percy Tambunan [EMAIL PROTECTED] writes:
can you tell me where to find some useful example or documentation about
using python with mysql? Especially with MySQLdb module.
thanks!
Try looking at URL: http://www.python.org/peps/pep-0249.html and
URL:
First off, this post is going to be long :)
I have designed a database that tracks member earnings on the site. Currently, the
site has been operating for two weeks, has 10,000 members, and the earnings table
already has 750,000 rows. I ran a query to see how many rows were being added
First off, this post is going to be long :)
I have designed a database that tracks member earnings on the site. Currently, the
site has been operating for two weeks, has 10,000 members, and the earnings table
already has 750,000 rows. I ran a query to see how many rows were being added each
Here's my problem:
I've just installed mysql version 3.23.51 (before this one I tried
3.23.49) compiled from scratch with:
CFLAGS=-fomit-frame-pointer -O3 -fPIC ./configure --prefix=/opt/mysql
--disable-shared --with-mysqld-user=mysql --with-debug
It compiles and runs fine, but fails as soon
Pada 23 Jul 2002 12:11:18 +0200
Andrea Carpani [EMAIL PROTECTED] menulis :
select * FROM $table1 s,$table2 t
where the two tables are choosen randomly (some of the tables are quite
big), then repeats this with another (not cached) connection. The script
runs on another machine. If I leave
On Tuesday, 23. July 2002 09:34, William_dw -- Sqlcoders wrote:
Hi!,
I'm hoping someone can give me a pointer as to what's going wrong that's
crashing our MySQL server, I've included a snippet of the log (for the last
time it restarted and then the errors after that).
020722 8:55:45
On Wednesday 17 Jul 02, Chris Tjon writes:
I recently download mysql-3.23.51 and compiled it on a solaris 9 (sparc)
system using gcc-3.1. I ran into a couple of minor compile errors which
were easily fixed by a couple of type casts.. so far, it seems like the
casts are fine here are
Pada Tue, 23 Jul 2002 03:20:54 +0200
Richard Pijnenburg [EMAIL PROTECTED] menulis :
Dear list,
I've been trying to install mysql 4.0.2. alpha.
The configuration is going well.
That also count's for the make command.
But when I run the make test command I'm getting the following error:
Pada Tue, 23 Jul 2002 09:19:27 +0800
lorenzo.kh [EMAIL PROTECTED] menulis :
Hi,
Assuming that there are 2 users for MYSQL.
First user issues 'lock tables customer_table write';
Second user wish to view the customer info using the command 'select * from
customer_table';
This select query
Pada Mon, 22 Jul 2002 12:00:14 -0700
Cindy [EMAIL PROTECTED] menulis :
b) BUT if previously set, this does not work. If you don't remember
the password, then you need to stop the mysql server (if
applicable), and (re)start it using safe_mysqld --skip-grant-tables
[and then
Pada Tue, 23 Jul 2002 00:43:51 -0400 (EDT)
Yuri [EMAIL PROTECTED] menulis :
I am acessing MySQL 3.23.51 running
on FreeBSD 4.6-i386.
Variable interactive_timeout=28800.
But without activity server disconnects
in 10 minutes. In both cases of just
mysql client and myODBC from Windoz box.
On Tuesday 23 Jul 02, David Starks-Browning writes:
On Wednesday 17 Jul 02, Chris Tjon writes:
I recently download mysql-3.23.51 and compiled it on a solaris 9 (sparc)
system using gcc-3.1. I ran into a couple of minor compile errors which
were easily fixed by a couple of type casts..
Pada Fri, 19 Jul 2002 14:51:00 -0400
Luis Manuel Cova [EMAIL PROTECTED] menulis :
Hi..
I'm working on a proyect to implement a SQL server with PHP to allow acces
to a MySQL server on the web.
The Master server (the server everybody work with) is a Windows 2000 CENTURA
SQL server.
I
Hi,
I thought that I would report a very minor bug that I have just found in the mysql
command.
(Ver 11.13 Distrib 3.23.36)
If I do something like:
select * from foo where bar=123;;
I get the result of the select followed by:
ERROR:
No query specified
This is because I
The Database is called wald_data and the fields are:-
f_name varchar(30) not null,
t_name varchar(120) not null,
sub_p varchar(120) not null,
sub_g varchar(120) not null,
datevarchar(30) not null
Hi there is there a simple tutorial on using Mysql-Front with M$ Access
as i have a number of issues relating to operational M$ Access 2000 DB
that i want to migrate to Mysql Back-end and preferable utilise
MySql-Front .
I assume that i use Access Export Feature to migrate tables content to a
William_dw,
Tuesday, July 23, 2002, 10:34:16 AM, you wrote:
WS I'm hoping someone can give me a pointer as to what's going wrong that's
WS crashing our MySQL server, I've included a snippet of the log (for the last
WS time it restarted and then the errors after that).
WS I've been trying to
Tam,
Tuesday, July 23, 2002, 12:39:33 AM, you wrote:
T I have difficulties obtaining the MySQL4.0.2a. It seems that numerous
T downloads
T links point to the files stated as 4.0.2 zip file but during the setup , it
T was 4.0.1a
T instead. Where can I obtain the 4.0.2a ? Many thanks.
There
Edward,
Monday, July 22, 2002, 4:46:07 PM, you wrote:
After issuing an incorrect GRANT command Mysqld crashed, but
restarted itself. On the next boot-up of the machine, Mysqld
crashes on startup with an added message about unable to find
user.MYD Copying user.MYD from a
Steve,
Tuesday, July 23, 2002, 7:36:39 AM, you wrote:
S Can anyone tell me how do achieve the following in MySQL:
S Update oitems
S SET Pstatus = SELECT product.Pstatus from products
S WHERE oitems.Pstatus not like %Printed%
SAND oitems.ProdCode=products.Code
S i.e. I need
First of all, changing action to INT(2) vs INT(11) takes the same space
{# inside ()'s is for display purposes not storage} on disk {I think
it's 4 bytes, but would have to look it up}. TINYINT or maybe even ENUM
{my preference} would only take 1 byte and would serve your purpose.
You could make
Dear MySQL fellows,
I'm having a problem with a program running 24/7 dumping core almost every
morning. The program has a few memory leaks, and the odd behavior could be
related to this. The program is connected to the database at all times. It
never reconnects.
Database server is running on
[snip]
If I do something like:
select * from foo where bar=123;;
I get the result of the select followed by:
ERROR:
No query specified
This is because I have ';;' at the end of the line and it is complaining
about the empty command.
OK, I should not have typed it, but I
What instances can cause a Table to crash?
Is this caused by a bug in itself, a power failure, or something else?
Richard
William_dw,
Tuesday, July 23, 2002, 10:34:16 AM, you wrote:
WS I'm hoping someone can give me a pointer as to what's going wrong
that's
WS crashing our
Cindy wrote:
I seem to be destined to become an expert on restarting mysql and
dealing with passwords despite myself :-). This time I'm working on a
slight variation: restarting mysql on a machine that we haven't been
using for some 18 months and that I myself have never used.
Mysql appears
On Tue, Jul 23, 2002 at 07:38:42AM -0500, Jay Blanchard wrote:
[snip]
If I do something like:
select * from foo where bar=123;;
I get the result of the select followed by:
ERROR:
No query specified
This is because I have ';;' at the end of the line and it is complaining
Hi...
What is the best way in MySql to store a session_id in hex format.
Can Integer also store hex values like:
E4FA762685A23E002D86483AACE9BD7B
Thanks
Ilyas
-
Before posting, please check:
http://www.mysql.com/manual.php
20 simultaneous cartesian products on large tables would be expected to make
any sql server busy, not to mention use a lot of temporary disk space.
Are you sure you are not running out of disk space?
Andrea Carpani wrote:
Here's my problem:
I've just installed mysql version 3.23.51 (before
On Tue, 2002-07-23 at 15:27, Gerald Clark wrote:
20 simultaneous cartesian products on large tables would be expected to make
any sql server busy, not to mention use a lot of temporary disk space.
Are you sure you are not running out of disk space?
No, there's enough disk space and memory,
On Tue, 2002-07-23 at 12:28, Dicky Wahyu Purnomo wrote:
I think the proper word for your case is mysql busy not hang.
you should check from your system (OS) side the cpu usage of mysql
where the query is running
When the problem arises both cpu's (client and server) are 2% busy and
there's
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors be before you are notified?
Alain Williams wrote:
Hi,
I thought that I would report a very minor bug that I have just found
Are there any ways to remotely connect to MySQL besides TCP/IP? Also,
what are the 'bad' implications for allowing to connect to MySQL via TCP
remotely?
Thanks for your advice in advance.
-
Before posting, please check:
Pada 23 Jul 2002 15:40:17 +0200
Andrea Carpani [EMAIL PROTECTED] menulis :
error: 'Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent
bug'
well, if this the case
try to run : mysqladmin -p processlist or
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql select left(ftText,20) from Txt_index where match(ftText)
against('+(wÝd200206*) +wÝ12p' in boolean mode);
+--+
| left(ftText,20) |
+--+
| wÝd20020601 wÝ12p
In the last episode (Jul 23), Jan Peuker said:
Dan Nelson wrote:
So what you really want is
CREATE TEMPORARY TABLE tmp
SELECT code FROM mytable WHERE zip 12345 ORDER BY zip DESC LIMIT 5;
INSERT INTO tmp
SELECT code FROM mytable WHERE zip = 12345;
INSERT INTO tmp
SELECT code
hola!!
I need re-compiling mysql 3.23.37 in linux, how can I do this.
In the maestrosdelweb link said how is the compilation, the problem is that
these commands (./config and make) are not available from my install
folders. I have not a directory where I can found.
I have in:
/var/lib/mysql/
Hi.
Thought I'd try sending this again as no takers for my earlier post!
Has anyone got any good ideas or examples about doing Version Control on
a MySQL table? I'd like all changes to fields to be recoverable back to
any date-time in the past, without changing the current state of the
Hello,
I was wondering if there was anyway for me to speed up my update query.
I wanted to index the field that i was searching for., but i heard that
indexing slows down updates or that some information might not work...is that
true? thanks for any help.
my update statement:
UPDATE
Description:
ERROR 2013: Lost connection to MySQL server during query.
How-To-Repeat:
select distinct s.supplier_id, s.who_pay, r.name as rname, s.name,
s.nick, s.address, s.contact_person, s.email, s.fax,
s.comment
from
From: Gerald Clark [EMAIL PROTECTED]
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors be before you are notified?
The ability to run more than one query on one line is a
On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
From: Gerald Clark [EMAIL PROTECTED]
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors be before you are
After a hard day of work I think I managed to isolate the problem which
looks a lot like a bug:
server: mysql-3.23.51
compiled with: CFLAGS=-fomit-frame-pointer -O3 -fPIC ./configure
--prefix=/opt/mysql --disable-shared --with-mysqld-user=mysql
--with-debug
os: HP-UX 11.00
I have a small
this message is about a user defined function i wrote, which
is not working well. i don't know if this is the right list,
if not, i apologize, could someone point me to the correct one?
i have written a user defined function which translates an HTML
entity representation of a letter with a
Hi.
On Fri 2002-07-19 at 22:54:10 +0200, [EMAIL PROTECTED] wrote:
Warning: Host 'netsonic.megalan.co.za' is blocked because of many connection
errors. Unblock with 'mysqladmin flush-hosts' in
/usr/local/www/v-webs/m/meg001/www.megalan.co.za/include/globalmegalan.inc
on line 20
Lo all,
Hi.
On Fri 2002-07-19 at 11:15:00 -0400, [EMAIL PROTECTED] wrote:
I have a table of members that includes a status flag and a history
table of activities that includes a date. What I need is all members
with a particular status and their activites (which may be none) for
some date range.
If
Hi.
On Wed 2002-07-17 at 14:16:39 +1200, [EMAIL PROTECTED] wrote:
I was wondering what advantages one has over
the other.
I think the old way is easier but is it good enough?
I have no clue what you are talking about and I am sure I am not the
only one. Mind giving an example?
Hi,
I looked at the Date example that comes with the mm.mysql driver, but I
still can't get this to work.
When I run the code below, I have no errors, but I only end up with nulls
in my table.
This is getting weird..
Thanks,
Eric
==
import java.sql.*;
import
Hi.
IMHO, the self-join is the correct solution for the given table layout
(which looks reasonable to me).
Greetings,
Benjamin.
On Wed 2002-07-17 at 09:26:48 +0530, [EMAIL PROTECTED] wrote:
[...]
Select companyid, count(*) from CompanyServices where
serviceid = 1 or serviceid = 2
Hello,
I'm working on a purge utility to purge 3 tables: call_record,
modem_call_rec and makrup. Those 3 tables are related with foreign key
recid, so I used the following sql to purge data that is older than 30 days:
delete call_record, modem_call_rec, markup from call_record,
There didn't seem to be any responses to this question last time I posted.
So I'll try again. Does anyone know where to locate mysqlimport logs, if
there are any?
TIA
James
-Original Message-
From: James Ching [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:54 PM
To:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR 2013: Lost connection to MySQL server during query.
How-To-Repeat:
select distinct s.supplier_id, s.who_pay, r.name as rname, s.name,
s.nick, s.address, s.contact_person, s.email,
Hi.
On Tue 2002-07-23 at 08:21:43 -0700, [EMAIL PROTECTED] wrote:
SCO UNIX 5.0.6, run ./script/mysql_install_db
Get the warning message as follow.
Please advise what I should do. Thanks.
Well, the warning message you cited already explains that. If you have
additional question, please
My MySQL databases appear to have been overwritten somehow, and I am
very distressed about this. Please tell me that there is a way to
recover this data.
I am using Mac OS X, and recently upgraded to PHP 4.2. I have been
accessing MySQL from PHP and phpMyAdmin for a while, occasionally
Hi.
On Tue 2002-07-23 at 08:35:29 -0700, [EMAIL PROTECTED] wrote:
Hello,
I was wondering if there was anyway for me to speed up my
update query. I wanted to index the field that i was searching
for., but i heard that indexing slows down updates or that some
information might not
Hi.
On Wed 2002-07-10 at 11:56:14 -0700, [EMAIL PROTECTED] wrote:
Does anyone know of an Apache Module for auth-ing against a MySQL
database? MySQL lists one on its website and its no longer
supported by the developers. I found Apache lists one that is
also not supported anymore.
Hi!
On Jul 23, Artem V. Ryabov wrote:
Hello mysql,
see this 2 queries:
why they not equal?
why first skip many records?
mysql select left(ftText,20) from Txt_index where match(ftText)
against('+(wщd200206*) +wщ12p' in boolean mode);
3 rows in set (0.36 sec)
mysql select
[snip]
I quite agree that to have more than one command on a line is a nice thing.
What I am saying is that barfing on an empty command is not the right thing
to do.
I remember, many years ago, I wrote some coding standards where I said:
Every program/function should do nothing
I am having a or problem
reproducible by script below
(or by sql or by query if
mail filter likes those words
better:) ).
Briefly:
4 tables joined to each other:
/-ar
a
\-b-br
I would expect to get totals based on
the root record in a:
a_idq_a q_arq_b q_br
1 1 4
At first I want to thank you for a fast answer,
On Tuesday 23 July 2002 21:45, Peter Zaitsev wrote:
On Tuesday 23 July 2002 19:39, Sergey S. Kostyliov wrote:
Description:
ERROR 2013: Lost connection to MySQL server during query.
snip
Note:
The same results with oficial
Hi.
Your example looks incomplete. What do you do with the records
afterwards, which also allows site to be removed in a way that you
suggest it does not need a code (logic) change?
The general answer is that most interfaces have a way to access the
columns by name. I do not know dbi good
Philip Molter [EMAIL PROTECTED] writes:
On Thu, Jul 18, 2002 at 11:44:14AM -0400, Richard Fox wrote:
: The mysqld.log file says:
:
: 020717 13:05:05 mysqld started
: 020717 13:05:05 /usr/local/libexec/mysqld: Can't find file:
: './mysql/host.frm' (errno: 13)
: 020717 13:05:05 mysqld
Hi.
On Thu 2002-07-11 at 09:53:05 -0400, [EMAIL PROTECTED] wrote:
Bhavin,
I am using distinct all 15 fields and order by all 15 fields, but there is
different order on 15 fields for distinct and order by.
Are all fields of binary types? If not, DISTINCT equals sort -uf, not
sort -u (i.e.
Can anyone suggest a good data modeling tool that can be used for:
a) Reverse enginering: dump file = data model
b) Create a new data model
c) Generate the ddl from the data model
d) The tool should handle the latest features of MySQL 3.23.52
Any comments about the tool called dezign. Is it any
Hi.
On Tue 2002-07-23 at 16:19:43 +0100, [EMAIL PROTECTED] wrote:
Hi.
Thought I'd try sending this again as no takers for my earlier post!
Has anyone got any good ideas or examples about doing Version Control on
a MySQL table? I'd like all changes to fields to be recoverable back to
At 15:09 +0200 7/23/02, Ilyas Keser wrote:
Hi...
What is the best way in MySql to store a session_id in hex format.
Can Integer also store hex values like:
E4FA762685A23E002D86483AACE9BD7B
The largest integer type is BIGINT, which is 8 bytes (16 hex digits max).
Your value looks like it's 32
I have several mysql servers installed, all without TZ variable, one of
them, insists in set the select now() to 4 hours ahead of my internal
clock, first I touch that I should set TZ to my time time zone in
/etc/init.d/mysql, but when I do that, the select now() advances 4
more hours.
Hi Victoria,
Do you know when the 4.0.2a-MAX would be available for download then?
Thank you.
Regards,
Michael
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 4:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Problem downloading
Hi.
On Mon 2002-07-08 at 17:49:03 -0700, [EMAIL PROTECTED] wrote:
Hello,
I have _a lot_ of http log data to throw into a mysql db (currently over 1.5
billion rows). New data is coming in all the time, so I don't want to lock
myself into one set of big tables that are over 100 gigs each.
Ok here's the problem. Trying to write a select statement to be able to
round a set of numbers to the nearest quarter of an inch. Here is what I
have so far:
*-*
SELECT
CONCAT(ROUND(inside_length + (wall_thickness * 2),
Hi.
On Mon 2002-07-08 at 22:54:09 -0700, [EMAIL PROTECTED] wrote:
I'm trying to get the name of a booth or tradeshow depending on the
customer_link_type (which is an ENUM) combined with the
customer_link_table_id which tells me the index/id of the correct table
to look in. I've tried this
Hi.
On Tue 2002-07-09 at 10:49:51 +0200, [EMAIL PROTECTED] wrote:
Hi all again,
I've been experimenting and would like to know if there is a known bug in
the std function when used with a group by clause?
I'd like to know if others have found this problem or is it just me:
I have a
I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
All char fields are mixed with upper case letters, numbers(0-9) and
sign(like $).
Because there is no low case char, I don't have to put -f option for unix sort.
Thanks.
At 08:23 PM 7/23/2002 +0200, Benjamin Pflugmann
Hi.
On Tue 2002-07-23 at 17:09:05 +0100, [EMAIL PROTECTED] wrote:
On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
[...]
The ability to run more than one query on one line is a feature, not a bug.
An empty semicolon is a badly-formed query. It's perfectly logical for the
Alain Williams wrote:
On Tue, Jul 23, 2002 at 11:59:43AM -0400, denonymous wrote:
From: Gerald Clark [EMAIL PROTECTED]
Why do think this should not be an error?
If you were writing a script, would you not want to know you had made
the error?
Just how many , or how severe should errors be
Hi.
On Fri 2002-07-19 at 11:13:26 -0500, [EMAIL PROTECTED] wrote:
Why is it that when I submit a reply or message to the mysql mailing list
that my e-mail sometimes does not show up for hours.
Seems to me that this makes rapid response and give--take nearly
impossible. I have asked our
On Tue, 23 Jul 2002 [EMAIL PROTECTED] wrote:
sql,query
You have written the following:
You need to make sure you have all the Caldera/SCO OS patches installed.
http://www.caldera.com and look in the OS support.
Good Luck,
--
Boyd Gerber [EMAIL PROTECTED]
ZENEZ 1042 Fort Union #135,
Hi.
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
All char fields are mixed with upper case letters, numbers(0-9) and
sign(like $).
Because there is no low case char, I don't have to put -f option
Understand.
But, how to use IP addresses instead of hostnames?
--- Benjamin Pflugmann [EMAIL PROTECTED]
wrote:
Hi.
On Tue 2002-07-23 at 08:21:43 -0700,
[EMAIL PROTECTED] wrote:
SCO UNIX 5.0.6, run ./script/mysql_install_db
Get the warning message as follow.
Please advise what I should
Understand.
But, how to use IP addresses instead of hostnames?
--- Benjamin Pflugmann [EMAIL PROTECTED]
wrote:
Hi.
On Tue 2002-07-23 at 08:21:43 -0700,
[EMAIL PROTECTED] wrote:
SCO UNIX 5.0.6, run ./script/mysql_install_db
Get the warning message as follow.
Please advise what I should
Understand.
But, how to use IP addresses instead of hostnames?
--- Benjamin Pflugmann [EMAIL PROTECTED]
wrote:
Hi.
On Tue 2002-07-23 at 08:21:43 -0700,
[EMAIL PROTECTED] wrote:
SCO UNIX 5.0.6, run ./script/mysql_install_db
Get the warning message as follow.
Please advise what I should
Hi,
In MSAccess, I am able to use a query as a (partial) source for another query.
«Select Names, Department from qrySelectedEmployees, tblDepartment
where qrySelectedEmployees.EmplId = tblDepartment.EmplId»
Is this possible with MySQL? If so, how is it implemented?
Thanks for your help.
Hey, thanks *so* much for checking into this.
Your message did help. In case you're curious. First, I had the admin
create a 777 dump directory from root. Still couldn't write out. Then,
though, I just tried going to /tmp as you had done, and that was fine.
/tmp -- I feel like an idiot, but
In the last episode (Jul 23), Greg D. said:
I was wondering if there was anyway for me to speed up my
update query. I wanted to index the field that i was searching for.,
but i heard that indexing slows down updates or that some information
might not work...is that true? thanks for any
Dear list,
I've been trying to install mysql 4.0.2. alpha.
The configuration is going well.
That also count's for the make command.
But when I run the make test command I'm getting the following error:
ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not
created in 30 seconds;
In the last episode (Jul 23), Greg Westin said:
My MySQL databases appear to have been overwritten somehow, and I am
very distressed about this. Please tell me that there is a way to
recover this data.
I am using Mac OS X, and recently upgraded to PHP 4.2. I have been
accessing MySQL
mysql show databases;
+-+
| Database|
+-+
| CarbonUFSVolumeInfo |
| mnta|
| mntb|
| vi.recover |
+-+
4 rows in set (0.04 sec)
Umm, those look very much like files from a
Hello guys,
I'm runing mysql 4.0.0 under apache and mod_perl on solaris 2.28 - we
are in a kinda testing/adjusting period. So, yesterday I've wrote an
utility on top of
`ps -o vsz,rss -e` to monitor the memory usage by my processes and also
added mysqld to the list.
So, here's what I saw
virtual
Hi.
First, for some reason, I got your email three times (both, personally
and to the list - once to both would be okay).
On Tue 2002-07-23 at 12:30:38 -0700, [EMAIL PROTECTED] wrote:
Understand.
But, how to use IP addresses instead of hostnames?
The only context where you use hostnames in
Oops, sorry, few mistakes here
Mike Blazer wrote:
Hello guys,
I'm runing mysql 4.0.0 under apache and mod_perl on solaris 2.28 - we
are in a kinda testing/adjusting period. So, yesterday I've wrote an
utility on top of
`ps -o vsz,rss -e` to monitor the memory usage by my processes and
Dear list,
Ive been trying to install mysql 4.0.2. alpha.
The configuration is going well.
That also counts for the make command.
But when I run the make test command Im getting the following error:
ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not created
in 30
I need help with MySQL.
I just moved my servers and have new DNS names and IP addresses. I need to
update the databases to reflect the changes. I used PhpAdmin to make some
of the changes, but I am still getting Internal Server Error's. Any help
in directing me for help would be appreciated.
Check the manual at www.mysql.com. Use your first query to create a
temporary table. Then use your temporary table as a source for additional
queries. The tem table will be destroyed when your session is terminated.
(Handy if you are piping in several SQL statements from the command line.
For
I absolutely agree with Benjamin.
It would be bad mojo for the engine OR the client to silently ignore any
error. While it may be trivial for the developers to code around your type,
they can't code around all of ours. I constantly type form for from but I do
not expect the client or the engine
Try round(value*4,0)/4
Worked on the samples I tried
-Original Message-
From: Nicholas Stuart [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 2002 1:47 PM
To: [EMAIL PROTECTED]
Subject: rounding?!
Ok here's the problem. Trying to write a select statement to be able
to
round a
Hi Benjamin, Vivian,
On Wed, 2002-07-24 at 05:23, Benjamin Pflugmann wrote:
On Tue 2002-07-23 at 14:58:16 -0400, [EMAIL PROTECTED] wrote:
I have 14 fields are chars (like char(8), char(9)), and one field is int(4).
All char fields are mixed with upper case letters, numbers(0-9) and
Im getting in trouble trying to restore a .sql dump generated with
mysqldump for a database with lots of foreign keys because of the
order of tables in the .sql. the first table already declares a
FOREIGN KEY referencing a table not yet created, halting with a
'cant create blahblahblah'.
(ERROR
I have a system that has been in production for more than a year and
fairly reliable.
I have a Penguin Systems Relion 120 running Redhat Linux 2.2.14 and
MySQL 3.23.48
A few weeks ago it started crashing occasionally. About a week ago it
started crashing a lot. Some times it gets a core dump
1 - 100 of 101 matches
Mail list logo
