回复： Re: 回复： Re: MySQL 4.1 and PHP 4.4

--- Gleb Paharenko <[EMAIL PROTECTED]>写道: > > You can change the character_set_xxx variables using > SQL > queries. I usually put 'SET NAMES' at the beginning > of my > scripts. > Must i add mysql_query("SET NAMES 'utf8'") before every occurance of real mysql_query()? I have added mysql_query

How to start mysql with --old-password

Dear Friends, I need to start mysql with --old-passwords but i did not know how to do so. Actually i had mysql installed with someone else. I did not know how have he installed that. He have placed an entry in /etc/rc.d/rc.local as /usr/local/mysql/bin/mysqld_safe & to start mysql when server start

I NEED QUERY on Difference between values (Any Group Functions are there)

i have to write one query DivisionUnitsYear ameerpet 200 2004 ameerpet 300 2005 ameerpet 500 2006 >From these values i want to retreive as like this DivisionUnitsYear a

i have one doubt

i have to write one query DivisionUnitsYear ameerpet 200 2004 ameerpet 300 2005 ameerpet 500 2006 >From these values i want to retreive as like this DivisionUnitsYear

Re: help with character sets and collation

I'm sorry but I do not know what you mean by NO_TABLE_OPTIONS in @@sql_mode). The database has a Collation = ascii_general_ci. The only other option is ascii_bin. With respect to the table, it also has Collation of the same, ascii_general_ci. There are many Collation types which the table may

Re: NOT IN vs IS NULL

Devananda, >Could anyone give me some insight as to which of the following queries >is "better" (and why) - or if there is another query that would be faster than either? It's late on Friday so I could be missing something, but wouldn't the following be simpler? SELECT offer_id FROM paytab

RE: 4 GIG Limitation

Hello, Check out http://dev.mysql.com/doc/refman/5.0/en/table-size.html Also, not sure if it's a typo but MySQL 11.8 is a ways off. Did you mean 4.1 or 5.0? Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Message- Fro

RE: 4 GIG Limitation

Adnan wrote: > Greetings, > > I recently was told that MYSQL has a 4 GIG size limitation. I am not > sure if this is for a table size or for the actual size of the > database itself. Is there such a limatation for MYSQL 11.18 running > on RedhatAS 3? > > Thanks, > > a

4 GIG Limitation

Greetings, I recently was told that MYSQL has a 4 GIG size limitation. I am not sure if this is for a table size or for the actual size of the database itself. Is there such a limatation for MYSQL 11.18 running on RedhatAS 3? Thanks, asadiq -- MySQL General Mailing List For list archives:

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

sheeri kritzer schrieb: No problem: Firstly, how are you measuring your updates on a single table? I took a few binary logs, grepped out for things that changed the table, counting the lines (using wc) and then dividing by the # of seconds the binary logs covered. The average for one table was

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

No problem: Firstly, how are you measuring your updates on a single table? I took a few binary logs, grepped out for things that changed the table, counting the lines (using wc) and then dividing by the # of seconds the binary logs covered. The average for one table was 108 updates per second.

Re: How NOT to log SHOW INNODB STATUS in the query log.

On 1/27/06, Imran Chaudhry <[EMAIL PROTECTED]> wrote: > > Hi; > > My query.log is full of 'show innodb status' queries. > > How do I get this ascii log file not to log these. OR some help with a > > grep script to copy the file without these lines. > > I noticed the same in the logs of a 4.1 test s

Re: mysql 5.0.18: Bind on unix socket: Permission denied

[Sorry] I didn't realize that hitting Reply (using Gmail) sent a private message. Usually on lists the message ends up on the list. Will need to observe the header in the future. tx; -nat On 1/27/06, Gleb Paharenko <[EMAIL PROTECTED]> wrote: > Hello. > > Please, next time always CC your messages t

RE: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

Hello, Another consideration besides the performance aspects, are the characteristics between MEMORY and the NDB storage engines. (You'll be gaining or losing functionality depending on how you look at it.) Briefly: MEMORY - in memory, table locks, hash & B-tree indexes, no disk i/o or persisten

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

sheeri kritzer schrieb: Why are you using a heap table? We started out with a myisam-table years ago when the table was much smaller und less frequently updated. We tried innodb about 2 or 3 years ago and couldn't get a satisfying result. We then changed it to HEAP and everything was fine.

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

Why are you using a heap table? My company has tables with much more information than that, that get updated much more frequently. We use InnoDB tables, with very large buffer sizes and have tweaked which queries use the cache and which don't, on a system with lots of RAM (10Gb). Basically we've

Re: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

a cluster would not necessarily give you speed but would give you scalability, basically it increases your concurrency at which you can service clients, also in your case the lockups are occuring because of the obvious reason that the threads are competing for the system resources, so a cluster may

ERROR 1025 when doing ALTER TABLE to change a myisam-table to a CLUSTER table?

Hello, I am just doing my first testing on a mysql-cluster system. Curently, I habe 1 management node running and 2 Data-Nodes that also run a mysqld each. The servers are Dual-Opterons with 6GB of RAM each. I did a dump of a database of one of our production systems (about 1.5GB mysqldump-fil

Performance of MEMORY/HEAP-tables compared to mysql-cluster?

Hi, Did anybody ever benchmark heap-tables against a cluster? I have a table with 900.000 rows (40 fields, CHARs, INTs and DOUBLEs, Avg_row_length=294) that gets around 600 updates/sec (grouped in about 12 extended inserts a minute inserting/updating 3000 rows each). This is currently a HEAP-ta

Re: Error inserting text containing a "?" character

Hello. Check that you're using the fresh enough versions of Connector/NET and MySQL. See: http://bugs.mysql.com/bug.php?id=5392 David P. Donahue wrote: > This morning I began noticing some errors coming from my MySQL database > that appear to be the result of a user inserting text which conta

A propos de l'upgrade MySQL et de l'interclassement...

Bonjour, J'utilise une technologie CMS, installée depuis l'année dernière sur une base MySQL 4.0.16-nt. Le CMS à crée lui meme lus tables et y fait référence en utilisant l'encodage UTF-8. Depuis, nous avons migré à la version MySQL 4.1.16-nt et l'encodage par défaut choisi a été latin_swedish

Re: SSL Overhead

Hello. When running our benchmark tests using secure connections (all data encrypted with internal SSL support) performance was 55% slower than with unencrypted connections. See: http://dev.mysql.com/doc/refman/5.0/en/compile-and-link-options.html Khalid Hanif wrote: > Hi Guys, > > What so

Re: Unable to connect tomcat with mysql pl help

Hello. See: http://dev.mysql.com/doc/refman/5.0/en/error-access-denied.html sankar subramanian wrote: > Hi All, > Iam using tomcat 5x and mysql5.x the proble is when i try to connect > mysql and tomcat using j/connector 3.x tomcat throws error as access denied > to [EMAIL PROTECTED] host

Re: mysql 5.0.18: Bind on unix socket: Permission denied

Hello. Please, next time always CC your messages to the list as well. I'm not a lampp expert and can only point you to: http://dev.mysql.com/doc/refman/5.0/en/program-options.html >This advice proved very helpful. This is where its at now: >I noticed that the .err file belonged to user 'nobod

Re: question about recovery with binlog

Hello. At least it replaces the contents of my test file. If you're able to provide the test case where replace utility doesn't work please provide it to the list with the contents of the file. wangxu wrote: > I execute follow statement. > - > shell>replac

Re: help with character sets and collation

Hello. I do not see the CHARACTER SET of your table (usually SHOW CREATE includes it, may be you have NO_TABLE_OPTIONS in @@sql_mode), so I assume it is the same as database character set - ascii. Check if the problem disappears after changing the character set of your fields to utf8. Chris wro

Error inserting text containing a "?" character

This morning I began noticing some errors coming from my MySQL database that appear to be the result of a user inserting text which contains a question mark anywhere in it. The error is: "Parameter '?' must be defined ..." Is there a way to tell MySQL to just treat the "?" as another characte

ANN: Advanced Data Generator 1.6.0 released

Dear ladies and gentlemen, Upscene Productions is happy to announce a new version of the database developer tool: "Advanced Data Generator" (version 1.6.0) A fast test-data generator tool that comes with a library of real-life data, can generate data to your database, SQL script or CSV files, man

SSL Overhead

Hi Guys, What sort of overheads am I expecting to get when running MySQL 5.0.18 in SSL mode? I need to decide whether to run MySQL in SSL mode, or use CIPE (on RHEL 3). Thanks, Khalid -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://l

Linux Threads MySQL

I got this error, You seem to be running 32-bit Linux and have 308 concurrent connections. If you have not changed STACK_SIZE in LinuxThreads and built the binary yourself, LinuxThreads is quite likely to steal a part of the global heap for the thread stack. Please read http://www.mysql.com/doc

Re: How NOT to log SHOW INNODB STATUS in the query log.

> Hi; > My query.log is full of 'show innodb status' queries. > How do I get this ascii log file not to log these. OR some help with a > grep script to copy the file without these lines. I noticed the same in the logs of a 4.1 test server. I put it down to MySQL Administrator which was monitoring