Hi,
This applies to 4.1.10 on Solaris 8, with 1 GB of RAM.
Our internal customer wants to be able to make 1000 concurrent
connections to our database, with a mix of MyISAM and InnoDB tables, but
according to http://dev.mysql.com/doc/mysql/en/table-cache.html and an
online Solaris reference
(http
Hi,
just Start here http://dev.mysql.com/doc/mysql/en/select.html
mathias
Selon Octavian Rasnita <[EMAIL PROTECTED]>:
> Hi,
>
> I have the following tables:
>
> create table articles(
> id int unsigned not null primary key,
> title varchar(255) not null,
> body text not null
> );
>
> create tab
hi,
you didn't speakabout your tuning work on the databases with only one machine.
Have you done such work with the indexation part for best performance ?
I can tell you that several databases with about 40 Go for all is not huge.
but if you want look at some linux clustering solutions like openm
Hi,
I have the following tables:
create table articles(
id int unsigned not null primary key,
title varchar(255) not null,
body text not null
);
create table newspapers(
id int unsigned not null primary key,
name varchar(255) not null
);
create table visitors(
id int unsigned not null primary k
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.10, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released. This has been released shortly after
3.1.9 to fix the following issue that we noticed after release:
- - Fixed connecting without a database
At 05:32 PM 6/22/2005, you wrote:
Hi,
I use MySQL for years with very much respect of it's stability and
performance.
But in these years one of my servers has grown to several hundreds of
databases with approximately 50 tables in each of the databases.
Some of these database have tables cont
Dan
Yes, I completely overlooked that. Thanks!
Dan Nelson wrote:
In the last episode (Jun 23), Schalk Neethling said:
I run the following query against MySQL:
SELECT
demographic_no, first_name, last_name, chart_no, sex,
year_of_birth, month_of_birth, date_of_birth, family_doctor,
ro
In the last episode (Jun 23), Schalk Neethling said:
> I run the following query against MySQL:
>
> SELECT
>demographic_no, first_name, last_name, chart_no, sex,
>year_of_birth, month_of_birth, date_of_birth, family_doctor,
>roster_status, patient_status, phone
> FROM demographic
> JOI
Hi,
I use MySQL for years with very much respect of it's stability and
performance.
But in these years one of my servers has grown to several hundreds of
databases with approximately 50 tables in each of the databases.
Some of these database have tables containing more than a million
records
Greetings!
I run the following query against MySQL:
SELECT
demographic_no,
first_name,
last_name,
chart_no,
sex,
year_of_birth,
month_of_birth,
date_of_birth,
family_doctor,
roster_status,
patient_status,
phone
FROM demographic
JOIN demographic ON allergies.de
Responses interspersed
James <[EMAIL PROTECTED]> wrote on 06/22/2005 04:48:59 PM:
> I did a little test by configure the `name` and `city` with FULLTEXT
> INDEX and a regular INDEX.
>
> mysql> describe testing_text_performance;
> +---+--+--+-+
John Trammell wrote:
#!perl
use strict;
use warnings;
sub foo {
warn "wantarray() in foo() is: ", wantarray(), "\n";
my @r = 3 .. 8;
return @r;
}
my @x = foo() or warn "in ... or warn() #1\n";
warn "[EMAIL PROTECTED]: @x\n";
my $x = foo() or warn "in ... or warn() #2\n";
warn "\$
I did a little test by configure the `name` and `city` with FULLTEXT
INDEX and a regular INDEX.
mysql> describe testing_text_performance;
+---+--+--+-+---++
| Field | Type | Null | Key | Default |
Extra
Berman, Mikhail wrote:
Hi everyone,
My "/usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx
--password=" command hangs.
I can ping host from local machine
I can "locally" execute mysqlshow command on the host.
I can "locally" execute mysqlshow command on remote server
My environment is
Harald Falkenberg wrote:
Hallo,
after creating a user via the grant command, I found that this new user
can see by the 'show database' command the mysql database although the
grant does not apply to it.
This new user can run the 'use mysql' command, but has no access to the
tables.
The db tabl
Hallo,
after creating a user via the grant command, I found that this new user
can see by the 'show database' command the mysql database although the
grant does not apply to it.
This new user can run the 'use mysql' command, but has no access to the
tables.
The db table only show access grants t
Hi everyone,
My "/usr/local/mysql/bin/mysqlshow --host=xxx--user=xxx
--password=" command hangs.
I can ping host from local machine
I can "locally" execute mysqlshow command on the host.
I can "locally" execute mysqlshow command on remote server
My environment is UNIX with MySQL 4.1.xx ins
Alternatively, you can parse the text files using application logic
(java, c++, etc) and then after extracting (and cleaning) your data
insert them into mysql.
matter of fact we do something very similar - read from a host of text
files - massage the data and then send them to be inserted into the
On Wed, 22 Jun 2005 [EMAIL PROTECTED] wrote:
> You were SO close!!!
>
> SELECT
> FROM
> WHERE CHAR_LENGTH(varcharfield) >= 60;
Thanks so much. I knew I was close but couldn't remember the exact
command.
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To u
Ed Curtis <[EMAIL PROTECTED]> wrote on 06/22/2005 02:27:02 PM:
> I've been cruising the docs for a while now and can't find what I'm
> looking for. I know it has soemthing to do with value or LEN or
something
> easy like that but I just can't find the right command structure.
> I need to list th
Hello.
It is recommended to use precompiled binaries in most cases. MySQL
has a very flexible system of parameters which you could change through
different ways. If you want to use this server as dedicated database
server, probably the solution exists (I mean integrating MySQL binaries
witho
Something doesn't sound like it's setup properly. There was a time that
I had more then 100 slaves connected to a master. Many reads and writes
occurred on the masters and all slaves kept up.
I suspect that your running out of IO bandwidth on a slave from a table
scan or huge and frequent sorts.
I've been cruising the docs for a while now and can't find what I'm
looking for. I know it has soemthing to do with value or LEN or something
easy like that but I just can't find the right command structure.
I need to list the rows in a table where the length of a field, lets say
field1 is a mini
From: <[EMAIL PROTECTED]>
> That's what I Ntried to say, yes :) The main problem is the decimal comma
> in the amounts.
What about reading the data into the table and storing the 'amount' in
varchar for now. Then you can run an update query in which you replace the
decimal comma with a decimal poi
Hello Anoop,
On 22 Jun 05, Anoop kumar V wrote to All:
AkV> Are u saying that u have data in a text file and you need to parse
AkV> this and insert them into mysql?
That's what I Ntried to say, yes :) The main problem is the decimal comma
in the amounts.
Regards,
Hans.
jdh dot be
I have a table which includes the following columns in addition to
lots of other ones
name - populated with just one name
city - populated with just one city
keywords - lots of keywords
I'm definitely going to use a FULLTEXT on the `keywords` column
For `name` and `city` ...I will allow users
Frank, thanks for the reply.
I'd thought of that, but I was worried about using HotBackup (we use
this for all of our backups on our production machines) - the hot backup
manual at http://www.innodb.com/manual.php doesn't mention if it can
follow a symlink to the data file.
Thanks for the l
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.17, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.17is a bugfix release for the stable tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0
(altho
When I have seen this error it was caused by a field defined in the
MySQL database as NOT NULL in the Create table and the value in Access
is NULL or usually for us an empty field in EXCEL which is appears to be
intreped as NULL when you do a PASTE APPEND.
Ours is often times a datetime field but
Hi,
I've been successfully using mysql 5.0.x on my win32 development machine.
I would like to install it on a server running stable Debian. Unfortunately,
there are no .deb packages for the MySQL 5.0 series.
I have tried to use the linux precompiled binaries but my debian complains about
not bei
>Description:
>How-To-Repeat:
<[/usr/local/mysql] $> scripts/mysql_install_db --user=mysql
exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the
following errors:
0509-130 Symbol resolution failed for my_print_defaults because:
0509-136 Symbol
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.1.9, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.1.9 is the latest production release of the 3.1 series that is
suitable for use with all versions of MySQL, including MySQL-4.1 or
M
Hello.
Looks like a bug for me. I've reported it at:
http://bugs.mysql.com/bug.php?id=11494
David Sparks <[EMAIL PROTECTED]> wrote:
> db1 corruption # cat > my.sql
> DROP TABLE IF EXISTS service_contacts;
> CREATE TABLE service_contacts (
> croeated datetime NOT NULL default '00
Hello.
There could be a lot of reasons. First, are you able to connect
to MySQL using mysql command line client? If you are able then
what error do you see?
Krishna Chaitanya <[EMAIL PROTECTED]> wrote:
>
> sir,
> i am a software employee working in a firm.. i am not able to create a
On Wed, 22 Jun 2005 09:55:39 -0400, [EMAIL PROTECTED] said:
> Jochem van Dieten <[EMAIL PROTECTED]> wrote on 06/22/2005 07:34:30 AM:
>
> > On 6/22/05, David Kagiri wrote:
> > > When i run the queries below they all work just fine
> > >
> > > SELECT sum(consultation)+ sum(laboratory) FROM nairobi,
Jochem van Dieten <[EMAIL PROTECTED]> wrote on 06/22/2005 07:34:30 AM:
> On 6/22/05, David Kagiri wrote:
> > When i run the queries below they all work just fine
> >
> > SELECT sum(consultation)+ sum(laboratory) FROM nairobi,
> familymembers WHERE familymembers.dependantid = nairobi.memberid and
>
On 6/21/05, Sebastian wrote:
> i never understand why people use datetime anyway.. unix timestamp is so
> much easier to work with.
Unix epoch is by definition UTC. Sometimes I want to work with dates
in some local timezone. In other databases that have a more complete
implementation of the SQL st
On 6/22/05, David Kagiri wrote:
> When i run the queries below they all work just fine
>
> SELECT sum(consultation)+ sum(laboratory) FROM nairobi,familymembers WHERE
> familymembers.dependantid = nairobi.memberid and familymembers.memberid =
> "AKI1"
>
> SELECT sum(consultation)+ sum(labora
Zachary Kessin <[EMAIL PROTECTED]> wrote on 22/06/2005 09:12:22:
> Martijn van den Burg wrote:
> > Stephane,
> >
> >
> >>I've was wondering if anyone is using MySql as their main ERP
> >>production database, if so how stable and reliable is it?
> >
> >
> > SAP and MySQL have teamed up to cert
Hallo,
I get data with a format that I can't choose. The fields are enclosed
in double quotes ("), separated by commas (,). The main problem is that
some fields contain amounts with a decimal comma. I have not found a
way yet to load these data properly. Could somebody help me please?>
Groetjes,
sir,
i am a software employee working in a firm.. i am not able to create any
tables in to my mysql server .. plz suggest me the possible reasons for
it...
thanking u ,
c.krishna chaitanya
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
Martijn van den Burg wrote:
Stephane,
I've was wondering if anyone is using MySql as their main ERP
production database, if so how stable and reliable is it?
SAP and MySQL have teamed up to certify (part of?) SAP's R/3 ERP system
on MaxDB. Check:
http://searchsap.techtarget.com/originalCont
Stephane,
> I've was wondering if anyone is using MySql as their main ERP
> production database, if so how stable and reliable is it?
SAP and MySQL have teamed up to certify (part of?) SAP's R/3 ERP system
on MaxDB. Check:
http://searchsap.techtarget.com/originalContent/0,289142,sid21_gci967139
David,
David Griffiths wrote:
The manual is a little unclear on per-table-tablespaces in 4.1/5.0
(http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html)
Using per-table-tablespaces ignores the innodb_data_file_path (yes, it
uses it for the ibdata files, but not for the tablespace/data-
44 matches
Mail list logo