Hi,
> -Original Message-
> From: Fabrice Schleifer [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 11:31 PM
> To: [EMAIL PROTECTED]
> Subject: MyODBC Blocking Table for DROP request ?
>
>
> Hello everybody,
>
> here is a strange thing that creates me nightmares ...
>
> How
Oops,
the syntax is
SELECT ... FROM ... WHERE .. LOCK IN SHARE MODE;
Heikki
-Original Message-
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, February 21, 2002 9:27 AM
Subject: Re: Fake interval data type
>Hi!
>
>>Its kind of a subtle
Hey all,
Just did a compile and install of v4.01 for multiprocessor Sparc. Server
has started, runs OK, have fiddled with privileges successfully...
Naturally, next step: I¹d like to test everything.
But now, I get a Segmentation Fault immediately at run-all-tests¹ script in
sql-bench.
Any id
>>Yes, I read through the numerous threads about this topic but I can't
>>solve my problem
>>
>>After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO
>>(./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47
>>--with-apxs=/opt/apache-1.3.23/bin/apxs)
>>
>>apache complains wi
Wolfgang Pichler wrote:
> Do you have also recompiled apache after compiling php ?
>
YES
> Am Mit, 2002-02-20 um 10.04 schrieb Andre Konopka:
>
>>Hi,
>>
>>mmh, maybe it's not a mysql-problem...
>>Yes, I read through the numerous threads about this topic but I can't
>>solve my problem
>>
Hello everybody,
here is a strange thing that creates me nightmares ...
How-To-Repeat:
Stage 1 . Using a my SQL GUI :
Create a simple Table ...
create table FAKE (bidon integer)
Everything works fine ...
Stage 2. Using a C compiler and MyODBC3.51 Driver (actually I use Borland as
C Compile
Hi!
>Its kind of a subtle point, but innodb's locking not only locks rows, it
>locks the ABSENCE of rows. If I understand correctly this means that
>something like:
>
>BEGIN WORK
>SELECT COUNT(*) FROM table WHERE starttime>? AND endtime(check the count)
>INSERT INTO table (if count is zero)
On Wed, Feb 06, 2002 at 10:02:02AM -0600, Todd Newbold wrote:
> Hi everyone,
>
>When using replicate-ignore-table in mysql, does filtering happen
> before or after transmission from the master to the slave?
Is the directive on the slave? If so, that's where it happens.
--
Jeremy D. Zawodny
Hi,
Try this:
select * from table1,table2 where table1.column1 like
concat(table2.column2,'%');
Anvar.
At 04:57 PM 20/02/2002 +, you wrote:
>>mysql,query
>>
>>
>>Hi , is there any way of performing something like the below statement?
>>
>>select * from table1,table2 where table1.column1
Hello,
I have a table with a column defined as BLOB. However, when I dump
this table using ./mysqldump, the dump file cannot be imported. Is
that because a binary field cannot be dumped into a text file? Any
solution if I really need to do the backup by dumping the table?
Cheers!
Dennis W
Is there another way as I do not have that version of
MYSQL installed on my server?
THanks-
KCK
--- Tod Harter <[EMAIL PROTECTED]> wrote:
> On Wednesday 20 February 2002 09:20, Web boy wrote:
>
> You want to use UNION. If I remember correctly its a
> fairly new feature for
> MySQL, but its a st
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote:
Hi,
Now I assume that the text you sent is from our documentation.
For to build an InnoDB table:
mysql> create table table_name (id int)type=innodb;
Query OK, 0 rows affected (0.14 sec)
Regards,
Miguel
>Dear sir,
>
>I am using MySQL database &
At 21:14 20/02/2002 -0800, Nilesh Deshpande wrote:
Hi!
Very strange the printed messages you sent.
What MySQL release version are you using ? I did the test with
your start InnoDB set with 3.23.48 and got:
c:\mysql\bin>mysqld-max --standalone --console
InnoDB: The first specified data file c:\
Hi Nilesh,
On Thu, 2002-02-21 at 15:14, Nilesh Deshpande wrote:
> I am using MySQL database &
> I just wanted to use transaction.so as per manual i
> have to make table type as Innodb.
>
> Then i had set Innodb startup options as follows
>
> innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
>
Hope this makes sense
I'm seeing random hung reads() after a mysql insert that appears to be
related to a sig alarm race condition. The basic workflow of this program
is
while (1)
recvfrom() /* few hundred packets a sec */
parse packet
insert into sql
However, once per second a sig a
Dear sir,
I am using MySQL database &
I just wanted to use transaction.so as per manual i
have to make table type as Innodb.
Then i had set Innodb startup options as follows
innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
innodb_data_home_dir = c:\ibdata
set-variable = innodb_mirrored_log_g
Thanks Arjen,
seems like a bit of a fiddle but not a bad solution considering some of the
other options. Unfortunately I also need the row level locking of innodb
so it's not going to work in my case. This lead me to ponder, if this
sort of row level protection was added would it be at the
My guess. . .
I have seen this problem with other databases . . . don't know if it is
true for MySQL as well. Try to change to your field definition to
float(5,2) as it may be counting the (.) as part of your field size.
So if you number is xx.xx you will need 5,2. 4,2 would give you xx.x
Da
Everyone,
I experienced table deadlock on my MySQL server...my client program does a
Table Write lock before writing to it...but suddenly the computer
hangs-up...do, other client got stuck and waiting for the table to be free
for writing...
But as I know...only the thread who does locking can do t
I have created a table in the mysql db, using phpmyadmin with the following
statement:
create table books
( isbn char(13) not null,author char(30),title(60),price float(4,2),primary
key(isbn));
which works fine and creates the table i need the problem comes when i try
to insert some values into
Hi,
On Thu, 2002-02-21 at 03:11, subodh kumar wrote:
> I am finding Problem with connecting JSP and mysql,
> it gives no error as well as exception,no output is coming out.
> please help me in this problem
> anticipating quick response
I don't mean to be negative, but considering you're basicall
You can also try:
Select SUBSTRING( MAX( CONCAT(LPAD(calltime,6,'0'),finishcode) ), 7) AS
finishcode,
0+LEFT( MAX( CONCAT(LPAD(calltime,6,'0'),finishcode )), 6) AS calltime
>From callhistory As H,calllist As L
where
H.rowid = L.rowid
group by H.rowid
This is from:
http://www.mysql.com/doc/
Hi Neil,
On Thu, 2002-02-21 at 08:26, Neil Silvester wrote:
> Just a trivial question.
> How does dual locations work?
> I am based in our Brisbane Australia office and am using MySQL as a backend
> for a company Intranet. Our parent company is based in Hayward, California
> and has recently conv
Hi there,
I'm having quite a bit of trouble with an application I'm writing on Linux,
using MySQL.
The database connectivity stuff works fine, all my queries return sane
results, etc, but I can't run the application under gdb.
When I try to connect to the database when under gdb, I get:
Access
Hi, I am a new user of MYSQL, when I use JDBC to
connect MYSQL, I got exception:
SQLException: Server configuration denies access to
data source.
Could some one kindly help me ?
Thanks a lot.
Jeff Zhao
Here is my program, it is very simple
import java.sql.*;
public class LoadDriver
{
his is my first post here so please excuse any irrelevancies.
I am trying to load a .csv file that contains 41943 Records of Data.
I am only able to load 20972 Records. (it seems to skip almost every-other
record).
The file, located @:
http://thisLinux.kicks-Ass.net/projects/databases/tbl_mapZip
Hi Neil,
On Wed, 2002-02-20 at 20:51, Neil Freeman wrote:
> I am using MySQL v3.23.40 on Windows NT. When creating various MyISAM
> tables the files saved are of the form *.frm *.MYD and *.MYI. So far so
> good. When I copy these files over to a Linux box though some of the
> *.MYD and *.MYI exte
Just a trivial question.
How does dual locations work?
I am based in our Brisbane Australia office and am using MySQL as a backend
for a company Intranet. Our parent company is based in Hayward, California
and has recently converted an old DOS based database over to MySQL. We are
both in the proce
David,
> How would you use a temporary table? Is that the most efficient way?
Use SELECT INTO temp_tbl to replace the sub-select clause.
Rewrite the existing SELECT into a join with the temp_tbl.
Is there another way?
=dn
> Richard,
>
> > Does anyone know what is wrong with this syntax...
Hi Andre,
On Wed, 2002-02-20 at 19:04, Andre Konopka wrote:
> mmh, maybe it's not a mysql-problem...
Indeed, doesn't look like it.
> Yes, I read through the numerous threads about this topic but I can't
> solve my problem
>
> After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DS
Hello,
I searched the manual but it seems like MySQL does not support ANSI SQL
CHECK constraints. These are often used to check that rows inserted into
tables meet specified criteria. For example table T created as follows
CREATE TABLE T (
X INT,
CHECK (X <= 10)
);
has a check constraint s
Hi,
On Wed, 2002-02-20 at 14:44, SplitSlim wrote:
> I need some help, this is a mission critical server and it has
> CRASHED!
> Details:FreeBSD on INTEL, MySQL v3.23.36 (FreeBSD Port)
> 020219 22:52:01 mysqld restarted
> mysqld got signal 11;
> The manual section 'Debugging a MySQL server' tell
Hello,
Have a look at :
http://www.compagnie.com/stef/solution1.jpg
http://www.compagnie.com/stef/solution2.jpg
I'm searching for a solution to change a high traffic mysql server with a
distributed system.
1)Is the solution 1 is good for a writing + reading access ? Are there
problems with lock
On Wednesday 20 February 2002 05:51, Sasa Babic wrote:
> On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
> > sql,query
>
> The above is for antispam filter.
>
>
>
> I have a need for an interval data type. It would contain start and end
> of a certain time event. Since it is not
Thanks, Greg! That line not only worked, but it gave me a more clear
example of the structure of such queries. :)
-Mike
> -Original Message-
> From: Johnson, Gregert [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 12:56 PM
> To: [EMAIL PROTECTED]
> Subject: RE: Getting
On Wednesday 20 February 2002 02:06, Anvar Hussain K.M. wrote:
> Hello,
>
> I don't feel the the table sizet will be a problem. But how would the
> database function with such a huge number of queries per second.
>
> If I read right, you will be taking a maximum (presently) of 42 channals
> each t
MySQL(mysql-server-3.23.36-1) is working find now, but I need upgrade to
MySQL-4.0.0-2.i386.rpm and this error appears.
[root@switch newrad]# rpm -Uvh MySQL-4.0.0-2.i386.rpm
error: failed dependencies :
MySQL-server conflicts with mysql-server-3.23.36-1
libmysqlclient.so.10 is nee
MySQL(mysql-server-3.23.36-1) is working find now, but I need upgrade to
MySQL-4.0.0-2.i386.rpm and this error appears.
[root@switch newrad]# rpm -Uvh MySQL-4.0.0-2.i386.rpm
error: failed dependencies :
MySQL-server conflicts with mysql-server-3.23.36-1
libmysqlclient.so.10 is nee
From: <[EMAIL PROTECTED]>
> >>My query
> select * from table1,table2 WHERE table1.ID = table2.code
> >> Query results
> 1 2 2
>
> >> Desired results
> 1 2
Try:
SELECT * FROM table1,table2
WHERE table1.ID = table2.code
GROUP BY table2.code
You'll find this someplace in:
http://ww
Hello,
I am having a difficult time figuring out how to get a certain specific
result from the database .
>>Example tables:
table1
ID|name
---
1 |15
2 |25
3 |50
table2
ID|code
---
1 |1
2 |2
3 |2
>>My query
select * from table1,table2 WHERE table1.ID = table2.code
The current qu
How would you use a temporary table? Is that the most efficient way?
David
-Original Message-
From: DL Neil [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 11:03 AM
To: Shade, Richard; [EMAIL PROTECTED]
Subject: Re: MYSQL HELP
Richard,
> Does anyone know what is wrong
Hello,
I don't feel the the table sizet will be a problem. But how would the
database function with such a huge number of queries per second.
If I read right, you will be taking a maximum (presently) of 42 channals
each taking taking data at the rate of 360/sec. That would be 42x360 =
15120 quer
Hi,
I think you can try to use REPLACE INTO table (a,b,c,d) SELECT e,f,g,h FROM
table2 WHERE field=what_you_want.
Best Regards,
Jocelyn Fournier
Presence-PC
- Original Message -
From: "Felix Richter" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2002 3:01 PM
SELECT LAST_INSERT_ID() will return the last auto_increment key written. This value
is connection-specific, so that inserts performed on other connections will not affect
it (in other words, you'll get the last key generated by user 1, regardless of what
user 2 does in the meantime).
--Greg J
use LAST_INSERT_ID() to get the last inserted id
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
and
'The most recently generated ID is maintained in the server on a
per-connection basis. It will not be changed by another client. It will not
even be changed if you update another AUTO_INCREM
Hi,
I wonder if anyone can offer me some advice with this one:
I have a table called 'iq_data' holding just a primary key and a field
called 'iq_data'.
+++--+-+-++
| Field | Type | Null | Key | Default | Extra |
++-
Richard,
> Does anyone know what is wrong with this syntax...
>
> Select H.FinishCode, L.RowID
> From CallHistory As H, BD2.CallList As L
> Where (H.CallTime in(Select MAX(CallTime) From CallHistory Where H.RowID =
> L.RowID)
> AND H.RowID = L.RowID);
Sub-selects not (yet) permitted by MySQL (
>Description:
When I try to run, I get the following output:
bin/safe_mysqld --user=mysql &
410
# ./bin/my_print_defaults: syntax error at line 1: `(' unexpected
>How-To-Repeat:
I used gtar to untar the binary Solaris 8 version. I get the error eny time I
try and start mysql.
>F
Richard Shade
Systems Administrator
(936)559-2280
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 11:39 AM
To: Shade, Richard
Subject: Re: MYSQL HELP
Your message cannot be posted because it appears to be either spam or simpl
>Description:
problem with test rpl15, FreeBSD 4.0, gcc version 2.95.2 19991024
>How-To-Repeat:
>Fix:
>Submitter-Id: <[EMAIL PROTECTED]>
>Originator:Gestore minimo
>Organization:
>MySQL support: [none ]
>Synopsis:
>Severity:
>Priority:
>Categ
SELECT Table1.orderid, Table2.otherfield1, Table2.otherfield2
FROM Table1, Table2
WHERE Table1.orderid = Table2.orderid;
--Greg Johnson
-Original Message-
From: SpyProductions Support Team [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 12:31 PM
To: [EMAIL PROTECTED]
Subjec
Hello
I'm new to MySQL, Unix and Replication.
I would like to know if in a scenario where I have one master and
several slaves I can convert one of the slaves to master in the event
my master goes down. Once I can bring the master back up, how to I
reverse the operation? Does any one know how to
Looking through the MySQL stuff online, I still can't come up with a
statement to pull data from one table based on data from another.
Table1 Contains:
orderid
Table2 Contains:
orderid
otherfield1
otherfield2
I want to get the data from table 2 based on a matching orderid first pulled
from t
to create a second instance of the same table
and this will probably show the relationship twice
SELECT p1.lname, p1.fname, p2.lname, p2.fname FROM members AS 'p1' LEFT JOIN
members AS 'p2' ON p1.engagedto = p2.id
not sure if you can do the LEFT JOIN table AS 'table2' or not, can't get to
mysql.
Hello sir,
I am finding Problem with connecting JSP and mysql,
it gives no error as well as exception,no output is coming out.
please help me in this problem
anticipating quick response
Thanking you!
subodh
-
Before posting,
On Mon, 18 Feb 2002, David Steinbrunner wrote:
> [EMAIL PROTECTED] wrote:
> > Good, Free Mac GUI to mySQL?
>
> The only free GUI client for mySQL for the Mac that I know of would be
> CocoaSQL: http://homepage.mac.com/mxcantor/ which is only for Mac OS X.
GNUe Forms and Designer have recently st
Hi,
I am trying to extract blob data from a query using the C API functions
(actually I am using Delphi). I understand the structure of the result set
and need to know the length of the blob field to extract it.
As far as I can tell the only way to find the length of the fields is by
using the
>
>mysql,query
>
>
>Hi , is there any way of performing something like the below statement?
>
>select * from table1,table2 where table1.column1 like table2.column2
>
>thanks in advance
>
>Rich
-
Before posting, please check:
bc203,
Wednesday, February 20, 2002, 5:31:03 PM, you wrote:
b> Now I can not open my all databases. The error following:
b> [root@linuxserver /root] # mysql -u root -p
b> Enter password:
b> Welcome to the MySQL monitor. Commands end with;or \g.
b> Your MySQL connection id is 1 to server version
Scalper,
Wednesday, February 20, 2002, 5:28:41 PM, you wrote:
S> I am trying to run multiple versions of MySQL (not simultaneously) on my
S> Windows box.
S> One is NuSphere's 3.23.44 with Gemini tables and the other is Max 3.23.49.
S> Do I only need to put the base files into two separate dire
Hello,
I am new with MySQL and have it running on Windws 2000 server and
programming with VC++ 6.0
Now converting from SQL 7.0 to MySQL
I wonder if there is a way to print out the data structure of the table in
MySQL?
Regards
Theo van Stratum
Albanet Ltd
(Technical Manager, Senior Programmer)
Had a similar problem a few years back. System worked fine for a number
of months then started crashing whenever I recompiled the kernel. Turned
out to be a defective secondary cache (yes it was a Pentium and yes it
was a number of years ago). Showed up only under heavy cpu load. Try
stres
Thanks, I will have a look at the official site. Is anybody aware of a
non-oficial site that contains an example with a real db as backend.
(With real db I mean tables with a few thousand+ records per table and
advanced queries with multiple joins) and then how one can optimise the
c code to run
Why?
Victoria Reznichenko wrote:
> Vincent,
>
> Sunday, February 17, 2002, 9:49:55 PM, you wrote:
>
> VS> Hello,
> VS> according to the docs:
>
> VS>"For the moment, GRANT only supports host, table, database, and column names
>up to 60
> VS> characters long.
> VS> A user name can be up to
Bob,
Wednesday, February 20, 2002, 2:01:12 AM, you wrote:
BR> I seem to have forgotten how to get into MySQL and work.
BR> (It's been a while but I'm starting up again. I get these
BR> errors: bob@sfpetard:~> mysqladmin create library
BR> mysqladmin: CREATE DATABASE failed; error: 'Access deni
Tim,
Tuesday, February 19, 2002, 9:57:07 PM, you wrote:
TW> Hopefully someone out there can help me as I haven't been able to find any
TW> documentation on this that applies.
TW> I am running MySQL version 3.22.32 on a FreeBSD v4.4 machine. I am getting
TW> "Error 2013: Lost connection to MyS
George,
Wednesday, February 20, 2002, 4:51:32 PM, you wrote:
GL> Hi list,
GL> Where can I find an online tutorial / example on how to use the C API
GL> for mysql?
Look in MySQL online documentation about C API:
http://www.mysql.com/doc/C/C/C.html
GL> George
GL> (mysql, query, sql)
-
shashidhara,
Wednesday, February 20, 2002, 11:51:59 AM, you wrote:
sn> Hello
sn> how to install mysql client only to connect server
sn> in windowsNt and Linux
sn> right now i'am working in server
sn> please mail to
sn> [EMAIL PROTECTED]
You can use a standart client program for Linux
MySQL-cl
Exactly what the error message says. In other words you do not have the
correct permissions to access the mysql database.
- Original Message -
From: "bc203" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2002 3:31 PM
Subject: What is error code 1044 ?
> Now I
Now I can not open my all databases. The error following:
[root@linuxserver /root] # mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with;or \g.
Your MySQL connection id is 1 to server version: 3.22.32
Type 'help' for help.
mysql> use mysql;
ERROR 1044: Access denied
I am trying to run multiple versions of MySQL (not simultaneously) on my
Windows box.
One is NuSphere's 3.23.44 with Gemini tables and the other is Max 3.23.49.
Do I only need to put the base files into two separate directories and then
modify the my.ini to point to the version I want to use a
Why bother with the line :
if ($dbcnx != FALSE)
When you could use :
if (!$dbcnz) . ?
- Original Message -
From: "Craig Westerman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2002 3:24 PM
Subject: Connect question
> Below is two scripts. The fi
The two passwords in the connections are different perhaps???
- Original Message -
From: "Craig Westerman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2002 3:24 PM
Subject: Connect question
> Below is two scripts. The first one connects fine. The second give
Below is two scripts. The first one connects fine. The second gives the
following error.
Parse error: parse error in /usr/www/users/abc/connect.php on line 1
What is the problem with the second script? Thanks in advance - Craig
#1 - Works
---
Our List of J
No reason, you have the right idea especially if you are dealing with
multiple platforms
-Original Message-
From: Cip [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 8:54 AM
To: [EMAIL PROTECTED]
Subject: Inventory management system based on mysql
Hi all,
I am trying to
Do you have also recompiled apache after compiling php ?
Am Mit, 2002-02-20 um 10.04 schrieb Andre Konopka:
> Hi,
>
> mmh, maybe it's not a mysql-problem...
> Yes, I read through the numerous threads about this topic but I can't
> solve my problem
>
> After compiling php-4.1.1 with mysql suppor
Hi all,
I am trying to put together an inventory management system for my company
an I was thinking to do it using mysql for the database, Red Hat Linux with
apache for the server.
I opted for a web like environment for this project because there are so
many different computers that need to a
Hi list,
Where can I find an online tutorial / example on how to use the C API
for mysql?
TIA
George
(mysql, query, sql)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
On Wednesday 20 February 2002 09:20, Web boy wrote:
You want to use UNION. If I remember correctly its a fairly new feature for
MySQL, but its a standard SQL thing. From the manual:
SELECT ...
UNION [ALL]
SELECT ...
[UNION
SELECT ...]
UNION is implemented in MySQL 4.0.0.
UNION is used t
- Original Message -
From: Javier <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 20, 2002 2:47 PM
Subject: Sum function question
> Hi, i have a table like this
>
> Key Field-1
> A string1
> A string2
> A string3
> B string1
> B stri
Hi, i have a table like this
Key Field-1
A string1
A string2
A string3
B string1
B string 2
I want to create a query to get the following result (only one line by key
field):
A - string1,string2,string3
B - string1,string2
I try to use the Sum function but it
Hi there,
I was following the instructions to compile the latest version of mysql
for Mac OS X, when I ran into a few errors.
I downloaded the source file as per the instructions from Apple
(http://developer.apple.com/internet/macosx/osdb.html), and then
followed the instructions on mysql
(h
Hello I have a query that goes through and gets the
data out of three tables without a problems. Now the
task at hand is to compair that out put against three
identiacal tables not displaying any duplicate date.
Tables:
a
a.aocode , a.CaseNo , a.CaseName
b.
b.ao_code , b.initials
c
c.CaseNo
Good Morning Alexander!
Looks like you have tuned your system pretty well.
> They are slightly less than 25716, is there any way to check if this
upper
> limit becoming reached sometimes?
sysctl kern.openfiles will tell you how many are open now but there is
no way to know if the upper limit i
Hi!
I need to SELECT some rows using a lengthy WHERE-clause and then to UPDATE these rows
just to set a flag. What is the best way to do this (performance-wise)? Being able to
do that in one single query would be great because otherwise I had to use transactions
to be sure to match _exactly_
Hi all, I have a thorny problem and I hope this is the right place, I've been
everywhere else I could think of. I have limited skills in this area.
I have a site with content management run by mysql/php (just to be original), using
two databases on the same machine. db1 is the working copy for
>Description:
A standard test fails. This is on PowerPC 64-bit Linux which
is very new and we have only just finished with glibc as
64-bit. Thus, the syscalls, glibc and the compiler itself are
all suspect -- so I don't expect anyone can really track this
[EMAIL PROTECTED] writes:
> >Description:
> When I run a ./configure --prefix=/usr/local/mysql --with-libwrap the configure
>completes but the make fails.
>
> Making all in sql
> make[2]: Entering directory `/usr/local/src/mysql-3.23.49/sql'
> Making all in share
> make[3]: Entering directory `/
root writes:
> >Description:
> When i execute the following query on my database:
>
> SELECT retaillastdone_.* FROM retaillastdone_ WHERE
>(retaillastdone_.source_="mercury" AND retaillastdone_.timestamp_ BETWEEN
>97864920 AND 978735599099) ORDER BY
>retaillastdone_.owner_,retaillast
You may simply copy or move "logrotate" from /etc/cron.daily in /etc/cron.hourly.
Logrotate will then be executed hourly, have a look into /etc/logrotate.conf,
/etc/logrotate.d and determine which files are due to be rotated. But as you cannot
set other delays but "daily","weekly","monthly" (se
I maintain 3 machines running MySQL.
Machine 1: Redhat 6.2 (Pentium 133, 40 megs, 1.5 gig)
An attempt to upgrade the server from version 3.23.46 to 3.23.49 via rpm
upgrade generated no errors or warnings but the resulting mysqld server
crashed. Reinstallation of an earlier version was required
On Wed, Feb 20, 2002 at 11:38:31AM +0100, [EMAIL PROTECTED] wrote:
>
> sql,query
The above is for antispam filter.
I have a need for an interval data type. It would contain start and end
of a certain time event. Since it is not possible to have two different
events at the same place and at th
Hi there,
I am using MySQL v3.23.40 on Windows NT. When creating various MyISAM
tables the files saved are of the form *.frm *.MYD and *.MYI. So far so
good. When I copy these files over to a Linux box though some of the
*.MYD and *.MYI extensions appear as lowercase *.myd and *.myi
This causes
Robert,
`mysqladmin ping` will print "mysqld is alive" if the server is running,
or error message in any other case.
Peter
On Wed, 20 Feb 2002, Li, Robert wrote:
> Hi, all mysql team
>
> As we know, use safe_mysqld or mysql.server
> we can startup Mysql instance.
> But how can i know when all
Hello
how to install mysql client only to connect server
in windowsNt and Linux
right now i'am working in server
please mail to
[EMAIL PROTECTED]
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
Hi, all mysql team
As we know, use safe_mysqld or mysql.server
we can startup Mysql instance.
But how can i know when all the mysqld daemons
really startup except use command ps?
Thanks in advance.
Robert Li
Computer Associates
-
Hi,
mmh, maybe it's not a mysql-problem...
Yes, I read through the numerous threads about this topic but I can't
solve my problem
After compiling php-4.1.1 with mysql support (mysql-3.23.47) as a DSO
(./configure --enable-libgcc --with-mysql=/opt/mysql-3.23.47
--with-apxs=/opt/apache-1.3.23/bi
hi everybody,
I have an OpenBSD 3.0 box running MySQL here, in my opinion setup correctly
and everything runs smooth. now I have the challenge to migrate an m$Access
based application called WinCard to play correctly with MySQL. the problem
is, that it is not possible to enter new records from th
Hi Ken,
Here are the values:
kern.maxfiles: 24616
kern.maxfilesperproc: 22154
They are slightly less than 25716, is there any way to check if this upper
limit becoming reached sometimes?
Now there are question about innodb tables and 4.0.1.
1. What can be gained by switching to innodb inside
Hi!
>> You may want to try out Intel's C++ compiler for Linux if you are using
an
>> ix86 CPU. We used it here at work and it resulted in code that ran more
than
>> twice as fast, though we have never tried it with MySQL.
>
>I wonder whether Intel's C++ compiler accept those flags. Are those fla
1 - 100 of 101 matches
Mail list logo
