> Don't forget that MySQL is the fastest thing on the planet for your (and mine)
> kind of simple query and insert/updates. We measured 12 times faster
> performance in MySQL than Oracle in one part of our application, and I
> strongly believe that in the MySQL case the Java program overhead becam
> On Monday 07 October 2002 12:04, Edwin Raj wrote:
> > When I type mysql in the command prompt it is giving the error "ERROR
> > 2002: Can't connect to local MySql server through socket
> > '/var/lib/mysql/mysql.sock' (111)"
> > There is no file mysql.sock at that location???
>
> Exactly.
>
> > W
there is an error in your sql statement :
your origin sql is:SELECT COUNT (*) FROM test;
you should delete the space between 'count' and '(*)'.
the correct sql is :SELECT COUNT(*) FROM test;
=== £º===
>Hello All,
>
>I seem to be running into a very strange problem.
>
>In the
One other thing..
If something goes wrong or some costumers complain about being charged
without their request etc. the credit card companies can come after you. And
if they are able to prove that you have not done everything you should to
keep the CC information secure and that your routines we
On Monday 07 October 2002 12:04, Edwin Raj wrote:
> When I type mysql in the command prompt it is giving the error "ERROR
> 2002: Can't connect to local MySql server through socket
> '/var/lib/mysql/mysql.sock' (111)"
> There is no file mysql.sock at that location???
Exactly.
> What is the probl
win2k sometime can't know what is "localhost",you can use "127.0.0.0" instead of
"localhost",I think it should be worked.
=== 2002-09-25 17:05:00 ===
>i've installed ver 3.23.47 sa win2k pero di ko sya
>mstart as service..
>
>
>if i type this==>mysqladmin create database01
>ER
On Monday 07 October 2002 11:32, Robert H.R. Restad wrote:
> Thanks for doing the test :)
Don't forget that MySQL is the fastest thing on the planet for your (and mine)
kind of simple query and insert/updates. We measured 12 times faster
performance in MySQL than Oracle in one part of our appli
Le 7/10/02 7:33, « Iikka Meriläinen » <[EMAIL PROTECTED]> a
écrit :
> On Mon, 7 Oct 2002, Stéphane Pinel wrote:
>
>> What is the best strategy to make mysqld listen from another port than 3306
>> ?
>>
>> In fact we have 2 servers that handle mysql. The first is listening at port
>> 3306 but we
On Mon, 7 Oct 2002, Stéphane Pinel wrote:
> What is the best strategy to make mysqld listen from another port than 3306
> ?
>
> In fact we have 2 servers that handle mysql. The first is listening at port
> 3306 but we need that the second one listen from another port in order to
> run in our loca
What is the best strategy to make mysqld listen from another port than 3306
?
In fact we have 2 servers that handle mysql. The first is listening at port
3306 but we need that the second one listen from another port in order to
run in our local network IP Port Mapping
What is the simple way to
Hi Friends,
OS : Linux Redhat 6.2
Kernel version : 2.2.14-5.0
MySql version : 11.13 Distrib 3.23.36, for pc-linux-gnu (i686)
When I type mysql in the command prompt it is giving the error "ERROR
2002: Can't connect to local MySql server through socket
'/var/lib/mysql/mysql.sock' (111)"
There i
> Thats a pretty nifty speed. PHP have a considerable overhead compared to new
> versions of Java. (I use both languages... I prefer PHP for webpage
> generation, but Java for serverside applications)
And both have a significantly larger overhead than C. Have you tried Escapade? It's
a simple,
> I am hesitant to dig into C++ just to solve this problem, so I am as far as
> possible trying to solve the performance issues within Java and MySQL. I
> will probably rewrite the code countless of times just to see if I can do
> it, and last resort would be C++.
Why dig into C++? MySQL has a p
45 seconds to create 120 000 MyISAM table char rows?
Thats a pretty nifty speed. PHP have a considerable overhead compared to new
versions of Java. (I use both languages... I prefer PHP for webpage
generation, but Java for serverside applications)
I am hesitant to dig into C++ just to solve this
The amount of updates will vary from time to time. Sometimes I imagine there
will be 200-300 records to update, but for the most time maybe 10-50
records.
The mathematical system I will create is in a way recursive... You check
Record #1 - how many records in the database has similar values. Afte
On Monday 07 October 2002 11:09, John Jacques wrote:
> Hello, I have a few SQL books, but they only have simple SQL queries in
> them.
>
> I signed up with the list a few days ago and I have seen select
> statements that do amazing things. I went to the book store and they
> don't have any books w
Hello, I have a few SQL books, but they only have simple SQL queries in
them.
I signed up with the list a few days ago and I have seen select
statements that do amazing things. I went to the book store and they
don't have any books with these types of select statements in them.
Please let me
Hello everyone.
I'm working on migrating Oracle to MySQL 4.0.3
MySQL works on Redhat 7.3 and Pentium 550Mhz with 256 Mb RAM.
Our application need Transactions, so I decided to use InnoDB.
But, InnoDB is slower than I expected.
-
mysql> SELEC
This requires a similar function to Oracles decode. I do not know if MySQL
provides such a function.
Regards
Peter Goggin
- Original Message -
From: "Alex Shi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 6:47 AM
Subject: where clause question
> Hi,
>
> I
After I used the comment "mysqld",I used the "mysqladmin ping" comment,then the
following infomations appeard(c:\mysql):
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the p
Is it possible to do a "show tables" similar to a select statement
where ...
similar to: select field where anotherfield like "ABC%" gives matches
for all "field" which begins with ABC
I'd like to say
show tables like "ABC%"
ie. to get a list of all tables whose name begins with ABC.
Than
hi list,
Does anyone has experient in analyzing MySQL traffic? Is there any
method/tool to know how frequent a particular table is accessed / which
table is heavily used / which is the table that causing speed bottle neck
and et cetera.
Thanks.
Chee Peng
Hi folks!
I have just installed mysql version 3.23.49! It's all ok!
I have setted error message to be shown in portuguese language! But i
cannot write (using mysql client) any query that uses special portuguese
character, any advice?
Of course, my charset is already setted to latin1.
--
I'm a newbie, so thanks for any help.
Running RedHat Linux 7.3 - Apache - MySQL & scripting
with PHP on an Intel box...
Question 1:
I want to print a specified field or fields, in
specified records to the line printer several times a
day...
Can anyone get me started on the PHP script to do
this
Hi,
I'm trying to insert some data into a MySQL table and I'm just not getting
it to work. It's not a problem with the connection with the database because
I get to SELECT and show the data, but when I try to INSERT or UPDATE any
record, nothing happens...The weird thing is that it doesn't appear
Hi
Just did a quick test using phpMyAdmin
INSERT INTO `db`.`speedtest` SELECT * FROM `db`.`table1`
These are just standard MyISAM tables
The query creates about 120,000 rows and 5 indexes on CHAR fields in 45
seconds so you should be fine if MySql does the work. If you have a lot of
Java manip
> I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run
> queries on datasets of 220,000
>
> SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time
> than I can count (0.1 sec at a guess)
>
> The insert/update bit is the bit which will dictate the speed - how
Hi
I am running php/mysql on 2x PIII 1 GHz / 512MB RAM / SCSI and can run
queries on datasets of 220,000
SELECT * FROM `Tablename` WHERE `Prod_code` LIKE 'A43611109%' in less time
than I can count (0.1 sec at a guess)
The insert/update bit is the bit which will dictate the speed - how many
reco
Hi,
I need a where clause in following situation:
Say I want to query two tables: A and B. In table A there is field Afn,
while in table B there ere 3 fields: Bfn1, Bfn2 and Bfn3. I want to
compose a query, in which the where clause can do this:
if A.Afn=1, then check Bfn1,
if A.Afn=2, then c
Hello,
I'm having problems compiling the C++ mysql api on linux, here's the
output:
automake
automake: Makefile.am: required file `./INSTALL' not found
automake: Makefile.am: required file `./NEWS' not found
automake: Makefile.am: required file `./COPYING' not found
automake: Makefile.am: requir
Hello,
I just added a user called "our_guest" to our mysql database, and the user
should be able to log on through a jsp page
I *can* log our_guest into MySQL from a command line.
But the user cannot log on via the www. The SQLException thrown is
java.sql.SQLException: No IP restriction
Mysql - how many tables will it handle?
I currently have no access to docs, so forgive me as I'm sure it is
documented.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.c
My query is:
SELECT id, title_analytic, date, keyword_article, author_article, keyword,
name
FROM Article, Years, Keyword_Info, Keywords, Author_Info, Authors
WHERE Article.id = Keyword_Info.keyword_article
AND Article.id = Author_Info.author_article
AND Article.date_of_pub = Years.yearsid
AND Ke
I would agree, storing credit card numbers on a database such that they can
be used by an automated system (without manual intervention) is a serious
risk. Unless you are operating an EXTREMELY secure server with good
firewalls and the bare minimum of shell access I would have second thoughts.
I
On Sunday 06 October 2002 23:05, Sergey S. Kostyliov wrote:
> On Sunday 06 October 2002 22:04, Stan P. van de Burgt wrote:
> > So, a fix to this MySQL bug anyone??
>
> I don't think this is a mysql bug.
> I'm personaly solve this problem by just glibc downgrade
> E. g. RedHat-7.3.
>
> wget ftp://
On Sunday 06 October 2002 22:04, Stan P. van de Burgt wrote:
> So, a fix to this MySQL bug anyone??
I don't think this is a mysql bug.
For me it seems like a bug in a RedHat patch to glibc.
Btw mysql binary packages are not affected.
(IIRC they are staticaly linked against mysql team homemade
gli
At 11:21 AM 10/06/2002, David Gerler wrote:
>Hi,
>Can someone give me an overview
>of protecting the numbers with mysql and SSL? Will the SSL protect the
>numbers when they are stored on the site? Or just when they are
>transmitted? Should I use something like PGP to encrypt the numbers
>before st
Hi,
I am working on an application that will need to store users CC
numbers so that they can be charge once a month and to verify
identity. My question is: I am in process of getting an SSL, but my
experience with SSL is none existent. Can someone give me an overview
of protecting the numb
So, a fix to this MySQL bug anyone??
- Stan
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTEC
corereader contains safeguards to prevent updates,
but its design helps quick development of queries
such as yours. you can do a multiple join with
multiple selects just by pointing and clicking to
try out various ideas.
it's free at http://corereader.com/
it installs at the novice skill l
Hello all,
On Saturday Sun, 6 Oct 2002 11:27:29 +0200,
Stan P. van de Burgt wrote:
> >Description:
> if I access the mysqld locally, all is well, but if I access it
> from outside (i.e. not over the 127.0.0.1 interface), the daemon
> hangs and restarts.
>
> Could this be the result of a run of
Hi, I need some help with Mysql on OSX 10.2.1
I get this error
phpBB : Critical Error
Could not connect to the database
I created a database with nothing inside " phpbb "
I set all the users with passwords and used
default user: root and local host and I get that error
I have not created any
What is the best strategy to make mysqld listen from another port than 3306
?
In fact we have 2 servers that handle mysql. The first is listening at port
3306 but we need that the second one listen from another port in order to
run in our local network IP Port Mapping
What is the simple way to
He is replacing *2* P3/1GHz by *1* P4/1.7GHz, I just wanted to point
out that it doesn't look so much like an "upgrade".
And, you know, not all webservers need the same amount of power.
The main "webserver" I manage is actually a cluster of 6 load-balanced
Apache/mod_perl front-ends with a dedica
I found the following statement in my mysql.server script, and I changed it
back to default... (the howto at tldp.org had me put this in, and I had
forgotten about it)
$bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --bind-address=
127.0.0.1 &
$bindir/safe_mysqld --datadir
> -Original Message-
> From: Robert H.R. Restad [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, October 06, 2002 9:04 AM
> To: James Riordon; [EMAIL PROTECTED]
> Subject: RES: Re: Server comparison running Mysql
>
> Another thing... I noticed once when I moved a website from one server to
> ano
http://www.php.net/manual/en/ref.mysql.php
- Original Message -
From: "Vinod Bhaskar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 06, 2002 3:56 AM
Subject: How to connect web database from Local machine
> Hi all,
>
> I am having MySQL database on web. (eg., at www
After giving up MySQL installation with the RPMs I am now wanting to freshly install
MySQL 3.23 (the latest) on my SUSE 7.3 Linux machine. I am a sort of newbie to Linux
also. On p.98 of the Widenius MySQL reference manual I am suppose to do this;
Add the full path;
/usr/local/mysql/mysql/bin
Hi James,
What kind of disks are in the old system and the new system (scsi or ide,
any raid, what rpm do they have etc..?) I ask this because high cpu levels
can be a symptom of a diskbound server...
Try running the following:
iostat -x 5 5
vmstat 5 5
Let me know & I'll try to help.
Cheers
I am writing a serverside application in Java which needs to query/search
200 000 rows and update affected records once every 2 minutes.
As performance/speed is of importance here - and this Table only contains
5-10 Columns of Integer numbers, I figured that using a HEAP type of table
would be t
>Since it seems that your new box is limited by the CPU, the conclusion
>seems that your old 1GHz biprocessor had more horsepower than the new
>single 1.7GHz processor.
>
>Have you replaced a dual PentiumIII by a single PentiumIV ?
>Some benchmarks show that a 1.7GHz PIV performs only marginally b
Maybe P4 1,7 mhz performs marginally better than a P3/1000Mhz, but ...
My webserver have a P3/450Mhz with 384 MB Ram and a 10 Gb IDE drive :P I
cant seem to get above 1.0 load average on the machine on normal use (I have
average 10-30 people online simultaneously 24 hours a day). The machine runs
Hello James.
What first occurs to me... did you install the two systems independently, or
did you simply copy/paste the compiled apache/mysql/php files/directories?
.. Stupid question, but you never know. At first this performance breach
seems to me like incompability between the different amount
Hello,
Since it seems that your new box is limited by the CPU, the conclusion
seems that your old 1GHz biprocessor had more horsepower than the new
single 1.7GHz processor.
Have you replaced a dual PentiumIII by a single PentiumIV ?
Some benchmarks show that a 1.7GHz PIV performs only marginally
Hi all,
I am having MySQL database on web. (eg., at www.lmcr.net). What is the PHP
script which I can connect the MySQL table from my Local machine. Can
anybody help me.
Regards,
Vinod.
-
Before posting, please check:
ht
Hi Friends,
I am having a local MySQL database & tables in Linux and the data is
updated in the table using PHP scripts working through apache web server.
local MySQL database is connected using the following php scripts.
mysql_connect("localhost","root","vinodb")
or die ("cannot connect to m
Okay, I'm very sorry for bothering you all with this. If I had not panicked,
I probably would have found it myself.
The solution was right under my nose :
http://www.mysql.com/doc/en/perror.html
even tough perror doesn'"t work on my macosx machine, the above webpage
states nicely that errno 13
Okay, I'm very sorry for bothering you all with this. If I had not panicked,
I probably would have found it myself.
- Original Message -
From: "jeroen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 06, 2002 9:23 AM
Subject: need urgent help recovering after renistall
>Description:
if I access the mysqld locally, all is well, but if I access it
from outside (i.e. not over the 127.0.0.1 interface), the daemon
hangs and restarts.
Could this be the result of a run of RedHat up2date which placed a new gclib?
>How-To-Repeat:
[root@liz root]# mysql -h liz -u mysel
1. MySQL storeed data in where you put Mysql
server/data/. Format data file.myi, file.myd, file.frm
2. yes
rgds,
d34dflowers
--- Chris Couture <[EMAIL PROTECTED]> wrote:
> 1 - Where does mySQL normally store it's data base
> files?
>
> * From what I have seen, it depends on how you
> in
Another in my hopefully-sparse-enough tedia2sql announcements.
tedia2sql now supports MySQL and one-to-one relationships thanks to the
international nature of the internet (Thanks, Martin).
What is tedia2sql? You create your database diagram (ERD) in Dia using the
UML shapes. Then you run tedia2
Maybe you didn't specify the correct data-dir in my.cnf?
Thomas
sql,query
On Sun, 6 Oct 2002 09:23:51 +0200 "jeroen" <[EMAIL PROTECTED]> wrote:
> hello,
>
> I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
> installed a new system (I'm running on MacOSX, was 10.1.
hello,
I'm kindof a newbie with MySQL, and recently did something fairly stupid : I
installed a new system (I'm running on MacOSX, was 10.1.5.1, now after
upgrading it is 10.2.1) and I did not properly do it I'm afraid : I backed
up my /usr/local/var directory which contained all my mysql 3.23.28
63 matches
Mail list logo
