Dear users
can someone clarify the difference between manipulate and analysis !!
Manipulate should genreally mean changing the data and analying would mean
investigating.
So when we talk about Buffereing and Overlaying, does it come as part of
analysis or manipulate.
Or if someone can explain
Look at your fsync stat and your buffer pool ratio. You may get better
performance out of use O_DIRECT since it does not double buffer your log
writes.
Next make sure your buffer pool ratio is close to 1 (100%), if not raise
your bugger pool if you can. Additionally make sure you transaction logs
4.0.18 does not support Unicode. The JDBC driver tries to set the UNICODE
charset but can't because this mysql version cannot store Unicode data as a
charset. If you used 4.1.1, which is alpha it supports the charset and
correlations.
My suggestion is this. Store the blobs on NAS as UNICODE text.
On Apr 22, 2004, at 6:26 PM, Boyd Lynn Gerber wrote:
CC="gcc" CFLAGS="-I/usr/local/include" CXX="gcc"
CXXFLAGS="-I/usr/local/include" ./configure --prefix=/usr/local/mysql
--enable-thread-safe-client --with-innodb --with-berkelye-db=./bdb
--with-openssl --with-extra-charsets=comples
On a 7.1.0 s
I just wrote:
On Apr 22, 2004, at 6:26 PM, Boyd Lynn Gerber wrote:
CC="gcc" CFLAGS="-I/usr/local/include" CXX="gcc"
CXXFLAGS="-I/usr/local/include" ./configure
--prefix=/usr/local/mysql
--enable-thread-safe-client --with-innodb --with-berkelye-db=./bdb
--with-openssl --with-extra-charsets=comples
On Thu, Apr 22, 2004 at 08:05:07PM -0700, Emmett Bishop wrote:
> Howdy all,
>
> I've got a few questions about the table cache and the
> tmp_table_size.
>
> First off, a little background info. The server has
> been running now for 193 hours. I've got 3 GB of RAM
> on my box and I'm running RH li
On Fri, Apr 23, 2004 at 02:07:43AM +, Saurabh Data wrote:
>
> Dear users.
>
> I havent found any documentation for the interoperability/compatibility of
> MySQL with other open source tools as a spatial database backend.
>
> Is is because, MySQL provides limited functions for spatial analys
On Thu, Apr 22, 2004 at 10:05:36PM -0500, Terry & Cheryl Haimann wrote:
> How do you set up calculated fields in mysql?
Unless I'm not sure what you're asking, you don't.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com
Friends,
Sorry to post this question again. I got a message saying that the server couldn't
transfer this message to some groups. Also I didn't get any response to this
question.
We are using mysql 4.0.17 with innodb option. In a query, when a WHERE clause
contains a non-indexed colu
How do you set up calculated fields in mysql?
Thx,Terry
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Howdy all,
I've got a few questions about the table cache and the
tmp_table_size.
First off, a little background info. The server has
been running now for 193 hours. I've got 3 GB of RAM
on my box and I'm running RH linux. The MySQL
installation is version 4.0.13.
After taking a look at Show Sta
Dear users.
I havent found any documentation for the interoperability/compatibility of
MySQL with other open source tools as a spatial database backend.
Is is because, MySQL provides limited functions for spatial analysis and
fuctions to test spatial relationship between spatial object ?
Howev
I'm posting this as a last ditch effort to get this working or at least
find out what's going on and perhaps get a workaround if one exists.
Platform: Windows XP SP1
Database: MySQL 4.0.18
JDBC Drv: 3.0.11
History:
There is an existing website which uses ColdFusion/SQLServer. The owner of
this we
Oh.
If only I'd tried ONE more thing before mailing that out!
If anyone does have the same problem, the vital (missing) piece of
information is that I was using MySQLCC. It seems to have problems with SPs
unless you open a new query window after changing the contents of a
procedure..
Thanks,
M
Hi all.
Another hiccup along the happy road with MySQL 5.0!
The last bit of a stored procedure I have just put together does this:
-- insert cluster row
INSERT INTO clusters (Name) VALUES (sName);
SELECT LAST_INSERT_ID() INTO iNewClusterID;
-- insert map row
INSERT INTO map (X, Y) VALUES (iX,iY
On Thu, 22 Apr 2004, Steven Palm wrote:
> On Apr 22, 2004, at 3:28 PM, Boyd Lynn Gerber wrote:
> > On Thu, 22 Apr 2004, Steven Palm wrote:
> >> Using the production code 4.0.18 on a UnixWare 7.1.0 system, it fails
> >> to compile here.
> > I was able to build it with the following...
> >
> > CC="gc
On Apr 22, 2004, at 3:28 PM, Boyd Lynn Gerber wrote:
On Thu, 22 Apr 2004, Steven Palm wrote:
Using the production code 4.0.18 on a UnixWare 7.1.0 system, it fails
to compile here.
Anyway, the errors:
source='sql_lex.cc' object='sql_lex.o' libtool=no \
depfile='.deps/sql_lex.Po' t
Alter table 'tablename' change column 'columnname' 'new-columnname' not null
default 0
If you have any null values in that column, you will not be able to make the
change.
J.R.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.c
Small correction :
"Kernel 2.4.21-9.ELsmp on an x86_64" is not valid in this case. It came form
another machine.
Real kernel version is
Linux pinhpe02 2.4.21-9.EL #1 SMP Thu Jan 8 16:54:40 EST 2004 ia64 ia64 ia64
GNU/Linux
MySQL:
mysql-pro-4.0.18-unknown-linux-ia64
Problem Description:
/usr
This seems very basic to me but I can't find (though
only really looked for a little bit) the syntax for
issuing an alter table statement that will force a
field to no longer allow NULL values. I have some
fields in a MyISAM table of MySQL 3.23 and wish to
require them to contain a value.
What is
Hello Everyone,
We are already working with MySQL support on this issue but just wondering
if there are anyone using MySQL database on RH 3.0. Following is our O/S and
DB version info
O/S :
Red Hat Enterprise Linux AS release 3 (Taroon Update 1)
Kernel 2.4.21-9.ELsmp on an x86_64
Linux pinhpe02
On Thu, 22 Apr 2004, Steven Palm wrote:
> Using the production code 4.0.18 on a UnixWare 7.1.0 system, it fails
> to compile here.
>
> I do not have a 'CC' executable, so I am using gcc. If this is the
> problem, did I just miss installng the CC (c++) compiler at some point?
You have to use the
that solution doesnt work.if you are working on Xpyou
could a system restore.thats what I did.and then I
installed mysql again.
S.
--- "Tam, Michael" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I forgot to reply to the list instead.
>
> This is a recap of what I sent to Vasanthsena x.
>
> Thes
John M,
Thanks for the solution, gave me exactly what I was looking for.
Thanks,
James
-Original Message-
From: John McCaskey [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 22, 2004 3:54 PM
To: James; [EMAIL PROTECTED]
Subject: RE: Last Record Pulling my hair out :D
Try, SELECT * FR
Think you want:
Select max(job_id)
from job_log_2004
> I'm trying to select the last record (row) in a db. I'm trying with a
> select:
> Select * from job_log_2004 where job_log_2004.JobID = (select
> max(job_log_2004.JobID) from job_log_2004) and it fails. The part about
> select max works an
Try, SELECT * FROM job_log_2004 ORDER BY JobID DESC LIMIT 1. This is
simpler than your sub select method and probably faster. Sub selects
don't work in MySQL 4.x so if you are not using a newer beta build that
is probably why it fails.
John A. McCaskey
-Original Message-
From: James [ma
I'm trying to select the last record (row) in a db. I'm trying with a
select:
Select * from job_log_2004 where job_log_2004.JobID = (select
max(job_log_2004.JobID) from job_log_2004) and it fails. The part about
select max works and returns a number. What on earth am I doing wrong?
Or is there an
I've seen a quirk in Mysql behavior over the years when dealing with max().
In a query such as this:
select max(somecol) from sometbl where id=# and otherthing=#
(index is on id, but not on otherthing)
We see the query run just fine (0.x seconds to run) almost all of the time.
But
> ERROR 1005: Can't create table './TNMailServer/TNSession.frm' (errno: 121)
>
> This is on version mysql-standard-4.0.18-pc-linux-i686
If this is on a typical linux box, errno 121 is
#define EREMOTEIO 121 /* Remote I/O error */
typically relate to an NFS mounted file system. Does the
Ok,
Looks like I will be building my own server for my company.
Its sole purpose will be to run mysql/php/apahce as fast as possible for
under $2.5k
I'm not using mysql for storage. I will be using it to return many complex
queries in fewer seconds. Its speed over space.
So far I've been able to
On Tue, Mar 30, 2004 at 05:45:06PM -0500, Schwartz, Evelyn wrote:
> Does anyone have a list of the files that need to be backed up for a
> cold backup of an innodb database:
>
> Obviously all the MyISAM files and the innodb database files. But what
> about the log and archive log files?
Yes, t
Dave Dennis <[EMAIL PROTECTED]> wrote:
> Dear MySQL list,
>
> Managed to create a problem where:
>
> mysql > use mysql;
>
> ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
>
> Need a procedure to follow / documented steps to restore root's access
> to database mysql,
Hi,
I forgot to reply to the list instead.
This is a recap of what I sent to Vasanthsena x.
These are the steps I do when I have to uninstall it.
1. Stop mysqld (through service or manually using mysqladmin)
2. Remove mysqld service if you have setup the service.
Using the production code 4.0.18 on a UnixWare 7.1.0 system, it fails
to compile here.
I do not have a 'CC' executable, so I am using gcc. If this is the
problem, did I just miss installng the CC (c++) compiler at some point?
Anyway, the errors:
source='sql_lex.cc' object='sql_lex.o' l
It seems to work quite well. The documentation could use a bit of updating,
but it only took me 20 minutes or so to figure it out.
If you are using the InnoDB table type, I believe that there is no other way
to do a hot backup. The other hot-backup scripts that come with MySQL work
only with MyISA
Hi dathan,
thanks for your help. I am planning to test it out with a 4.0.18 server and
see if the problem still persists.
I also went through all the bug fix reports in the link you sent below,
however I could not find any bug fix related to this problem from 4.0.14,
15,16,17. I would apprecia
Dear MySQL list,
Managed to create a problem where:
mysql > use mysql;
ERROR 1044: Access denied for user: '[EMAIL PROTECTED]' to database 'mysql'
Need a procedure to follow / documented steps to restore root's access
to database mysql, version 4.0.17 .
Kind regards,
+
Hello.
I have a problem I believe must have been solved lots of times before. I am doing a
fulltext search on two tables at the same time. The problem is that it takes about
20-30
seconds (two really small tables! < 400 entries!!!).
Here is the query:
SELECT DISTINCT object.id_object FROM obj
I have a requirement where I have to accept only two parameters in script
for space and other calculation i.e.
-i -o
My instance can have multiple databases and can have MyISAM and Innodb table
type both. I am looking for following info for MyISAM tabel type
Total space allocated
Total space u
Dear users
Can someone comment on general compatibility/interoperability of OSS with
other OSS or with the proprietary systems.
Many THanks
Saurabh Data
___
Saurabh Data
School of Computing
University of Leeds
Leeds LS2 9JT
U.K.
You can specify the date (Datetime or Timestamp) format when creating
table as follows:
Type=>Format
-
DATETIME => -MM-DD HH:MM:SS
DATE => -MM-DD
TIME => HH:MM:SS
YEAR =>
TIMESTAMP
---
TIMESTAMP(14) => MMDDHHMMSS
TIMESTAMP(12) => YY
At 11:21 -0400 4/22/04, Keith C. Ivey wrote:
On 22 Apr 2004 at 12:31, Johan Hook wrote:
Assuming you want to order your arbitrary selection you could
do something like:
(SELECT t.Id FROM tab t LIMIT 10)
UNION ALL
(SELECT t.Id FROM tab t WHERE 1 < 0)
ORDER BY t.Id
You don't even need to inclu
At 10:59 -0400 4/22/04, Lou Olsten wrote:
Per one of my last posts on searching... I can't find the meanings
for these variables. I've tried a general google search with no
luck. Anyone got any ideas?
convert_character_set
error_count
slave_compressed_protocol
sql_big_tables
sql_low_priority_u
Erich Beyrent wrote:
Hi all,
This is probably a dumb question...
I am in the planning stages for a database project, where I will need to
store a bunch of documents in both PDF and MS Word format. Assuming that
the documents are stored as binary in the database, suppose I want to be
able to sea
On 22 Apr 2004 at 12:31, Johan Hook wrote:
> Assuming you want to order your arbitrary selection you could
> do something like:
> (SELECT t.Id FROM tab t LIMIT 10)
> UNION ALL
> (SELECT t.Id FROM tab t WHERE 1 < 0)
> ORDER BY t.Id
You don't even need to include the dummy query. You can do a UNIO
At 7:48 -0500 4/22/04, Faine, Mark wrote:
I'm trying to configure a JDBC realm using a third party database and it
seems they are using the mysql password command to store their passwords. I
read in the docs:
"When a standard realm authenticates by retrieving the stored password and
comparing it w
At 11:35 +0200 4/22/04, Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Paul DuBois <[EMAIL PROTECTED]> writes:
At 18:51 +0200 4/21/04, Jacek Jaroczynski wrote:
Is there possibility to first LIMIT and then ORDER records?
Not with a single SELECT. ORDER BY occurs before LIMIT.
You could u
Per one of my last posts on searching... I can't find the meanings for these
variables. I've tried a general google search with no luck. Anyone got any ideas?
convert_character_set
error_count
slave_compressed_protocol
sql_big_tables
sql_low_priority_updates
sql_max_join_size
sql_slave_skip_cou
Thanks for your suggestion of searching the docs offline. I already had the
HTML ones on my laptop, so it was a small step.
Lou
- Original Message -
From: "Donny Simonton" <[EMAIL PROTECTED]>
To: "'Lou Olsten'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, April 21, 2004 4:51
Seems like MySQL is selecting the primary key, or thinks that reading
all rows is faster than using the month_day key.
What happens if you do one day at a time with an = as in:
WHERE month_day = 14
or WHERE month_day = 14 AND month_day=7 (etc)
Does it run faster? Does the explain show key used=m
Hi Kamlesh,
You should send an explain of the query, but if there is no index
on tableB.user_id your join will not work well, since the actual join
would be on tableB.user_id=tableA.user_id
Either change your index on table b to be user_id,user_data2 or add
this index.
Hope this helps,
Ken
Ke
At 20:38 -0700 4/21/04, John Mistler wrote:
I could be much clearer:
I understand the backtick character, when used on either side of a string
i.e. `Hello there` will allow the string to be accessed as one unit, even
though there is a space in it. Also, it will allow for `Hello-there` to be
acces
> Is it indexed?
>
> And don't forget you can use the command
> SHOW INNODB STATUS\G
>
> to show the last FK related error.
ahh yes - i did not know about this command
LATEST FOREIGN KEY ERROR
040422 14:39:09 Error in foreign key constraint creati
From: Scott Swaim [mailto:[EMAIL PROTECTED]
> Thank you Chris for that answer. I did not know if it was a
> mysql problem or php problem.
>
> Again I apologize (especially to Mike Johsnon) for the
> multiple request. I was getting a return error on the list
> and I thought it was a configura
Hi all,
This is probably a dumb question...
I am in the planning stages for a database project, where I will need to
store a bunch of documents in both PDF and MS Word format. Assuming that
the documents are stored as binary in the database, suppose I want to be
able to search the database for t
Hi,
> I'm trying to create a table with the following syntax
>
> CREATE TABLE TNSession
> (
> SessionID int(11) NOT NULL auto_increment,
> IPAddress varchar(50) default NULL,
> Created datetime default NULL,
> Expired tinyint(4) default '0',
> AccountID int(11) default '0',
> PRIMARY KEY (SessionI
Hi,
I'm trying to create a table with the following syntax
CREATE TABLE TNSession
(
SessionID int(11) NOT NULL auto_increment,
IPAddress varchar(50) default NULL,
Created datetime default NULL,
Expired tinyint(4) default '0',
AccountID int(11) default '0',
PRIMARY KEY (SessionID),
KEY FK_AccountI
I would bet 99.9% of the problem is you aren't using indexes.
Run an explain on your queries that will show you were the problem probably
is.
Donny
> -Original Message-
> From: Teus van Arkel [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 22, 2004 6:11 AM
> To: [EMAIL PROTECTED]
> Sub
[EMAIL PROTECTED] wrote:
> Hi All,
>Can you specify what format to use for the datetime column eg.
> in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on?
>
No.
You can use DATE_FORMAT() function to format date values when you retrieve data:
http://dev.mysql.com/d
Gabriela Moisi <[EMAIL PROTECTED]> wrote:
> Do you plan to include in future MySQL release command like
>
> REBUILD AUTOINCREMENT field_name ...?
>
> (to rebuild auto_increment field, useful after masive delete, to start
> again from 1)
For MyISAM table you can do it with ALTER TABLE state
I'm trying to configure a JDBC realm using a third party database and it
seems they are using the mysql password command to store their passwords. I
read in the docs:
"When a standard realm authenticates by retrieving the stored password and
comparing it with the value presented by the user, you
"Eric J. Janus" <[EMAIL PROTECTED]> wrote:
> Is there a way to re-read the variables in my.cnf without having to re-start
> the server.
No.
> I realize that I could manually change most of the variables,
> but being lazy as I am, having the server just re-read its settings would be
> idea.
>
So
Is there a way to re-read the variables in my.cnf without having to re-start
the server. I realize that I could manually change most of the variables,
but being lazy as I am, having the server just re-read its settings would be
idea.
Thanks,
Eric
--
MySQL General Mailing List
For list archive
On Thursday 22 April 2004 12:56, [EMAIL PROTECTED] might have typed:
> Hi All,
> Can you specify what format to use for the datetime column eg.
> in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on?
If you read the manual, you will see that the column is formatted in one wa
Hi All,
Can you specify what format to use for the datetime column eg.
in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on?
Regards,
Amit
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTE
Do you plan to include in future MySQL release command like
REBUILD AUTOINCREMENT field_name ...?
(to rebuild auto_increment field, useful after masive delete, to start
again from 1)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lis
Hello,
We are setting up a mysql database for working with and manipulate large
amounts of data.
I'm using a visual basic script for manipulating particular rows in
every record in a test-database with almost 65.000 records.
This script is checking the spaces in row and put this in several
variab
Assuming you want to order your arbitrary selection you could
do something like:
(SELECT t.Id FROM tab t LIMIT 10)
UNION ALL
(SELECT t.Id FROM tab t WHERE 1 < 0)
ORDER BY t.Id
/Johan
Harald Fuchs wrote:
In article <[EMAIL PROTECTED]>,
Paul DuBois <[EMAIL PROTECTED]> writes:
At 18:51 +0200 4/21/0
>>
>> --Bruce
>>
>
> There are many different options. php-general list
> might have something in the archives.
>
> Usually my preferred method is storing application
> wide settings and commonly used functions in a file
> that is included on each page.
>
>
>
> You might also take a look at parse
- Original Message -
From: "Dan Bowkley" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 22, 2004 10:05 AM
Subject: Re: unstable mysql connection
> you might also try using some sort of VPN solution; depending on distance,
> setting up pptp might not be a bad idea anywa
Hello!
I am facing a problem when using SQL_CALC_FOUND_ROWS in certain queries.
The query where I am ordering by a column is much more slowly than the same
query NOT using SQL_CALC_FOUND_ROWS
select SQL_CALC_FOUND_ROWS * from table by date desc
- this query takes about 1.2 s
select * from table
--- Bruce Vander Werf wrote:
> I am developing a php/mysql web application, and I
> am facing the task of
> storing application settings. Because it is web
> based, I will need to
> read the app settings on a per-session basis.
>
> I see one of two choices here - store each setting
> as a separat
Hi,
On Wed, Apr 21, 2004 at 06:35:53PM +0200, Mechain Marc wrote:
> Add this in your my.cnf slave file:
>
> slave-skip-errors = 1062
Ahh, that's what i was looking for. Seems as if i had not read chapter 6
of the documentation thoroughly enough...
Thanks,
Georg
--
MySQL General Mailing List
Victor Sp?ng Arthursson <[EMAIL PROTECTED]> wrote:
>
> Using mysql version 4.0.x, and would like to know if it is possible to
> join in a count(*) from a related table which count the number of
> corresponding posts in this per post in the first table?
>
> A little like:
>
> table1:
> +---
you might also try using some sort of VPN solution; depending on distance,
setting up pptp might not be a bad idea anyways. The overhead can hit 5% or
even 10%, but the added security and error correction makes it well worth
it, especially over a potentially buggy connection such as yours.
I've p
Hi!
Using mysql version 4.0.x, and would like to know if it is possible to
join in a count(*) from a related table which count the number of
corresponding posts in this per post in the first table?
A little like:
table1:
+-+--+
| id | name |
+-+--
Check the process list (do a ctrl+alt+delete and click the processes tab) to
see if mysql is still running; you might have to stop the service before
removing it. Even with permissions set to read/write for everyone, it still
won't let you delete it if it's running at the time.
hth
Dan
- Orig
Hello,
MAM> The good, bad, and the ugly of it? We're debating if we should use it on
MAM> our INNODB tables or use a script to do a hotbackup.
On a big database, restore a mysqldump file can take hours.
ibbackup is very fast. restore is near as fast as a file copy.
you can parameter the load tha
78 matches
Mail list logo
