 | | | MySQL General | | TK wrote
> My MySQL server (4.0.20 Linux) was running slowly. I checked the slow queries log and found many of these during the problem period
>
> # Time 060730 20 44 40
> # User@(protected) xxx []
>/ >Is there an efficient way to find the closest numerical value across
>three columns? I do not know if there is a way to find it across one. /
Not sure about efficiency but if the criterion numbeOn Mon 31 Jul 2006 06 26 01 -0700 (PDT)
Phong Nguyen <pnguyen5us@(protected) > wrote
> My question is if we decide to switch server 1 to
> server 2 (oracle database to mysql) or server 2 to
> server1 Penduga Arus wrote
> On 7/31/06 Peter Lauri <lists@(protected) > wrote
> > What version of MySQL do you have? Depending on that there are different
> > methods.
>
> MySQL 5 can you please show me hChris
At 10 42 AM 7/30/2006 you wrote
>Starting to build a new schema and one of the items is image storage
>In the past I have always used filesystem storage.
>
>Was wondering if I could get a cJ?rn Dahl-Stamnes wrote
> I got the following query
>
> select s.id s.name sum(p.fee) as fee from serie as s inner join race_serie as
> rs on (rs.serie_id s.id) inner join races as r on (r.id rsI guess MySQL should make binary for NetBSD too.
----- Original Message ----
From Clay R White <claymail@(protected) >
To mysql@(protected)
Sent Sunday July 30 2006 2 01 58 AM
Subject MySQLOn Sat Jul 29 2006 at 08 35 41AM -0700 Abdullah Ibn Hamad Al-Marri wrote
> Why MySQL 5.0.23 while it has serious bug?
>
> I thought you guys will release 5.0.24 instead.
This is still the case.i am working on a data collection system for an epidemiological study.
the study holds among other things sensitive personal information. the
personal info is stored in ONE table (i am using innodb_fMarco
It is also possible to set table locks by hand using a lock table
query. These connections will simply show up as sleeping or doing
something else. There currently isn 't a show locks commandAt 05 43 AM 7/29/2006 you wrote
>Dear list
>
>we are running a Mysql 5.0.22 server that is accessed by a number of
>java web applications (jdbc driver 3.1) over the network. The
>database layer wasI executed a "Load Data Infile " 24 hours ago and its still running. Yikes!
I have 6 of these tables to load and at this rate it will take forever. Can
someone please run through my Status variables [I searched the bug database...please let me know if I missed an already filed
or fixed bug.]
I am trying to dump a database from MySQL 4.0.24 using the client tools from
5.0. Debian server UbutnJoerg Bruehe wrote
> Hi
>
>
> MySQL 4.1.21 a new version of the popular Open Source Database
> Management System has been released. The Community Edition is now
> available in source and binary I am not aware of any such bug related to the LOCK TABLES privilege.
Like you I could not find a mention in our bugs database for any version.
It is easy to demonstrate that this is not the case. IIn the last episode (Jul 28) Andr?? Ress said
> We have a problem with abortet clients and long time querys.
>
> If our application performs a long time select statement on the mySql
> database anSeeing posts about mysqlcheck on the list prompted me to check out that
utility. A lot of it I can see is very useful and I understand what it
does. However what does the "optimize " command meanhi
i have attached my geometric query which is very slow. how to optimize this query
regards
shann
Hi
My mysql is crashing. Below table has the values it logs in the .err file
before restarting. I am using the large.cnf file.
The parameters I have changed are below. Rest are default values.
On Fri 2006-07-28 at 07 08 +0100 C.R.Vegelin wrote
> But when I run it with INNER join is takes more than 2 hours !!!
> In both cases the query applies to 9.571.220 rows matched with 0 changed.
> Grass Cake wrote
> I 'm still unsure about foreign keys..even after reading the doc file and
> Paul Dubois 3rd edition
>
> My doubt is...how much constraint is applied.....( probably a bad
> explanatbruce wrote
> hi...
>
> i 'm trying to figure out how to allow all users on machines within my
> network access to a mysql db...
>
> i 've tried
> grant access all on *.* to '* '@ '% '
> grant accessHi
I know that bdb has --skip-bdb and innodb has the ability to be disabled
at startup but what about federated csv archive etc? My problem is I
don 't want to recompile and I don 't want to caOn Thursday 27 July 2006 08 35 pm Dilipkumar wrote
> Hi
>
> If the tables are not in use you can tar -cvzf filename.tar.gz the datadir
> and move it to the new server but you should use the same mI have a Dell P2800 SERVER WITH
Red Hat AS 4 ( 64 bit machine)
6 GB of RAM
Dual Xeon DUALCORE 2.8Ghz with 2MB of L2 Cache
I will use MySQl 5.0 and InnoDB exits a config to use all power of thi-----BEGIN PGP SIGNED MESSAGE-----
Hash SHA1
Hi
MySQL Connector/J 5.0.3 a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
This is the first generally-available produ[snip]
i have a question i want to do something like this
select 10 as a 1 as b (a+b) as c
im want to get something like this
a | b | c
-------------
10 | 1 | 11
how can i do this... i wantchylli wrote
> I run following command
> use db1
> insert into db2.c select a.a a.b a c b.d b e ... from a left join b on
> (a.id b.id)
Do you have an index on a.id and b.id ?
> size of tabThis blog may help
http //www.xaprb.com/blog/2006/07/23/how-to-track-what-owns-a-mysql-connection/
Cheers
Ravi
Rithish Saralaya wrote
> Hello people.
>
> Is it possible to find the process thatDirk Bremer wrote
> I am using MySQL server 4.1.10 on Windows 2003 Server with MyISAM
> tables. I have an issue where occasionally an index (MYI) file becomes
> corrupted. I do not know why this occu |
|
|
