Hi all,
I'm going to run MySQL off a shared Unix server so I'm wondering what the
memory requirements are. I have about 15 tables are simple text columns
(~10 - 20 columns). The largest tables will be ~25MB.
I did a quick test on my Win32 Machine and the largest query only takes up
18MB of
Hello.
On Fri 2002-12-06 at 09:59:32 -0500, [EMAIL PROTECTED] wrote:
MySQL folks,
I have a server which handles hundreds of connections at a time typically.
Many of these are actually inserting data. It is currently configured as a
replication master. Let's call it A. The slave is currently
Hello.
On Fri 2002-12-06 at 14:57:00 -0500, [EMAIL PROTECTED] wrote:
Helmut,
I suppose that depends really upon the composition of your database.
That's completely true. On the data stored and how it is used,
i.e. what are common queries.
[...]
The only other thing that I
Use the CONCAT function
Adolfo
-Original Message-
From: tag [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 06, 2002 3:57 AM
To: [EMAIL PROTECTED]
Subject: select question
HI,
I need to do a select query that can do the following:
select * from table where col1 like
Has anyone used DBTools Software? (http://www.dbtools.com.br/EN/)
It is a free utility for managing MySQL other db's.
I also discovered Intelligent Converters at www.convert-in.com
Both look good.
The first is free and does more than convert Access to MySQL.
The second converts more stuff...
Hello.
On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED] wrote:
First off, we are using Innodb tables on version 3.23.53a-max.
If the command STOP SLAVE is issued in the middle of the following type of
transaction:
set autocommit = 0;
update...;
update...;
update...;
commit;
Hello.
On Fri 2002-12-06 at 11:46:16 -0500, [EMAIL PROTECTED] wrote:
From what I've been reading in the MySQL documentation, 3.23.43b
InnoDB features foreign key constraints, which is great! But from
the MySQL 4.1 wishlist items found here (scroll to the bottom):
Hello.
On Fri 2002-12-06 at 17:54:53 +0100, [EMAIL PROTECTED] wrote:
[...]
I have one question : if I go the RestTimes route, that is having a row per
day and so 7 row per restaurants : can I, in one SQL request, know if THAT
restaurant is open or close now ? I now there are NOW() function in
Hello.
On Fri 2002-12-06 at 09:59:25 -0800, [EMAIL PROTECTED] wrote:
Hi,
I just send this email again. Does anyone care about
HPUX build?
You need to be more specific in the future. That will enhance the
chance for someone seing the problem.
I have never used HP-UX. That said, some
Hello.
On Fri 2002-12-06 at 21:53:40 +0200, [EMAIL PROTECTED] wrote:
Lo all,
If I have a database with various tables, and I want to upgrade the tables
and the data in the tables, will it screw up the permissions assigned to
users if I use DROP TABLE / CREATE TABLE (to recreate the changed
Hello.
On Fri 2002-12-06 at 15:35:53 -0600, [EMAIL PROTECTED] wrote:
I am new to this list and have not been able to find an answer in the
searchable archive, So I am sorry if this question has been asked
before.
The documentation (section 4.10.7) mentions 2 way replication but does
not
Dear Andy,
There is no way I can make my client app regard é and É to be
identical, even if I want it to, even if it would seem logical to
you that it should be so. This cannot be changed. So, I'm now at a
loss as how to store and work with this in MySQL. I need to use
some of those
Hello.
On Fri 2002-12-06 at 14:32:13 -0600, [EMAIL PROTECTED] wrote:
after trying this it shows mysql as running, but /tmp/mysql.sock as
not being created. i stopped mysql and then started it again, and
the same thing happened...still no mysql.sock? should i just
reinstall? what is the best
Hello.
On Fri 2002-12-06 at 17:04:27 -0500, [EMAIL PROTECTED] wrote:
I have a large blob column with encrypted data and also i have other
non-blob columns. I get results when i do the following
Note: ID = non blob column
Select ID from table
i get records returned
when i select from
Hello.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
Heikki and all,
I've got a quick question which may be more general sql related but
since I'm using innodb tables specifically for the row locking.
The following process description is specifically designed to prevent
Hello.
On Sat 2002-12-07 at 14:26:00 +0100, [EMAIL PROTECTED] wrote:
Hello.
On Fri 2002-12-06 at 16:13:54 -0600, [EMAIL PROTECTED] wrote:
First off, we are using Innodb tables on version 3.23.53a-max.
If the command STOP SLAVE is issued in the middle of the following type of
Ç×°®µÄÅóÓÑ£º
ÄúºÃ£¡
ÕâÊÇÀ´×ÔÏÃÃÅÊÐӯͨԶº½µç×ӿƼ¼ÓÐÏÞ¹«Ë¾µÄÎʺ¸ÐлÄúÊÕ¿´Õâ·âÓʼþ¡£ÎÒÃÇÕæ³ÏµÄÏ£
ÍûÄúÄܳÉΪÎÒÃÇÔÚ¹óµØÇøµÄÖØÒª»ï°é¡£ÎÒÃÇÊÇÒ»¼ÒÖÂÁ¦ÓÚ»¥ÁªÍøÐÅÏ¢·þÎñ¡¢µç×ÓÉÌÎñ·þ
ÎñºÍÆóÒµÓ¦Ó÷þÎñµÄ¸ßм¼ÊõÆóÒµ¡£ÎÒÃÇÓÐ×ŶàÄê´ÓʲÙ×÷ϵͳµÄ¾Ñé,ÕâΪÎÒÃǵĿռä
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
Hello friends, newbie here.
1. I need to know if these features are supported or not by MySql ver 4.05a.
- Referencial integrity constraint
- Stored Procedure
- View
- Trigger
Please see
Hello.
On Sat 2002-12-07 at 04:04:04 +, [EMAIL PROTECTED] wrote:
Hi folks.
I have an application in which I require the only case equivalencies
to be a-z A-Z. What I mean is, e/E should be regarded as identical
in strings, but neither e/É (E-acute) nor é (e-acute)/É (E-acute)
should
Hello.
On Sat 2002-12-07 at 03:36:56 -0500, [EMAIL PROTECTED] wrote:
Hi all,
I'm going to run MySQL off a shared Unix server so I'm wondering what the
memory requirements are. I have about 15 tables are simple text columns
(~10 - 20 columns). The largest tables will be ~25MB.
You can
drop table if exists your_table;
create your_table (...);
-Original Message-
From: Peter Abilla [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 1:12 PM
To: [EMAIL PROTECTED]
Subject: Drop, Create. . .help
I want to do the following:
1-If table x exists, then
Benjamin Pflugmann wrote:
Hello.
On Fri 2002-12-06 at 10:28:23 -0600, [EMAIL PROTECTED] wrote:
Heikki and all,
I've got a quick question which may be more general sql related but
since I'm using innodb tables specifically for the row locking.
The following process description is
I am running MySQL 3.23.46 under Linux kernel 2.2.20 as the back-end of
an active website. On occasion mysql seems to stop responding. When I
log into the server one of the MySQL processes is consuming a
substantial amount of CPU resources (i.e. it is on the top of the list
when viewing the
I have successfully configured two mysql instances to replicate to each
other (According to /doc/en/Replication_Features.html, it is possible to
do it in a A-B-C-A relationship, but I only did it with two servers
and I don't have log-slave-updates on (I think if I did, it would
immediately stop
Hello.
On Sat 2002-12-07 at 10:36:00 -0600, [EMAIL PROTECTED] wrote:
[...]
Why do you repeat job_id = 111 and thread_id = 0? If you are using a
transaction seperation level of at least REPEATABLE READ (which is the
default), InnoDb assures that you always see the same rows within one
I have read 4.10.7 and the only caveat stated is that updates can occur
in different orders on the different servers. Each of my updates are
autonomous and that should not be a problem. Are there any other
gotchas I should be concerned about. I saw a posting the stated not to
turn on
Hello.
On Sat 2002-12-07 at 11:40:28 -0600, [EMAIL PROTECTED] wrote:
I have read 4.10.7 and the only caveat stated is that updates can occur
in different orders on the different servers.
I did not mean to discourage you from using two-way replication. I
just tried to explain (what I believe)
I have the binlog files stored to a separate drive (actually a partition on
a drive other than the raid array for the tables). When this partition
becomes full, mysql's load average goes from 1.5 to 25 and stays there until
more space is available on the partition that holds the binlog.
This
Hello.
On Sat 2002-12-07 at 12:09:44 -0500, [EMAIL PROTECTED] wrote:
I am running MySQL 3.23.46 under Linux kernel 2.2.20 as the back-end of
an active website. On occasion mysql seems to stop responding. When I
log into the server one of the MySQL processes is consuming a
substantial amount
Thanks Benjamin,
I found that kill -9 seems to be the only way to kill the hung process.
I'll see if I can find another way.
Here is the output of mysqlbug:
Submitter-Id: Paul Borghese
Originator:-
Organization:-
MySQL support: [none]
Synopsis: MySQL process hanging
Severity:
I have been learning a bit about the Perl DBI MySQL API. This API offers
several ways of fetching the results of a query. Among these,
fetchrow_array returns a numbered array, while fetchrow_arrayref returns a
reference to an array. When would you want to use a reference to an array
rather than
On Sat, Dec 07, 2002 at 02:08:28PM -0500, Amittai Aviram wrote:
I have been learning a bit about the Perl DBI MySQL API. This API offers
several ways of fetching the results of a query. Among these,
fetchrow_array returns a numbered array, while fetchrow_arrayref returns a
reference to an
At 04:22 PM 12/7/2002 +0100, Benjamin Pflugmann wrote:
Hello.
On Sat 2002-12-07 at 07:47:18 +0700, [EMAIL PROTECTED] wrote:
Hello friends, newbie here.
1. I need to know if these features are supported or not by MySql ver
4.05a.
- Referencial integrity constraint
- Stored Procedure
- View
Hi,
I used it for a while, it's quite good for free software, but it is rough
around the edges. Some of the menus are a bit hard to navigate and it
crashes once in a while too.
I'm currently using EMS Hitech's MySQL Manager. It's one of the best GUI's
I've come across. There are a couple
I would like to lock a specific record in a MySQL table so that no other
user can update it while another user is is update the record via the
user interface. Can someone please tell me the easiest way to do this?
Thank you,
Richard Reina
Greetings...
Are you using Windows to connect to the MySQL. Then you can try SQLyog at
http://www.webyog.com/sqyog/download.html It will help you a lot in these
works and you dont have to write queries also.
Rgds
Insane
- Original Message -
From: Padma kuruganti [EMAIL PROTECTED]
To:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 6 Dec 2002, Mariella Di Giacomo wrote:
I have been running MySQL 4.0.5 64 bits on a Sun sun4u sparc
SUNW,Sun-Fire-880, Solaris 2.8.
I have been using the binary version that MySQL provides.
Yesterday I have downloaded the Solaris
Dear Benjamin, dear Michael,
1. I need to know if these features are supported or not by MySql ver
4.05a.
- Referencial integrity constraint
This is supported with InnoDB tables. If you _always_ need referential
integrity, simply set InnoDB tables as the default table type in my.cnf /
Hi,
I wrote an application using mysql C API.
If I exit my application without closing database, will it be closed automatically?
void error(int code) {
printf(error: %d\n, code);
exit(0);
}
int main() {
...
error(-255);
...
}
How to pass the mysql database connector to a function? is
I have used a database creation script for months under 3.23.53a.
Now, I want to upgrade to version 4.0.5 and the script doesn't work. The
first table is created but mysql complains with:
Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm
(errno:150)
= = = SCRIPT TO TRY = = =
I'm just getting into MySQL and have discovered two tools so far...
- DBToolsFreeware www.dbtools.com.br/EN/ Manage
MySQL Convert Access
more
- Intelligent Converters Shareware www.convert-in.com Converts from
Access,
Excel more
At 14:37 -0800 12/7/02, Admin-Stress wrote:
Hi,
I wrote an application using mysql C API.
If I exit my application without closing database, will it be closed
You don't close a database. What do you mean? Do you mean close
the connection to the server? If so, exiting without closing is the
At 18:50 -0500 12/7/02, Will Standley wrote:
I'm just getting into MySQL and have discovered two tools so far...
- DBTools Freeware
www.dbtools.com.br/EN/ Manage MySQL Convert Access
more
- Intelligent Converters Shareware www.convert-in.com
Converts from Access,
Excel more
Please
Hello:
We are running a large e-commerce site currently with ASP/MSSQL. The ever
increasing number of hits, complexity of the site and request for reporting
is slowly but surely bringing us to the point were the current database
application is getting tired.
Now we're thinking Linux, MySQL and
Thank you all for your input.
I've gathered the information I need to start with.
thank you again
--- Benjamin Pflugmann [EMAIL PROTECTED]
wrote:
Hello.
On Fri 2002-12-06 at 14:57:00 -0500,
[EMAIL PROTECTED] wrote:
Helmut,
I suppose that depends really upon the
composition of
Hello.
On Sat 2002-12-07 at 14:15:59 -0800, [EMAIL PROTECTED] wrote:
I would like to lock a specific record in a MySQL table so that no other
user can update it while another user is is update the record via the
user interface. Can someone please tell me the easiest way to do this?
Depends
Hello.
On Sat 2002-12-07 at 18:20:07 -0600, [EMAIL PROTECTED] wrote:
Hello:
We are running a large e-commerce site currently with ASP/MSSQL. The ever
increasing number of hits, complexity of the site and request for reporting
is slowly but surely bringing us to the point were the current
I finally found the solution :
I had bad old include files in
/usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.2/include/
that come from a old gcc installation.
I removed them and now it's ok.
Pierre.
On 2002.11.13 06:50 Pierre wrote:
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with
Hi,
I try to compile mysql-3.23.53 on my GNU/Linux system with gcc-3.2
there was no problem with the configure, but for the make I got this :
[...]
gmake[3]: Entering directory `/tmp/mysql-3.23.53/sql'
g++ -s -DMYSQL_SERVER
-DDEFAULT_MYSQL_HOME=\/usr/local\
-DDATADIR=\/usr/local/var\
I'm using Phpadmin to add these fields with these values, and it keeps
crashing...what am I missing?
-Deepak
Error
SQL-query :
CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(dsuthar)
NOT NULL, `user` VARCHAR(dsuthar) NOT NULL, `select_priv` VARCHAR(Y) NOT
NULL,
On Sat, 2002-12-07 at 21:50, Deepak Suthar wrote:
I'm using Phpadmin to add these fields with these values, and it keeps
crashing...what am I missing?
-Deepak
Error
SQL-query :
CREATE TABLE `db` (`host` VARCHAR(localhost) NOT NULL, `db` VARCHAR(dsuthar)
NOT NULL, `user`
Hey everyone,
Ok if I issue this command:
mysql grant select,insert,update,delete,create,drop
- on *.* to someusr@% identified by 'passwrd';
I already know that this statement creates the user someusr w/ password=passwrd
and it can connect from anywhere. What I don't know: Can this user now
At 21:39 -0800 12/7/02, Ryan McDougall wrote:
Hey everyone,
Ok if I issue this command:
mysql grant select,insert,update,delete,create,drop
- on *.* to someusr@% identified by 'passwrd';
I already know that this statement creates the user someusr w/
password=passwrd
and it can connect from
53 matches
Mail list logo