I have a bunch of CSV files that I wish to import into a table. I can
do that with LOAD DATA INFILE INTO TABLE ..
but there's a bunch of them with different names (naturally) and I
wish to do them in one go. From my understanding, there is no way to
specify the table since it is inferred
Hi,
I would like to study about how to tuning mysql for the best
performance. I am looking for any books about it, so I can study about
it offline.
I am looking forward to a favorable reply from you. Thank you.
Regards,
Eko Budiharto
I've just made it through the MySQL Certification Study Guide and have
found it to have pretty good coverage of tuning as well as other
subjects. There are probably more in-depth sources available, but it
might be a good place to start.
- Dan-o
On Aug 9, 2004, at 12:42 AM, Eko Budiharto
You may want to take a look at High Performance MySQL by Jeremy D.
Zawodny and Derek J. Balling (http://www.oreilly.com/catalog/hpmysql).
- glenn
On Aug 9, 2004, at 10:42 AM, Eko Budiharto wrote:
Hi,
I would like to study about how to tuning mysql for the best
performance. I am looking for any
hi,
i write a application in java that creates database-diagrams like
ms-visio can do this! until now i only support ms sqlserver and oracle
for importing data from the database and displaying a database-diagram!
now i want to add mySQL support into my application! for this reason i
need to
Hi Michael,
i write a application in java that creates database-diagrams like
ms-visio can do this! until now i only support ms sqlserver and oracle
for importing data from the database and displaying a database-diagram!
now i want to add mySQL support into my application! for this reason i
hi,
is it possible to connect to a mySQL-Server without entering a database
and then check all available databases?
thx mseele
--
G H Softwareentwicklung GmbH Tel.: +49(0)7451/53706-20
Robert-Bosch-Str. 23 Fax: +49(0)7451/53706-90
D-72160 Horb a.N.
Yes.
Which language you are using?
Regards,
Karam
--- Michael Seele [EMAIL PROTECTED] wrote:
hi,
is it possible to connect to a mySQL-Server without
entering a database
and then check all available databases?
thx mseele
--
G H Softwareentwicklung GmbH Tel.:
+49(0)7451/53706-20
i use mySQL english version! why?
Karam Chand schrieb am 09.08.2004 14:13:
Yes.
Which language you are using?
Regards,
Karam
--- Michael Seele [EMAIL PROTECTED] wrote:
hi,
is it possible to connect to a mySQL-Server without
entering a database
and then check all available databases?
thx mseele
hi all,
i'm developing a web based application under r-g linux 9 with MySQL 3.23.54a-11. i
have planned to upgrade it to 4.0.20. it seems that if i keep the current version of
MySQL running for more than 8 hrs, it times out with the web-server (tomcat 4.x) and
dies out. due to this, i have
oh! sorry! i use java!
[EMAIL PROTECTED] schrieb am 09.08.2004 14:33:
Not which natural language, which programming language? We need to know in
order to help you. C, C++, Java, Perl, PHP, Python... The answer will
differ.
Alec
Michael Seele [EMAIL PROTECTED]
09/08/2004 13:20
To
hi all,
i'm developing a web based application under r-g linux 9 with
MySQL 3.23.54a-11. i have planned to upgrade it to 4.0.20. it
seems that if i keep the current version of MySQL running for
more than 8 hrs, it times out with the web-server (tomcat
4.x) and dies out. due to this,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Seele wrote:
| hi,
| i write a application in java that creates database-diagrams like
| ms-visio can do this! until now i only support ms sqlserver and oracle
| for importing data from the database and displaying a database-diagram!
| now i
The rename scenario is your best option. Just make sure you flush the tables
to ensure that users are seeing current data. You normally do not want to
`pull the rug` out from your users by deleting a table that they may be
attempting to access.
-Original Message-
From: Haitao Jiang
To:
On 8 Aug 2004 at 20:04, Steve Leibel wrote:
What I'm wondering is if there is a cleaner and simpler way, for
example to set up some sort of proxy server on host X that will
establish a connection with the mysql database and then relay
requests and responses back and forth to my code on
Good morning to all.
I am using the mySQL connector to connect to the mySQL database. My
question concerns the session between the DB and the client.
How is the session maintained? In other words, how does the DB know that it
is communicating with my specific connection? Here is why I ask.
God, I feel real stupid this morning and know I should know this. I have
2 tables in the same database and I'm trying to select distinct data from
a row with the same name in each table.
SELECT DISTINCT company FROM pages, pdflog ORDER BY company ASC
I'm missing something I'm sure because it
Hi,
God, I feel real stupid this morning and know I should know this. I have
2 tables in the same database and I'm trying to select distinct data from
a row with the same name in each table.
SELECT DISTINCT company FROM pages, pdflog ORDER BY company ASC
I'm missing something I'm sure
Feel stupid again ;-)
Where's your JOIN?
With regards,
Martijn Tonies
Thanks, that makes me feel better :)
Ed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
He does have a join. He has an *implied* INNER JOIN
(http://dev.mysql.com/doc/mysql/en/JOIN.html):
FROM pages, pdflog
What he is really missing is the WHERE clause that matches something from
pages with something from pdflogWithout it he is requesting a
Cartesian product of his
On Mon, 9 Aug 2004 [EMAIL PROTECTED] wrote:
He does have a join. He has an *implied* INNER JOIN
(http://dev.mysql.com/doc/mysql/en/JOIN.html):
FROM pages, pdflog
What he is really missing is the WHERE clause that matches something from
pages with something from pdflogWithout it he
What he is really missing is the WHERE clause that matches something from
pages with something from pdflogWithout it he is requesting a
Cartesian product of his tables (every combination of each row from both
tables).
I prefer to define my JOINS *explicitly*. It makes it harder to
Mahesh S [EMAIL PROTECTED] wrote:
i'm developing a web based application under r-g linux 9 with MySQL 3.23.54a-11. i
have planned to upgrade it to 4.0.20. it seems that if i keep the current version of
MySQL running for more than 8 hrs, it times out with the web-server (tomcat 4.x) and
Paul McNeil [EMAIL PROTECTED] wrote:
This tells me that the DB is treating my connections as the same connection.
I need to know if the problem is that MySQL is caching and reusing any
connection from my client OR if the problem is with my driver.
For each connection a new thread is created
Michael Seele [EMAIL PROTECTED] wrote:
is it possible to connect to a mySQL-Server without entering a database
and then check all available databases?
Sure, SHOW DATABASES is it:
http://dev.mysql.com/doc/mysql/en/Show_database_info.html
--
For technical support contracts, goto
I think a quick way to write this query would be
(http://dev.mysql.com/doc/mysql/en/UNION.html):
( SELECT magazine FROM pages )
UNION DISTINCT
( SELECT magazine FROM pdflog )
ORDER BY magazine;
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ed Curtis [EMAIL PROTECTED]
Michael Seele [EMAIL PROTECTED] wrote:
i write a application in java that creates database-diagrams like
ms-visio can do this! until now i only support ms sqlserver and oracle
for importing data from the database and displaying a database-diagram!
now i want to add mySQL support into my
Eko Budiharto [EMAIL PROTECTED] wrote:
I would like to study about how to tuning mysql for the best
performance. I am looking for any books about it, so I can study about
it offline.
I am looking forward to a favorable reply from you. Thank you.=20
High Performance MySQL by Jeremy Zawodny is
Steve Leibel [EMAIL PROTECTED] wrote:
Hello, I'm new to this list so I hope this is the right type of
question that can be asked.
At work I have access to a particular database only from a particular
host, say X. I would like to write a little script to view the data.
The script would
Haitao Jiang [EMAIL PROTECTED] wrote:
Case 1: I have a table A under a running MySQL 4.1.3b server. If I
replace A.MYD and A.MYI files without stop and start the server, will
data gets corrupted?
It depends on many factors. Honestly, there are lots of cases where you will
get correct data and
So this means that my DB driver is somehow using the same connection when I
ask it to create 2 different ones?
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 12:13 PM
To: [EMAIL PROTECTED]
Subject: Re: Multiple Connections
Paul McNeil
Paul DuBois [EMAIL PROTECTED] wrote:
Is it possible to tell mysql to create the directory for a database in a
specified directory rather than in mysql's data directory?
No.
You can create the database, then (with the server down) move it
where you want it and create a symlink in the
That depends on your definition of a join...
I don't call it a join without a join condition. It gives you tableA * tableB
results - that's a carthesian product. Hardly a normal join.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL MS SQL Server.
I think a quick way to write this query would be
(http://dev.mysql.com/doc/mysql/en/UNION.html):
( SELECT magazine FROM pages )
UNION DISTINCT
( SELECT magazine FROM pdflog )
ORDER BY magazine;
Thanks for all the help on this one. I just also realized that the server
I'm working with has
I think so:
CREATE TEMPORARY TABLE tmpList
SELECT DISTINCT magazine
FROM pages;
INSERT tmpList
SELECT DISTINCT magazine
FROM pdflog;
SELECT DISTINCT magazine FROM tmpList;
DROP TABLE tmpList;
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Ed Curtis [EMAIL PROTECTED]
I couldn't get temporary table to load into memory using type=heap, here's
the sample error as following:
mysql create table tblheap (
- id int not null auto_increment,
- primary key (id),
- value_a tinyint )
- type=heap;
ERROR 1164: The used table type doesn't support
Hi all, I am looking to upgrade to MySQL 4.0.13 on a Solaris production
server, and would like to install and test 4.0.13 without disturbing the
existing 4.0.2 server, so that there will be minimal downtime when actually
upgrading the production system.
So, i should be able to compile 4.0.13
I think the error is self-explanatory - you can't use auto_increment in a
heap table (but you can have an index)
Terry
- Original Message -
I couldn't get temporary table to load into memory using type=heap,
here's
the sample error as following:
mysql create table tblheap (
Hmm... while researching for table=heap; I found the following, and tried to
implement to no avail... So I tried that example and yet failed...
http://builder.com.com/5100-6388-1058872.html
Subtitled Flipping the switch
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Dear Friends,
I have a table in mysql database, which retains emails, I have PHP
application where I enter emails and emails get stored in mysql database,table, I have
an option to unsubscribe as well, which works,
However, Problem application is giving me is in case I unsubscribe one email
Global settings go in /etc/my.cnf. Server-specific settings go in that
server's DATADIR/my.cnf.
Running multiple servers is documented in the manual
http://dev.mysql.com/doc/mysql/en/Multiple_servers.html. Using clients in
a multi-server setting is documented on one of the sub-pages.
4.0.13
I guess i dont fully understand how mysql uses my.cnf.
Global settings go in /etc/my.cnf.
Global to what? All mysql servers running on the machine, or some other
definition? I guess my confusion is partially because my.cnf states the port
number for both servers and clients, but both servers
At 13:11 -0500 8/9/04, sean c peters wrote:
I guess i dont fully understand how mysql uses my.cnf.
Global settings go in /etc/my.cnf.
Global to what? All mysql servers running on the machine, or some other
Servers and clients
definition? I guess my confusion is partially because my.cnf states the
At 13:40 -0400 8/9/04, Scott Hamm wrote:
Hmm... while researching for table=heap; I found the following, and tried to
implement to no avail... So I tried that example and yet failed...
http://builder.com.com/5100-6388-1058872.html
Subtitled Flipping the switch
You might want to read the section
sean c peters wrote:
I guess i dont fully understand how mysql uses my.cnf.
Global settings go in /etc/my.cnf.
Global to what? All mysql servers running on the machine, or some other
Yes, all servers and clients on the same machine.
definition? I guess my confusion is partially because my.cnf
Thanks all. I already upgraded mysql to beta version of more than 4.1.x
(rookie here trying to figure out a way to issue command to show the current
version in shell prompt)
finally got type=heap to work. Thanks all.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
I wanna know is do I do the Analyze the table before the Optimize the
table or should I do it the other way around???
Thanks,
FletchSOD
For some reason, I am getting hundreds of zero-length binary log
remnants in my log area. Any idea what could be causing this? Is there
any danger in deleting the logs that don't show up in 'show master
logs'?
show master logs output:
mysqld_bin.058
mysqld_bin.059
bash-2.05b# ls -altr
Are you in the process of stopping and restarting the MySQL Database server?
-Original Message-
From: Ciarochi, Anthony
To: [EMAIL PROTECTED]
Sent: 8/9/04 2:13 PM
Subject: what is causing these XX.1.1.1.1 logs?
For some reason, I am getting hundreds of zero-length binary log
remnants in
I am using 4.0.20a Windows version downloaded as the binary file with
Installer built in.
The system was installed with the defaults. Nothing was run and the
default mysqld was allowed to run at start up. I have tried this using
Windows XP, Windows 2000 Pro Windows 98.
I am testing the system by
My guess is that since your id field is not auto_increment and you're
not specifying a value, all email addresses are getting an id of 0.
Since your primary key is composed of both id and email, MySQL isn't
complaining.
[EMAIL PROTECTED] wrote:
However, Problem application is giving me is in
At 20:25 +0100 8/9/04, Kerry Frater wrote:
I am using 4.0.20a Windows version downloaded as the binary file with
Installer built in.
The system was installed with the defaults. Nothing was run and the
default mysqld was allowed to run at start up. I have tried this using
Windows XP, Windows 2000
I am having a problem building a SELECT statement that joins two tables
with a WHERE condition.
SELECT
trucks.*
FROM
trucks, history
WHERE
trucks.account_id = '100'
AND trucks.status = 'Active'
AND history.truck_id = trucks.id This is the
tricky bit
GROUP
You need to change your INNER JOIN to a LEFT JOIN
SELECT
trucks.id, sum(history.time_sec) as total_seconds
FROM
trucks
LEFT JOIN
history
ON trucks.id = history_truckid
GROUP BY
trucks.id
ORDER BY
total_seconds desc
One other issue ---IMHO, the
Hi all,
I have just installed mysql on my pc and outside hosting with a webhosting company.
I have an access db that I want to convert into mysql. I tried the program
http://www.intranet2internet.com/public/default.asp?PAGE=softwareDETAILS=A2M
to convert a tiny access db as a test. This I did
Nope. Many of the start times for the mysqld processes go back to June
22, when the server was last rebooted.
The backup script that runs every evening at 11:30pm does do a
mysqlhotcopy, and resets the master and slave replica servers. This is
reflected in the creation time of the log files
Hi,
In my Users table I have one column for users names, I need to modify this
now so that users have a column for first names and a seperate column for
last names. My question is how can I update the current users in the table
so that their details are stored correctly?
Many thanks for your
You can load the data by using the mysql command.
mysql -uuser -ppassword fileToLoad.sql
...
If you are on a shared database server I do not think you will be able to
issue the CREATE and DROP database commands.
-Original Message-
From: EWA Goodson Wickes
To: [EMAIL PROTECTED]
Sent:
Many thanks Paul,
I will read and digest tomorrow in normat daylight hours.
Kerry
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 09 August 2004 20:55
To: Kerry Frater; MySQL List
Subject: Re: Creating a New User - What am I doing wrong?
At 20:25 +0100 8/9/04,
hi...
sorry for the length of this post!!
i have the following, that i somehow managed to get working at some point,
but i've screwed it up!!!
basically i have a number of tables, that i'm trying to join. the tables
are:
universityTBL(
name varchar(50) not null default '',
In my ongoing quest to get upgraded to 4.1.3 beta (yes the version I'm
upgrading to keeps changing), i have been reading about mysqld_multi to
manage multiple server instances on the same machine.
But, from what i've read, it appears that this is for running multiple
instances of the same
DVP
Dathan Vance Pattishall http://www.friendster.com
-Original Message-
From: sean c peters [mailto:[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 1:43 PM
To: [EMAIL PROTECTED]
Subject: mysqld_multi different server versions
So am i correct in thinking that i wont
Can I do issue
CREATE and DROP database commands with phpadmin? Our hosting paln has this
Thanks a lot
- Original Message -
From: Victor Pendleton [EMAIL PROTECTED]
To: 'EWA Goodson Wickes ' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, August 09, 2004 4:09 PM
Subject: RE: AM
Hi,
Am using MySQL Connector/J 3.0 JDBC driver with 4.1.3-beta-standard on
OS X.
I have the following code snipet:
// ..
while (rs1 != null rs1.next())
{
// ..
Calendar cal = Calendar.getInstance();
cal.clear();
cal.setTime(rs1.getTimestamp(i));
Thanks, the LEFT JOIN worked.
I do have a question though, why is it considered best practice to list
all non-aggregated columns ( I assume you mean columns from trucks.*)
in the GROUP BY statement? I ask because I am interested in fast,
secure, standards-compliant code, I'm just not always
Because not doing so violates the SQL standard. Allowing you to
included non aggregated columns in the SELECT list is a non standard
MySQL extension to the SQL language. You will get an error in other
products, such as oracle, where you will get a xxx is not a group by
expression error.
I am by no means a phpMyAdmin guru, but the version I have (2.5.7) has
an option for it, accessible by clicking on the Databases link from
the main page. I suspect, however, that they will give you a single
database that you will not have the DROP DATABASE privilege for and
that you will
There must be an even number of replicas because the cluster mirrors
data between two machines. It doesn't do three way mirroring. An
even number of nodes are required because each two data nodes becomes
a node group.
If you have three machines, you could create two NDB processes on each
followup to my initial question.
i can use the following select query to get close... however, it doesn't
really use 'left joins', and i can't figure out how to arive at the results
with the user names being correctly identified.
mysql select
- p1.name as pname,
- p2.statusID as
Hi Bruce,
I haven't reconstructed your database to test for sure, but I think your
problem is stemming from the way your joins are working.
First of all, since you are left joining to the university_urlTBL, you will
also need to left join to any tables you join from that table. If you don't
do
i think my problem is that the parsefileTBL will have null values for the
userID for some rows. the userID is the join for the userTBL. as i stated,
this is ok, as i would like to be able to display whether or not the
parsefileTBL/university_url has a person assigned to it...
-Original
phpMyAdmin will display a create database box on the initial page, if you
have the rights to create databases. If you don't have the right, then it
wont.
Often hosting plans have their own programming for creating databases
because of the problems of making sure you cannot mess with other peoples
Bruce,
A couple of questions...
Do you always expect one or more entries in the university_urlTBL for a
universityID that is in the universityTBL? If so, then you don't need to
left join the university_urlTBL from the universityTBL.
If you would like, you can send me a gzipped mysqldump of the
Bruce,
What do you get when you do this:
SELECT
*
FROM
university_urlTBL
WHERE
universityID = 40;
Lachlan
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 10 August 2004 10:46 AM
To: 'Lachlan Mulcahy'
Subject: RE: left join issues!!!
i
Hi Folks,
I am having a few issues with a LOAD DATA LOCAL INFILE command. As you
can see by the command below, I am receiving an error 1148. The
documentation states this is generally because I don't have
--enable-local-infile on in both client and server. I have switched it
on via command line
lachlan..
yes. the way i'm setting this system up, is that i have a university.. each
univeristy may have multiple urls underneath
(english/registrar/athletics/etc...)
each url is then assigned to a person, with the results of the person going
in the parsefileTBL (for each url). the
I didn't get a response to the question below, and my alternative solution
produced another error message as follows. Rather than try to establish a
new database, I used the Test database established when I reinstalled
mysql. With a csv file saved under mysql/data/test, I did a load data
this will gives you 4 records for this particular school...
select * from university_urlTBL where university_urlTBL.universityID='40';
+--+-+++--+-
---+-+
| universityID | urltype | url| userID | actionID |
universityTBL(
name varchar(50) not null default '',
city varchar(20) default '',
stateVAL varchar(5) not null,
userID int(10) not null default'',
ID int(10) not null auto_increment,
primary key (ID),-+
unique
Bruce,
Try building your join table by table.. start with
SELECT
fields
FROM
universityTBL LEFT JOIN university_urlTBL ON
universityTBL.ID = university_urlTBL.universityID
WHERE
universityTBL.ID = 40;
Then if that works.. chain on your next table and
Hi,
While creating db instance, I have this error after
db_admin:
2004-08-10 11:38:12 1 ERR 11277 IPC
create_sem: semget error, No space left on device
I'm running MaxDB on Solaris 9. Could this be solved
by increasing semaphores? How do you increase
semaphores?
Thanks
Hello,
I am installing a LAMP setup. I've installed MySQL on
AIX, but that was binary (recommended for AIX by MySQL
site) and all I did was gunzip in the directory I
wanted MySQL installed in and soft linked the that
with '/usr/local/mysql'. I've just installed Apache2
and I am not sure if the
Perhaps the problem is that there is no such option as --enable-local-infile
in the mysql client. I believe you want --local-infile. Client options are
detailed in the manual http://dev.mysql.com/doc/mysql/en/mysql.html.
Michael
Logan, David (SST - Adelaide) wrote:
Hi Folks,
I am having a few
Hi Michael,
Thanks. I rechecked things but
porkribs /u2/lcscreative/sql_scripts $ mysql --local-infile -u davidl -p
make_web_tables.sql
Enter password:
ERROR 1148 at line 46: The used command is not allowed with this MySQL
version
Still a most unhappy camper. I had to resort to placing the file
I'm having a problem getting MySQL 4.0.20 compiled on one of my servers.
Technically it's a RH9 box, although it doesn't much resemble one after
I'm through with it. OpenSSL is of course compiled from source and
installed in /usr/local/ssl (default). ld.so.conf has of course been
modified
already did that
i can get everything working until i get to a part where i want to add the
link to the userTBL.
i can get the results that have everything that i want except the
userTBL.name. when i do a left join on the userTBL.ID, parsefileTBL.userID,
i get NULLs where the names should
James,
I recommend you use the binary packages on the MySQL site. If anything
you're going to have a much more painful time attempting to compile MySQL
yourself getting all the options right and linking against the correct
things. The MySQL team makes exceptional packages and have done a lot of
hi...
in trying to get a better understanding of temp tables. is there a way to
perform a select, to write the results to a temp table, and then use the
temp table to perform another operation on the information within the temp
table...
ie...
select * from
foo
write the results of the select
Well, as you say, that error message means it's been disabled in either the
client or the server. You rebuilt the server from source with
--enable-local-infile, and the server says local-infile is ON. You've tried
turning it on in the client with --local-infile, but you haven't mentioned
I am trying to update a related table with a subquery. This is what I am
using -
update tbl1 set col1=col1+1 where ID IN (select ID from tbl2 where
status='Active');
But I get syntax error. I am not much of a database guy, so can't understand
what am I doing incorrectly. Can someone help?
TIA,
Temporary tables work pretty much like regular tables, except they don't last.
CREATE TEMPORARY TABLE bar SELECT * FROM foo WHERE ...
UPDATE bar SET ...
SELECT * FROM foo JOIN bar on foo.id = bar.id WHERE ...
Michael
bruce wrote:
hi...
in trying to get a better understanding of temp tables.
91 matches
Mail list logo