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: mysql@lists.mysql.com
Sent: Thursday, January 20, 2005 2:17
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
i did
SELECT .. FROM table WHERE cateid=1 AND ctimexx 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
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
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
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
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.
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 MySQL 4.1
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
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.
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
-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
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
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
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/share/mysql\
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
--
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]
[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
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
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]
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
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 Jan
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 =
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 a
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
[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
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
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
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
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
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
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
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
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,
We want only mysql 4.1.8 client version .How to get only client installed
without server being installed?
Thanking you,
yours sincerely,
35 matches
Mail list logo
