Hello,
Dear All,
i'm now a days having quite big problem, i would like to get help from
you guyz, ... we have Railways Reservation System of whole country
hosted on our servers which is purely in php MYSQL.
problem is that when the country wide offices start working, our
server CPU uUsage
Can you give us more insight into your database layout?
Are you using indexes?
How many clients are accessing it?
What kind of queries?
Are those queries written to take advantage of the indexes?
j- k-
On Monday 12 July 2004 10:28 pm, s.ahmad said something like:
Hello,
Dear All,
thankyou for your kind attention.
there are 50+ Reservation stations in the country. Where multiple
operators are sitting and reserving seats. Indexes are being used in
the DB. as i am related to hosting company, i havent seen if they are
taking advantage of indexes.
regards,
s.ahmad
On Mon,
Hi list,
i've installed mysql-administrator and mysqlcc graphical clients
downloaded from mysql.com. As i read in doc from the site, i unzipped
the downloaded files in /usr/local.
It seems to be ok, but i cannot execute the apps.
[EMAIL PROTECTED] bin]$ ls
mysql-administrator
50 clients accessing the database should not overload a system like that. I
would recommend posting your database layout. That might help in diagnosing
the problem.
j- k-
On Monday 12 July 2004 11:08 pm, s.ahmad said something like:
thankyou for your kind attention.
there are 50+
On Tuesday 13 July 2004 08:12, A. Lanza might have typed:
Hi list,
i've installed mysql-administrator and mysqlcc graphical clients
downloaded from mysql.com. As i read in doc from the site, i unzipped
the downloaded files in /usr/local.
It seems to be ok, but i cannot execute the apps.
think this will work, have not tried it:
char(int) returns a character
rand() returns a random number between 0 and 1 (with loads of decimal places)
round(int) rounds a number to a whole number.
so a random password generator could be
SELECT char(round(rand()*100), round(rand()*100),
Hi,
I'm running MySQL 3.23.52 with binary logging enabled. All commands seems to
be written to the log except for LOAD DATA LOCAL INFILE. Is there a
setting that needs to be tweaked for this to work?
Thanks for your help,
David
_
Joshua,
- Original Message -
From: Joshua Chamas [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, July 12, 2004 11:33 PM
Subject: RE: Concurrency Question
Quoting Marvin Wright [EMAIL PROTECTED]:
Hi,
It suggests below to bundle transactions into one commit, at
Not sure about the 3.x series, but in 4.x, if you build your own mysql, you
need to explicitly enable that feature via a configure option. I think
binary builds all have it enabled though.
Issac
- Original Message -
From: David Brännlund [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hi,
I found out that when joining varchar column, you have to trim down the
left column in order for MYSQL to match the row, is it a known issue? Or
join only works fine in number column?
CREATE TABLE `tb_test1` (
`id` varchar(5) NOT NULL default '',
`name` varchar(100) NOT NULL default
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password after
they log in.
The command SET PASSWORD = PASSWORD('newpassword') works fine as long as the
user has been created with no specific host extension in the mysql database
(corresponding
Hi!
On Jul 12, Hickey,Thom wrote:
I've been comparing the performance of 4.1 with the MySQL 3.23.58 that came
with our Rocks cluster software.
I'm finding that 4.1 is running approximately 1/3 slower (e.g. a 0.075
second query goes to 0.100 seconds) than 3.23.58. Size of buffers, etc.
Description:
Installed MySQL Binary, previous attempt with 'RPM' failed. From the
Binary
install everything seems ok, however when I attempt to start the
mysqld, and
run test to check it, I get a failure message as follows:
[EMAIL PROTECTED] mysql-standard-4.0.13-pc-linux-i686
Have you tried this with the latest MySQL 4.1.x build? Does it not work in
this version? What does the explain plan show?
-Original Message-
From: Francis Mak
To: [EMAIL PROTECTED]
Sent: 7/13/04 4:01 AM
Subject: Cannot do join on varchar
Hi,
I found out that when joining varchar
Hello,
We are happy to announce the release of SQL Maestro 1.5. The trial
version of the software is always available at
http://www.sqlmaestro.com/products/download.html.
In this version we have implemented a possibility to connect to a
remote MySQL server using a secure protocol. The secure
Sorry, I should have included it originally. These are the only lines
referencing innodb that I can find.
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
When that user does a select user() are they receiving the numeric ip
address or the dns resolved name? If you set up the privilege with the
numeric ip and dns is resolving this the two values will not match. If
necessary you can use --skip-name-resolve.
-Original Message-
From: Stephane
On Tue, 13 Jul 2004, s.ahmad wrote:
thankyou for your kind attention.
there are 50+ Reservation stations in the country. Where multiple
operators are sitting and reserving seats. Indexes are being used in
the DB. as i am related to hosting company, i havent seen if they are
taking advantage
Hi,
you can try to add your headings to the stopword list, but remember:
- A word is any sequence of characters consisting of letters, digits,
`'', and `_'. Any word that is present in the stopword list or is just
too short is ignored.
- The stopword list is global and will affect all
I suggest that you add more indexes to your tables. If you run an EXPLAIN
on your query, you will see that you are doing WAY too many table scans and
that is what is slowing you down. Index the columns in each table that
reference the ID values of another table. Then run your EXPLAIN again and
Is there a way to get the output of a select into outfile statement to
have the column headers in it and not just the data?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey all,
Got this query:
SELECT first,last,email FROM CustomerTable AS t1,
OrderTable AS t2, CartTable AS t3 WHERE t2.cart_id=t3.cart_id
AND t1.id=t2.customer_index AND t3.submitted='1' AND
t3.product_index='1' AND t3.quantity0
GROUP BY t1.email ORDER BY t1.first,t1.last
For some strange reason
Jeremy Zawodny writes:
The web servers record web metrics to local mysql databases. I would
like those local databases to be consolidated onto the DEPOT [as three
separate DBs].
You cannot do that.
snip
You'd need to run 3 instances of MySQL on DEPOT, one for each WWW
server you'd like to
Were the records exactly the same?
-Original Message-
From: Aaron Wolski
To: [EMAIL PROTECTED]
Sent: 7/13/04 10:04 AM
Subject: Why this query doesn't group the email addresses?
Hey all,
Got this query:
SELECT first,last,email FROM CustomerTable AS t1,
OrderTable AS t2, CartTable AS t3
Yes sir. Exactly!
A
-Original Message-
From: Victor Pendleton [mailto:[EMAIL PROTECTED]
Sent: July 13, 2004 11:15 AM
To: 'Aaron Wolski '; '[EMAIL PROTECTED] '
Subject: RE: Why this query doesn't group the email addresses?
Were the records exactly the same?
-Original
Right on!
Effectively, user() returns the dns resolved name. So obviously this will
not match the mysql user table entry, where the ip range is specified.
I will try the --skip-name-resolve option, but I have to wait for a
scheduled down time of the server.
Thanks for the expert advice!
At
Having that many instances on one box is going to be a
management nightmare. I can only imagine the recovery
scenarios should you have a hardware problem. Perhaps
you may want to think about writing your metric data
to a local mysql instance then pulling the data from
each instance into the
On Tue, Jul 13, 2004 at 11:23:03AM -0400, Marc Knoop wrote:
Jeremy Zawodny writes:
The web servers record web metrics to local mysql databases. I would
like those local databases to be consolidated onto the DEPOT [as three
separate DBs].
You cannot do that.
snip
You'd need
Jeremy Zawodny writes:
Can you, or anyone comment on the praticality of doing so? I estimate
10,000 to 30,000 records per web server, per day using 3 remote web
servers. The number of web servers would not likely grow to more than 12.
That should be a problem at all. I know of much larger
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select statement that makes all chars after the first char lower case?
Example:
Current: AARON
After: Aaron
I think this is possible.. just don't know how to execute the
Trying to get MySQL running on SCO Openserver 5.0.7 and get this message:
dynamic linker: ./bin/mysqld: binder error: symbol not found:
pthread_key_delete; referenced from: ./bin/mysqld
And I have FSU threads installed ...
Any help would be appreciated
Thanks!
Jim Ginn
--
MySQL
SELECT CONCAT( UPPER( LEFT( first, 1 ) ), LOWER( RIGHT( first, LENGTH(
first ) - 1 ) ) ) AS `first` FROM table
On Jul 13, 2004, at 12:51 PM, Aaron Wolski wrote:
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select
Dear All,
On executing a Stored Procedure (in MySQL 5.0.0-alpha) containing
multiple Select statements, I get the error
SELECT in a stored procedure must have INTO.
I found that this is a MyODBC bug.
http://bugs.mysql.com/bug.php?id=2273
and
http://bugs.mysql.com/bug.php?id=2658
Mark
What type of field is the email field?
Wes
On Jul 13, 2004, at 11:04 AM, Aaron Wolski wrote:
Hey all,
Got this query:
SELECT first,last,email FROM CustomerTable AS t1,
OrderTable AS t2, CartTable AS t3 WHERE t2.cart_id=t3.cart_id
AND t1.id=t2.customer_index AND t3.submitted='1' AND
Hi there,
Thanks for the help!
Someone else also gave me a similar query which did exactly as yours
did. But with the same minor problem
In this table.. I also have columns for last and email. So the columns
are first,last,email.
The problem with both yours and this other person's query is
It's ulgy, and I'm not sure how efficient it is, but this will do the trick:
select concat(left(first,1),substring(lower(first) from 2)) as first;
Aaron Wolski wrote:
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select
varchar, sir.
-Original Message-
From: Wesley Furgiuele [mailto:[EMAIL PROTECTED]
Sent: July 13, 2004 1:14 PM
To: Aaron Wolski
Cc: [EMAIL PROTECTED]
Subject: Re: Why this query doesn't group the email addresses?
What type of field is the email field?
Wes
On Jul 13, 2004,
Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it
I have been trying out 4.1.3 beta on XP, and note that in SQLyog, Maestro,
and even MYSQL Administrator, the number of records shown is always one
more than actual - in InnoDB tables only. Even an empty table still shows
as 1. This is different than the count shown in these GUIs with 4.1.1
Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it
How can I copy the data directory from linux to windows, with the same
mysql version (4.0.16) in both OS and innodb tables?
I try simple copy all files (iblogs, ibdata, mysql dir, database dir)
but I get this error when open a table:
ERROR 1016: Can't open file: 'advogado.InnoDB'. (errno: 1)
--
You are doing an implicit group by of first, last as
well as your explicit group by of email.
So you could have two records with the same e-mail
address generate two records with your group by
Justin Time [EMAIL PROTECTED]
Justin Credible [EMAIL PROTECTED] --DUPE--
Case differences
Hi,
I'm setting up MySQL databases on 'shared server' space I've rented using
cPanel's 'MySQL Database' interface. I can add 'access hosts' (it's not
limited to localhost) and it says the % wildcard is allowed. Forgive me if
this is a trivial or annoying question (I can't find the answer
Try using mysqldump for the innodb files.
-Original Message-
From: Mauricio Bruns
To: MySQL List
Sent: 7/13/04 12:41 PM
Subject: Moving InnoDB database from Linux to Windows
How can I copy the data directory from linux to windows, with the same
mysql version (4.0.16) in both OS and
On Tue, 13 Jul 2004, Jim Ginn wrote:
Trying to get MySQL running on SCO Openserver 5.0.7 and get this message:
dynamic linker: ./bin/mysqld: binder error: symbol not found:
pthread_key_delete; referenced from: ./bin/mysqld
This was an error for some versions of MySQL. This is fixed in
Justin:
Interesting. So, if GROUP BY t1.email doesn't group simply by
t1.email, then how would the query be written to accomplish that? And
how is it occurring that Aaron is implicitly grouping by email, first,
last instead of just grouping by email? Is it because of the ORDER BY
clause?
Wes
After much searching (and trying to read non-English posts), I've
stumbled across the solution. I installed the mysql-MAX rpm, changed the
my.cnf file and Viola! it works!
--
Hugh
mailto: [EMAIL PROTECTED]
Hugh Taylor wrote:
Running MySQL 4.0.15 on SuSE 9 Professional. MySQL works fine until I
If I have tables within 3 different mysql dbs, is there a way for me
to combine all 3 tables into a scope so that I may run a query
accessing information from those 3 tables within 3 mysql dbs?
In MS Access/MSSQL, it would be called linking, but I couldn't find
out whether mysql has that or not.
Hello, mysql gurus,
I have been trying to transfer some huge databases (20G) to another
server using mysqldump. Here is my command
mysqldump --add-locks --allow-keywords -q -p db db.dump
When I tried 'mysql -p db db.dump' in another server, everything goes
all right until at some point it
If the db's are on the same server and you have the needed permissions for all
of them, just prefix the table names with the db names like so:
select dbname.tablename.field1, dbname2.tablename2.field2. and so on.
Your FROM will need similar qualifiers.
j- k-
On Tuesday 13 July
What are the table types being moved? What is the max packet size?
-Original Message-
From: ginger cheng
To: [EMAIL PROTECTED]
Sent: 7/13/04 2:42 PM
Subject: question about using mysqldump file
Hello, mysql gurus,
I have been trying to transfer some huge databases (20G) to
Boyd Lynn Gerber:
I'll give the newer version a try as I was using:
/usr/local/mysql-4.0.18-pc-sco3.2v5.0.7-i386
build from your site ...
Thanks!
Jim
On Tue, 13 Jul 2004, Jim Ginn wrote:
Trying to get MySQL running on SCO Openserver 5.0.7 and get this
message:
dynamic linker:
On Tue, 2004-07-13 at 11:13, Justin Swanhart wrote:
You are doing an implicit group by of first, last as
well as your explicit group by of email.
So you could have two records with the same e-mail
address generate two records with your group by
Justin Time [EMAIL PROTECTED]
Where is the implicit group? The 'order by'
shouldn't effect how things
are grouped. On MySQL 4.0.17:
Wow. I wasn't aware. Is that expected behavior?
Other databases (Oracle) generate an error when you
include columns in the select list that aren't in a
group by, or they do an implicit
Hi, I am very new to MySQL and using it as the backend of my VB.NET
application. Now, I am trying to create an installation package from within
VB and don't know what files from MySQL MyODBC 3.51 I need to add to my
installation package. Can anyone provide some help in this regards?
Also, I will
[...] how do I just 'allow any host'? [...]
maybe it's just '%'?
AFAIK, that's it.
Greetz
Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Boyd Lynn Gerber:
Updated to (your) 4.1.3-beta and now get:
./bin/mysqld --skip-grant
dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m
Check in /usr/lib and see:
l /usr/lib/libssl*
-r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@
-r-xr-xr-x 3 bin
On Tue, 2004-07-13 at 13:51, Justin Swanhart wrote:
Where is the implicit group? The 'order by'
shouldn't effect how things
are grouped. On MySQL 4.0.17:
Wow. I wasn't aware. Is that expected behavior?
Yup, check out:
http://dev.mysql.com/doc/mysql/en/GROUP-BY-hidden-fields.html
On Tue, 13 Jul 2004, Jim Ginn wrote:
Updated to (your) 4.1.3-beta and now get:
./bin/mysqld --skip-grant
dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m
Check in /usr/lib and see:
l /usr/lib/libssl*
-r-xr-xr-x 3 bin bin 191812 Sep 20 2003
Boyd Lynn gerber:
Much better but it complains about max_allowed_packet? It is set to the
default 1M ...
Thanks!
Jim
Installing all prepared tables
Fill help tables
ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes
040713 17:43:07 Aborting
040713 17:43:07 ./bin/mysqld:
Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it
I am trying to do an INSERT ... SELECT statement. When using MySQLcc
everything is fine. However when I try to execute the command using PHP I
get error 1146: Table 'caldata.resource' doesn't exist. Following is my
query statement. I am trying to combine a bunch of tables together and I
don't
Matthew Stanfield wrote:
I'm setting up MySQL databases on 'shared server' space I've rented
using cPanel's 'MySQL Database' interface. I can add 'access hosts'
(it's not limited to localhost) and it says the % wildcard is allowed.
Forgive me if this is a trivial or annoying question (I can't
Hi,
I'm now running redhat AS 3.0 with kernel version 2.4 and have 8GB of RAM.
If I set my innodb_buffer_pool to 2048M, it just will not start, I get this
error.
040713 22:10:24 mysqld started
040713 22:10:24 Warning: Asked for 196608 thread stack, but got 126976
InnoDB: Fatal error: cannot
On Tue, 13 Jul 2004, Jim Ginn wrote:
Much better but it complains about max_allowed_packet? It is set to the
default 1M ...
I have my stune set as follows.
NODEosr507
EVDEVS 96
EVQUEUES88
NSPTTYS 64
NUMSP 256
NSTREAM 4352
NHINODE 1024
GPGSLO 1000
GPGSHI 3000
NSTRPAGES
Astrum Et Securis
We've just bought a new Power Mac G5 Macintosh computer for the office and
I'll be needing to do some database engineering work using it. I've never
worked with mySQL on MAC, so I really have no experience with what happens
on a MAC.. Anyone here who works with mySQL on a
Nawal Lodha wrote:
Dear All,
On executing a Stored Procedure (in MySQL 5.0.0-alpha) containing
multiple Select statements, I get the error
"SELECT in a stored procedure must have INTO".
I found that this is a MyODBC bug.
http://bugs.mysql.com/bug.php?id=2273
and
I gather you have used MySQL on other platforms? Won't be much different. OS
X is BSD Unix-based, so it will be very similar (if not identical) to using
MySQL on a Unix box.
Have fun.
Or were you asking about compiling, etc?
j- k-
On Tuesday 13 July 2004 03:21 pm, MySQL Junkie said
Don't know much about creating a package in VB.NET but why not just the
windows installer from the web page instead, its always worked piece of cake
on the windows boxes if worked with. Can you call it from and then add in
some programming in VB to add the users?
-Original Message-
From:
Astrum Et Securis
Josh,
Thanks for writing in...
Yes in fact I have worked with MySQL on other platforms. And am glad to hear
it wont' be a problem or much different.
Thanks a lot.
Dominor,
RSJ
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could call a Perl, C++ or Java program from cron to periodically
update the
I have a query like this
select hex(blob_field) as myField from table
When the blob field is empty ('') it returns 'x'.
i'm using ADO with Visual Basic and MyODBC 3.51.
MySQL Version is 4.0.18 and SO is Win XP Pro (also happens on Windows 2K)
Felix Beltran.
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could
Hi all, this is my first post, and I whould like to know if there is a way to create
Foreign Key´s between Parent and Child table, I realy dont know if is it possible to
do it and if OK, how will be a simple SQL code of it.
I use PowerDesigner 10.0 and Erwin 4.0
Tks for all
Everton Sanga
An option would be a log reader program that uses
Oracle log miner to only show commited transactions
from the redo logs. You could then replay the SQL
that is being executed on the oracle box on the mysql
server as long as the tables are defined the same.
9i has an enhanced log miner that can
Sergei, Thom..
I am interested in seeing this thread followed through. As developers at my
work have experienced similar performance issues between 3.23.x and 4. Our
database is also of similar size and a full optimize has been run.
Regards,
Lachlan
-Original Message-
From: Sergei
You should take a look at using InnoDb table types.
-Original Message-
From: Everton Sanga
To: [EMAIL PROTECTED]
Sent: 7/13/04 8:26 PM
Subject: Foreign Key
Hi all, this is my first post, and I whould like to know if there is a
way to create Foreign Key´s between Parent and Child table, I
Roy
I don't think we provide any merge module for our ODBC installation yet, but
the changes that the odbc installer makes are very trivial so you could make
them yourself.
Are you going to run the mysql installer or perform the install yourself?
If you are going to perform the install yourself,
Dear all:
Do any one try to upgrade the mysql from 3.23 to 4.1?
In doc,mysql doesn't recommend update the mysql from diff series.Do any one try it
successfully?
Do I just need to copy the datafile to the new mysql ?
Best regards.
MaFai
[EMAIL PROTECTED]
Since I don't have control on this server(cannot upgrade), so I cannot tell
if same happen in 4.1.3.
However, I would like to know the result in 4.0 as well. Anyone test this
script in 4.0/3.X server? I suspect this could be a unicode problem in 4.1?
If 4.1.3 could fix the problem I will suggest
Boyd Lynn Gerber:
I have (think) the MySQL dataserver running. You wouldn't know where I
could find a compiled:
mysql.so
module for apache/php data access?
Thanks!
Jim
On Tue, 13 Jul 2004, Jim Ginn wrote:
Much better but it complains about max_allowed_packet? It is set to the
default 1M
What table types are you currently using?
-Original Message-
From: MaFai
To: [EMAIL PROTECTED]
Sent: 7/13/04 10:09 PM
Subject: Upgrade 3.23 to 4.1.x
Dear all:
Do any one try to upgrade the mysql from 3.23 to 4.1?
In doc,mysql doesn't recommend update the mysql from diff series.Do any
On Wed, 14 Jul 2004, Jim Ginn wrote:
I have (think) the MySQL dataserver running. You wouldn't know where I
could find a compiled:
mysql.so
module for apache/php data access?
Yes there is one in ftp.sco.com
ftp://ftp.sco.com/pub/openserver5/507/iso/suppcd3/osr407suppcd3.iso
and in MP3
Hi list...
I found that someone else had this problem:
http://lists.mysql.com/mysql/161614
But the solution is missing...
I couldn't find any other reference to this problem, does any one know the
answer?
Regards
FBR
[EMAIL PROTECTED]
13/07/2004 07:15 p.m.
To
[EMAIL PROTECTED], [EMAIL
Hello,
Is there any way to fix a connection of replication
from slave host when user on slave host noticed
that the connection of replication had been lost?
Now I have a following environment.
MySQL Master server == replication == MySQL Slave server
Both server has
Turbo Linux 8.0 WS
86 matches
Mail list logo
