Hi, all
Who can recommend me a good tools for testing performance under heavy use of
mysql. With large corcurrent queries.
-Ares
--
Nuclear Science & Technology Virtual Research Center
http://nst.pku.edu.cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubs
Hi all,
Now I'm facing a big problem and see if anyone know how to solve it. I'm
using RS6000 AIX 4.3.2 CPU*2 1G RAM with HA. And DB is MySQL 4.0.12-max.
Here is the content of my.cnf.
[client]
#password = your_password
port= 3306
socket = /tmp/mysql.sock
# Here follo
MySQL 4.0.12 max on AIX 4.3.2 HA. When I use show full processlist on localhost, all
Hosts show as localhost. but when I use show full processlist from remote, all Hosts
show as remote IP.
as follow:
mysql> show full processlist;
+-+-+-++-+
MySQL 4.0.12 max on AIX 4.3.2
Following are part of .err log file:
030615 1:29:44 Aborted connection 163 to db: 'New' user: 'happy' host:
`192.168.5.108' (Got an error reading communication packets)
030615 1:29:54 Aborted connection 167 to db: 'New' user: 'happy' host:
`192.168.5.108' (Got an
But is it available on AIX 4.3.x ?
-Ares
On 02 Jun 2003 19:50 CST you wrote:
> DATA DIRECTORY and INDEX DIRECTORY is ignored on Windows.
>
>
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MyS
0, when you are not using
> the --skip-symlink option.
>
> Make sure that option is set correctly.
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
>
>
> - Original Message -
> From: "Ares Liu" <[EMAIL PROTECTED]>
> To: <[EMA
HI, ALL
Under windows XP, mysql-4.0.12, when I create a table with special data and index
directories as follow:
USE DATABASE test;
CREAT TABLE IF NOT EXISTS test_table ( Vola INT NOT NULL, PRIMARY KEY (Vola))
DATA DIRECTORY="D:/mySQLDBs/test/data"
INDEX DIRECTORY="D:/mySQLDBs/t
change your my.ini or my.cnf
- Original Message -
From: "Bonnie Poole" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 22, 2003 8:53 AM
Subject: MySql Install on a AIX RS6000
>
>
>
>
> I am trying to install on a AIX box. I do not want to install into
> /usr/local. I hav
As both of them type IV JDBC, which one is the better?
-Ares
> sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request thi
seconds of querying normal
COLUMNs. I want to know query speed in larger table.
Regards
Ares
- Original Message -
From: <[EMAIL PROTECTED]>
To: "Ares Liu" <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 1:28 PM
Subject: Re: How Huge of your mySQL database o
All,
Now I want to design a database which contains more than 10G data to use. I
think the largest table in my db will contains more than 30 million records
and the amount of this kind of table will be up to 7 or 10. In my instance
there won't be so many clients connecting. normally, there are le
All,
Can I implement parallel queries to mySQL by using sevial query sentences in
a single PHP file? Who knows how to do it? including query the same table or
different tables in parallel.
Regards
Ares
-
Before posting, please
download a windows 3.23 version and install it. as you finished, under
mysql\docs\ you will find manual in HTML fmt.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi all,
I am a new member of this list. now I have a question. on my site, I add a
new lonely database to store some data, and in this db, there is a table
contained four columns, in which I put more than 17 million records in each
column. after do that, I found out that my site became very slow.
14 matches
Mail list logo
