Dear Scott Haneda:
Thx.
I also try add the key for
'server_name',it cost 3 hours,but it still not yet
completed.
For some reason, we have broken adding
key process. >>_<<
We now engage on spliting table, hope
[EMAIL PROTECTED] :
When use query with 'like' condition,it would cost too much time.
Mysql is using innodb structure ,but not myisam.
We haven't test how diff between innodb & myisam.
But now the performance is too low.
We plan to separate the table group by date or specified flag.
It seems ne
Thanks for your reply Brent. It was really useful.
Looks like Opteron would be a good choice since there
wont be several multiple queries at the same time but
instead we will be happy if the single query runs
fast. You had mentioned adding more RAM would help,
how much RAM would be ideal ? Does the
Frederic Wenzel wrote:
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last operati
Hello.
See:
http://dev.mysql.com/doc/mysql/en/binary-log.html
Philippe de Rochambeau <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: US-ASCII, 25 lines --]
>
> Hello,
>
> my /var/lib/mysql directory contains many -bin.xxx files, some of
> which date back t
Hello.
You should find the clues in the error log, which is usually located in the
data directory.
See:
http://dev.mysql.com/doc/mysql/en/starting-server.html
Mohsen Pahlevanzadeh <[EMAIL PROTECTED]> wrote:
> Dears,I have slackware10.I install it completely.
> But when i use /etc/rc.d/
Hello.
The complete answer on your question you can receive at [EMAIL PROTECTED]
S?rgio Almeida <[EMAIL PROTECTED]> wrote:
> Greetings!
>
> I have a question about MySQL licences. I'm developing a web application
> for my customer to install and use on his local network (I use PHP to
Does "repair table" work in this case?
--- "Logan, David (SST - Adelaide)"
<[EMAIL PROTECTED]> wrote:
> Hi Vicki,
>
> If you have a backup of the .MYD file, you should be
> able to copy this
> over the existing one and run myisamchk -r to
> rebuild the index.
>
> Regards
>
> David Logan
> Data
Hello,
I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
256 MB memory. On this machine we use an adserver with a mysql
backend. All click and view logs are kept in mysql tables. The number
of the advertisements are increasing and so do the server's overhead.
Some times I can n
Hardware improvements would certainly help.
There are two things that immediately spring to mind
1) double or quadruple the ram
2) increase/change your discs - add high speed SCSI/SATA putting the
database and swap space on these discs.
The final option is to look at a two process
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello,
I use a mysql server on red hat 9 linux box with PIII 733 Mhz cpu and
256 MB memory. On this machine we use an adserver with a mysql
backend. All click and view logs are kept in mysql tables. The number
of the advertisements are increasing and s
Even I had the same problem and couldnt use SSL on
windows.
The developers have legal issues when using SSL on
windows. I think there is some development going on
using CryptoAPI but I am not too sure.
My advice, dont even try on Windows. Atleast it was a
big pain in ass for me.
Karam
--- Jose
Hello,
I just checked with the same version at home and it
works.
Dont know whats the problem at office.
Will check again?
Karam
--- Artem Koltsov <[EMAIL PROTECTED]> wrote:
> Works fine on WinXP 4.1.8. Only generates warning:
>
> mysql> show warnings;
>
+-+--+---
Dear all,
I need SSL support for MySQL. I've checked the documentation and it
seems that for windows there is no SSL support in the binaries. In
addition the documentation in the examples is for Linux.
Has anyone has used MySQL with SSL in windows? If so ... how? How easy
is to set it up? What
Thanks for your ultra detailed reply.
The tables are just samples (no where related to
actual table). Well I am not that bad in db designing
also ;)
I checked the manual - you indeed can execute two
statements like this in one. And if you see the query
I am even changing the table type in the lat
Can somebody try this on 4.1.7?
I will download 4.1.8 tomorrow and check it out.
Damn...my connection is slow (on a dialup) and 35MB of
download...h
Regards,
Karam
--- Chris <[EMAIL PROTECTED]> wrote:
> There was a serious (threat of data loss) bug in
> 4.1.7 InnoDB . I'm not
> very familia
You can use FIELD in the ORDER BY. See pp. 330 of the
MySQL Cookbook, or FIELD in the MySQL docs:
http://dev.mysql.com/doc/mysql/en/string-functions.html
mysql> SELECT * FROM test;
+--+---+
| name | month |
+--+---+
| foo | Mar |
| bar | Jan |
| baz | May |
| quux | Nov |
There was a serious (threat of data loss) bug in 4.1.7 InnoDB . I'm not
very familiar with the specifics, but this problem could be that.
In any case I'd be scared to run InnoDB on a 4.1.7 without fully
understanding the problem. You should definitely consider upgrading to
4.1.8 , or, at the ve
There is certainly *something* wrong if the ALTER TABLE statement causes the
server to hang; the statement should either succeed or fail with an error
but in neither case should the server hang.
I'm still back on 4.0.15 so I'm not in a great position to try the code
myself but I see a few odd thin
Works fine on WinXP 4.1.8. Only generates warning:
mysql> show warnings;
+-+--+--+
| Level | Code | Message
|
+-+--+--
Hello, I'm a newcomer to MySQL and to databases in general. I'm using MySQL
4.1.9 on a x86-system running Windows XP Pro SP2. I am trying to use the
MySQL C api and I've made the following test program in C (hope the
indentation isn't lost):
#include
#include
#include
static MYSQL m;
static
Hello,
I am running mysql 4.1.7 on Win2K.
I have two tables:
CREATE TABLE `child` (
`id` int(11) NOT NULL default '0',
`name` char(1) NOT NULL default '',
PRIMARY KEY (`id`,`name`)
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
> - to remove the bin logs:
>
> PURGE MASTER LOGS TO 'filename'; (where filename is the
> name of the last bin log to keep)
I prefer RESET MASTER - it clears and delete
Philippe de Rochambeau wrote:
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to October 2004. What exactly are these files? Can I
safely remove the older ones?
- these are the bin logs, used in replication. MySQL writes all INSERT,
UPDATE, etc., and DDL co
On Tue, 25 Jan 2005 08:44:45 -0500, Michael Stassen
<[EMAIL PROTECTED]> wrote:
> I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
> reasons I avoid DISTINCT when possible.
Isn't this supposed to be correct? Ordering has to take place as the
very last operation, after any sele
On 25 Jan 2005 at 16:07, Shuva, Judith wrote:
> Hi J.R.
>
> Thanks for your answer.
>
> I saw that the API suppose to be in the MySQL server, so I downloaded
> mysql-essential-4.1.9-win32.msi, but after the installation, I can't
> find the API in the MySQL folder...
>
> Please, HELP!
Hi,
Th
Hello,
my /var/lib/mysql directory contains many -bin.xxx files, some of
which date back to October 2004. What exactly are these files? Can I
safely remove the older ones?
Many thanks.
Philippe
-rw-rw1 mysqlmysql1073741948 Oct 16 15:00
/var/lib/mysql/mydb-bin.029
-rw-rw
I am not sure what you mean by "getting MySQL C API".
The API are built in libmysql.lib and libmysql.dll or
mysqlclient.lib. The header files are in include
directory.
Just include them in your project and start coding.
Hope I was of help.
Karam
--- "Shuva, Judith" <[EMAIL PROTECTED]>
wrote:
Here's a little more info for you.
http://dev.mysql.com/doc/mysql/en/c.html
J.R.
-Original Message-
From: Shuva, Judith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 25, 2005 9:08 AM
To: mysql@lists.mysql.com; J.R. Bullington
Subject: RE: Where can I download The MySQL C API??
Hi J.
Hi J.R.
Thanks for your answer.
I saw that the API suppose to be in the MySQL server, so I downloaded
mysql-essential-4.1.9-win32.msi, but after the installation, I can't
find the API in the MySQL folder...
Please, HELP!
Thanks,
Judith
-Original Message-
From: J.R. Bullingto
http://dev.mysql.com/downloads/
Please note the section of Official APIs
# Application Programming Interfaces (APIs)
* Official APIs:
o The C API is included with the server, above.
J.R.
-Original Message-
From: Shuva, Judith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, Jan
Hi,
I just downloaded mysql-essential-4.1.9-win32.msi, and as I understood,
the C API supposes to be in here.
Where exactly? I can't find it
Thanks,
__
Judith Shuva
I suspect mysql is doing the DISTINCT before the ORDER BY. One of the
reasons I avoid DISTINCT when possible. Try:
SELECT Documents.ID, Name
FROM Documents, DocumentFiles, DownloadLog
WHERE Documents.ID = DocumentFiles.Document
AND DocumentFiles.ID = DownloadLog.DocumentFile
GROUP B
Hey - It's been awhile since I set up mysql on a box (it's one of those
things where I teach myself, do it once, then forget it, heh) - but I seem
to remember you need to do some things to initialize the databases and set
initial privileges before it will work - su to the "mysql" user and run
"
Greetings!
I have a question about MySQL licences. I'm developing a web application
for my customer to install and use on his local network (I use PHP to
develop the application). The application will be installed on a machine
(server) on the same personal network. In this scenario, what is the
Mohsen Pahlevanzadeh wrote:
Dears,I have slackware10.I install it completely.
But when i use /etc/rc.d/rc.mysqld start ,I recieve following mesage :
mysql ended
Please guide me that i can configure mysql in slack.
Yours,Mohsen
- look in the .err file (probably located in your data directory) to
Dears,I have slackware10.I install it completely.
But when i use /etc/rc.d/rc.mysqld start ,I recieve following mesage :
mysql ended
Please guide me that i can configure mysql in slack.
Yours,Mohsen
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
-
Please visit www.tiscali.co.za
-
Hi there,
I'm trying to install MySQL-3.28.55 on a RedHat Linux 2.4.20-8 server.
When I run the make command after the configure command, i get the following
response just before
Hello
I am trying to run the following query on my server:
select Documents.ID,
Name
from Documents,
DocumentFiles,
DownloadLog
where Documents.ID = DocumentFiles.Document and
DocumentFiles.ID = DownloadLog.DocumentFile
order by DownloadLog.AddedOn desc
limit 5
I
Hello.
Yes. For example:
mysql> select count(*) from yo group by a order by a desc;
+--+
| count(*) |
+--+
|6 |
| 12 |
|3 |
+--+
3 rows in set (0.00 sec)
mysql> select count(*) from yo group by a order by a asc;
+--+
| count(*
Hello.
> How to create the default?
Put the following line into [mysqld] section of your config file:
default_character_set=utf8
See:
http://dev.mysql.com/doc/mysql/en/charset-defaults.html
> I just upgraded from 4.0.8 to 4.1.9.
After upgrading, some times it is necessary to do
Hello.
You can enable logging on the server. See:
http://dev.mysql.com/doc/mysql/en/log-files.html
You need the error log, query log, slow log. But be careful!
Heavy loaded server can produce a lot of messages and your
files will grow quickly. If you use InnoDB, you can enable
the InnoD
Hello.
See:
http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
"Cecep Rosuludin" <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> I found an error in mysql message, when I tried to excute this sql in mysql=
> front:
>
> select dsr2.mother_vessel,mother_vessel_voy,voyage.v
Hello.
May be you should think about the ENUM type. See:
http://dev.mysql.com/doc/mysql/en/enum.html
For example:
create table mon(mon enum('Jan','Feb','Mar','Apr' , 'May' , 'Jun' , 'Jul' ,
'Aug' , 'Sep' , 'Oct' , 'Nov' , 'Dec') , a int);
insert into mon values('Jan',5);
insert into
Hello,
I think your tables have a collation different from the connection collation.
Open mysql client:
mysql> show variables like 'colla%';
+--+---+
| Variable_name| Value |
+--+---+
| collation_connection
45 matches
Mail list logo
