Hi everyone! I recently bought Mr. DuBois' MySQL book and got through the tutorials
just fine. Since I wanted to venture into the wild without the help of the tutorials,
I decided to make a project of my own.
I have a guitar magazine collection with song transcriptions and all; I own around 60
Mike, what version of MySQL are you running?
A month ago or so, I tried 4.1alpha on a FreeBSD4.8 machine and noticed the same
thing you are describing. I had a bunch of threads inserting on a MyISAM table and
the threads would just wedge. They'd show up in SHOW PROCESSLIST and wouldn't
respond to
Thanks, that did the trick :)
>> Jeremy Zawodny wrote:
On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote:
Hello,
Happy 4th to all :)
Anyway, I am attempt to temporarily disable InnoDB tables. We just
setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13
from RPM's, pre
On Wed, Jul 02, 2003 at 10:57:18AM -0500, Roy W wrote:
> Is there a simple MySQL command that will give a Row Count (# of records)
> WITHOUT running a select (huge database)
If it's a MyISAM table, just run a SELECT COUNT(*) FROM table_name.
It's really efficient. Try it. :-)
--
Jeremy D. Zawodn
On Fri, Jul 04, 2003 at 07:26:54PM -0500, Mike Blezien wrote:
> Hello,
>
> Happy 4th to all :)
>
> Anyway, I am attempt to temporarily disable InnoDB tables. We just
> setup on a new RH/Linux 7.3 server that had the MySQL version 4.0.13
> from RPM's, pre-installed... but we currently don't need t
Hello,
Happy 4th to all :)
Anyway, I am attempt to temporarily disable InnoDB tables. We just setup on a
new RH/Linux 7.3 server that had the MySQL version 4.0.13 from RPM's,
pre-installed... but we currently don't need the InnoDB tables but may in the
near future... I've commented out all the
Hello!
I have a problem with linking a program coded in C language (Visual C++). I am using
a libmySQL library and while linking the program I get an error message. I can't even
link an example code delivered with MySQL base. If someone had a similar problem and
could help me, I would be very
Arkadiusz-
Could you post the code..Many of us would like to compile and link it..be
aware that you cannot use the Microsoft linker to link against linux libtool
*.libs..It is always best to compile all of the code on your target
platform; create a library and then link against it
Brak Danych!
Mart
I use mytop. The only thing that I see is x "insert" queries all trying to
insert to the same table. Killing the oldest query doesn't help, in fact
killing any or all of them doesn't do any good either (they just appear to
get "marked" as killed).
Note that the table that they're waiting for is
Hello!
I have a problem with linking a program coded in C language (Visual C++). I am using
a libmySQL library and while linking the program I get an error message. I can't even
link an example code delivered with MySQL base. If someone had a similar problem and
could help me, I would be very
On Thu, Jul 03, 2003 at 06:51:28PM +, Mike Lucente wrote:
> Hello,
>
> I have nine process that import data to tables with the same structure
> within about 1000 databases on a server. Each process fires at the same
> time, every 5 minutes.
>
> Lately I'm seeing these inserts hang, all wait
On Fri, Jul 04, 2003 at 02:35:15AM -0700, Dathan Vance Pattishall wrote:
>
> I'm looking for help to formalize this process as well as present my
> findings at the next mysql convention in Orlando. Do you think this would
> be a valid topic? If so would the mySQL team allow me to present it?
It
On Fri, Jul 04, 2003 at 08:48:37AM -0400, Paul Chvostek wrote:
>
> I've been looking at Apache's mod_log_mysql and mod_mylo, and if I don't
> need the extended featureset offered by mod_log_mysql, I can't help but
> wonder if I'd get any better performance than with something like:
>
> LogFormat
I couldn't get the LOCAL option to work; even when I started mysql with
the --local-infile argument. After reading around in the manual I decided
to grant myself the FILE privilege since I am the only user on my computer
where I am teaching myself mysql.
On Friday, July 4, 2003, at 12:08 PM, Pa
I am trying to to use a DSNless connection from an ASP script( on IIS5) to a
MySQL db on Linux.
I am trying this:
strConnection=_
"driver={MySQL};server=192.168.33.124;uid=me;pwd=mypassword;database=MySQL;o
ption=NUM"
Set adoDataConn = Server.CreateObject("ADODB.C
At 11:27 -0500 7/4/03, Richard Grubb wrote:
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the
tutorial in the "MySQL Reference Manual" in Chapter 3.
I get an empty set with the following command:
SELECT * FROM pet WHERE birth >= "1998-1-1";
I have tried many variations which all
"MaFai" <[EMAIL PROTECTED]> wrote:
>
> I would also like to know the impact when:-
> - the master db fail
> - a lot of insert/update transactions in the master, would it replicate
> immediately to the 2nd database
If the mater db fail, how can be many inserts/updates?
> - when the secondary db f
Hi,
I speak a little english. So
I want to install mysql-3.23.53 on RH 9...
This is my ./configure options:
./configure --prefix=/usr --exec-prefix=/usr --sysconfdir=/etc
--localstatedir=/var/lib/mysql --mandir=/usr/share/man --infodir=/usr/share/info
--with-mysqld-user=mysql --libexecdir=/usr/
> From: Egor Egorov <[EMAIL PROTECTED]>
> Date: Thu, 3 Jul 2003 10:51:08 + (UTC)
> Subject: Re: replicating FLUSH LOGS
>
> "Bill Easton" <[EMAIL PROTECTED]> wrote:
> > Under MySQL 3.23, FLUSH LOGS was replicated. Under 4.0.13, this appears
to
> > no longer be the case.
> >
> > Was this intenti
On Friday, July 4, 2003, at 12:27 PM, Richard Grubb wrote:
SELECT * FROM pet WHERE birth >= "1998-1-1";
Try: SELECT * FROM pet WHERE birth >= "1998-01-01";
You need 2 characters for the day and month fields.
___/
/
__/
/
/
Ed Leafe
http://leafe.com/
http://opentech.leafe
I have mysql 3.23.49 on Mac OS-X 10.1.5 and am going through the tutorial
in the "MySQL Reference Manual" in Chapter 3.
I get an empty set with the following command:
SELECT * FROM pet WHERE birth >= "1998-1-1";
I have tried many variations which all give either the empty set or
incorrect resu
Here's what I get:
mysql> SELECT USER();
++
| USER() |
++
| [EMAIL PROTECTED] |
++
1 row in set (0.02 sec)
mysql>
Kevin
Victoria Reznichenko wrote:
What is the output of SELECT USER()?
--
MySQL General Mailing List
For list archives: h
hello,
i am a MySQL newbie, my MySQL server is 3.23.36 install on RH7.1.
i am trying to enable a binary log in my server recently, i give a command:
'safe_mysqld --log-bin' to enable it, but i think it doesn't work,
because i cann't find any files such as 'hostname-bin.001' or
'hostname-bin.index
"Jian Sun" <[EMAIL PROTECTED]> wrote:
>
>Does anybody know how to drop table option? I added a table option "alter table
> abc order by col1 desc". Now I want to remove this option, How can I do?
ORDER isn't a table option, it's a single time action.
--
For technical support contracts,
"Sreesekhar Palaparthy" <[EMAIL PROTECTED]> wrote:
>If i have a table having fields of different datatypes
> which
> include BLOB/TEXT type, how do i give an insert statement?? Can
> i
> give a query to insert only BLOB/TEXT field seperately? Please
> help me out.
You can insert data
przemys?aw ho?ubowski <[EMAIL PROTECTED]> wrote:
>
> Somehow I managed to make all users (root also) unable to access and use
> 'mysql' database, and so I cannot fix it. Could you tell me how to fix it?
>
> No matter what user I use to get access finally I get: "ERROR 1044: Access
> denied for us
"Kevin H. Phillips" <[EMAIL PROTECTED]> wrote:
> I am trying to set up mysql 4.0.13 on my RedHat 9 machine. I rebuilt
> the source rpm. (I had a previous installation which I deleted first).
>
> I can log on to the mysql monitor as root but can't creat databases,
> can't change passwords, can't
Sean Berry <[EMAIL PROTECTED]> wrote:
> I need to know how to be able to read in data from to mysql from two different
> places. For example from /usr/local/mysql and /usr/local/data
You can use symlinks:
http://www.mysql.com/doc/en/Symbolic_links.html
--
For technical support contra
Hello All,
What syntax for MySQL should I be looking at to solve a problem like
the following:
3 Tables (oversimplified to show the problem area)
individual.id
individual.name
individual_addresses.individual_id
individual_addresses.address_id
address.id
address.street
Although the structure is
Victor Pendleton wrote:
>You could create your own script that runs myisamchk then after completing
>starts the MySQL service and place this in the windows startup folder.
>
>-Original Message-
>From: Luis Lozano [mailto:[EMAIL PROTECTED]
>
>How can i check and repair DBs, before service i
Mike Richardson and John Dean are pleased to announce the 2.0 release of
Rekall, a personal, programmable DBMS system for Linux and Windows. If you
want to distribute your Rekall application commercially then there is a
run-time version of Rekall V2.0.0 available too. There are also versions
avail
I left out a paragraph in my last message. Here is the full message:
I am running WinXP Home, upgraded from Win 98, on an AMD 1G.
After I installed MySQL 4.0.13, my system began to degrade. Eventually,
things got so slow that it took several seconds for Windows, including the
login screen and s
I am running WinXP Home, upgraded from Win 98, on an AMD 1G.
After I installed MySQL 4.0.13, my system began to degrade. Eventually,
things got so slow that it took several seconds for Windows, including the
login screen and start meny, to respond to my mouse clicks. Rebooting
did not help; if a
Hi,
I speak a little english. So
I want to install mysql-3.23.53 on RH 9...
This is my ./configure options:
./configure --prefix=/usr --exec-prefix=/usr --sysconfdir=/etc
--localstatedir=/var/lib/mysql --mandir=/usr/share/man --infodir=/usr/share/info
--with-mysqld-user=mysql --libexecdir=/usr/
I've been looking at Apache's mod_log_mysql and mod_mylo, and if I don't
need the extended featureset offered by mod_log_mysql, I can't help but
wonder if I'd get any better performance than with something like:
LogFormat "INSERT INTO httpdlog (vhost,host,logname,...) ('%v','%h','%l',...);"
mys
Hi,
If i have a table having fields of different datatypes
which
include BLOB/TEXT type, how do i give an insert statement?? Can
i
give a query to insert only BLOB/TEXT field seperately? Please
help me out.
___
Click below to experience S
On Fri, Jul 04, 2003 at 02:27:18PM +0200, Davide Monge wrote:
>
> I need to understand if there where the possibility to do:
>
> [EMAIL PROTECTED] root]# mysql -u root -ppw R500 < INSERT INTO CARTA (date,
> time, commessa, barcode) VALUES ("03/07/2003", "14:55:54", "03-0456",
> "99TPPEMETALPPC/425"
hi!
The MySQL online manual reports:
...omissis...
shell> mysql database < script.sql > output.tab
If you have problems due to insufficient memory in the client, use
the --quick option! This forces mysql to use mysql_use_result()
rather than mysql_store_result() to retrieve the result set.
Us
When compiling mysqlcc-0.9.2,I get:
checking for libmysqlclient...
checking for "/usr/lib/mysql//libmysqlclient.a"...yes
checking for mysql_real_connect in -lmysqlclient...no
configure:error:Could not find libmysqlclient in
`/usr/lib/mysql/ /usr/lib/ ...etc.
I did:
./configure --with-mysql-lib=
Hi Woody,
I can't answer your question, but I just wanted you to know that I like your
signature ;-). Thats definitely a good one.!!
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 4日 金曜日 18:02、woody at nfri dot com さんは書きました:
> I am in the process of setting up replication for my mysql servers
At 04:02 AM 7/4/2003 -0500, woody at nfri dot com wrote:
What kind of traffic volume is generated with replication, our database
has a pretty steady read/update volume throughout the day and its pretty
much 50/50 read/write. I do plan to offload some of the reads (such as
for daily reports and in
Hi,
has anybody tested MySQL 4.0.12/13 with InnoDB tables agains PostgreSQL 7.3.x?
Regards,
Rafal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Fri, 4 Jul 2003, Jeremy Zawodny wrote:
> On Thu, Jul 03, 2003 at 01:35:51PM -0700, Dathan Vance Pattishall wrote:
> >
> > The 3rd approach was to write software with some pointers from a book
> > called MySQL "The definitive guide to using, programming, administering
> > MySQL databases 2nd e
I am in the process of setting up replication for my mysql servers, and
had a couple of questions I wanted to clarify. One of the slaves will
be located in an offsite hotsite, and another local. The hotsite slave
will only be used to mirror the data, in the event of a failure or
accident at the o
hi there i am having a major matching issue trying to import data from an old database
with free text and matching the record and getting the id , ok say i have a record
which is saraw i need to match it to sara winter for instance how can i do this ?
--
MySQL General Mailing List
For list arch
Good day to all;
I'm new to this group;
ERROR 2002: Can't connect to local MySQL Server
through socket '/var/lib/mysql/mysql.sock' (111).
The os is SUSE 8.1 and MySQL 4.0.13. This error has
been plaqueing me for weeks and after many re-installs
have resorted to the kind assistance of this group.
Hi all.
I configured a linux box for viewing the WinNT workstations of a NT network
using samba as client of wins service from an NT server.
If I execute a ping to the name of a WinNT workstation in the network it
works. But if I connected to mysql from a WinNT workstation and execute
mysqladmin
On Thu, Jul 03, 2003 at 10:49:59PM +0200, awarsd wrote:
> Hi,
>
> I think MySQL uses binary tree, but my question is that what happens when we
> delete record. Does the binary regenerate itself??
MySQL handles tree (re-)balancing when necessary.
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MyS
On Thu, Jul 03, 2003 at 01:35:51PM -0700, Dathan Vance Pattishall wrote:
>
> The 3rd approach was to write software with some pointers from a book
> called MySQL "The definitive guide to using, programming, administering
> MySQL databases 2nd edition" that I picked up at the last convention. I
>
49 matches
Mail list logo