I am running a debian linux server and I need mysqlplus installed. There
isn't a package yet for debian (at least not to my knowledge) to install it.
So, I downloaded the mysql++ 1.7.9 source to install it. I am running
version 2.95.4 of gcc. Is there something I am doing wrong? Do I need to
in
If it's really utf8 problem lets check this out. Please submit the report
as Sergei had asked.
Regards,
Igor
-Original Message-
From: Donny Simonton [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 19, 2004 1:02 PM
To: 'Brian Wintz'; [EMAIL PROTECTED]
Subject: RE: MySQL 4.1.1 Performanc
- Original Message -
From: "Walt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 8:00 AM
Subject: Newbie question
> I need a little advice on where to get started. I want to create a db and
simple form that will populate the db. Which language is best? W
Greetings:
Crack open the beer, PEAR DB 1.6.0 is here! (Hey, I'm a bit giddy
with excitement that my intense work during the past seven weeks
has come to fruition.)
For those unfamiliar with PEAR DB, it's a package of PHP classes
that provide an object oriented API with common methods of accessi
Chris,
- Alkuperäinen viesti -
Lähettäjä: "Chris Nolan" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Kopio: <[EMAIL PROTECTED]>
Lähetetty: Monday, February 16, 2004 1:56 PM
Aihe: Re: InnoDB Hot Backup + MySQL embedded?
> Heikki,
>
> Thank you greatly for answeri
Network configuration:
- Firewall connected to Internet, with two ports: LAN (protected) and DMZ
- Web server on the DMZ segment
- Internal Servers on the LAN segment.
We would like to introduce a web database application on the Web server,
using a Slave replication of a Master database running o
I was wondering what the bottleneck was. I'm adding a dozen indexes to
the same large-ish InnoDB table. Each successive index takes a bit
longer (45 seconds or so on a dual P3-933 with 2 gig of RAM).
Is it disk additional tables-space management that is taking the extra
time? Would faster disks h
To make it simple, is it possible to make function having many undecided parameters
with MySQL 5.0 stored procedure/function?
For example,
add(3)
add(3,5)
add(3,5,1,4,9)
add(3,5,1,4,9,8,6,7,2)
In C, we use pointer to handle this,
but I don't know how to code this at stored function CREATE FU
Hi,
I have been backing up via the dubious method of copying the database data folder onto
another machine where it is properly backed up onto DLT.
(yes, I know I should have used mysqldump!)
Recovering some tables today I copied the files back into their position (including the ibdata1 file and
Mark,
I am using the
'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource'
class, which worked fine in 5.0. I've done some
further debugging and figured out a way to get the
datasource to at least run. If I explicitly pass the
"user" and "password" parameters (along with
"serverName", "data
I have a query where I want to display the column headings as row
headings.
Here is my query:
Code:SELECT DISTINCTROW Avg(DateDiff(OrderDate, POItem.ReceivedDate))
AS AvgLeadTime,
Min(DateDiff(Po.OrderDate, POItem.ReceivedDate)) AS MinLeadTime,
Max(DateDiff(Po.OrderDate, POItem.ReceivedDate)) A
Hi,
Yeah, by default mysqldump buffers the result of the "SELECT * FROM
table" query in memory before writing the SQL statements (using
mysql_store_result()). If you use the --opt option (or at least -q
or --quick), it dumps the data as it gets it (using mysql_use_result()).
Hope that helps.
M
Steve Edberg wrote:
It's my understanding that doing a simple delete
delete from table_name
actually DOES drop and recreate the table (and thus its indexes). On
the other hand, if you are continually adding & deleting records, you
might well need to do a periodic 'analyze table_name' o
Greetings,
I'm part of a project that deals with high-resolution topological
data generated by LIDAR technology and we're considering using
mySQL to store the row data (xyz triplets).
Right now we have aproximatelly 40 GB of ASCII files with such data.
In this format a triplet is represented by ~2
Hi James,
Your key_buffer is using tons of memory at 1.5 GB! table_cache is
probably too big, too.
Matt
- Original Message -
From: "James Kelty"
Sent: Saturday, February 14, 2004 3:03 AM
Subject: Massive memory utiliazation
> Hello,
>
>
>
> We have currently tuned MySQL for a high r
I think --with-extra-charsets=none means that no additional character
sets will be _compiled_ into the server. Complex character sets must be
compiled into MySQL, but simple ones can be loaded dynamically. I think
the character sets you are seeing are ones that can be loaded
dynamically. For ins
It's my understanding that doing a simple delete
delete from table_name
actually DOES drop and recreate the table (and thus its indexes). On the
other hand, if you are continually adding & deleting records, you might
well need to do a periodic 'analyze table_name' or 'optimize table_nam
This will only be a problem if the two inserts are using the same mysql connection/link_indentifier.
This isn't usually the case in a web environment, unless you are using a persistent mysql connection across multiple instances of the same script.
mysql_insert_id() returns the last insert id for
Egor Egorov wrote:
> > Why do I still get all these character sets and how to get rid of them ?
> If you want to have only latin1 configure MySQL with --with-charset=latin1
option,
> additional character sets you can define with --with-extra-charsets
option.
This was the first what I did. And the
Andy Bakun wrote:
On Thu, 2004-02-19 at 08:24, Alex Greg wrote:
I have a select query which is selecting all records in a table (which has
around 8,000,000 rows in). "time" is a field of type "time". Should I be using
<= and >= or BETWEEN to find records in a certain range? Which does MySQL
op
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom O'Neil wrote:
> I've been running an application on WebSphere 5.0
> (Linux) that uses the MySql Connector/J 3.10 to
> connect to a MySql-max 4.0.15 database (also on
> Linux). All was working fine, until I recently
> installed WebSphere 5.1. Now m
Is it possible to JOIN the results of a DESCRIBE TABLE to some other
query? The semantics of what I would like to do is the following:
SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON
desc.d_table = 'footable' AND desc.d_field = Field;
so the resultset would look like a regular DE
Brian,
I know that I have been using 4.1.0 and 4.1.1 and when compared to 4.0.x,
4.1.x is much faster for us. We have been pushing over 3000 queries per
second with 4.1.1 without any problems. Now we aren't using utf8, but I
don't think that would really be the problem.
Donny
> -Original Me
I need a little advice on where to get started. I want to create a db and simple form
that will populate the db. Which language is best? What should I read to help me
along?
tia Walt
[EMAIL PROTECTED] wrote:
>
> Hi,
>
> I have some logging data from a webserver in a table and want to do some
> analysis.
> I infact want to see how many files are requested at one time.
> To do this I
> SELECT COUNT(time) anz FROM table GROUP BY time ORDER BY anz DESC
> This gives me the number
Hi!
On Feb 18, Brian Wintz wrote:
> I have begun working with MySQL 4.1.1 using the utf8 encoding to capture
> unicode data. I converted an existing MySQL 4.0 (latin1) database by doing
> a dump and load (with the new databases character set to utf8). I'm
> noticing that the performance on the n
Hi All,
I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
My trouble is when I create the my.cnf file and start MySQL.
MySQL don´t stat.
the /usr/local/mysq
On Thu, 2004-02-19 at 08:24, Alex Greg wrote:
> I have a select query which is selecting all records in a table (which has
> around 8,000,000 rows in). "time" is a field of type "time". Should I be using
> <= and >= or BETWEEN to find records in a certain range? Which does MySQL
> optimise for?
I
I run MySQL version 4.0.16 on my linux box.
My replication is working fine when I drop my database and import it on the
master server. It seems to me that configuration files for both master and
slave are OK. Privillege too.
I define a user with the following right's:
* Reload
* File
I'm looking for a good report generator (similar to Crystal Reports) for
MySQL that runs on a Linux/Apache
system. I'm currently using a php scripts that I wrote, but its being
unbearable to keep up with the report
demand. So i'm looking for something I could easily integrate into my
current w
>> This is probably tediously basic for all you super whiz
> MySQL people
> but help me out if you can.
>>
>> I have 2 tables in my database (there will be more)
>>
>> table_Applics & table_keywords
>>
>> I want to select columns of information from
> table_applics based on the
> ID results from ta
Hi All,
I´m trying to do some customization in a MySQL-Server-4.0.17
to gain a better performance.
We have a Intel P4-2.4 Ghz with 1 Gb RAM and 40 Gb HD
on a FreeBSD-5.2.1 box dedicated for MySQL.
My trouble is when I create the my.cnf file and start MySQL.
MySQL don´t stat.
the /usr/local/mysq
I've dumped alot of databases before using mysqldump, and am trying to
dump a larger database than normal, about 2.2GB in size.. The largest
table just over 12 million rows... It's dumping over a network to a
tape backup server..
I start the job off:
/usr/local/bin/mysqldump -c -F --host=prv-m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL Connector/J 3.0.11, a new version of the Type-IV all-Java JDBC
driver for MySQL has been released.
Version 3.0.11 is a bugfix release for the STABLE tree that is
suitable for use with any MySQL version including MySQL-4.1 or MySQL-5.0.
It
...
I have a, possibly not so unusual problem, with dates. The standard MySQL datatime
accounts for
all dates starting between the year and inclusive.
...
Take a look at using Julian Day numbers. This date form is used in
astronomy and general calendar conversion
Hello all. I'm trying to 'make' MyODBC, and I receive the following error:
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -Iyes/include -O3
-DDBUG_OFF -c utility.c -Wp,-MD,.deps/utility.TPlo -fPIC -DPIC -o utility.lo
/bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -o
Hi all,
I'm basically trying to get a count of banner ad impresssions and banner ad
click-thrus from phpAdsNew into a simple report on another site to figure
out how to accurately get the stats to pass onto php and smarty to output
onto a webpage for a user to see their stats on an application I'm
Quick question...
What you drop a table are the indexes for that table dropped to?
I'm about to write a script to take a data pull every night and
re-populate a table with the results, then have my apps run off of the
new consolidated table for a speed increase. If I drop the Consolidated
table,
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
job 2
Basically, I'd lik
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
> You can set it as an alias using AS .
>
> Respectfully,
> Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typ
On Wednesday 18 February 2004 09:24 pm, Ligaya Turmelle wrote:
> You can set it as an alias using AS .
>
> Respectfully,
> Ligaya Turmelle
Yes, I was aware of this option, but I was looking for a way to automatically
alias all fields with a set prefix or postfix. On a big table it's a lot of
typ
At 9:33 + 2/19/04, Mark Maunder wrote:
'connection ID' below should be 'last insert id'. Sorry, it's 2am here
and I'm fresh out of coffee. BTW the information you want is here:
http://www.mysql.com/doc/en/Information_functions.html#IDX1409
"The last ID that was generated is maintained in the se
I've been running an application on WebSphere 5.0
(Linux) that uses the MySql Connector/J 3.10 to
connect to a MySql-max 4.0.15 database (also on
Linux). All was working fine, until I recently
installed WebSphere 5.1. Now my datasources
(configured exactly as before) no longer work -
WebSphere seem
Carl Schéle, IT, Posten wrote:
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
-
0 hd carl mattias 1957
1
This is probably tediously basic for all you super whiz MySQL people but help me out
if you can.
I have 2 tables in my database (there will be more)
table_Applics & table_keywords
I want to select columns of information from table_applics based on the ID results
from table_keywords.
something
I'm still a beginner myself but try something like
SELECT COUNT(YEAR), WINNER1 AS WINNER, WINNER2 AS WINNER, YEAR FROM
CHAMPIONS WHERE CLASS = "hd" GROUP BY WINNER;
I think this will give you something like:
COUNT(YEAR) WINNER YEAR
2 car
I left out the details because of the fear of putting
people to sleep. Here it goes
The requirement is to design High Availability for an
Application that is using a MySQL database. The
following is the configuration I have in mind.
CONFIGURATION:
- Two machines, Primary and Secondary. Each
On Wed, Feb 18, 2004 at 02:18:59PM -0800, Gowtham Jayaram wrote:
> Hello all:
>
> I am looking into the Replication issues that surface in a Failover
> scenario (Master goes down and Slave is pressed into service).
>
> I understand that it is critical for the Master and Slave databases
> to mirro
Hi,
I have a select query which is selecting all records in a table (which has
around 8,000,000 rows in). "time" is a field of type "time". Should I be using
<= and >= or BETWEEN to find records in a certain range? Which does MySQL
optimise for?
select time,price from csq where id = 12345 and da
I am desperately looking for some programming examples for building custom
gui's. And can't find any online using MySQLDriverCS.
I have one built but I need to find better examples.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mys
Hello,
I am trying to create some tables that I can use the delete on cascade function for.
This would help me code the project and ensure data integrity. I am on the docs @
http://www.mysql.com/doc/en/InnoDB_foreign_key_constraints.html but I am not quite
understanding the syntax.
I am creati
I'm copying this to the list (hope you don't mind). You'll find you get
quicker and better responses when all the experts on the list see your
question. Plus, someone else may have a similar question and benefit
from the answers you get.
I've never seen this problem myself, but it looks like
I have begun working with MySQL 4.1.1 using the utf8 encoding to capture
unicode data. I converted an existing MySQL 4.0 (latin1) database by doing
a dump and load (with the new databases character set to utf8). I'm
noticing that the performance on the new 4.1 database is about 5 times
slower. I
reply
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I have some logging data from a webserver in a table and want to do some
analysis.
I infact want to see how many files are requested at one time.
To do this I
SELECT COUNT(time) anz FROM table GROUP BY time ORDER BY anz DESC
This gives me the number of requests at any time. I now want to see
Hello,
I'm am trying to make MySQL Server to log connections (attempts, successes,
failures) to a Syslog. I know that it's possible to log all queries but I
just want the connections. Has anyone already done this? Is there a patch
file that I can use?
Thank you,
António Fernandes
--
MySQL Gene
Hi
Maybe I am missing something. Why not install MySQL on a windows box
and use one of those porters. Then just copy your tables to the Linux box.
Mike
- Original Message -
From: "J. Allen Crider" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Fe
On Tuesday 17 February 2004 18:16, you wrote:
> Do you know what the default character set for MySQL is?
By default MySQL uses latin1 (ISO-8859-1) character set.
>
> Thank you!
>
> -Original Message-
> From: Egor Egorov [mailto:[EMAIL PROTECTED]
> Sent: Saturday, February 14, 2004 4:18 AM
"Bungarz, Kai" <[EMAIL PROTECTED]> wrote:
> Hi!
> I get error 2013: "Lost connection to mysql server during query", while
> loading
> data into a table using "load data infile..".
> This happens only, when "load data" needs much time and files are
> rather
> big.
> Is there any "time_out" paramete
"Przemyslaw Popielarski" <[EMAIL PROTECTED]> wrote:
> I'm trying to build MySQL 4.0.18 for Linux x86 2.4.24 from source without
> support for extra charsets. Lets say I need only latin1.
>
> My configure:
>
> FLAGS="-O3 -march=pentium4 -mcpu=pentium4 -fomit-frame-pointer" CXX=gcc
> CXXFLAGS="-O3
Thanks Mark...
You popped me out of great confusion/problem.
Binay
- Original Message -
From: "Mark Maunder" <[EMAIL PROTECTED]>
To: "Binay" <[EMAIL PROTECTED]>
Cc: "mysql users" <[EMAIL PROTECTED]>
Sent: Thursday, February 19, 2004 3:03 PM
Subject: Re: Last inserted id
> 'connection ID
"Binay" <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have a php script which insert a row in one of my table. Now i want the
> auto_generated id produced by this insert query. I know i can use mysql_insert_id
> function to fetch that auto_generated id. But my question is say two or more person
> visit
'connection ID' below should be 'last insert id'. Sorry, it's 2am here
and I'm fresh out of coffee. BTW the information you want is here:
http://www.mysql.com/doc/en/Information_functions.html#IDX1409
"The last ID that was generated is maintained in the server on a
per-connection basis. This means
The two simultaneous insert statements will be have separate connections
to the database and last_insert_id() is connection specific. So if
you're running apache, and you're worried about two different apache
child processes getting the same connection ID, don't. Because those two
children will hav
I think that fastest way to get round this (mite be wrong)
is to use the binary. Then all you need to do is change the sym link!
This is a bit of a work round but should work?
Simon
- Original Message -
From: "Ross O" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 1
Hi!
I get error 2013: "Lost connection to mysql server during query", while
loading
data into a table using "load data infile..".
This happens only, when "load data" needs much time and files are rather
big.
Is there any "time_out" parameter i have to set/change?
Best regards,
Kai
Wissenschaftli
Hi
I have a php script which insert a row in one of my table. Now i want the
auto_generated id produced by this insert query. I know i can use mysql_insert_id
function to fetch that auto_generated id. But my question is say two or more person
visiting the same page/script causes a insert opera
Im trying to upgrade 3.23 on my redhat 9 machine. I
have one lone perl-dbd-mysql libmysqlclient dependency
that is throwing me off. when i try to upgrade it
wont go. so i try to uninstall that perl rpm and it
says its mysql 3.23 needs it and when i try to
uninstall mysql 3.23 it says the perl db
Sasha Pachev wrote:
J. Allen Crider wrote:
I have just decided to try to learn something about MySQL after
several years of working with Oracle and wanted to transfer the data
I have in an Oracle 9i database to a new MySQL database. Since this
is strictly for personal use, I can't justify the
Hi!
I got a table, champions, looking like this:
idclass winner_1 winner_2 year
-
0 hd carl mattias 1957
1 hs daniel
Obviously I wrote my original message too quickly and did not make
myself clear. I am well aware that DB2 and numerous other commercial
products work on Linux. What I meant to say was that, of all of the
products that I could find listed on www.mysql.com for converting data
from Oracle to MyS
I've been watching the group for a long time, and there is a huge debate
about MyISAM vs InnoDB for "large" tables.
It really does depend on what you want to use your table for, what hardware
you running on, and what size you consider to be large!
For me, I also have mainly numerical data, and 1-
Hi!
- Original Message -
From: "Sasha Pachev" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Thursday, February 19, 2004 12:58 AM
Subject: Re: MySQL version 4.1.x
> lee wrote:
> > Anyone know when 4.1.x is scheduled for going "Production?" The website
says
> > it's curren
73 matches
Mail list logo
