Hi. Here is the An-san City of the South Korea.
We are the company which is developing the programs – ERP(ENTERPRISE RESOURCE
PLANNING) and has been concerned with MY_SQL DATABASE.
Recently, we suggested to the client of Korea that we want to develop the
programs(ERP, MIS, MRP) with adapting
Hello all,
I just ordered a new server to act as a database-only server for my website
(wheresgeorge.com). I'm currently running mysql 3.22.29 (I'm stuck there due
to my web hosting provider). I plan to upgrade to the latest stable version
of mysql, but have the following questions about the
I'm pulling my hair out about a query that should be simple. I have a
table "members" with columns id, group_id, and a few more that aren't
important here. group_id refers to another row in the same "members"
table, but not all members have a group_id. What I want to do is
select, for a particu
I run a site that gets a LOT of traffic and uses mySQL. But for some reason,
mySQL is making MAJOR load on my server. I have tried it on several servers,
and they all end up with load averages like 10+! We have optimized our code
as much as possible and STILL are getting super high loads! Is ther
> I am looking to update a record in a table, but take the
> exsisting value and adding the new value to it...
>
> I.e.
>
> Exsisting record = 150, new record being inputed = 250 for a
> total of 400 to be entered into the database.
UPDATE table SET row = row + 250 WHERE id = #;
---
> > regarding mysql_pconnect() we haven't tried that, but the nature of
> > the site suggests it would need like 500 apache deamons connected
> > all the time. And that's a lot of sort buffers and stuff beeing
> > allocated for each one of those ?
Not if you disable keepalive requests, which I do
- Original Message -
From: "Johan Wahlström" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, December 29, 2001 2:39 AM
Subject: Re: Most Performance, Opinions ?
> Hello!
>
> Can I actually turn off locks all the way, so that updates never locks
> a MyISAM table at all ?
>
>
I am looking to update a record in a table, but take the exsisting value and
adding the new value to it...
I.e.
Exsisting record = 150, new record being inputed = 250 for a total of 400 to
be entered into the database.
I have looked at the man pages on this but all it gives is static numbers,
Hi, all
When I query data from a table ,the following error occurs:
ERROR 1030: Got error 127 from table handler.
Would you please tell me the reason to cause the error and how to deal with
it?
Thank you!
-
Before posting, please
Hi.
My question is similar to yours in some ways,
perhaps we can help each other.
You say
> We need no transactions, or any data integrity at all. We can afford to
> loose some data in trade for performance. (like a few hours or something,
> which seems like a lot even if the replication whou
I need the collective experience & brains of the group for this one.
My app is a phone book -- I need to search by name, city, province, etc.
But there are over 22 million entries.
I like using compound indexes, but they make the database
VERY big, and slow to load. The last 2 million entries to
Hello!
I'm looking for opionions or advice about configuration options and
table type choices. We're into performance, we want to have the maximum
possible querys per/second, or as low resource usage as possible, for
the choosen codebase/system (linux+apache+php4+mysql).
Our primary (sql) server
You get quite a few examples with the documentation which is very good (I had
nil experience with SQL before reading the MySQL docs and had no problems
learning by it -- and I'm an learn-by-example man myself).
Plus I don't think I'm wrong if I say a Google search on "MySQL tutorial" will
return
> -Original Message-
> From: Peter Reck [mailto:[EMAIL PROTECTED]]
> Sent: Friday, December 28, 2001 3:31 PM
> To: [EMAIL PROTECTED]
> Subject: ODBC DRIVERS for MYSQL
>
>
>
> A newbie question:
>
> DESIRED FUNCTION:
> to import data from MySQL db to MS word through webquery
>
> ODBC
>
PROBLEM
there is NO SYSTEM DSN offered to add under the "add" button under the
"SYSTEM DSN" tab
After clicking the Add button under the System DSN tab,
you scroll to and select "MySQL" then continue.
Xi2
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: Friday, Dec
A newbie question:
DESIRED FUNCTION:
to import data from MySQL db to MS word through webquery
ODBC
I was guided to install myODBC by going to
http://www.mhysql.com ---> downloads ->API's -->MyODBC
myODBC 2.5.39 DOWNLOADED, UNIZPPED AND INSTALLED
I was told to add a NEW SYSTEM DSN for M
I just added a fulltext index to a table, and MATCH queries on the table
are timing out. Can anyone offer any insight on this?
The table has 2000 rows of data in it, and phpMyAdmin reports it as
having a total size of 244,228 bytes.
Table Structure:
CREATE TABLE Customers (
ID mediumint(9) NOT
seem to be half remembering hearing somewhere that when Access opens a form
(from any database, be it a jet database or MySQL linked via ODBC) it pulls
down all the records that the form may want to look at as opposed to the one
record you are looking at. Is this correct?
If so can some one poin
I'm new to mysql and have gotten most things to work satisfactorily thus
far. One of the things that is stumping me at the moment is how to
perform queries using joins and how to optimize them for speed.
the query is structured as follows:
SELECT products.return
FROM products,prodcat
WHERE pr
> related question:
>
> Does MySQL label as "slow" (as I believe PostgreSQL does) any
> query that is
> not referencing an indexed table?
No. Any query that takes longer than long_query_time,
e.g. 10 seconds on most systems, to execute.
Use SHOW VARIABLES to see it.
/ Carsten
--
Carsten H. P
related question:
Does MySQL label as "slow" (as I believe PostgreSQL does) any query that is
not referencing an indexed table?
-Original Message-
From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 28, 2001 2:42 PM
To: Jurrien Wijlhuizen; [EMAIL PROTECTED]
Sub
> Hi all,
>
> For a few month I was using mysql-3.23.39 without any problems but
> today the load went up to 25 and higher. I've tried some finetuning
> (like shorten timeouts to 5 minutes) and upgraded to mysql-3.23.46 but
> in vain. Still after a few minutes the load is back to 25 and this is
>
The Compaq CC compiler (V6.4) has slightly different prototype for strtoll
than does the version with mysql. The difference is not that big and would
not affect to execution but the compiler thinks this as a bad thing and
gives You an error.
I've included the global.h with a fix to this problem.
Hi.
On Fri, Dec 28, 2001 at 01:14:00AM -0600, [EMAIL PROTECTED] wrote:
> In the last episode (Dec 28), Benjamin Pflugmann said:
> > On Thu, Dec 20, 2001 at 09:19:00AM +, [EMAIL PROTECTED] wrote:
> > > I've seen various bug reports for mysql 4.0.1 but no sign of it on
> > > the site. Has it be
In the last episode (Dec 28), Goran Krajacic said:
> How to optimize this query:
>
> SELECT col1, col2, MAX(col3) FROM Table WHERE col4>2 AND col5 = 2 GROUP BY col3
>LIMIT 1;
Try a compound index on (col5,col4), or if you really want speed,
(col5,col4,col3,col2,col1), which will let mysql use t
Hi,
I'm trying to install DBD::MYSQL on Windows 2000 Pro.
I've already install DBI
Using ppm for ActivePerl
I downloaded DBI and extracted it to a folder.
Then i ran
ppm> intall DBI
It installed fine.
I did the exact same thing for DBD::MYSQL but i get the following error
Error: Package 'DBD
forgive the newbieness of this question, but is there some example databases
to play with on mysql?...sort of like the northwind traders example database
for m$ access...i have only been playing with mysql for a couple of days,
and so far impressed overall, but the easiest way for me to learn thin
How to optimize this query:
SELECT col1, col2, MAX(col3) FROM Table WHERE col4>2 AND col5 = 2 GROUP BY
col3 LIMIT 1;
The best that i figured out is to set the index on col3.
I was unable to find out the working combination for multi-column indexing.
Please advice.
Matt,
Being that I am a PHP developer, the answer is right there in front of you.
Since you are getting the member_id after you insert the first bunch of
information, the best way you can do this in my experience is to create a
search group and reference the information that you just got, so you
Hi all,
For a few month I was using mysql-3.23.39 without any problems but
today the load went up to 25 and higher. I've tried some finetuning
(like shorten timeouts to 5 minutes) and upgraded to mysql-3.23.46 but
in vain. Still after a few minutes the load is back to 25 and this is
the output of
Hello,
Forgive me for what is probably a fairly novice question as I am still
fairly new to MySQL. I have constructed the following database with
three tables:
CREATE TABLE members (
member_id int DEFAULT '0' NOT NULL AUTO_INCREMENT PRIMARY KEY,
first varchar(20) NOT NULL,
last varchar(20)
You can see if you're allowed to create Berkeley and InnoDB by using the
"show variables" command.
Just I guess, but the rpm's probably aren't configured for Berkeley and
InnoDB tables. You're probably going to have to download the tarball and
configure it yourself.
If you'd like I can send you
Run the following query:
SHOW VARIABLES LIKE 'have_%';
You should see something like this:
+---+---+
| Variable_name | Value |
+---+---+
| have_bdb | NO|
| have_gemini | NO|
| have_innodb | YES |
| have_isam | YES |
| have_raid | NO
Hi!
On Dec 28, Ken Kinder wrote:
> This is getting really annoying. No matter what type of table I create, it
> ends up being MyISAM. I _must_ have at least transactions and foreign key
> support would be nice. Also, does anyone know how I can have transactions on
> create table statements?
T
with this code:
Query myQuery = pDatabase->query();
myQuery << "Select * from repdata";
myQuery.store();
I get an
Debug Assertion Failed
in file dbgheap.c
line 1017
Expression: _BLOCK_TYPE_IS_VALIDE(pHead->nBlockUse)
pDatabase is a pointer to a connection object.
I am connected to the database
I am using the RPM's, but it didn't give an error so I'm assuming it is
properly configured. The MySQL version is:
[ken@ken ken]$ mysql --version
mysql Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)
Sorry -- I should have included that.
I'm assuming there's something wrong with my syntax
Ken,
When you configured/compiled MySQL, did you use the --with-innodb option?
What version of MySQL are you running?
FWIW, I wasn't real impressed with the Berkeley tables, but the InnoDB
tables work very well.
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Ken Kinder [mail
This is getting really annoying. No matter what type of table I create, it
ends up being MyISAM. I _must_ have at least transactions and foreign key
support would be nice. Also, does anyone know how I can have transactions on
create table statements?
Here the interaction with MySQL that is dri
Hi!
InnoDB is a table type which provides transactions, row level locking, and
foreign key constraints to MySQL.
InnoDB is included in all versions of MySQL-4.0 and in MySQL-Max-3.23.
InnoDB in MySQL-Max-3.23.47 is identical to MySQL-4.0.1
Changes from 3.23.46:
* InnoDB allows now several s
BSi;
Yes, you are correct.
I think you found an important behavior in MySQL. Whether it is a bug or a feature
depends on what the developers choose
to do. If they revise the manual, it must be a feature. ;-)
I think MySQL evaluates your original SELECT statements like a 'short-circuit OR': As
I'm Sorry if this question has been posted often.
but i cannot find answer.
I have installed openssl and MySQL 4.0.1 with --with-openssl --with-vio
And...
mysql> SHOW VARIABLES LIKE '%ssl%' ;
+---+---+
| Variable_name | Value |
+---+---+
| have_openssl | YES |
On Friday 28 December 2001 10:18 am, Steve Rapaport wrote:
> I didn't think it was possible to put arbitrary mysql commands like SHOW
> MASTER STATUS into a script. ?I had assumed I was limited to the
> shell-level utilities like mysqlimport and mysqldump.
> How exactly do I put the
> interactiv
>Description:
This is on a 4.01 server. That is a slave of a 3.23.44 server. Below
is the log file from the crash.
011228 09:18:09 mysqld restarted
011228 9:18:09 InnoDB: Started
/usr/sbin/mysqld: ready for connections
011228 9:18:10 Slave: connected to master '[EMAIL PROTECTED]:3306',
rep
>>How do we automatically know the master has failed and record that offset?
>>
>
> You need to have your system set up in such a way that failover event will
> trigger the execution of a script, which will do all the magic.
Good idea!
I didn't think it was possible to put arbitrary mysql com
.
So, as there's no way of making MySQL read data in MS Access Object, is
there a way to avoid stupid PopUp forms asking for confirm to an "Action
Query"?
.
From a Macro:
SetWarnings False
From VBA:
DoCmd.SetWarnings False
-
Hi!
MySQL 3.23.47 is now released.
This is a minor bug fix release.
If you have not hit any of the listed problems, you only have to
consider upgrading if you are using replication and the RELEASE_LOCK()
command. In this case you should either upgrade just the slaves or the
master and the slave
Thanks to all who have helped me with my mySQL questions. I think I'm getting the
hang
of it now.
I do have another question. How can I join more than two tables? I have two mySQL
books and neither give examples, they just say it can be done.
I have floating numbers in my tables. I want t
I mistakenly set the value of a DATETIME column to the value of
UNIX_TIMESTAMP(). I know that this is not good practice and I would have even
expected it to fail.
But what has happened was totally unexpected for me, invalid date values like
'2000-10-09 55:17:71' were inserted. As I could not set
hi
could anybody give me a hint what a "table is full"-error on an InnoDB-Table
means?
I had converted some MyISAM-Tables (about 300.000 rows each, 10-23 columns
of different integer-types, 3-6 indexes) on a test-system because i hoped for
better performance since i have lots of updates and reads
Hi,
I have a table that has now reached 4gb but I thought that shouldn't be a
problem since the table is running with raid. I noticed that the Datafile
length has reached the Max Datafile length and I tried to increase it with
myisamchk -r --data-file-length=8589934588 with no success. Do I need
> > Here is how you can do the above:
> >
> > * make sure slave runs with log-bin.
> >
> > * before you direct updates to the slave, record the binlog offset and
> > position on the slave by running SHOW MASTER STATUS ( on the slave not on
the
> > master!)
>
>
> Whoops! When the failover
Hi there,
I've been trying around for some time now and i just don't see a solution to
my problem:
I have a table called "feiertage" ("Holidays"):;
mysql> select * from feiertage;explain feiertage;
++
| datum |
++
| 2001-12-24 |
| 2001-12-25 |
| 2001-12-26 |
| 2002-0
Banach, Timothy P writes:
> > Hello,
> >
> > Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the
>documentation apply equally to HEAP tables in v. 4.0?
> >
> > Or, rather, if memory and address space were unlimited, how large could a heap
>table possibly be in v. 4.0?
>
> Hello,
>
> Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the
>documentation apply equally to HEAP tables in v. 4.0?
>
> Or, rather, if memory and address space were unlimited, how large could a heap table
>possibly be in v. 4.0?
>
> TIA
>
> Tim Banach
> State Stre
Sinisa Milivojevic wrote:
>A.J. Bonnema writes:
>
>>Hi,
>>
>>I just download MySQL and MySQLGui. I got MySQL running and loaded with
>>some data, but MySQLGui refuses to work with the error I quoted in the
>>subject.
>>
>>The versionnumbers are: MySQL: 3.23.41-1, MySQLGui: 1.7.5
>>
>>Other prog
A.J. Bonnema writes:
> Hi,
>
> I just download MySQL and MySQLGui. I got MySQL running and loaded with
> some data, but MySQLGui refuses to work with the error I quoted in the
> subject.
>
> The versionnumbers are: MySQL: 3.23.41-1, MySQLGui: 1.7.5
>
> Other programs, like mysql commandline f
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> Trond Eivind Glomsrød writes:
>> >
>> > Yes, install gcc 2.95.2 or 3.0.3
>>
>> That is very much _NOT_ recommended. Both have serious issues, none
>> are compatible with the other libraries installed.
As long as you
> Hi
>
> I'm trying to use user variables such as @myvar within a query which I've
> got running perfectly on a 3.23.35a server , however, i can't get the same
> query to run on 3.22.32 server :(
>
> Does anyone know if 3.22.32 supports user variables ?
3.23.6 was the first version to support UDV
Is there any reason for mysqld processes not dying?
Any try to kill it result in a '' processes (accoarding to ps
aux). And what is a defunct process?
The kernel prints the message: "mm: critical shortage of bounce
buffers". Any ideia what is it´s relation with Mysql?
The machine has no spec
Hi
I'm trying to use user variables such as @myvar within a query which I've
got running perfectly on a 3.23.35a server , however, i can't get the same
query to run on 3.22.32 server :(
Does anyone know if 3.22.32 supports user variables ?
Thanks
Girish
-
Hello Caryen,
Thanks
ps -A | grep mysqld
shows no process running on that name.
but i did not get any errot on log files.
wiating for solution
thanks
-Sam
- Original Message -
From: Carsten H. Pedersen <[EMAIL PROTECTED]>
To: sam <[EMAIL PROTECTED]>; [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Hi,
I just download MySQL and MySQLGui. I got MySQL running and loaded with
some data, but MySQLGui refuses to work with the error I quoted in the
subject.
The versionnumbers are: MySQL: 3.23.41-1, MySQLGui: 1.7.5
Other programs, like mysql commandline find the socket no problem. What
can I
Steve, Doug & Gordan,
Thanks for taking the time to help me.
Billy
- Original Message -
From: "Steve Rapaport" <[EMAIL PROTECTED]>
To: "Billy Reed" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, December 28, 2001 2:17 AM
Subject: Re: MS Access to MySQL convert
> Instead of
Hi!
> "Benjamin" == Benjamin Pflugmann <[EMAIL PROTECTED]> writes:
Benjamin> Hi.
Benjamin> On Wed, Dec 19, 2001 at 05:03:25PM -0700, [EMAIL PROTECTED] wrote:
>> >Description:
>> This problem pertains to the Sun Solaris distributions, I have
>> not tried others. Description follows:
>> mysql
> i run mysql_insyall_db and when i started safe_mysql
If you were able to run mysql_instal_db, then mysqld
was already running.
> # ./safe_mysqld --user=mysql &
> [1] 19554
> # Starting mysqld daemon with databases from /var/lib/mysql
> 011228 12:32:19 mysqld ended
>
> mysqld.log shows
>
> 0
MySQL Manager,
http://www.mysqlmanager.com/
A lot of features including Export/Import Data,
Visual Query Builder, Extract/Print Metadata,
Syntax HighLight, BLOB Editor and so on.
HTH,
Vadim
- Original Message -
From: "John Mayson" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Hello All,
I am new to Mysql.
I installed Mysql-3.23.46 source in RedHat-7.1linux.
i run mysql_insyall_db and when i started safe_mysql
# ./safe_mysqld --user=mysql &
[1] 19554
# Starting mysqld daemon with databases from /var/lib/mysql
011228 12:32:19 mysqld ended
mysqld.log shows
011228 12
Dear Marek, Phillip and all,
Frist I would like to say thanks to Marek, Phillip and someone help me
before ! Finially, the server is running ( need to use the command
#mysql --host=192.10.0.113).
But I still have some question would like to ask, if you don't mind !
How I can set a different u
Hi Community!
I'm producing Databasedriven Webapplications here in Austria using
Databasesystems and PHP - sometimes even C++
So thats what my situation looks like!
One of the most interesting Databaseserver is MySQL ... It's quite fast ...
you can do nearly everything u can do with commercial Da
69 matches
Mail list logo