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-
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
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
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://
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,
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
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
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
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 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,
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
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
-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
>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
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
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
-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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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 "\$
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;
> +---+--+--+-+
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
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
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
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
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
-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
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
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,
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,
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
44 matches
Mail list logo
