Hello everyone,
We are using MySQL as the database backend on quite a big portal
page with about 50.000 users and 3 mio. PIs per day. MySQL is as well the
backend for the (php) session management. We are using a heap for that case
as well as for instance phpbb does.
Lately we are experien
What is causing me to have this problem in "mysql Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it? My firewall, web, and mySQL server are the same
machine.
# telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to conne
ps ax|grep sql
if mysql is running. and if you telnet to that port (3306) and still you
can't connect.
check if you have blocked your port on your firewall.
usually, firewall for linux are iptables and ipchains
flush them first and try.
HTH
On 7/7/05, Daevid Vincent <[EMAIL PROTECTED]> wrote
Daevid Vincent wrote:
What is causing me to have this problem in "mysql Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it? My firewall, web, and mySQL server are the same
machine.
Shorewall can affect localhost as well
Try
Try
/sbin/iptables -L -n
make sure there's no rule that block connection to/from port 3306 (TCP)
Daevid Vincent wrote:
What is causing me to have this problem in "mysql Ver 12.22 Distrib 4.0.24,
for pc-linux-gnu (i686)". I am running shorewall, but that shouldn't affect
localhost should it?
Hello there,
I run MySQL 4.1.12 and have some databases with the default collation of
latin1_swedish_ci. I have edited the my.cnf file to read
default-collation = latin1_german1_ci
Now I would like to change the collation on all existing databases,
tables and columns to have the latin1_german1_c
Gleb Paharenko wrote:
Hello.
Setting master to 127.0.0.1 could produce a problem.
"MASTER_HOST and MASTER_PORT are the hostname (or IP address) of the
master host and its TCP/IP port. Note that if MASTER_HOST is equal to
localhost, then, like in other parts of MySQL, the port may be ig
Hi,
I want to buil a hierarchical database, with different kind of relations.
I have differents elements which are linked between them by different kinds
of relations.
Ex:
element 1 IS A element 72
element 22 IS PART OF element 36
I want to have a table "elements",for several reasons: I
Hello.
If you don't want to write a script (I think it shouldn't be difficult anyway)
for this purposes, you could use mysqldump with
--skip-create-options or --compatible=no_table_options,no_field_options.
Using this you could get the dump of you database and table definitions
without info
Hello.
Are you sure that your server doesn't swap? Providing output
of 'SHOW STATUS', 'SHOW VARIABLES' and your table definition
could give more information for suggestions. Also, if you have
a hash index on a MEMORY table that has a high degree of key
duplication (many index entries contai
Hello.
Are you sure that mysql is running? Is it possible that you have
skip_networking in your configuration file? See:
http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server.html
"Daevid Vincent" <[EMAIL PROTECTED]> wrote:
> What is causing me to have this problem in "mysql V
Hello.
I think you have a big fragmentation of your query cache. Fragmentation
can force the query cache to prune (delete) queries from the cache due
to lack of memory. See:
http://dev.mysql.com/doc/mysql/en/query-cache-configuration.html
Remigiusz Soko$owski <[EMAIL PROTECTED]> w
Hello.
In archives at:
http://lists.mysql.com/mysql
you could find a lot of questions about database design and
good answers with explanations.
"Monty Harris" <[EMAIL PROTECTED]> wrote:
> Dear Group,
>
> I have just completed the Sams MySQL in 24 hours and feel like I now have a
Hi list:
I don't know if this the right forum to ask the following questions:
Will MySQL production version 5.0 support grant in prepared statements?
The "yet" part is encouraging in "ERROR 1295 (HY000) at line 17: This
command is not supported in the prepared statement protocol yet"
Will prep
Hello yet again,
Thanks for the quick answer, Gleb! I am quite sure that the system
doesn't swap. I'll give the BTREE index a shot and I will let you know what
effect it had.
Here's a the free Output from one of the systems:
total used free sharedbuffers
I would like to thank you all for the help and the
explanations.
I think I'll stick to the option of having the
database behind the firewall. The problem is I don't
control that part of the company, as you can imagine
so I'll have to ask the network administrators for
that.
Just want to resume wh
Scott Haneda <[EMAIL PROTECTED]> wrote on 07/06/2005 08:16:41 PM:
> I am using 4.0.18-standard
> So I do not have `DATEDIFF`, but I need to ability to do so, anyone know
> some other simple trick to get days between two dates?
> --
> -
>
Hi,
I'm running out of resources even though I think I shouldn't.
The open_files_limit=256, max_connections=246, and table_cache=64 and
I'm trying to actively create 'Too many open file errors' with this
configuration, to be able to quantify the effect of raising the
filesystem's ulimit, and the
Hello.
I think such kind of logic could be implemented on database layer,
because the main task for you is to keep data integrity, and this was
one of the reason of database creation. However, without triggers your
task becomes difficult. Unfortunately they're available only in MySQL
5.xx, w
Dear list:
I am preparing an entity relationship diagram and encountered the
following problem:
The entity "individual" has the attributes firstname, lastname.
The entity "company" has the attributes name, companytype.
Now I wish to include the subtype "customer" with the attributes
taxid, billin
[EMAIL PROTECTED] wrote on 07/07/2005 11:22:52 AM:
> Dear list:
> I am preparing an entity relationship diagram and encountered the
> following problem:
> The entity "individual" has the attributes firstname, lastname.
> The entity "company" has the attributes name, companytype.
> Now I wish to i
IGNORE: test only since I did not get my last posting.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Kasthuri,
Maybe it's time to re-think your application architecture? A 200-meg
BLOB is quite large for a highly-concurrent system, considering that
MySQL will have to read/save it in its entirety _and_ allocate network
buffers for it, so essentially you're allocating _400_ megs or so
_per_
cl
Hi everyone,
My environment:
- Linux 2.6.7-1.7asp #1 Thu Jul 15 17:36:07 YEKST 2004 i686 i386 GNU/Linux
- server version: 4.0.13
I wrote a script-SQL like this:
#Begin of script-SQL
...
DATA_BEGIN=$1
DATA_END=$2
TIME_BEGIN=$3
TIME_END=$4
USER_NAME=$5
PRICE=$6
CUR_TABLE=acc_cur
TMP_TABLE=acc_tm
Dear Shawn,
Thanks for your reply.
I find that "individuals" and "companies" each have attributes that
are completely irrelevant to the other. E.g. "individuals" have sex
and language (so e-mail can be sent to them as "Dear Sir" or "Dear
Madam" in both English and Spanish). The only time they ha
Dear Shawn,
Thanks for your reply.
I find that "individuals" and "companies" each have attributes that
are completely irrelevant to the other. E.g. "individuals" have sex
and language (so e-mail can be sent to them as "Dear Sir" or "Dear
Madam" in both English and Spanish). The only time they ha
Can you help set me straight?
I recently upgraded from coldfusion 5 to coldfusion mx 7. In the process
I also switched from odbc to jdbc connections to mysql
(4.0.21-nt-max-log).
>From looking at the query log, I'm now getting...
SHOW VARIABLES
...once per connection
followed by...
Hello.
Your value 256 for open_files_limit is too low. Set it at least to
several thousands. See:
http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html
"Martijn van den Burg" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm running out of resources even though I think I shou
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daniel Gaddis wrote:
> Can you help set me straight?
>
> I recently upgraded from coldfusion 5 to coldfusion mx 7. In the process
> I also switched from odbc to jdbc connections to mysql
> (4.0.21-nt-max-log).
>
> From looking at the query log, I'm
Hi,
Still having difficulty with stored functions. I downloaded and installed
MySQL 5.0.7 and
I *still* cannot get stored functions to work.
I used the example for hello from section 19.2.1 of the online documentation
for MySQL and the example code doesnt work for me either.
Below are the
[EMAIL PROTECTED] wrote on 07/07/2005 01:57:33 PM:
> Dear Shawn,
> Thanks for your reply.
> I find that "individuals" and "companies" each have attributes that
> are completely irrelevant to the other. E.g. "individuals" have sex
> and language (so e-mail can be sent to them as "Dear Sir" or "De
At 11:41 -0700 7/7/05, Nic Stevens wrote:
Hi,
Still having difficulty with stored functions. I downloaded and installed
MySQL 5.0.7 and
I *still* cannot get stored functions to work.
I used the example for hello from section 19.2.1 of the online documentation
for MySQL and the example code doe
Alberto,
Persons and companies are distinctive entities, yes. Treating either as
if it were a subspecies of the other leads one into absurdities. Either
may be a customer, but neither need be. You haven't described the
problem context. Conceivably one or the other could also be a
contractor,
Nic,
At the end of the func, your sproc delimiter // needs to come before
restoration of the semi-colon as delimiter, thus:
DELIMITER //
CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50)
RETURN CONCAT('Hello, ',s,'!');
//
DELIMITER ;
PB
-
Nic Stevens wrote:
Hi,
Still having di
select count(*) from store group by orederId.
For the above sql, I am not getting the count of unique order ids..
help!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[snip]
select count(*) from store group by orederId.
For the above sql, I am not getting the count of unique order ids..
[/snip]
select orderID, count(*) from store group by orderID
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysq
select count(distinct ordr_ID) from store
-Original Message-
From: Gana [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 3:01 PM
To: mysql@lists.mysql.com
Subject: Count(*)
select count(*) from store group by orederId.
For the above sql, I am not getting the count of unique orde
Thanks to all for you help and time.
After reading to replies, I think that perhaps a clean way of dealing
with individual and company customers in a single table could be to
leave them out of the "parties" tree altogether and relate them to
the "parties" table without a generalization hierarchy
Thanks to all for you help and time.
After reading to replies, I think that perhaps a clean way of dealing
with individual and company customers in a single table could be to
leave them out of the "parties" tree altogether and relate them to
the "parties" table without a generalization hierarchy
Have you checked that the user failing to connect has the right privileges?
Check the user table of mysql database to see if that user has a select
privilege in that table.
Laurie
At 01:01 AM 7/7/2005, Daevid Vincent wrote:
What is causing me to have this problem in "mysql Ver 12.22 Distrib
Privet!
User with similar privileges successfully drops table on my MySQL 5.0.7:
mysql> drop table acc_tmp;
Query OK, 0 rows affected (0.01 sec)
mysql> show grants for current_user;
+-+
| Grants for [EMAIL PROTE
hi...
i'm considering an app where i'm going to parse a lot of colleges (~1000)
faculty information. would it be better to have all the faculty information
in one large table or would it be better/faster to essentially place each
college in it's own separate table, and reference each table by a
co
bruce wrote:
>hi...
>
>i'm considering an app where i'm going to parse a lot of colleges (~1000)
>faculty information. would it be better to have all the faculty information
>in one large table or would it be better/faster to essentially place each
>college in it's own separate table, and referenc
even though this might mean i get a table with 5 million records??? as
opposed to say a 1000 different tables, each with 50,000 records?
-bruce
-Original Message-
From: Daniel Kasak [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 07, 2005 5:34 PM
To: [EMAIL PROTECTED]; mysql@lists.mysql.
I would strongly recommend creating one table, with a column that stores
the college_ID for each faculty member, and a separate table to
correlate college name and college_id. For example...
Create table faculty (
last_name varchar(50),
first_name varchar(50),
college_id
as of now.. i've heard that there might be a file limit.. but given that i'm
using linux, i doubt it.. and if there is a limiit.. i'm sure it's a kernel
option that i can tweek...
in my app, i'm not worried about profs transferring between schools... that
data's going to be ptreety static, and sep
bruce wrote:
>even though this might mean i get a table with 5 million records??? as
>opposed to say a 1000 different tables, each with 50,000 records?
>
>-bruce
>
>
That's right.
Databases are made for this sort of thing.
If you have a separate table for each location, constructing queries to
p
You have not said what type of information you will be storing in this
database. Is it going to be just faculty information? Even if it is
just faculty information, you do realize that each school treats
departments a bit dfferently. The faculyt maybe under different
school, may specialize in certa
Hi there somehow my AS field alias of a sub query is adding a dot at
the start therefore I cant use it in my application.
(SELECT SUM(feed_usage.bandwidth) AS bandwidth FROM feed_usage WHERE
customerID IN (57) AND
DATE_FORMAT(feed_usage.stats_date,'%m%Y')=DATE_FORMAT(NOW(),'%m%Y') )
AS total_
Yes even I have problems working with stored procs without prepared
statements support.
It would be great if someone from MySQL team can tell if they have plans to
include prepared statements in stored procs in the production release of
MySQL5.0.
Regards
sujay
-Original Message-
From:
Hi everyone,
My environment:
- Linux 2.6.7-1.7asp #1 Thu Jul 15 17:36:07 YEKST 2004 i686 i386 GNU/Linux
- server version: 4.0.13
I wrote a script-SQL like this:
#Begin of script-SQL
...
DATA_BEGIN=$1
DATA_END=$2
TIME_BEGIN=$3
TIME_END=$4
USER_NAME=$5
PRICE=$6
CUR_TABLE=acc_cur
TMP_TABLE=acc_tm
Hi,
> Your value 256 for open_files_limit is too low. Set it at
> least to several thousands. See:
> http://dev.mysql.com/doc/mysql/en/not-enough-file-handles.html
Thanks for the link, I already knew of it ;)
It is low and I intend to raise it, but my operating system's ulimit is
still 256 at
52 matches
Mail list logo
