hi,
i have a machine with 6G memory, loaded with RHEL4. now, my question is
mysql support innodb as the default table type? will be stable running
RHEL4?
i saw /usr/share/mysql/my-innodb-heavy-4G.cnf file, then, i replace the
existing one (/etc/my.cnf). but, it failed to start the mysql
Dear MySQL,
My MySQL 4.1.9 has lost the ability to work out what IP address clients
are connecting from. Eg:
$ mysqladmin processlist
++--+---+--+-+--+---+--+
| Id | User | Host | db | Command | Time | State | Info|
I learn configuring the mysql server in the manul 5.3.1.I notice there is a
parameter --large pages.Please tell my how do i alter linux system memory
pages .
_
免费下载 MSN Explorer: http://explorer.msn.com/lccn
--
MySQL
Hello,
I am trying to build a sql statement for MySQL 4.0.x which does count
the accumulated total entries in a table per day since a specified start
date.
For example:
Day 1 = 10
Day 2 = 12
Day 3 = 9
The statement I am using gives back the entries per day, starting each
day with 0.
For
Currently i have 4 Gbyte RAM and RH 9 Linux using InnoDB
and yes, it's stable :)
Hiu Yen Onn wrote:
hi,
i have a machine with 6G memory, loaded with RHEL4. now, my question
is mysql support innodb as the default table type? will be stable
running RHEL4?
i saw
Alexandra wrote:
Hello,
I am trying to build a sql statement for MySQL 4.0.x which does count
the accumulated total entries in a table per day since a specified
start date.
For example:
Day 1 = 10
Day 2 = 12
Day 3 = 9
The statement I am using gives back the entries per day, starting
Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote on 14/10/2005
03:28:15:
Hi Listers,
Does anybody know if the MyISAM engine (apart from InnoDB) allows the
use of raw disk space rather than having cooked files? If not, is this
feature likely to be included in a future release? I had a
Hi Alec,
Thanks for the response. You are probably quite right about the gains,
mostly my query was through curiosity more than anything. I use raw
devices with Informix and a couple of other databases and there are
small improvements to be seen on these products. On very large scale
Dan Buettner wrote:
I tend to disagree - at my place of employment, a newspaper, we have
hundreds of gigabytes of BLOB data (ad and page layouts digital
artwork) stored in SQL databases. Granted we are using Sybase for that
and not MySQL but there are a lot of advantages to it - access
Hi
I am working with MySql 4.1.14 under Windows XP.
I am trying to do a database import from a file.
I have the following table definiton
CREATE TABLE attribute_instance (
name varchar(200) NOT NULL default '',
id int(11) NOT NULL default '0',
PRIMARY KEY (id,name),
KEY id (id,name),
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM:
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script
about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this the test script
written
I need to convert this query into one without a subquery:
SELECT
r.selector_forms_results_max_points AS points,
r.selector_forms_results_description AS description,
FROM selector_forms_results AS r
WHERE r.selector_forms_id = 1
AND r.selector_forms_results_max_points = (
SELECT
(response interspersed)
Boris Villazon [EMAIL PROTECTED] wrote on 10/14/2005
08:30:13 AM:
Hi
I am working with MySql 4.1.14 under Windows XP.
I am trying to do a database import from a file.
I have the following table definiton
CREATE TABLE attribute_instance (
name varchar(200)
Hi!
[EMAIL PROTECTED] wrote:
lu ming [EMAIL PROTECTED] wrote on 10/14/2005 12:20:19 AM:
Hi, joerg
Thank you very much!
But i want to know more about this problem. I find a perl script
about
mysql server's test in the mysql-test
subdirectory(/mysql-test/mysql-test-run.pl). Is this
Kristen G. Thorson [EMAIL PROTECTED] wrote on 10/14/2005
09:15:21 AM:
I need to convert this query into one without a subquery:
SELECT
r.selector_forms_results_max_points AS points,
r.selector_forms_results_description AS description,
FROM selector_forms_results AS r
WHERE
[EMAIL PROTECTED] wrote:
Kristen G. Thorson [EMAIL PROTECTED] wrote on 10/14/2005
09:15:21 AM:
I need to convert this query into one without a subquery:
SELECT
r.selector_forms_results_max_points AS points,
r.selector_forms_results_description AS description,
FROM
Hi all,
I have a rather strange problem that I cannot seem to figure out. When
I run the following query from the MySQL console:
SELECT
Inventory.ID as InventoryID,
Inventory.Name,
Inventory.Capacity,
Inventory.Beds,
Avails.ID as AvailabilityID,
[EMAIL PROTECTED] wrote:
(response interspersed)
Boris Villazon [EMAIL PROTECTED] wrote on 10/14/2005
08:30:13 AM:
Hi
I am working with MySql 4.1.14 under Windows XP.
I am trying to do a database import from a file.
I have the following table definiton
CREATE TABLE
Hello, I am just starting with MySQL and PHP, but this discussion about
innodb has rather piqued my interest. Can someone please give a brief
explanation as to what it is.
Cheers,
Joe.
Gerald Taylor [EMAIL PROTECTED] wrote on 10/14/2005 10:42:33 AM:
Thank you for your answer. What I'm trying to do is return the scores of
the diff values of datapoints between a particular user and all the
other users in the system. (hence the mypmd.uid != pmd.uid) Some
datapoints
Joe Herman [EMAIL PROTECTED] wrote on 10/14/2005 01:42:41 PM:
Hello, I am just starting with MySQL and PHP, but this discussion about
innodb has rather piqued my interest. Can someone please give a brief
explanation as to what it is.
Cheers,
Joe.
In a nutshell, InnoDB is one of the data
Than you very much . It is working
Anil
DBA
-Original Message-
From: Dobromir Velev [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 13, 2005 8:58 PM
To: mysql@lists.mysql.com
Cc: Anil
Subject: Re: connection issue
When you connect without specifing the host, the mysql client will
MySQL 4.1.14 is the current version. You should always upgrade to the
lastest release and test your problem before trying to report bugs.
Ben Clewett wrote:
Dear MySQL,
My MySQL 4.1.9 has lost the ability to work out what IP address
clients are connecting from. Eg:
$ mysqladmin
I've tried tweaking the structure of the schema to have, for example, a PRIMARY
KEY index on email, no other indexes, and then insert in sorted order -- made
no improvement whatsoever. Another clue that leads me to believe that this may
be an OS issue: Starting a large cp on the same box
Hi
Is there a way to setup a maximum query execution time per user. I
understand the options max_connections and max_questions. But I am
looking for a way to kill a query per user if it takes longer than XX
minutes!
Thanks
John
--
MySQL General Mailing List
For list archives:
hi...
a basic/new/curious question. i have the following sample tbl schema. i do
the following update on the mysql command line and it updates for both
cases. my question is why???
it was my understanding that the two cases are different and shouldn't both
be triggered.the value of 'username' in
In the last episode (Oct 14), bruce said:
a basic/new/curious question. i have the following sample tbl schema.
i do the following update on the mysql command line and it updates
for both cases. my question is why???
update UserTBL set gid='25', usertype='Super Administrator11' where
Are you using the my-innodb-heavy-4G.cnf file for your machine? i loaded
the cnf file to /etc/my.cnf. then, it fails to start. what's wrong with it?
mind to tell me on how to set the default table type equal to
innodb?perhaps, can you guide me for cnf configuration for a 6G memory
big machine
hereby, i attached the my.cnf file. by default, i copied it from
/usr/share/mysql/my-huge.cnf. however, i have added default table type =
INNODB. from the my.cnf, i can see that there are flags for innodb
table, starting from
# Uncomment the following if you are using InnoDB tables
29 matches
Mail list logo