Hi,
I admit I m silly to shutdown mysqld with the killall command in the Redhat server,
I can't restart mysql service now. Most of the reason is because the script
mysql.server come with the mysql 4.1.10 does not like mysql.server start or
mysql.server stop, so I need to start it up use & and sh
Hi,
I finally got the backup data ported from mysql 5.0 (from freebsd) to mysql 4.1.10 in Redhat. Webmin started up and I can browse the data in each table. After installed all prerequisit perl modules, and start the web gui and start to run some queries, I expeirence it runs very slow. A sql in my
Jon,
- Original Message -
From: ""Jon Frisby"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 02, 2005 3:32 AM
Subject: RE: Switching to InnoDB turns out dissapointing
> set-variable =3Dinnodb_log_buffer_size=3D32M
=20
The log buffer is too big.
Is there a
Gabriel,
- Original Message -
From: ""Tucker, Gabriel"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tuesday, March 01, 2005 2:40 PM
Subject: innodb.status. files
Hello All
I have an MySQL instance running that is generating the =
innodb.status. files. However,
On Wednesday 23 February 2005 03:47, Hough Van Wyk said something like:
> I am developing a embedded VB application running on a hp ipaq
> running Windows CE 2003. This app has to connect to a MYSQL DB over a
> wireless network. I have surfed the internet for hours with no luck.
> Can anyone please
Hi,
I have installed the server and started up successfully. mysql.sock file
is written to /var/lib/mysql/ directory as well.
Now I found that I also need to install mysql 4.10-1 client. However
there is already mysql3 installed in the system. How can I remove the
old version in Redhat?
Here are
sam wun wrote:
Gleb Paharenko wrote:
Hello.
I used the following command backup database:
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
--quote-names --opt
I don't think this command backup user account info.
If you add --all-databases option it would also dump the
Gleb Paharenko wrote:
Hello.
I used the following command backup database:
mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
--quote-names --opt
I don't think this command backup user account info.
If you add --all-databases option it would also dump the mysql d
Hello:
MyODBC3.51 MYSQL4.1.10-max
MyODBC SQLDescribeCol can't get ColumnSize of any String types column.
SQLDescribeCol can get ColumnSize of numeric column.
Why ?
Regards,
Gu Lei
--
<>--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
Hey guys,
I just upgraded to mysql 4.1 and I'm trying to get damn unicode to work in
my database. I put "default-character-set=utf8" in my my.cnf file and
restarted the database. Then I created a brand new database new table, new
field. I try hooking into the newly created database with Mysql Co
> > set-variable =innodb_log_buffer_size=32M
>
> The log buffer is too big.
Is there a performance penalty associated with making the log buffer
size too large, or is just not beneficial?
-JF
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http:/
Hello:
I need SQLDescribeParam to get parameters' type information.
But with MyODBC3.51 and MYSQL 4.1.10max I got wrong type and wrong
number of parameters.
Does MyODBC support SQLDescribeParam ?
When will MyODBC support SQLDescribeParam ?
Thanks.
Regards,
Gu Lei
--
<>--
MySQL General
On Tue, 1 Mar 2005 18:09:37 -0600, Alfredo Cole wrote:
> El Mar 01 Mar 2005 17:32, Gary Richardson escribió:
>>
>> InnoDB uses transactions. If you are doing each row as a single
>> transaction (the default), it would probably take a lot longer.
>>
>> I assume you're doing your copying as a INSERT
Alfredo,
- Original Message -
From: "Alfredo Cole" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, March 02, 2005 2:09 AM
Subject: Re: Switching to InnoDB turns out dissapointing
El Mar 01 Mar 2005 17:32, Gary Richardson escribi=F3:
What have you actually done to
InnoDB is a very different platform from MyISAM.
> innodb_data_file_path = ibdata1:10M:autoextend
How big is your data? You need to set your innodb_data_file_path to
have enough space for this. Right now, your file is autoextending
constantly. I would either turn on per table table space, or
pre-
El Mar 01 Mar 2005 17:32, Gary Richardson escribió:
> What have you actually done to 'tune' the server? How are you doing
> the inserts?
>
> InnoDB uses transactions. If you are doing each row as a single
> transaction (the default), it would probably take a lot longer.
>
> I assume you're doing yo
Gary's got another point about the transactions.
I'd still look to using mysqldump first if possible, if they have the
ability it will be remarkably faster.
Otherwise, turning transactions off before the insert, and locking the
table as well, (if you haven't already done that) could prove to save
What have you actually done to 'tune' the server? How are you doing
the inserts?
InnoDB uses transactions. If you are doing each row as a single
transaction (the default), it would probably take a lot longer.
I assume you're doing your copying as a INSERT INTO $new_table SELECT
* FROM $old_table.
Hi:
I have switched from MyISAM tables to InnoDB, using MySQL 4.1.10 under SuSE
8.2.
My application, an ERP system developed in-house, uses 70 tables, the largest
one holding a little over one million rows. To assist when changing table
structures, we developed a software that creates a new ta
Shawn,
Yes, I know that is true.
With a framework that is properly spread out however, often the
inner query does not even know that the outer one is active.
The situation: list a bunch of hits from the database to be
displayed in a table.
1) the query is constructed and handed to the
Since this post, I have been able to enter a PDF file into the DB using
MySQLCC / MySQL CLI and INSERT / UPDATE statements. Now my issue is the ASP
/ aspUpload. That is not appropriate for this list.
Thanks anyways!
J.R.
-Original Message-
From: Martijn Tonies [mailto:[EMAIL PROTECTED]
S
Inserting Other Binary data into DB (NOT IMAGES)Inserting images in no
different compared to inserting PDFs.
What is your problem? What have you tried so far?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http:
Hiya Folks!
I'm struggling with a complicated subquery issue, and my SQL-fu isn't strong
enough to make a solution apparent. Hopefully one of you experts can give me a
nudge in the right direction :)
The query utilizes data from just one table, which looks like:
idX integer
idY
After doing much research I am at a loss how really utf8_bin and
utf8_general_ci differ, besides the obvious -- sort order.
What I inferred from MySQL docs and some online articles is the following.
utf8_bin is pretty much what it suggests, utf8 strings are stored as bytes
and MySQL server compar
Title: Inserting Other Binary data into DB (NOT IMAGES)
Good afternoon all,
I have a db (gasp!) that is holding images in a BLOB field already. I can upload and retrieve on the fly - no problems.
Now I am looking at inserting binary data such as M$Word Documents (.doc and .rtf), XML
Hi,
I've got webserver with php and mysql-4.0.22
There I've got large phpbb2. Sometimes, server's system load rapidly
grows, and mysql are locked. Normally, there are 7-10 mysql processes,
at this strange situation, there are 30-40.
I don't know what can make such big system load in time of 1 mi
I am attempting to use Redhat's update to get the latest version of
php-mysql. Howeever, each time I try it prompts:
Unresolvable chain of dependencies:
MySQL-bench 4.0.21-0 requires MySQL-client
Running rpm -qa | grep MySQL gives me:
MySQL-client-4.0.21-0
... and a host of other thin
Don Huff <[EMAIL PROTECTED]> wrote on 03/01/2005 02:33:34 PM:
> Hi,
>
> I am wanting to write a nesting of queries without having to
> retrieve all the records of the first query (because of the volume).
>
>
>
> res1 = query(db, sql1, USE_DATA);
> while (row1 = fetch_row(res1)
Christopher Malton wrote:
When I use the statement:
EXPLAIN SELECT * FROM workunits WHERE Sent>0
It returns
+---+--+---++-++-++
| table | type | possible_keys | key| key_len | ref|
rows| Extra |
+---
Hi,
I am wanting to write a nesting of queries without having to
retrieve all the records of the first query (because of the volume).
res1 = query(db, sql1, USE_DATA);
while (row1 = fetch_row(res1))
{ res2 = query(db, sql2_function_of(row1);
row2 = fetch_row(res2, USE_DATA);
Hello all,
Is there a way to change a table's Create_time that is displayed when
doing a `SHOW TABLE STATUS FROM mydb LIKE 'foo'\G`?
I've tried using touch to modify the file dates directly and searched
the online docs with no luck.
The reason I want to do this is because we had some tables tha
When I use the statement:
EXPLAIN SELECT * FROM workunits WHERE Sent>0
It returns
+---+--+---++-++-++
| table | type |
possible_keys | key | key_len | ref |
rows | Extra |
+---+--
To me what is more important is where this is leading,
http://www.distlab.dk/badger/Publications/exec_summary.pdf
a true parallel database cluster, with the end goal of this
work being a parallel MySQL.
My cluster waits ..
-pete
On Mon, 2005-02-28 at 14:04, Greg Whalin wrote:
> Just found an
Hi!
On Feb 26, leegold wrote:
> Is there any way to make relevance when using boolean mode more useful?
> If not, are there plans in the future Fulltext development "todo" for
> making it useful?
Current relevance formula is described in internals.texi (see mysqldoc
repository on mysql.bkbits.net
We have a master-slave setup in production.
The master is running on a dual-Opteron with SuSE 8 SLES.
The slave is running on a dual Xeon with SuSE 9.
Both run MySQL 4.0.20
We recently moved our traffic database to the machine and started
writing additional traffic (perhaps as much as 600,000 inse
Innobase Oy declares MySQL/InnoDB-4.1 stable
Innobase Oy has decided to declare MySQL/InnoDB-4.1 stable and recommended
for all production use, starting from version 4.1.10. MySQL/InnoDB-4.1 has
been out for almost two years now, there have been millions of downloads of
the software, and it is a
"Joppe A" <[EMAIL PROTECTED]> wrote on 03/01/2005 02:21:31 PM:
> Hello all,
>
> I have I small problem I wonder if there is a easy solution for..
>
> I have a SQL-query where I count out how many users per "n_id" I
> have. it is a little tricky because I had to do a left joint and
> compare tw
Hello all,
I have I small problem I wonder if there is a easy solution for..
I have a SQL-query where I count out how many users per "n_id" I have. it is a
little tricky because I had to do a left joint and compare two tables to get
out thoose that are represented only in one of the tables.
SE
Hello,
> Using TEXT or BLOB prevent me to display the string in a dbgrid, the real
> data is replaced by a text like "(MEMO)".
> I can use somethinh like "select substring( msg, 1,100 ) from mytable " to
> bypass the problem but is no the clean solution I looking for.
> I thank for your hints but
Using TEXT or BLOB prevent me to display the string in a dbgrid, the real
data is replaced by a text like "(MEMO)".
I can use somethinh like "select substring( msg, 1,100 ) from mytable " to
bypass the problem but is no the clean solution I looking for.
I thank for your hints but I'm looking, if po
Any idea 5.0.3 release date? There are many bugs fixed right now for 5.0.2!
Alejandro
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
In article <[EMAIL PROTECTED]>,
"Jim McAtee" <[EMAIL PROTECTED]> writes:
> In another table like this with month/year fields I once created a
> dummy date field that I populated with the date of the first of the
> month (1//), just to facilitate queries like this. Is
> there another approach? Can
Hello Gleb,
Below is an extract of the SQLyog history on startup
/*[02:26:25 PM][ 0 ms]*/ show variables like '%character%'
/*[02:26:25 PM][ 0 ms]*/ Set character_set_connection=utf8
/*[02:26:25 PM][ 0 ms]*/ Set character_set_results=utf8
/*[02:26:25 PM][ 0 ms]*/ Set character_set_client=ut
Hello All
I have an MySQL instance running that is generating the innodb.status.
files. However, there is no innodb_monitor table in any of the databases. How
is this happening?
Thanks - Gabe
4.0.20-max-log
SunOS 5.8
<><><><><><><><><><><><><><><><><><><><><>
"There are no problems, onl
Hello.
> I used the following command backup database:
> mysqldump --user=$USERNAME --password=$PASSWORD --host=$DBHOST
> --quote-names --opt
>
> I don't think this command backup user account info.
>
If you add --all-databases option it would also dump the mysql database.
I've tried to
Hello.
Use
set NAMES 'utf8';
to set the connection character sets to the corresponding values. See:
http://dev.mysql.com/doc/mysql/en/charset-connection.html
Rob Cochrane <[EMAIL PROTECTED]> wrote:
> Hi Gleb,
>
> Ok here is the command line info which also answers the
Hello.
See:
http://dev.mysql.com/doc/mysql/en/replication-faq.html
"Chris Knipe" <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Is two-way replication possible with MySQL 5.x? Any good sites / docs
> describing this type of setup?
>
> --
> Chris.
>
>
--
For technical support co
Hello.
Use TEXT or BLOB columns.
"AESYS S.p.A. [Enzo Arlati]" <[EMAIL PROTECTED]> wrote:
>
> I got this problem:
> I need to save in a varchar field a string wich can have the ended part
> filled with blank character, and I need to restore the string in the same
> way it was saved,
Hello.
>is it possible to mysqldump specific tables from multiple databases in
>a single run?
No.
> database. I can not (even off hours) lock the entire database (main
> one) long enough to do a full dump with locks so I see my options as:
You may write your own sql file in which you
49 matches
Mail list logo
