glibc ver. 2.2.40
In fact is the gethostby* functions which is create problems.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Messa
Dear Sir:
I downloaded mysql-3.23.43-src-pkg.zip for Solaris 8.
after passing ./configure --prefix=/usr/local/mysql,
I issued make Command, and got following Error
Messages:
sql_lex.cc: In function `int find_keyword(LEX*, unsigned int, bool)':
sql_lex.cc:167: `
Hi all,
we are using MySQL to manage our test data. Now we want to have tables
size only with 650 MB,
and if the table is full, the new one is generated automatic, or we use
some info. about that to
create a new table. Is this possible?
Best regards,
Aihong.
Frederic,
Thursday, October 31, 2002, 12:02:51 AM, you wrote:
FT> Yes, I use RedHat, and have try to find info on the mailing list and google,
FT> without any luck.
Here is some info:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:122632
FT> - Original Message -
FT> From: "Egor Egor
Jason,
Thursday, October 31, 2002, 3:01:15 AM, you wrote:
JT> "Error 13 means that mysqld doesn't have permissions on the host.frm
JT> file."
JT> I changed the permissions on host.frm to the following: -rw-rw-rw-
JT> I am still getting the same error. I tried a search on the archive for
JT> "
Alan,
Thursday, October 31, 2002, 12:00:03 AM, you wrote:
AM> This error comes up when altering table structure
AM> BUT it times out after a while.
AM> Error: 7 - Error on rename of '.\DBNAME\tablename.MYI' to
AM> '.\DBNAME\#sql2-61-19.MYI' (Errcode: 13)
AM> Some have said - "oh yeah, that's a p
Okan,
Thursday, October 17, 2002, 3:33:41 PM, you wrote:
OC> I am working on the replication feature of MySQL. I am managed to replicate
OC> the servers(both versions are 3.23.52 on Win 2K). Ay yhe my.ini file, the
OC> bin-log files are declared as log-bin=c:\mysql\log_files.bin and as I FLUSH
OC>
joseph,
Wednesday, October 30, 2002, 9:53:57 PM, you wrote:
js> On Tue, Oct 29, 2002 at 11:56:01AM +0200, Egor Egorov wrote:
>> Marco,
>> Tuesday, October 29, 2002, 7:22:44 AM, you wrote:
>>
>> MB> I need your expert and slow guided assistance.
>>
>> MB> I would some one to teach me how to do fo
Tom,
Wednesday, October 30, 2002, 10:01:50 PM, you wrote:
TR> I just got a Red Hat 7.3 box up and running and have mysql on it...I've
TR> noticed that when using mysqladmin it doesn't prompt me for a password
TR> like other boxes that I've been on(ones I didn't build) have...is there
TR> a way t
David,
Wednesday, October 30, 2002, 11:33:30 PM, you wrote:
DK> Can anyone tell me what GLIBC version is causing Mysql to crash?
glibc 2.2.5-40 is.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__
Aamer,
Wednesday, October 30, 2002, 8:34:44 PM, you wrote:
AR> I have a mysql database. Lets say it has a table called "maintable" with primary
AR> key as main_id. I want to add other tables to the database and use main_id as
AR> foriegn keys in those tables. If I want to start with the last row
Hi gang
Need to get all items that are not in id supplied
For example select * from test where id!=2 will do this but it will also
return values that are in 2 if they are also in another id!=2
In my example if I used the above query I would get
10,11,12,13,14,17,18,19,20,17,21,22,23
I would not w
* scott
> Hi gang
> Need to get all items that are not in id supplied
>
> For example select * from test where id!=2 will do this but it will also
> return values that are in 2 if they are also in another id!=2
> In my example if I used the above query I would get
> 10,11,12,13,14,17,18,19,20,17,
Hello, folks,
I've got an issue with a query. It's returning 95 rows, when there are only
3 that should be returned. Actually, it's returning many many copies of
each of the rows that are supposed to be returned, and nothing that
shouldn't be, so at least it's grabbing the correct information, b
Thanks Roger
Works great!
Can you explain the query if you have time!
Thanks again
Scott
-Original Message-
From: Roger Baklund [mailto:roger@;charlott.no]
Sent: 31 October 2002 10:46
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: A simple one that gets me!
* scott
> Hi gang
Hi
I want to "barge" in on this question, as it has bothered me in the past
as well.
The reason being:
I did the last write to the table maybe a day ago, but I want to write a
script that can give me some "stats" on the table at any time, so it
also makes sense to me to be able to have a get_last_e
Greetings.
Two days ago, during our first sql tests using mysql
in Innodb, we suffer an energy fault during a storm.
Even the UPS couldn't help :-). After energy back, we
realise that our database crashed and suffer
corruption damages. I read some chapters from the
manual but they are not so clear
* scott
> Can you explain the query if you have time!
[...]
> select t1.*
> from test t1
> left join test t2 on
> t2.id=2 and
> t2.item=t1.item
> where t2.id is NULL;
This is a self join. Read one table, left join to the same table looking for
the records you do _not_ wan
We have come up with a disk partitioning system for our MySQL system which
seems to me like a good idea, but I worry that there may be some kind of
hidden downside that I don't see. I would therefore like to query the
wisdom of the list to see if you can point out the error, if any, of my
ways.
We
* Petre Agenbag
[...]
> I did the last write to the table maybe a day ago, but I want to write a
> script that can give me some "stats" on the table at any time, so it
> also makes sense to me to be able to have a get_last_entry() function,
> or a total_rows_in table() (well, I guess you can do tha
* [EMAIL PROTECTED]
[...]
> In other words, any pix that has a bigpix defined is ok. But on any
> pix that does not have a bigpix defined, I "loose" the filename info
> from pix.
>
> And I don't understand why!
>
> Here is the second query:
>
> select
> pix_section.code,pix.filename,pix.id,pix_use.
hello everybody,
I just started working with mysql and php and I want to import a
database from filemaker to mysql: is that possible? and how?
thanks in advace for the help
Tosca
-
Before posting, please check:
http://www.
>Description:
>How-To-Repeat:
>Fix:
>Submitter-Id:
>Originator:root
>Organization:
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis:
>Severity:
>Priority:
>Category: mysql
>Class:
>Release:
"Who is the owner of host.frm and other files?"
root Should the owner be mysql?
Original Message Follows
From: Victoria Reznichenko <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: re: re: Unable to Start the Server
Date: Thu, 31 Oct 2002 11:54:02 +0200
Jason,
Thursday, October 31, 2
Dear Sir,
l created a 'vacc_table.sql' script as follow :
CREATE TABLE batches
( batch_noint(4) ,
batch_title char(20)
);
CREATE TABLE chart_of_acc_a
(
despvarchar(80) NOT NULL,
acc_no_achar(8) NOT NULL,
id
At 11/1/2002, you wrote:
I have a website using PHP and MySQL and having a problem.
This is what I have:
$db = mysql_connect("1.1.1.1","name","password");
mysql_select_db("database");
$query = "SELECT title, artist FROM songlist WHERE songlist.songid=1";
$result = mysql_query($query) or die("Que
Is there a MySQL data type to use in a column where I would like an
integer to be comma delimited? Say someone enters "100" as a value to
be written to the column. I would like it to be stored as "1,000,000". I
don't want trailing decimals either.
Thanks,
Ed
---
* Wai Meng Moan
[...]
> l discovered that the field "acc_no_b" displayed with
> a "varchar(8)"!
> which is different from my 'vacc_table.sql' script ,
> because l defined
> the field to be "char(8)" !!!
>
> is there any wrong with my script ??
In some cases mysql will automatically change your c
* [EMAIL PROTECTED]
> Is there a MySQL data type to use in a column where I would like an
> integer to be comma delimited? Say someone enters "100" as a value to
> be written to the column. I would like it to be stored as "1,000,000". I
> don't want trailing decimals either.
Integers are sto
We are experiencing some issues with performance on a non-MySQL box and are
looking for alternatives (and alternative methods). Once of the issues that
we seem to be facing, is that the pure volume of data which needs to be
pushed out. The other database is pushing out (at peak) 12.5 megabytes p
Thanks, I also found a way to do this via PHP which I'm using anyway to
pass the values.
Thanks again,
Ed
On Thu, 31 Oct 2002, Roger Baklund wrote:
> * [EMAIL PROTECTED]
> > Is there a MySQL data type to use in a column where I would like an
> > integer to be comma delimited? Say someone e
Benji,
why would you not simply generate the HTML and store it as files on the HD
that the web server can then serve without database interaction. I've seen
this done when the web pages were quasi-static. (Did not change with every
query but changed when something on the server triggered a change
A UPS is of little use if you dont have software installed to shut the
computer
down when AC power is lost.
Pedro Rocadas wrote:
Greetings.
Two days ago, during our first sql tests using mysql
in Innodb, we suffer an energy fault during a storm.
Even the UPS couldn't help :-). After energy back
>From the manual, 6.5.3.1 Silent Column Specification Changes, "In some
cases, MySQL silently changes a column specification from that given in a
CREATE TABLE statement. (This may also occur with ALTER TABLE.) If any
column in a table has a variable length, the entire row is
variable-length as
Hi,
Just a silly question: are you pushing those 12.5 Mbytes/s over the
network ? If this is the case you have hit the limit of Fast Ethernet
(12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be
faster ! May be an upgrade to Gigabit Ethernet would help...
Regards
--
Joseph Bueno
How much a database can push out has a lot dependencies. The first
probably being a very fast disk subsystem. If your disk can't pump out
way more than what you are trying to get, then it doesn't matter what
software or how many CPU's you have.
I could go on about dependencies on your data (1 i
Thanks to those who responded to me and the list (I am on the digest list)
why would you not simply generate the HTML and store it as files on the HD
that the web server can then serve without database interaction. I've seen
this done when the web pages were quasi-static. (Did not change with ev
Many thanks
I have checked out the mysql site and am starting to get my head around
it. How would I modify your query so that I had a clause that selected
in another value from another table?
Your suggestions have been most helpful
Lets say I had another table called others
And I wanted the qu
Just a silly question: are you pushing those 12.5 Mbytes/s over the
network ? If this is the case you have hit the limit of Fast Ethernet
(12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be
faster ! May be an upgrade to Gigabit Ethernet would help...
yes, 12.5 MBytes/s over the n
How much a database can push out has a lot dependencies. The first
probably being a very fast disk subsystem. If your disk can't pump out way
more than what you are trying to get, then it doesn't matter what software
or how many CPU's you have.
Disk is hardly being used. The database its self
Hey,
A lot of problems with web site to DB connections come from 2 things. I
assume you meant 12.5 mega"BITS" per second.
1) Over using a database when you don't need to, when you can just as well
create semi-static pages that get updated by the db on a regular basis (as
needed).
2) The data
How about exporting the data to text files and then importing them into
MySql.
Also you can try to write a VBScript (If you are using Win32) that connects
to both databases and select a table from one and run inserts to the other.
HTH.
JFernando
*** sql ***
-Original Message-
From: tosc
Jason,
Thursday, October 31, 2002, 3:17:30 PM, you wrote:
JT> "Who is the owner of host.frm and other files?"
JT> root Should the owner be mysql?
Yup. MySQL should be the owner of the data dir.
JT> Original Message Follows
JT> From: Victoria Reznichenko <[EMAIL PROTECTED]>
JT> To: [EMA
Joseph Bueno wrote:
Just a silly question: are you pushing those 12.5 Mbytes/s over the
network ? If this is the case you have hit the limit of Fast Ethernet
(12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be
faster ! May be an upgrade to Gigabit Ethernet would help...
Not qui
Benji Spencer wrote:
Indexes we can add, which we have. Unfortunately we are dealing with a
packaged application which we have only some abilities to deal with
the code (a total switch to MySQL we could rewrite the code for, but
we can not optimize specific queries as there is a common SQL
ge
At 10:08 2002-10-31, Benji Spencer wrote:
Just a silly question: are you pushing those 12.5 Mbytes/s over the
network ? If this is the case you have hit the limit of Fast Ethernet
(12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be
faster ! May be an upgrade to Gigabit Ethernet wou
I hate to jump into this, but I have to ask if you have only 30k rows why
are you producing such large amounts of data? Are you trying to store blobs
or large text data types? I don't think you will ever find a database
vendor that wants to compete with a local filesystem under those kinds of
con
Cal Evans wrote:
why would you not simply generate the HTML and store it as files on the HD
that the web server can then serve without database interaction. I've seen
this done when the web pages were quasi-static. (Did not change with every
It of course depends on how frequently the data i
> >Just a silly question: are you pushing those 12.5 Mbytes/s over the
> >network ? If this is the case you have hit the limit of Fast Ethernet
> >(12.5x8 = 100Mbits/s) and no database (not even MySQL ;) ) will be
> >faster ! May be an upgrade to Gigabit Ethernet would help...
> yes, 12.5 MBytes/
Hi.
Is there anyway to get a mysql server to tell me
a) What user I am connected as?
b) What host I am connected from (i.e., localhost vs. fqdn)?
c) What database I am using?
The reason for the question is that I want to print diagnostics in scripts
that don't contain connection information (it
Been waiting for someone to ask. The entire database is actually slightly
over 30K (35K is a closer number...small non-the-less)
How does 12 MBytes/s come from 35K rows? Part of the output is a large text
field. Each chunk of large text is no more then 100K and not each has a
large text with it
Petre Agenbag wrote:
also makes sense to me to be able to have a get_last_entry() function,
or a total_rows_in table() (well, I guess you can do that with a select
I'm sure I've said it personally a dozen times (and the archives
probably show many other people saying it too); you're not thin
Gelu Gogancea wrote:
glibc ver. 2.2.40
In fact is the gethostby* functions which is create problems.
I would strongly recommend moving away from the glibc gethostby*
commands at all and use the djbdns query commands instead (which have a
completely different structure but are much more well
SHOW PROCESSLIST?
> -Original Message-
> From: Brian Hughes [mailto:BLH@;pobox.com]
> Sent: Thursday, October 31, 2002 11:08 AM
> To: [EMAIL PROTECTED]
> Subject: Can server tell me how I connected?
>
>
> Hi.
>
> Is there anyway to get a mysql server to tell me
>
> a) What user I am co
It of course depends on how frequently the data is needed as well. If the
data is being requested a lot more frequently than the data is updated,
doing a static page that is updated outside the http request is the faster
way to do things. If the page is requested less frequently or barely mo
Hi,
I have a database which has identical entries. Is there a way to tell mySQL to throw
out duplicate entires when un insert/update is done via ColdFusion?
---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
-
Aren't these just aborted clients? When you upgraded before did mysql bring
the server to its knees or just yield many aborted clients/connects? Any idea
what your show processlist looks like when this is happening?
Before mine was flooded with a ton of processes like this:
| 17546 | root| loca
Okay, I figured out the problem. Test cases will not pass if you
compile MySQL with the flag --with-libwrap, if you don't include
127.0.0.1 in the /etc/hosts.allow file. Even if you have your machine's
IP in there, you must also include the localhost IP as well. Oh, the
frustrations this cause
Many thanks
I have checked out the mysql site and am starting to get my head around
it. How would I modify your query so that I had a clause that selected
in another value from another table?
Your suggestions have been most helpful
Lets say I had another table called others
And I wanted the query
The query below:
SELECT DISTINCT LEFT(sku,5) AS Item_Sku,count(*) as Quantity_Sold,
SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030'
AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC
Produces results like:
Item_Sku Quantity_Sol
Benji Spencer wrote:
is why that might be an option. However, it might be easier to switch
from MSSQL to MySQL if MySQL would handle the traffic better. We do
need a little logic to determine if the user is logged in (if they
aren't logged in, they don't see the page) but it shouldn't be all
Since your requests are mainly selects and each select is returning
a lot of data (more than 500K) you could eliminate most of your
network problem with MySQL replication :
You install a slave server on your web frontend and use it for all
your selects: no need to upgrade your network anymore !
Re
This really isn't a bug, just an a bit of information
I copmiled MySQL for Solaris 9 on an UltraSPARC using gcc-2.95.3.
If you compile MySQL with the option --with-libwrap for tcp wrappers
support, and then try to run the test cases, they will not fail, but
they will hang. If you compile MyS
Create an unique index.
See: http://www.mysql.com/doc/en/CREATE_INDEX.html
Regards,
Joseph Bueno
FlashGuy wrote:
> Hi,
>
> I have a database which has identical entries. Is there a way to tell
> mySQL to throw out duplicate entires when un insert/update is done via
> ColdFusion?
>
>
> --
Filter: SQL, UPDATE
Is there a way to do the following in one single statement? I know I can
get all of the info from the three tables in a single query using
joins...
// Start a transaction
conn.setAutoCommit(false);
// Do the work.
stmt = conn.createStatement();
// Update general acct info
sS
--- gerald_clark <[EMAIL PROTECTED]>
wrote:
> A UPS is of little use if you dont have software
> installed to shut the
> computer
> down when AC power is lost.
Indeed :-). The problem was the eletrical board. This
kind of problems shouldn't happen but sh*t happens
:-))). Anyway, I read more caref
* scott
[...]
> Lets say I had another table called others
> And I wanted the query you supplied to INCLUDE items from others that
> are not in test
>
> Eg, (old example)
> Others
>
> Name item
> --
> Abc 10
> Def 11
> Geh 12
> Ijk 13
> Lmn 99
This table has a different strucure
Brian,
Thursday, October 31, 2002, 6:07:43 PM, you wrote:
BH> Is there anyway to get a mysql server to tell me
BH> a) What user I am connected as?
BH> b) What host I am connected from (i.e., localhost vs. fqdn)?
SELECT USER();
BH> c) What database I am using?
SELECT DATABASE();
SHOW PROCESSLI
I'm sure you've already specified this, but here's a few questions:
Probably not a bad idea to recap
What size of machine (CPU, RAM, # and type of drives) are you using for
each server? (MySQL vs. MS SQL)
MSSQL (Current setup) - 2-1.2 GHZ CPUs, 4 gig of mem, and a RAID5 SCSI
array, Server
Filter: SQL, UPDATE
Is there a way to do the following in one single statement? I know I can
get all of the info from the three tables in a single query using
joins...
// Start a transaction
conn.setAutoCommit(false);
// Do the work.
stmt = conn.createStatement();
// Update general acct info
sS
Hello.
On Thu 2002-10-31 at 08:10:17 -0600, [EMAIL PROTECTED] wrote:
> We are experiencing some issues with performance on a non-MySQL box and are
> looking for alternatives (and alternative methods). Once of the issues that
> we seem to be facing, is that the pure volume of data which needs to
Use the concat function. It takes any number of arguments.
mysql> create table test (a char(5));
Query OK, 0 rows affected (0.04 sec)
mysql> insert into test values ('A');
Query OK, 1 row affected (0.02 sec)
mysql> select * from test;
+--+
| a|
+--+
| A|
+--+
1 row in set (0.
Sorry, I do not have much experience with MySQL on Suns (at least not
in pushing it to the limits). On an Athlon 700Mhz selecting 1
random rows out of 6, I get over 330MB/sec (1000 queries/sec) on
localhost and about 5.5MB/sec via a 100MBit TCP connection using the
mysql command line clie
Hi,
How can we Prepare Reports From
MYSQL,same as we do in th Access Reports,I am not
getting much information on how to start this.So, it
will be of great help to me if we give Some
information on How to get started.
I am working on a project in Linux, PHP, Apache,
MYSQL,
one o
Joseph Bueno wrote:
You install a slave server on your web frontend and use it for all
your selects: no need to upgrade your network anymore !
A very good suggestion indeed (IMHO); replication for performance in
this way is probably very under-utilized. I wonder if Slashdot is doing
it yet?
I can start/stop the daemon for MySQL with no problem.
And, if i ps -aux | grep mysql I show that it is
running, but if I check the log I get the following
output:
021025 20:11:44 mysqld started
021025 20:11:44
/usr/local/MySQL/mysql-3.23.52-pc-linux-gnu-i686/bin/mysqld:
Can't create/write to
Why not only do:
conn.beginTrans();
//Statments
conn.commit(); or conn.rollback();
-Original Message-
From: David Shanes [mailto:dshanes@;san.rr.com]
Sent: October 31, 2002 12:12
To: [EMAIL PROTECTED]
Subject: SQL UPDATE question
Filter: SQL, UPDATE
Is there a way to do the following
> I have a database which has identical entries. Is there
> a way to tell mySQL to throw out duplicate entires
> when un insert/update is done via ColdFusion?
Tell mySQL that the columns are UNIQUE.
Alec
-
Before po
Hi,
I manage a mysql server with a few hundred users. All of a sudden mysql
has started to put large files in /tmp
I've never noticed this behavior before. The files looks like this
-rw-rw1 mysqlmysql3788431360 Oct 31 17:49 #sql420e_36b82b_1.MYD
-rw-rw1 mysqlmysql
Benji Spencer wrote:
this helps A LOT. MySQL doesn't have to be on the Sun Box. What OS
where you using? We could put MySQL on a Windows box. I don't know
that I could convince them to put it on a Linux box though.
Have you tried installing a Windows copy of MySQL on the web server for
the r
Quantity_Sold,
SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030'
AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC
Produces results like:
Item_Sku Quantity_Sold Total_Sales
LE104 1 18
MD008 1 25
MD012 1 5
MD103 1 18
MD104 10 400
MD104
Have you tried installing a Windows copy of MySQL on the web server for
the replication suggestion given before? I know it may be difficult to do
politically.
This is a little hard to do politically for a number of reasons.
1) In order for this to work, the backend database (which allows upda
,5) AS Item_Sku,count(*) as Quantity_Sold,
SUM(price) AS Total_Sales FROM `orderline` WHERE (order_date>='20021030'
AND order_date<='20021031') GROUP BY sku ORDER BY Item_Sku ASC
Produces results like:
Item_Sku Quantity_Sold Total_Sales
LE104 1 18
MD008 1 25
MD012 1
Benji Spencer wrote:
3) We would be adding a database to a machine which is already
somewhat busy (we split the web and database off of the same box
because the CPUs where not able to keep up with both web and db activity)
Understandable, but it might actually improve performance to not be
w
Hi.
On Thu 2002-10-31 at 11:35:56 -0600, [EMAIL PROTECTED] wrote:
>
> >Sorry, I do not have much experience with MySQL on Suns (at least not
> >in pushing it to the limits). On an Athlon 700Mhz selecting 1
> >random rows out of 6, I get over 330MB/sec (1000 queries/sec) on
> >localhost an
The government has a white paper on this.
Just !google "benchmark MySQL"
-Original Message-
From: Benji Spencer [mailto:ben.spencer@;moody.edu]
Sent: Thursday, October 31, 2002 9:36 AM
To: Benjamin Pflugmann
Cc: [EMAIL PROTECTED]
Subject: Re: How much data can MySQL push out?
>Sorry,
Pretty lame.
-Original Message-
From: [EMAIL PROTECTED] [mailto:mysql@;lists.mysql.com]
Sent: Thursday, October 31, 2002 11:58 AM
To: Black, Kelly W [PCS]
Subject: Re: SELECT
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
>From: tosca ballerini <[EMAIL PROTECTED]>
>
>I want to import a
>database from filemaker to mysql: is that possible? and how?
It's a pain in the butt. FileMaker does not allow access to all the schema info you
need to do a fully automated CREATE TABLE, and its typing and relational mechanisms
a
use this
Shell>TMPDIR=/tmp
Shell>export TMPDIR
restart mysql.
-Original Message-
From: CM Miller [mailto:cmmiller1973@;yahoo.com]
Sent: Thursday, October 31, 2002 9:42 AM
To: [EMAIL PROTECTED]
Subject: How do I log into MySQL?
I can start/stop the daemon for MySQL with no problem.
>From: gerald_clark <[EMAIL PROTECTED]>
>
>A UPS is of little use if you dont have software installed to shut the computer
>down when AC power is lost.
That may be true of un-attended operation, but if someone is around to shut down when
the UPS starts making noise, Bob's your uncle!
But such so
Hi,
I could use some advice on this query.
SELECT cell, sum(att) as att , sum(lc) as lc , sum(csh) as csh,
ROUND((SUM( lc + csh ) * 100 ) / (SUM(att) - SUM(tccf + bpp + bpc + suf)),2)
AS drops, sum(tccf) as tccf, sum(bpp) as bpp, sum(bpc) as bpc, sum(suf) as
suf,
ROUND((SUM( tccf + bpp + bpc
#!/usr/local/bin/perl
use strict;
my @files=(`/bin/ls /tmp/sql*.M*`);
for (@files) {
unlink;
}
exit 0;
shell> crontab -e
0 2 * * * /usr/local/bin/perl /path/to/delete/program
:wq
:)
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 9:56 A
Hi ppl!
I've got a strange problem.
I've created a user account with access to some concrete database using
GRANT query (see below) but I cannot connect to the server using this
usename only when connecting via mysql_real_connect() from C API. When
using "mysql -u MY_USER" it works fine.
What's w
Am I right in assuming that comparing two md5 strings would be faster
if they were compared as two hexadecimal numbers than if they were
compared as two strings?
If so, is there any way to insist on this in a SQL query? I am using
PHP, and would like to know from that perspective if it makes an
Thanks,
Unfortunatley I think things will break if I remove the temporary files
while they still are in use =)
I want a solution that keeps the files limited in size. There must be
some settings that controll this kind of stuff.
/Lars
On Thu, 31 Oct 2002, Black, Kelly W [PCS] wrote:
> #!/usr/l
Varun VallaBhaneni wrote:
MYSQL,same as we do in th Access Reports,I am not
getting much information on how to start this.So, it
will be of great help to me if we give Some
MySQL only does the back-end work, not the reports, etc. You can easily
generate reports with PHP + MySQL in my experie
pico /etc/services
ulimit 2 # size in k
BTW
It cannot remove files in use.
It would simply generate cron errors
-Original Message-
From: Lars Andersson [mailto:lars@;rockar.nu]
Sent: Thursday, October 31, 2002 11:05 AM
To: Black, Kelly W [PCS]
Cc: [EMAIL PROTECTED]
Subject: RE: my
On Thu, Oct 31, 2002 at 12:38:37PM -0500, Michael T. Babcock wrote:
> Joseph Bueno wrote:
>
> >You install a slave server on your web frontend and use it for all
> >your selects: no need to upgrade your network anymore !
> >
>
> A very good suggestion indeed (IMHO); replication for performance in
Hello,
starting mysql-3.23.32 on ydlinux from the command
prompt. freezes the current terminal, BUT the mysql server
is running, i can access it from outside or a new term.
#safe_mysqld & or just #safe_mysqld, tried both. can't
find anything in the man. thanks--Joe M
-
Almost all modern unix type systems come with the powerd daemon.
-Original Message-
From: Jan Steinman [mailto:Jan@;Bytesmiths.com]
Sent: Thursday, October 31, 2002 10:46 AM
To: [EMAIL PROTECTED]
Subject: UPS (Was: Mysql in Innodb)
>From: gerald_clark <[EMAIL PROTECTED]>
>
>A UPS is of
1 - 100 of 159 matches
Mail list logo
