Hi ,
I am working on Performance Management in MySQL. I got the information of
table and the type of data is.
Now the problem is that how can I work on performance.
For Example :- As we know that mysql support 4GB Data per table
and we also knows that mediumtext can support 4GB data per column.
I am gradually winning the war in promoting opensource to a number of my
key customers. Notably a couple have made the move to OpenOffice.org,
albeit on Windows. I am currently re-writing a key application to use
mySQl (previously Access), so in all I'm pleased.
However, the head bean counter
Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the
merge tables themselves work in later 3.23 versions. If this is the
case the documentation needs to be updated to show which version
supports what.
Eric
On Sat, 20 Apr 2002, Benjamin Pflugmann wrote:
Hi.
AFAIK, insert
I use phpBB.
When I change default character set in mysql I have a problem in phpBB so:
Warning: Supplied argument is not a valid MySQL result resource in
/../functions.php on line 230
Unable to query db!
But /../admin/index.php regularly runs.
What my problem is?
thanks
Edakom Internet
Darren,
Friday, April 19, 2002, 3:33:50 PM, you wrote:
DV I am having problems with load data local infile.
DV The mysql host server is running 3.23.23
DV I was able to successfully use load data local infile before to import data
DV off of a client machine onto the mysql host but now all i
### CHANGES ###
--- version 15.12 ---
- module tables can now be iconified so that they do not clutter
dashboards
- added minimize button to module tables
- save module tables minimize state and icon coordinates in
configuration (save) files
- implemented automatic intelligent icon
The file does exist. The file and its directory are 0777 permission.
Darren
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 4:32 AM
Subject: Re: problem with load data local infile
Darren,
Friday, April 19, 2002,
On Fri, 19 Apr 2002 16:03:44 -0500 (CDT)
Russell E Glaue [EMAIL PROTECTED] wrote:
I think it would be a good idea to be able to specify the error log on
the command line when starting mysqld. Right now mysql users can only
specify the following logs on the command line:
log
Hi,
This might work for you but with two quries:
SELECT @minval := least(min(colOne),min(colTwo)) FROM myTable;
SELECT colOne-@minval FROM myTable;
Anvar.
At 06:26 PM 19/04/2002 -0400, you wrote:
I am trying to normalize a data set based on the minimum values of certain
columns.
I figured
Darren,
Saturday, April 20, 2002, 1:23:54 PM, you wrote:
DV The file does exist. The file and its directory are 0777 permission.
Such permissions are setting on all dirs, that contain path to your
dir?
Don't forget that you should have permissions to go through dirs ...
DV Darren
--
For
Darren,
Saturday, April 20, 2002, 2:34:06 PM, you wrote:
DV The file is in a world readable directory tree.
DV Shouldn't the LOCAL qualifier make mysql read the file from the client
DV running and not the host?
DV I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
DV
Hi all,
Does somebody know what cause these errors ? (the option 'warnings' is
turned on)
It's debian 3.0, mysql 3.23.47-log, the application which use mysql are
freeradius, postfix and courier (all in localhost).
020420 16:45:57 Aborted connection 172 to db: 'radius' user: 'radiusd'
host:
Hi,
Problems on the network.High risq for corrupting tables.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From:
Have a look at urSQL (http://www.urbanresearch.com/ursql) -- it allows you
to run ad hoc queries and export the results to several different formats
(ie HTML, MS Word, Excel, Text, etc).
On Sat, 20 Apr 2002, Pierre du Parte wrote:
However, the head bean counter in one office tackled me on
Hello,
I'm trying to apply my limited SQL knowledge to my newly acquired MySql
database and am running into the following problem:
In the (very good) manual on the mysql website, this example is given
CREATE TABLE persons (
id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
name CHAR(60) NOT
Hi.
On Sat, Apr 20, 2002 at 01:12:14AM -0700, [EMAIL PROTECTED] wrote:
Perhaps the INSERT_METHOD functionality was introduced in 4.0 but the
merge tables themselves work in later 3.23 versions.
As I said, INSERT for MERGE was introduced in 4.0 (including
INSERT_METHOD). Of course, MERGE
- Original Message -
From: Yahoo! Groupes
[EMAIL PROTECTED]
r
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 10:56 PM
Subject: Demande de confirmation d'inscription à mysql-france
Bonjour,
Nous avons reçu votre demande d'inscription au groupe
mysql-france sur Yahoo! Groupes, le
Hi,
Lets say that I am the admin on mysql server, how can
i know which tables currently are locked? And if
they are locked by someone else, how to do I remove
the locks.
Thank you.
Rajan.
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon,
Hi
A good place to put this would be either in the projects area of
WeberDev.com :
http://www.weberdev.com/index.php3?GoTo=jobmatching/about.php3
or the jobs area of WeberDev.com :
http://www.weberdev.com/index.php3?GoTo=jobs/Jobs.php3
Sincerely
berber
Visit
Hi,
I followed the steps for two-way replication as described in the
documentation for mysql in section 4.10
We have two servers on suse linux running mysql, lets call them A and B,
considering A as the master and B as the slave
updates and inserts made at both A and B are seen on each other
At 18:22 +0200 4/20/02, Robert Douglass wrote:
Hello,
I'm trying to apply my limited SQL knowledge to my newly acquired MySql
database and am running into the following problem:
In the (very good) manual on the mysql website, this example is given
CREATE TABLE persons (
id SMALLINT UNSIGNED
At 13:34 +0100 4/19/02, Mick Watson wrote:
Thank you :-)
I do realise the SQL is not being used as it should be, but as it is not my
database and nor is it my SQL, there's not much I can do to really change
either of these I merely have to work with a database that has been
produced by a
Hello,
Klym writes:
I hope I'm not out of line by asking a licensing question. I am
working on a MySQL database for a web-based survey. We will be
charging a fee to complete the survey and receive reports. Am I
required to purchase a MySQL licence for this or does my hosting
At 6:34 -0500 4/20/02, Darren Vollmer wrote:
The file is in a world readable directory tree.
Shouldn't the LOCAL qualifier make mysql read the file from the client
running and not the host?
I tried to LOAD DATA LOCAL INFILE on using the name (and no path) of a mysql
FRM file that is in the
Hi,
I'm building an appl that will be running in at least 10 machines in the
same time connected to the same mysql server. They will working on the same
table this way:
1) A client ask for 100 records, work with them and update them
2) Each record must be used just once (cause this, the table
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 6:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
I noticed what you mentioned about
- Original Message -
From: Fiasco [EMAIL PROTECTED]
To: Paul DuBois [EMAIL PROTECTED]
Sent: Saturday, April 20, 2002 7:28 PM
Subject: Re: Re: problem with load data local infile
The error I receive is:
Can't stat file 'filename' (errcode 2)
It can't stat *filename*? Don't
I used the perl exec command to run 'mysql --help'. The returned info
says that the client version is 3.23.49. The local infile option was not
listed
in the help.
I assume the client needs to be started like
mysql --local-infile=1 ?
And if local infile is disabled wouldn't I get a different
Hi
MySql Details My server is running MySQL 3.23.45 and I have
4.0.0-alpha-nt on my local test machine.
What is the fastest way to select the first or the last row from a database?
I have tried queries like this
(id is an auto incrementing primary key)
select * from names order by id
Hi,
For the first question you can make it in two step :
SELECT MIN(id) FROM names;
SELECT * FROM names WHERE id = min ;
SELECT MAX(id) FROM names;
SELECT * FROM names WHERE id = max ;
Regards,
Jocelyn Fournier
PresencePC
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL
Both files are world readable.
How do you know this?
Because FTP tells me they are.
Also, when you say client machine, what do you mean? In particular,
are the web server and the MySQL servers running on the same machine?
Client machine is the machine running the webserver and MySQL
Why only port 3306 is used by MySQL? Is there some standard used like used
for FTP, localhost ports ?
Thanks !!!
-- Paras
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Gelu wrote:
Hi,
Problems on the network.High risq for corrupting tables.
What kind of network problem it should be because the clients are on the
local machine.
Regards,
@+
--
DouRiX
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Yes, and it is the same standard used to assign ports -- RFC 1700.
Paras Mukadam wrote:
Why only port 3306 is used by MySQL? Is there some standard used like used
for FTP, localhost ports ?
Thanks !!!
-- Paras
-
Before
Hi,
I'm running Mysql 4.01 on mandrake 8.2 with all production data
using InnoDB type.
I've a field named dch_pri contain some account transaction data in
format of DECIMAL (14,2).
When running following query:
SELECT din_no, SUM(IF(tran_type = D, dch_pri, -dch_pri)) AS dch_sum
35 matches
Mail list logo