We want only mysql 4.1.8 client version .How to get only client installed
without server being installed?
Thanking you,
yours sincerely,
I need to execute an INSERT...SELECT query.
INSERT HIGH_PRIORITY INTO stations_data
(station_id,
Tmin,
Tmax,
Tmed,
RHmin,
RHmax,
RHmed,
rain,
Wmax,
slpres,
insertion_date)
(
SELECT
stations.station_id AS stId,
min(stations_rt_data.T) AS tmax,
Iavor,
if you use the directory quota method and InnoDB's
innodb_file_per_table
option in 4.1.9, I would be interested to hear the results. If the space
runs out in a database directory, then INSERTs etc. in that database should
fail with the error 'Table is full' and the SQL statement should be
Here is my My.ini. I have tweeked it per many sources but would
love some comments on it.
Thanks
Larry
[mysqld]
basedir=C:/MySql
datadir=D:/MySqlData
language=C:/MySql/share/english
port=3306
key_buffer_size=512M
table_cache=64
net_buffer_length=1M
max_allowed_packet=3M
query_cache_limit = 1M
quer
A single transaction logs into the db several times?
I assume its a browser based transaction, no?
Are you limiting connections (in my.conf)? Have you tuned the config, if
yes how so?
--Original Message--
From: Larry Lowry
To: mysql
Sent: Jan 21, 2005 12:49 PM
Subject: Connection perfo
Before I ask this question I must state I love mySql and want to use it more.
But I work in a shop were we mostly use SQL Server 2000. In trying to use
mySql (4.12 and 4.19) we are seeing some performance issues. I hope
someone can help me with this. I am in a Windows 2003 server environment an
We have a mySQL clustering system in the works, which will be able to
give you clustering support ( up to 32 nodes per cluster ), with full
transactions support, in a write to ALL (at the same), read from LEAST
BUSY architecture.
In other words, all nodes will be able to serve as slaves. The least
I'm playing around with using a load balancer to balance our slaves.
What I want to do is put a load balancer in front of our slaves and then
reconnect each time via the JDBC driver.
This way a slave can fail and I can just take it out of service. It
also means that I can keep performance up
Sirisha,
you cannot remove just a single ibdata file:
http://dev.mysql.com/doc/mysql/en/Adding_and_removing.html
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM
tables
htt
[snip]
Now I need to put data in a db but the problem is with this calculated
data. A friend of mine that use Oracle told me that I could define a
field
like field1 = field2 + field3, but I can't discover this option in
Mysql.
It's possible to make it ? Any other idea about it ?
[/snip]
Have you
To the best of my knowledge MySQL does not have a way to do this on the
fly such that a field value is contigent upon the values of other fields
in the table.
Does it have to be stored in the database at all? Seems to me that
calculated values often are best handled at query time rather than
On Fri, Jan 21, 2005 at 07:38:59PM +0100, Javier wrote:
> Now I need to put data in a db but the problem is with this calculated
> data. A friend of mine that use Oracle told me that I could define a field
> like field1 = field2 + field3, but I can't discover this option in Mysql.
You can't define
Hi All
I've an Excel document that have some data but there are a column that has
a formula related to other cells of the same row.
Now I need to put data in a db but the problem is with this calculated
data. A friend of mine that use Oracle told me that I could define a field
like field1 = fiel
The easiest way, which does not need any code changes, is to set up DNS
round robin. Every time the application resolves the database domain name
it gets a "random" (I believe the nameserver just circulates the list) IP
back.
Atle
-
Flying Crocodile Inc, Unix Systems Administrator
On Fri, 21 Ja
hello everybody,
Mysql version:4.1.8
OS:windows XP
data_file_path:ibdata1:10M in my.ini file /* which is default value*/
As every one knew the data and index files of all innodb tables are stored in
ibdata1(in this case).
We created some user defined tables(innodb type).The number of user
Does mysql stores queries? If so where?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
We are working with mysql 4.1.8 version and windows XP os.
In that version the default amount of tablespace for data files and index files
is given as data_file_path=ibdata1:10M .we then executed 'show table status'
command and got innodb freespace:4092 KB (in comment column)
We then cr
[snip]
I'm interesting to know what is the best way to select last inserted
record.
This can do it "ORDER BY id desc limit 5" .. but ..
[/snip]
That is generally best, but if you have an auto-increment field
SELECT MAX(auto-increment field), * FROM `table`
--
MySQL General Mailing List
For l
I'm interesting to know what is the best way to select last inserted record.
This can do it "ORDER BY id desc limit 5" .. but ..
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, Jan 21, 2005 at 09:21:18AM -0500, Eben Goodman wrote:
> connection layer, and based on time of day or something passes a
You could use a TCP load balancer such as Balance or PEN, or you
could modify the code to randomly select a server name from a
list at connection time.
-Jason Martin
--
Dear MySQL,
I am try to compile on SUSE 9.1 using gcc 3.3.3.
This fails quickly:
make[2]: Entering directory `//mysql-4.1.9/mysys'
if gcc -DDEFAULT_BASEDIR=\"/usr/local/mysql\"
-DDATADIR="\"/usr/local/mysql/var\""
-DDEFAULT_CHARSET_HOME="\"/usr/local/mysql\""
-DSHAREDIR="\"/usr/local/mysql/s
Your key_buffer_size and sort_buffer_size configuration variables play
a role in the speed of your indexes, including creation and
modification. If these are set low, creating an index can be pretty
slow. 43 minutes seems like and extremely long time to create an index
on only 160K records. It
Hello,
I hope that you have not destroyed the ibdata file. The tables are
there. Did you edit the my.cnf in the upgrade? What does mysqld print to
the .err log?
when we changed from 4.0.20 to 4.1.9 we moved to a new server and copied
only the database directories, but no error-logs or ibdata fil
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am interested in feedback, advice from anyone who has changed the
AES_BLOCK_SIZE (default 16 bytes, for 128 bit) to 32 bytes, or 256 bit
encryption as mentioned on:
http://dev.mysql.com/doc/mysql/en/Encryption_functions.html
I am only attempting to p
I am considering setting up replication for a loaded database that has
to perform thousands of heavy selects every day. I want to have a
master with one way replication to multiple slaves. But I also want to
be able to load balance connections across the multiple slaves. What
options exist t
Hi Marcelo,
> Hi I was wondering if there is a way to give the a number of
> connections that I want simultaniusly to the database, supose
> I only want that 8 computers to access the database at the same time
try "max_connections" to limit the connections the server allows.
http://dev.mysql.c
Hi I was wondering if there is a way to give the a number of connections that I
want simultaniusly to the database, supose I only want that 8 computers to
access the database at the same time
Regards
Marcelo
Hello.
Yes. See a long discussion at:
http://bugs.mysql.com/bug.php?id=6511
"Thomas van Gulick" <[EMAIL PROTECTED]> wrote:
> Try this:
>
> Setup a database server, with MySQL 4.1, with query cache turned on
>
> Setup a client machine with MySQL 4.0
> Setup a client machine with M
Hello.
As said Guilhem Bichot.
It will go up to 232 or 264 depending on your architecture (32 or 64
bit) then it will go down to 0 and grow again.
There is nothing wrong with having a thread of id 0 (I had tested).
>> I've looked though code of mysqld.cc, but haven't found any checks
Hello.
According to:
http://dev.mysql.com/doc/mysql/en/Windows_troubleshooting.html
these messages occur when the MySQL server cannot find the mysql privileges
database or other critical files. Check that you have right paths in your
config files. Can you start the MySQL server from the
I don't know if it's the right list to post it but here it goes:
We've been trying to connect to a 3.23.49 server with several libmysql.dll's
We found out that the 3.23.x and the 4.0.x dll's connect very slow (20
seconds).
And the 4.1.x dll's connect in like 2 seconds.
Does anyone have a clue on
Hi,
I noticed that the number of id when I do show processlist is getting
bigger and bigger. Now it is about 444,466,168. What is the maximum
number, and what will happen if it runs out of number?
--bk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
i did
"SELECT .. FROM table WHERE cateid=1 AND ctime>xx ORDER BY ctime DESC LIMIT 10"
mysql can use INDEX(cateid,ctime), with NO filesort, this is very
fast, cos LIMIT is used by optimization
but now i have to query:
cateid IN(1,2,3,4,5)
now mysql use filesort, which is bad, cos it get all mat
Hi,
i need some assistance in choosing an ADO.NET- provider for MySQL.
We will port an app from Visual Objects to C# soon. Currently we
are using the C-API. Our tables are mainly innoDB and we use
transactions. We will use relations.
Most of our customers have
- 5-20 concurrent users
- the ser
Hi,
I want to add one more thing. Usually manually entered queries must end up
with semicolon so if you hit enter before the end nothing happens.
Regards,
Dusan
- Original Message -
From: "shaun thornburgh" <[EMAIL PROTECTED]>
To:
Sent: Thursday, January 20, 2005 2:17 PM
Subject: Undo f
35 matches
Mail list logo
