Hi all,
I've got a question. We were testing something on our mysql server (
4.0.21) with MyISAM tables.
When we executed the query select * from people where name like ''; we
expected the same results as select * from people where name=''; but it
didn't.
The like function returned
On Saturday 10 September 2005 12:17, Gleb Paharenko wrote:
Hello.
Looks like it is a bug. See:
http://bugs.mysql.com/bug.php?id=7883
Duncan Hill [EMAIL PROTECTED] wrote:
I recently changed /etc/my.cnf to set myisam_data_pointer_size to 6, as
we're starting to encounter quite a few
Jaspreet Singh wrote:
Hi,
I am trying to compute the MySQL db size using show table status
command. It gives me the size of .MYD and .MIY files, but not .frm which
is typically 12k (using 4.1.9 version of MySQL)
Qus 1. is there any way to deterministically compute the value of .frm
file
Adam Newby wrote:
Description:
We have distributed applications which make extensive use of the
get_lock() function
to acquire a system-wide lock. Occasionally, all copies of a given
application
block attempting to acquire a lock on the same lock string. Using
is_used_lock()
Jaspreet Singh wrote:
The problem is that MySQL users can only be 16 chars loong (bad !!) and
cannot have '@' or '#' in the name.
If you think 16 characters is not enough, you can file this as a bug/feature
request at http://bugs.mysql.com
Is there a way out ... Is there a way so that i
Clyde Lewis wrote:
Hey guys,
I'm looking for any best practices or a formula that is commonly used in
setting the value for thread concurrency in the configuration file.
I have 24 instances running on a sun 2900 server with 32GB or ram.
Here is a sample of my configuration file.
The best
Kishore Jalleda wrote:
Hi All,
We have a production Database, running mysql 4.0.17 , on a
Poweredge 2650 with 3 GB RAM, and dual Xeon 2.4 GHZ, the server
averages between 100 and 200 qps ( ,also and the CPU/MEM load is
pretty low and is extremely fast except for once in a while may be
Peter J. Schoenster wrote:
Hi,
I've got a database that is closed to 7G.
I'm using the Standard4.1.14 version.
The table was corrupt and I had to do a lot of moving of data to free up
enough space on the partition as I discovered I needed at least twice
the database size to do a
Dyego Souza Dantas Leal wrote:
Hello guys..
I want to use INTEL SHARED MySQL 4.0.25 - Pro with innodb tables on
PRODUCTION SERVER DELL 2600
The Linux Kernel is 2.6.12 and the hardware is DUAL XEON 2.4 HT iwth 4
GB of RAM
(i'm using raw partitions feature on innodb tables)
this is a secure
Ryan Stille wrote:
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But I
wanted to see if there is anything I should be weary about.
http://www.convert-in.com/mss2sql.htm
I have done a test migration before
Stephen P. Fracek, Jr. wrote:
We're having a problem with MySQLHotCopy. It has worked flawlessly in the
past but now we're getting an error message similar to this:
Dumping database... DBD::mysql::db do failed: Can't find file:
'./file.frm' (errno: 24) at
[EMAIL PROTECTED] wrote:
Hi all,
I've got a question. We were testing something on our mysql server (
4.0.21) with MyISAM tables.
When we executed the query select * from people where name like ''; we
expected the same results as select * from people where name=''; but it
didn't.
The like
Andrew stolarz wrote:
Hello All,
I am downloading and installing the Installer package (Mac OS X v10.3)
from the mysql site.
I am installing on a OSX 10.4 machine, at the end of the install I get an
error message saying
The application MYODBCConfig quit unexpedically after it was reopened,
Yes, in perl is OK, but in MySQL it is not really ok.
Perl regular expressions use ^ and $ for specifying the start and end of the
string while MySQL like operator doesn't
For example, if $string = 'a', // with match in perl, but /^$/ won't match.
MySQL like operator could use '%' for matching
I think it's a common misconception that MySQL will grow to meet the
settings in my.cnf.
That is, if you have 32M of actively used indexes, there is no
difference between key_buffer = 64M
and key_buffer = 512M. Similarly, if you have a need for 128 cached
tables, you'll gain
no benefit with
I'm on Fedora Core 4. When I right-click on a table in
Mysql-administrator and choose Edit table data nothing happens, and I
get this in the console:
(mysql-administrator-bin:4628): glibmm-CRITICAL **:
unhandled exception (type Glib::Error) in signal handler:
domain: g-exec-error-quark
code :
Hello!
But once you have done that, you can never recover the origional text.
Try it on this email if you doubt it.
Why? Why not to use regular expressions?
Use addslashes($htmlCode) and execute query normally.
$slashedHtmlCode = addslashes($htmlCode);
The problem is not in the executing
Vladimir B. Tsarkov wrote:
After the execution of the script:
?php
$string = \n\n\n\n 1;
echo addslashes($string);
?
we will get:
1
and no empty lines.
If you want to output the same data, that was written using a textarea field
of a form, you should use the br tag.
In one word: kiss.
$input = This is br the \n input;# value from user
$saved = This is br the br input; # value in database
$recovered = This is \n the \n input; # retrieved from db, != $input
-Original Message-
From: Vladimir B. Tsarkov [mailto:[EMAIL PROTECTED]
Sent: Sun 9/11/2005 2:15 PM
To:
John Trammell wrote:
$input = This is br the \n input;# value from user
$saved = This is br the br input; # value in database
$recovered = This is \n the \n input; # retrieved from db, != $input
Please don't top-post. That is the perfect argument for not applying
nl2br() before saving
Jasper Bryant-Greene wrote:
John Trammell wrote:
$input = This is br the \n input;# value from user
$saved = This is br the br input; # value in database
$recovered = This is \n the \n input; # retrieved from db, != $input
Please don't top-post. That is the perfect argument for not
Chris Spencer wrote:
I'm on Fedora Core 4. When I right-click on a table in
Mysql-administrator and choose Edit table data nothing happens, and I
get this in the console:
(mysql-administrator-bin:4628): glibmm-CRITICAL **:
unhandled exception (type Glib::Error) in signal handler:
domain:
Hi Jigal, all,
On Tue, 2005-09-06 at 17:30, Jigal van Hemert wrote:
Schalk Neethling wrote:
You guys should subscribe to the Planet MySQL RSS feed.
The entire issue was cleared up there by a member of the MySQL AB staff.
http://www.planetmysql.org/
Maybe the MySQL AB staff could take the
so the sql-bench stuff doesn't push the mysqld to its limits?
- Original Message -
From: Daniel [EMAIL PROTECTED]
To: Matthew Lenz [EMAIL PROTECTED]
Cc: mysql mysql@lists.mysql.com
Sent: Sunday, September 11, 2005 1:12 PM
Subject: Re: default my.cnf vs huge.cnf nearly same performance
Wow, thanks for all of the Information guys! I've learned alot and now I've
actually been doing more brain storming... I've been reading all of these
emails over and over - and they're helping me understand more!
What I'm trying to do is save User Sites in MySQL and use PHP to pull them
out
clint lenard wrote:
Hi guys, I'm fairly new to MySQL and I've searched for about a week looking
for an answer to this...
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another
Douglass, thanks for the tips!
As far as Mambo or Xoops - I wanted to create something a little different -
but I WAS thinking of using Smarty before-hand... I just wasn't sure how I
could really use it? I'm familiar with Smarty as far as I've played around
with it a little... but I guess I
27 matches
Mail list logo