I have command in the script:
mysqldump databasename -u username -p password > /to/a/directory/dump.sql
When i run the script it asks for a password and takes the password given in
the script for a table name.
How can I give the password in the script???
Try it like this:
--
mys
Hi,
I'm new to multi-threaded programming and reading the book "Programming
with POSIX Threads" and
trying to understand concepts and coding.
What I'm trying to do is to rewrite mysql client application (which
calculates ISP dial-up customers' billing)
into multi-threaded version.
I'm looking
Subhakar,
Nils already answered the first question.
About the second question, there unfortunately is no way to extract only the
table name and the type from SHOW TABLE STATUS. MySQL does not store table
information into any table, but in .frm files in the database directories
under the datadir.
How can I benchmark the perfomance of Mysql with the following setup:
Perl 5.8.0 (perl-DBI, perl-DBI-Mysql)
mysql-3.23.54a-11
apache-2.0.40-21
mod_perl-1.99_07-5
I want to compare the perfomance of Mysql against that of Pg using my
own data.
And, how can I resolve :
"DBD::mysql::st execute fa
"Ooks Server" <[EMAIL PROTECTED]> wrote:
> I've run into a problem with the behavior of concat(). If I have two fields,
> char(10), and I do this:
>
> concat(field1,fields)
>
> With MSSQL I get both fields including trailing spaces. With MYSql, I get
> the two fields with the trailing spaces trim
Mixo,
you have to add another InnoDB data file. Also adjust other InnoDB
parameters in my.cnf to get a good performance.
http://www.innodb.com/ibman.html#InnoDB_start
"
An advanced my.cnf example. Suppose you have a Linux computer with 2 GB RAM
and three 60 GB hard disks (at directory paths `/',
Hi Jeff,
We had similar problems caused by replication crossing a
firewall with a 5 minute timeout on its access control list.
If the replication stream went idle for 5 minutes, the firewall
would drop the connection and MySQL wouldn't notice.
Our workaround was to run a daemon on the master to
Mark Depenbrock <[EMAIL PROTECTED]> wrote:
> I have installed a Mac OS X 'PKG' binary package on my OS version
> 10.2.6 Mac.
>
> I have been instructed that after the installation I can start up MySQL
> by running the following command lines:
>
> [Computer:/usr/local/mysql] mark% sudo ./bin/mys
"Pedro X Gomes-Fabre" <[EMAIL PROTECTED]> wrote:
>
> Can I link two fields in two tables, in the way that if I add a new value
> into a table in the other table the value is added automatically,
No.
> or Do I need to add the values one time for every table?
Yes.
--
For technical support con
Note that trailing spaces are not removed when you insert data into a TEXT
(or BLOB for that matter) column. This may be of use to you, but TEXT does
have limitations.
Andy
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: 08 July 2003 09:31
> To: [EMAIL PROTECTE
Hi,
We use MySQL 4.0.13, Redhat 7.3(kernel 2.4.18.3). Apache 1.3.27
Mysql is alive and there are process but I don't see in ps (process
table) and very slow web receive.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.co
I'm not sure if there are formal resources on this topic, but here are some basic
guidelines I have followed in the past:
1) You can imagine that each running thread will have its own MySQL connection.
2) The connection can get created and held for the lifetime of a thread, or, if you
plan to have
Hi Loren,
Thanks for quick response. The previous application
is written by me in ANSI C using mysql API. I'd love to write it in Java if
it was first time:)
Do you have any suggestion related to MySQL C API?
Ganbold
At 02:28 AM 7/8/2003 -0700, you wrote:
I'm not sure if there are formal resour
I've seen one other reference to this exact situation but it didn't have
a resolution. What I've done is created a script that runs every 10
minutes via cron and checks a value from both databases and if it's not
equal then it issues a "slave stop" and "slave start" command on the
slave machine.
"Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> I've seen one other reference to this exact situation but it didn't have
> a resolution. What I've done is created a script that runs every 10
> minutes via cron and checks a value from both databases and if it's not
> equal then it issues a "slave stop"
Hey Folks
I'm having a tough time finding any information in the available
documentation about this feature. Does anyone out there have a bit of
insight as to what exactly it does.
Docs says MySQL will store a checksum for each row if this is 'on' - that's
about all I can find.
Some
How can I avoid this:
DBD::mysql::st execute failed: The table 'Transactions' is full at
/usr/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm
The table type is InnoDB.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 08, 2003 7:58 PM
Subject: Re: Replication stops for no reason...
> "Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> > I've seen one other reference to this exact situation but it didn't have
"awarsd" <[EMAIL PROTECTED]> wrote:
>
> I tried to look everywhere @ mysql.com but i couldn't my question is
> how many records can a table handle so it stays fairly fast?
> What is the maximum records it can handle??
Up to 4 billion rows.
--
For technical support contracts, goto https://order
"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> Hi, Nils
> I was able to stop the mysqld daemon using the kill command. However,
> when I tried to start it using mysqld_safe --skip-grant-tables, a line
> would appear saying:
> [EMAIL PROTECTED] root]# mysqld_safe --skip-grant-tables
> Starting
Hello. Thought I¹d pass this along to whoever cares.
Issue:
error running the mysql-test-run as logged
> Installing Test Databases
> Removing Stale Files
> Installing Master Databases
> mysqld is missing - looked in ../bin
> Error: Could not install master test DBs
Any suggestions?
Details:
I
Hello All,
I am trying to decide which storage I should use for the "Data Directory".
My application has lots of 'SELECT's (80%) and fewer
UPDATEs/INSERTs(20 %).
I have the following choices of Data storage
1) Xiotech SAN (66 Mhz FCAL)
2) NAS
3) Internal SCSI 3 RAID 5
Will I achieve any better
I've done a lot of stuff to try to get mySQL to work. I'm running Mac
OS 10.2.6 and Apache webserver.
First, I installed mySQL. No problems there. However, not knowing how
everything worked, I used PHPmyAdmin to delete the root user. Yes, I
know, stupid. Then, realizing my error with the h
Hello
The following query used to work when I was using an Access database, but
now that I've moved to MySQL I get a syntax error when I try and run it:
SELECT *, (SELECT COUNT (*)
FROM Links
WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS
LINK_COUNT FROM Categories
ORDER B
Well, I would avoid NAS as it introduces unwanted overhead when
accessing the data. As for SAN versus the internal RAID5, I am not sure,
I would say benchmark the two and see which comes out better, or wait to
see if there is anyone out there that has dealt with both.
Regards,
Mike Hillyer
www.vbm
All;
Does anyone know of a more secure way than storing the username and password
to the database connection within the odbc.ini ? We are using PHP on one
server connecting to a MySQL 4.0 database ?
Thanks
I took once moe a sharp look now that you did a reply with another sample.
Actually I was wrong the SQL statement was NOT correct - you forgot the
semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --execute.
~Michael Iatauro
--
MySQL General Ma
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.ac.id/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsu
I work for a small (but very fast-growing) company, and we're about to
start deploying our new website. Because it has a "live inventory"
setup, and because our internal tools are so integrated with the
ecommerce side of things, I figure that replication is the best tool for
us - we'd have a fast
Hi,
I am a newbie
I want to create a temporary table and I get the following error
message :
mysql> CREATE TEMPORARY TABLE tempemp AS SELECT * FROM emp;
ERROR 1044: Access denied for user: '@localhost' to database 'test1'
Any help would be appreciated
Didier
Does the mysql user have write permissions on the files?
HA. Mooduto wrote:
dear all,
what is the problem sql error : 1036 ...table is read only.
please help me..
thank's...
--
This mail sent through PSP: http://www.polinpdg.ac.id/
--
MySQ
Hi, sorry to keep this thread going ...
I'm sending you the output of my results ... I don't see the autoextend string in my
output. I'm using 3.23.56
I have the following entry in my .cnf file:
innodb_data_file_path=innodb_data01:5M;innodb_data02:5M:autoextend:max:10M
And the output of my vari
Dear all,
Is there a way to start mysqld in a way, that say only a superuser can
connect. I would need this e.g. for restoring a backup, because I do not
want users to connect to the server while I restore the binary log.
I already check the options for mysqld but could not find anything
(e
Trevor Sather wrote:
> Hello
>
> The following query used to work when I was using an Access database,
> but now that I've moved to MySQL I get a syntax error when I try and
> run it:
>
> SELECT *, (SELECT COUNT (*)
> FROM Links
> WHERE Links.CAT_ID = Categories.CAT_ID AND LINK_APPROVED = 'Yes'
I wonder if you could make a backup of your original users table, then make one
of JUST your super user... Then when you go to do your back up you would copy
your table with JUST your super user in there and go to work... After you are
done with the backup copy your old table back and restart mysql
Subhakar,
it is a bug which was fixed in 3.23.57:
http://www.mysql.com/doc/en/News-3.23.57.html
"
D.4.2 Changes in release 3.23.57 (06 Jun 2003)
...
SHOW VARIABLES LIKE 'innodb_data_file_path' displayed only the name of the
first datafile (bug #468).
...
"
Regards,
Heikki
...
Hi
I need to know if is there anyway to clone a existing database (structure and data)?
If yes, how can I do this? I looking for a SQL command.
Thanks in advance and best regards
Boris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Hi everyone,
I am trying to create tables with type innodb. I created a database and all
the tables of type ISAM. Now I am at the point of making relations and
establish refrential integrity. For that ofcourse I have to change the tables
in the Innodb type. I did that with the commad "alter tab
Hi,
can someone explain me the avantage of using date and time, and also can i set time +
XX minutes??
Thanx
Anthony
> Hi,
>
> can someone explain me the avantage of using date and time, and also can
> i set time + XX minutes??
>
> Thanx
> Anthony
Short answer is: You can use the date and time functions and formats.
There is one or just use '+' or '-' See chapter 6 in the ref. manual.
If you need both date and
I am a newbie myself, so please someone correct me if I am wrong, but here
is how I understand it:
A MySQL installation can support several databases. The system tables are
always in a system database that uses tables of type ISAM. You create
another database of type InnoDB, in which you keep your
couldn't you dump the database and then use the backup to reload the
database?
-dan
On Tue, 2003-07-08 at 13:58, Boris Villazon wrote:
> Hi
>
> I need to know if is there anyway to clone a existing database (structure and data)?
>
> If yes, how can I do this? I looking for a SQL command.
>
>
Yeah I though about that too. But i am not able to find the command for
creating a database in an innodb mode.?? DOu have an idea about it Grant??.
thank u
kamran
>= Original Message From "Quinlan, Grant" <[EMAIL PROTECTED]> =
>I am a newbie myself, so please someone correct me if I a
If there's a FAQ I'm missing, please point me to it.
v 4.0.13-NT
I'm a C++ programmer trying to learn Java and JDBC (Java Database
Connectivity). Obviously I need a database to bounce off in order to do
that. Enter MySQL.
I am going in through the command line shell. I am unable to do much
Greetings...
We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
bug.
http://www.mysql.com/doc/en/InnoDB_news-4.0.14.html says it should be
released in June... it's now July 8th.
When can we expect 4.0.14 to be released?
Thanks in advance...
Christian
-
Hmmm. Well you might be able to work some magic if you know the length of
the field it's supposed to be, then you could subtract the length of the
Field and then pad with spaces.
If this is to be displayed in a web page, and I assume you're trying to line
things up pretty, just put them in table
Can not make mysql connection -
error log:
030708 08:53:48 mysqld started
030708 8:53:49 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See http://www.innodb.com/ibman.html for installation help.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: t
You're using Windows, so I can't make any promises because this is what
I'd do under *nix, but when I first set up mySQL if I type:
# mysql -h localhost -p
The password will be denied, because no password is needed. So I'd
type:
# mysql -h localhost
And get in. This is under the /root/, and I
Avoid NAS... that's like dealing with mysql via NFS ...
Internal raid depending on controller type and disk configuration could be
faster than an external SAN... But chances are external SAN has alot more
scalability as far as adding more controller, cabinets and disks...
If it was my choice and
I have a shopping cart which creates temporary tables in the format of
zorder_;
These tables are used to hold a customers order while they shop and
after checking out, it is dropped. The values of the shopping cart are
put together in an HTML table and stored as their history.
What I want to
There'z no InnoDB mode for a database, it's only for tables and you can create InnoDB
tables in any database as long as it supports InnoDB features. Do you have mysqld-max
running?
HTH,
SB
-Original Message-
From: azamka [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 11:38 AM
To
Christian,
- Original Message -
From: "Christian Nelson" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, July 08, 2003 10:51 PM
Subject: 4.0.14 Date?
>
> Greetings...
>
> We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
> bug.
>
> http://www.
On Tue, Jul 08, 2003 at 12:49:54PM -0700, Christian Nelson wrote:
>
> Greetings...
>
> We're eagerly awaiting 4.0.14 since it fixes the SET FOREIGN_KEY_CHECKS
> bug.
>
> http://www.mysql.com/doc/en/InnoDB_news-4.0.14.html says it should be
> released in June... it's now July 8th.
>
> When can w
> I need to know if is there anyway to clone a existing database (structure and
> data)?
I use mysqlhotcopy myself.
http://www.mysql.com/doc/en/mysqlhotcopy.html
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscrib
I am working on mysqld-max. I have created the my.cnf file yet. The manual
does not have clear instructions on that. Can you help me in making mysqld-max
to work?? I mean can u explain me the procedure if possible.
Appreciate it
thank U
Kamran
>= Original Message From "Subhakar Burri" <
Hi,
Your solution converts the binary field to a string and then compares two
strings. You should get rid of any conversion problems by comparing the
values as binary data:
SELECT * FROM table1 WHERE field1 = BINARY 0x6100620063006400;
--
Mikko Noromaa ([EMAIL PROTECTED])
- SQL in Excel, ch
> have you done any "optimize" to your tables ?
> it should help improving the query performance.
>
> it's normal to have memory lower on each day, because your index files are growing,
> and takes memory.
> if you're not using innodb or bdb, you can try to run "flush threads" and "flush
> table
> I don't know anything about MySQLDriverCS but if you continue to have
> problems, you might try my provider at www.bytefx.com
Reggie,
You've ended a week's worth of frustration for me! Thanks a million! You've
got a great product, even if it's not a release version yet!
FYI, I only had to chan
Hello,
I have been reading this list for about a month or so, and have picked up
some good information.
I have this little nagging problem with the install on my machine.
I am running an XP box with Apache 1.3.27, PHP 4.3.2 and MySql
4.0.13. This is a dev machine I use all the time.
Now, whe
Hi Rudy,
How about changing the port number in my.cnf and restarting the server ?
All clients will look on the wrong port number and not be able to connect.
That should do it while you take your backup.
When finished change the port number back to 3306.
Best regards
Nils Valentin
Tokyo/Japan
This question came up at work today, would like to get some fellow developer's
opinions:
Scenario 1: 2 tables to track checks
in terms of HD space a separate table would have been smaller since the checks table
grows at 1000+ per week, but there would only be a handful of returned checks. In
t
Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
[EMAIL PROTECTED] Is this redundant, or is there a reason for this? The original
MySQL
install was done by an application we're running, but we've since added
additional databases.
thanks,
Jim
--
MySQL General
2003年 7月 9日 水曜日 00:55、Michael Iatauro さんは書きました:
> > I took once moe a sharp look now that you did a reply with another
> > sample. Actually I was wrong the SQL statement was NOT correct - you
> > forgot the semicolon in the first exapmple ;-)
>
> To my knowledge, the semicolon is unnecessary when u
Hi Mixo,
Do you have the autoextend feature enabled for the innodb table ?
It can be set f.e in my.cnf.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 8日 火曜日 22:45、mixo さんは書きました:
> How can I avoid this:
>
> DBD::mysql::st execute failed: The table 'Transactions' is full at
> /usr/lib/perl
Looking for a book to help me develop a philosophy for building
databases (particularly on MySQL). And then taking them from concept to
construction.
Something like Start by asking which queries you will be performing,
then define all data needed for each of those queries, then progress to
nor
At 18:36 08-07-2003 -0400, Larry R. Sieting wrote:
Hi,
When I delete both my.cnf from the root (C:\) directory and my.ini from
windows (C:\WINDOWS), Mysql will restart as sson as I log in to
WinMysqlAdmin. I dont want to use that program...
Anyway... any suggestions?
Go to start menu -> open a
Joe Celko's SQL for Smarties: Advanced SQL Programming
By Joe Celko
-Original Message-
From: David Thompson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:21 AM
To: 'MySQL Mailing List'
Subject: Good Database Philosophy Book?
Looking for a book to help me develop a philosophy
> Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
> [EMAIL PROTECTED] Is this redundant, or is there a reason for this?
Well, some people might say it's redundant, but it _is_ by design --
http://www.mysql.com/doc/en/Privileges.html
> ...
--
Joel Rees, p
did you try the --skip-networking option?
This option still allows local connections, so, not sure if it serves your purpose
though...
HTH,
SB
-Original Message-
From: Rudy Metzger [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 10:08 AM
To: [EMAIL PROTECTED]
Subject: backup / s
Hi Kalle,
Try
mysqldump databasename -uusername -ppassword > /to/a/directory/dump.sql
NO SPACE between the -p and the password
-Hassan
-Original Message-
From: Kalle Saarinen [mailto:[EMAIL PROTECTED]
Sent: Monday, July 07, 2003 10:06 PM
To: MySQL
Subject: mysqldump
Hello
I'm tryin
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
> -Original Message-
> From: Joel Rees [mailto:[EMAIL PROTECTED]
> Sen
Roger Davis wrote:
> localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
> has is separate from IP addresses.
Does this mean from the machine's console, or something else?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:h
From: http://www.mysql.com/doc/en/Can_not_connect_to_server.html
"A MySQL client on Unix can connect to the mysqld server in two different
ways: Unix sockets, which connect through a file in the file system (default
`/tmp/mysqld.sock') or TCP/IP, which connects through a port number. Unix
sockets
At 21:17 -0400 7/8/03, Roger Davis wrote:
localhost does not mean 127.0.0.1 Localhost is the socket to connect to and
has is separate from IP addresses. The % is for IP address access. That is
why there are 2 ways. I would hardly call that redundant.
Roger
That's true on Unix, but if Jim (the o
At 14:35 -0700 7/8/03, Steve Quezadas wrote:
> have you done any "optimize" to your tables ?
it should help improving the query performance.
it's normal to have memory lower on each day, because your index
files are growing, and takes memory.
if you're not using innodb or bdb, you can try to
At 8:55 -0700 7/8/03, Michael Iatauro wrote:
I took once moe a sharp look now that you did a reply with another
sample. Actually I was wrong the SQL statement was NOT correct -
you forgot the semicolon in the first exapmple ;-)
To my knowledge, the semicolon is unnecessary when using mysql --ex
I have just installed MySQL++ 1.7.9 using the RPMs
from Rpmfind.com.
It installed all Ok. The reason why I installed the
RPM over the source was that I can't get the source to
compile.
When I go and search the drive after the installation
I don't see the 'sqlplus.hh'
I am using Mandrake 9.1.
W
At 10:35 +0900 7/7/03, Nils Valentin wrote:
2003îN 7åé 7ì åéójì 10:28ÅANils Valentin ÇÇÒÇÕèëÇ´ÇÐǵÇ:
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql> SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO
I'm kinda new to administering MySQL. I have a remote db that I want to
backup to my local MySQL server (windows). I can do a dump of the db
from phpMyAdmin on the remote server. I try running it on my local
server through the MySQL Control Center, and it says "Read Only". I
don't have to enter pas
At 12:31 +0900 7/8/03, Nils Valentin wrote:
Hi Koh,
Shouldn't the value in the first sample be used like this ?
1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
Correct me if I am wrong.
You're wrong. :-)
0x6100620063006400 is a hex literal, which will be treated as
a string
Peter
hh is supposed to be a C++ header file
"In some cases hh is a precompiled header"
I would check out your make script or Ant build.xml to see how it's used
Is there an accompanying .h file e.g. sqlplus.h file?
Martin
- Original Message -
From: "Peter Moscatt" <[EMAIL PROTECTED]>
To:
At 9:35 -0400 7/8/03, DePhillips, Michael P wrote:
Hey Folks
I'm having a tough time finding any information in the available
documentation about this feature. Does anyone out there have a bit of
insight as to what exactly it does.
Docs says MySQL will store a checksum for each row if this is
Paul,
Your probably right about him running on windows, but I have also seen this
in other situations running linux. In fact, and yes I am almost ashamed to
say, I even set one up this way in my earlier days. It was on a local
network with no internet, and the "users" were on a custom app
I have a table like this (table_gender):
gender_id gender_description
---
0 female
1 male
I also have a table like this (table_post):
post_id post_
At 19:58 +0200 7/8/03, Boris Villazon wrote:
Hi
I need to know if is there anyway to clone a existing database
(structure and data)?
If yes, how can I do this? I looking for a SQL command.
There is no single SQL statement to do this. You can use mysqldump
to generate a file containing multiple
At 13:11 -0700 7/8/03, Daevid Vincent wrote:
Hmmm. Well you might be able to work some magic if you know the length of
the field it's supposed to be, then you could subtract the length of the
Field and then pad with spaces.
If this is to be displayed in a web page, and I assume you're trying to lin
At 12:58 -0500 7/8/03, azamka wrote:
Hi everyone,
I am trying to create tables with type innodb. I created a database and all
the tables of type ISAM. Now I am at the point of making relations and
establish refrential integrity. For that ofcourse I have to change the tables
in the Innodb type. I d
At 17:42 -0500 7/6/03, Greg Donald wrote:
> my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate
At 9:46 +0800 7/7/03, Ow Mun Heng wrote:
Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB tables? If you don't
use it, couldn't the files still be there? It's not like it's a security
risk (or is it?) or that it takes up lots of
Thanks for the Info Paul
I guess since I'm a newbie and the server's not especially loaded or
anything, I'll just leave it be.. (for the time being)
Thank
Cheers,
Mun Heng, Ow
H/M Engineering
Western Digital M'sia
DID : 03-7870 5168
-Original Message-
From: Paul DuBois [mailto:[EMAIL
At 9:39 +0200 7/7/03, Florian Weimer wrote:
I've got a table with 100 million rows and need some indexes on it
(one row is 126 bytes).
I'm currently using MyISAM and the indexing proceeds at an
astonishingly low rate: about 200 MB per hour. This is rate is far
too low; if we had to recover the dat
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
when reimporting or reinserting or whatever from a huge db i usually drop
all the indexes reimport then create them again much quicker
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 1:09 PM
To: Florian Weimer; [EMAIL PROTECTED]
Subject: Re: Fa
Hi Paul,
A good lesson to learn ;-).
What you are saying actually means that Kevin didnt need to install it again.
I must have missed this part in the manual.
Thank you for pointing this out.
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 9日 水曜日 11:14、Paul DuBois さんは書きました:
> At 10:35 +0900 7/
Hi Paul,
2003年 7月 9日 水曜日 11:17、Paul DuBois さんは書きました:
> At 12:31 +0900 7/8/03, Nils Valentin wrote:
> >Hi Koh,
> >
> >Shouldn't the value in the first sample be used like this ?
> >
> >1) SELECT * FROM table1 WHERE field1 = '0x6100620063006400';
> >
> >Correct me if I am wrong.
>
> You're wron
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
Try analyze your table(s).
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; "Florian Weimer" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, July 09, 2003 10:23 AM
Subject
At 11:23 +0700 7/9/03, Dominicus Donny wrote:
Try analyze your table(s).
What information will this yield to make indexing faster?
"Me fail English? That's unpossible"
###___Archon___###
- Original Message -
From: "electroteque" <[EMAIL PROTECTED]>
To: "Paul DuBois" <[EMAIL PROTECTED]>; "F
Hi,
I want to insert massive amounts of data in near real-time into a MySQL database. The
data is in a structured binary format, and I have code that parses the data into
logical data structures.
Right now I can load into a MySQL database via ODBC, but I need to improve throughput.
How can I
At 21:36 -0700 7/8/03, cmars wrote:
Hi,
I want to insert massive amounts of data in near real-time into a
MySQL database. The data is in a structured binary format, and I
have code that parses the data into logical data structures.
Right now I can load into a MySQL database via ODBC, but I need
1 - 100 of 105 matches
Mail list logo
