On 10/25/2010 3:03 AM, Johan De Meersman wrote:
SSD may still be useful if you have a lot of writes, though.
Only if by a lot you mean a minority.
A lone 2 TB rotating disk will beat a top-of-the-line SSD for linear
writes, and you can beat an SSD for linear reads with a pair of disks in
On 10/25/2010 4:32 AM, Glyn Astill wrote:
There have been some reports of raid cards not behaving themselvs
with SSDs attached.
I'd be surprised if these bugs haven't all been worked out by now. SSDs
started to hit the mass market in force about two years ago. Any vendor
still shipping a
On 8/5/2010 9:35 AM, Nunzio Daveri wrote:
So when I do top-c before I run the reports,
it says mysql is using 2GB, then I run the stress test (several reports) and it
hits 12GB then I stop the stress and even 30 mins later the server says there is
only 800mb of ram free???
That's normal Linux
On 8/4/2010 12:40 PM, Nunzio Daveri wrote:
it pretty much came down to it's knees within two hours of
running tests.
Can you clarify what happened in those 2 hours, exactly?
If you mean it took 2 hours of running a single test for performance to
collapse, I'm not sure this means anything. 2
On 6/7/2010 9:57 AM, Ryan Chan wrote:
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
Since MySQL only support BMP, so in fact 16 bit is needed actually?
I imagine they were thinking they'd extend the support to full Unicode
in the future and didn't want you to have to dump and
raid fifa wrote:
Is this a bug of mysql_ping() ? or any other advice?
Probably not. I think you'll find that it *does* time out, just after a
longer period than you'd prefer. Timeouts of 30, 60 and 120 seconds are
common in network code, because it's not possible to reliably determine
Stefano Elmopi wrote:
If I put the variable prompt in the general my.cnf, the prompt is
changed but for all instances.
If I put in the variable prompt in the my.cnf associated with the instance
in the [mysql] section, the prompt does not change.
This is because the client reads from my.cnf
Edward Diener wrote:
The source distributions listed at
http://dev.mysql.com/downloads/mysql/5.0.html#source do not specify any
as the Windows source distribution. I downloaded the .zip file, thinking
that might be the one, but it is not.
I just downloaded it, and it looks like the source
Kandy Wong wrote:
Is there a way to cache the MYSQL_RES in C++?
I've tried to develop a class with functions returning the MYSQL_RES,
MYSQL_ROW and MYSQL_FIELDS.
It sounds like you're trying to reinvent MySQL++:
http://tangentsoft.net/mysql++/
--
Warren Young, maintainer of MySQL
Mad Unix wrote:
During the update of the MySQL DB (delete/insert), I keep getting the
following message
Lost connection to MySQL server during query...
By default, the MySQL server drops a connection after 8 hours of
receiving no queries on that connection. This can happen in an
, it saves you from having
to do the timestamp string parsing yourself.
--
Warren Young, maintainer of MySQL++
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ben A. Hilleli wrote:
Obviously this poses a problem for 'normal' relational-databases
No, it just takes a little indirection to represent this in a properly
normalized fashion. What you need is:
1. A table of language names mapped to IDs:
Languages
INTEGER id AUTO_INCREMENT
Tim Johnson wrote:
I can not locate a C api function to _unescape_ strings.
Why do you believe you need one?
You need to escape strings when building SQL query strings to avoid
problems with quote characters, which are special in SQL. When MySQL
returns the queried data to your program,
Tim Johnson wrote:
Not sure what you mean by directly usable.
I mean directly usable. :)
If I do an insert statement with a backslash, for example:
headline\one, I will retrieve headline\\one, and that will
need to be unescaped, because it is not a true representation
of what was
Waynn Lue wrote:
I'm getting a weird ^A character when I
try to print it out in a textarea field.
In that case, what character set does the browser think it should be
using for the page? If you don't explicitly declare it, the browser has
to guess, and you know what happens when you rely
Waynn Lue wrote:
I'm trying to figure out if the fact that the charset
is set to latin1 is the reason why.
It shouldn't be. The registered trademark symbol is code point 0xAE in
ISO 8859-1 according to the 'pedia:
http://en.wikipedia.org/wiki/ISO_8859-1
So, it would seem that your
Michael wrote:
Has anyone successfully called the C API routines for MySQL from COBOL?
Dude, April 1 was, like, a month ago now.
You may have better luck finding an ODBC bridge for your COBOL
environment, which let you access MySQL indirectly.
--
MySQL General Mailing List
For list
Mike wrote:
I have so much data that we can't take a mysqldump of our database. The
directory tared is about 18GB.
Worst-case expansion for SQL data from binary to text format is about
5:1, which applies mainly to numeric data, not text. That's only 90 GB;
I carry a bigger hard drive in my
Mike wrote:
I not sure
what you mean by binary copy. Can you please explain?
A binary copy means copying the MySQL data directory directly, rather
than do a mysqldump, which converts the data to text format. The text
dump is converted back to binary format for disk storage on loading it
Olga Lyashevska wrote:
e7253:mysql olichka$ /usr/local/mysql/bin/mysql
Try:
$ /usr/local/mysql/bin/mysql -u root -p
It looks like you aren't logging into MySQL as root, so you don't have
permission to set the root password. (If you don't give -u, it uses
your OS X short user name
Tim McDaniel wrote:
I was a bit puzzled seeing -p database_name,
...
How very inconsistent and obnoxious.
It's best to think of -p as never taking an argument, always asking
interactively. Many operating systems will let a processes access the
command line parameters of another process,
Lamp Lists wrote:
I need to change ft_min_word_len fro 4 to 3. the
proces is very well explained on mysql.com
though, when open /etc/my.conf can't find the
ft_min_word_len line?
If a value for a configurable isn't given in my.cnf, it takes the
default value. So, add the line, restart the
Eli Shemer wrote:
Actually I'm not in liberty to reveal but it is essential to the project.
In that case, I am awe-struck, even astounded, at the possibilities
suggested by this hint. You must be working on a project that is
literally astronomical in scope. Please, let me explain how I
Michael Cole wrote:
I think you missed something in your formula,
You just have a 1 dimension dealt with here.
That would be every grain in that line.
Yes...so you use three columns to describe normal space. Call them x,
y, and z. Or elevation, azimuth and range. Or...
--
MySQL General
Eli Shemer wrote:
Is there any possible way to increase this limit ?
I'm curious to know what it is you're doing where you need accuracy
better than one part in a nonillion.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Steffan A. Cline wrote:
Starting mysqld daemon with databases from /usr/local/mysql/var
/usr/local/mysql/bin/mysqld_safe: line 426: 77090 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
--datadir=$DATADIR $USER_OPTION --pid-file=$pid_file $err_log 21
Steffan A. Cline wrote:
I built MySQL 5.045 from source and it will run fine, just not
from launchd.
My previous post was made with the assumption that you were using the
official binaries, and that they had not yet qualified them on Leopard.
I suggested Fink because it's an easy way to
Tim Johnson wrote:
Can't find file: './mysql/(database_name).frm' for numerous databases.
That's the file the actual table data is stored in. Unless you're on a
shared machine and are trying to run a private copy of MySQL, you
probably don't mean to put store table data in a subdirectory
Tim Johnson wrote:
The file pattern is *not* as I expressed it above.
Yeah, I figured that out, and ignored the error in my reply.
The answer remains the same: unless you're purposefully doing something
weird, there's a configuration error in that MySQL build. It's not that
the
Tim Johnson wrote:
Is there a possible repair routine to run?
It isn't broken, per se.
Someone chose to build it with this configuration, and presumably that
person made a choice that is sensible for their needs. If it doesn't
work for you, you can either build MySQL from source with the
Tim Johnson wrote:
It isn't broken, per se.
When you say that it isn't broken, could you please elaborate?
Once again: It seems to me that you're seeing a purposeful choice of
configuration. It could very well be that the configuration makes sense
in some one's use. The fact that it
Beauford wrote:
Is there a way to run the following command via cron.
$ man mysql
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
wangxu wrote:
actually I am using this piece of code,but I replaced fprintf to printf
just to simplify the problem.
Everything I said about printf() applies equally to fprintf(). The %s
work-around suggested by Pete Harlan will work, but not for very good
reasons. Again: see
I'm replying to you both personally and to the MySQL++ mailing list,
where this message is on topic. Please reply only on the list, not to
me directly.
wangxu wrote:
below is my code;these code works very fine until, the length of the
field content exceeds 30,
How certain are you
Kevin Waterson wrote:
This one time, at band camp, Warren Young [EMAIL PROTECTED] wrote:
Storing arbitrary data in a BLOB column is
tantamount to trying to turn the database into a file system. If you
want a file system, use a file system.
What is a file system, if not a database
Ratheesh K J wrote:
I want to know whether this is the right approach. Or should we
actually store the attachments in directories and just stiore the
attachment path in the database.
Databases are designed to handle arbitrarily large numbers of rows of
structured data, where each datum is
sofox wrote:
Message: Multi-statement transaction required more than
'max_binlog_cache_size'
bytes of storage; increase this mysqld variable and try again
Why don't you try doing what it suggests?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Kaj Arnö wrote:
So: For client licensing, nothing as changed -- but stay tuned for an
announcement next week!
Did I miss it? It's been almost 2 weeks, and I don't see anything in
the MySQL press release archive or your blog.
--
MySQL General Mailing List
For list archives:
Paul Warner wrote:
When a user enters text with a £ sign (Great Britain Pound) in the
browser and clicks enter, any insert or update statement apparently
gets truncated in mysql.
It's possible that somewhere along the line, the character is getting
translated to a multibyte Unicode format.
Paul Warner wrote:
Now we are in UTF-8, it is saving everything I can throw at it
without creating garbage characters. Whew.
Yep. Even though it wasn't the solution to your immediate problem,
switching to UTF-8 will prevent a whole class of future ones.
--
MySQL General Mailing List
For
of a commercial
license?
--
Warren Young
Maintainer of MySQL++ http://tangentsoft.net/mysql++/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
++ mailing list, not here.
--
Warren Young
MySQL++ Maintainer
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
year old
versions of GCC, either.
--
Warren Young
Maintainer of MySQL++
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Peter M. Groen wrote:
Still no luck. I'm trying to build libmysqld as a shared library for use in a
project.
This is a platform-specific issue. I don't see anything in this message
or your previous thread that tells the details about your platform.
What compiler, what operating system,
Fábio Emilio Costa wrote:
I'm working in a project in C++ using MySQL C API (Win98/Dev-C++
4.9.9.8/MySQL DevPak/MySQL 4.1.13) and I want to know if it's possible
to setup the server environment language (--language) via
mysql_options() function.
It seems that you are actually asking whether
Steven Altsman wrote:
checking whether mysql clients can run... no
configure: error: Your MySQL client libraries aren't properly installed
Read through config.log to see what test was tried, and how it failed.
I've looked at the PureFTP archives and they aren't particularly helpful
I take
Steven Altsman wrote:
cp /usr/local/mysql/lib/mysql/* /usr/lib
No no no! There are several better options:
1. Add /usr/local/mysql/lib/mysql to your system's dynamic loader
configuration. On Linux, for instance, this is /etc/ld.so.conf; you
need to run ldconfig after changing that file.
Karima Velasquez wrote:
character is: \ (backslash).
Of course that will cause problems. This is the escape character in
SQL, used extensively when inserting BLOB data. Again, I believe
MySQL++ would have prevented this problem, because its escape
manipulator would have escaped the
Karima Velasquez wrote:
i'm capturing raw audio/video data and want to store it into mysql. in my
c++ program i create the query to do this, i use sprintf to create this
query using %s format for the printing.
Um, you are aware that C strings (which sprintf uses) are
null-terminated, and
Karima Velasquez wrote:
i know about the null terminating character, but i don't think this is the
problem.
It might not be your immediate problem, but you will run into it eventually.
rigth data: 82
wrong data:
rigth data: ^
wrong data:
That should only happen if your column is set
Karima Velasquez wrote:
do you know about any sample code on
using BLOB columns using c++ to create querys???
C++, eh? I happen to be the MySQL++ maintainer. Two of its example
programs, cgi_image and load_file, deal with BLOBs.
http://tangentsoft.net/mysql++/
Notice the
Marco wrote:
So how can I do that?
There's nothing special you need to do with MySQL itself. Somehow your
program obtains UTF-8 data. Insert said data into database. That's it.
Perhaps you should read up on UTF-8, to see why this is so.
Again, don't expect the database server to be able
Sujay Koduri wrote:
I was connecting to MySQL 5.0.4 through the C API and it was workign fine.
But when I downgraded to MYSQL 4.1.13, the same code is giving the following
error.
Try rebuilding your program against the v4.1 APIs.
--
MySQL General Mailing List
For list archives:
Marco wrote:
So is there any solution on how I can properly use foreign characters
and store them in a MySQL 4.0 database?
You can store UTF-8 in any database in the world. UTF-8 is compatible
with any application capable of dealing with null-terminated strings of
8-bit characters.
Warren Young wrote:
That's why it's possible in the Unix/C world,
Typo: should be That's why it's _popular_...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Johnson, Michael wrote:
MySql is an 8th grade toy.
So why are you here? Go haunt an Oracle mailing list.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
When you have a stored procedure that returns a result set, it seems
that the server returns its results the same way as with a multi-query.
As a result, if you don't set the multi-query option when setting up
the connection with the C API, the server refuses to return the result
set. You
Maclen Marvit wrote:
1. The pexports did not find _mysql_server_init
That function is only needed when using the embedded MySQL server. It's
probably an optional configuration setting, so it's no big suprise that
you don't have that function. If you're connecting to a separate MySQL
Jan Bartholdy wrote:
I want to use a mysql database in a cygwin application (GRASS). Should I
install mysql under cygwin or does exist any possibilities to use the
database with myodbc under cygwin only? Thanks, Jan
I believe people have gotten MySQL to build under Cygwin, but you should
be
[EMAIL PROTECTED] wrote:
If I understand Cygwin correctly, it is a Linux shell that runs under
Windows.
Uh, sort of.
Cygwin is a GNU environment ported to Windows. You've got your bash,
your GCC, your ls, etc. To make all this work with minimal porting,
there's a Cygwin DLL and library
Brian Dunning wrote:
But I have to take it one more step: I want to first limit my found set
to those matching a different search criteria, and then find 50 of those.
SELECT id FROM bla WHERE whatever
That gets you a list of IDs that match the criteria. Then select 50
IDs, and issue the
Patrice Serrand wrote:
mysql_query (mysql, INSERT INTO db_unicode.unicode_tbl VALUES (6, _utf8
'atüpedâ' COLLATE utf8_general_ci));
I'm no Unicode expert, but I've never seen that _utf8 bit before. What
is it? Or more accurately, what do you expect it to do? I ask because
that
razat gupta wrote:
But it gives an exception on the reach of 150 connections.It should
allow us to create almost 500 connection.
Use netstat on the server to find out how many connections are actually
in use. You may find that your program is not properly closing down
connnections, for
I'm the maintainer for MySQL++ (a C++ wrapper for the MySQL C API) and
while digging through the code I found a reference to mysql_refresh(),
apparently a C API function. I can't find documentation for this
anywhere. What does it do?
If it's obsolete, I'd like to know that, too. I'll remove
Paul DuBois wrote:
It's not obsolete, just undocumented.
Okay, thanks. It's documented in MySQL++ now. :)
(It doesn't say more than that bug DB entry, so I doubt you want a
corresponding MySQL doc patch.)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Ankur G35 Saxena wrote:
All I had to do was rpm -Uvh --nodeps pkg_name
I have the MySQL AB RPMs running on Red Hat 9 just fine. I didn't have
to force them at all.
I suspect you had to force it because you had MySQL installed already.
The problem is, the Red Hat package is called mysql,
Jeff Justice wrote:
I'm not sure where I would go to
change the .bash_profile.
It's in your home directory. You land there just by opening a new
Terminal window. I suppose if you had to wimp out, you could probably say:
$ TextEdit .bash_profile
But real Unix users don't use GUI text
Ron Thomas wrote:
What do most people use for a report designer for linux?
Perl. :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David Kinyanjui wrote:
I have a mysql++ question... I'm not sure if this is right list to post
to.
It isn't. The MySQL++ mailing list's home is
http://lists.mysql.com/plusplus
Well, I just upgraded mysql++ from version 1.7.9 to 1.7.17.
1.7.21 is the current version. See
Warren Young wrote:
if (rs.begin() != rs.end())
That will never be true for any STL or STL-like container. I think you
want something like (rs.size() 0).
Sorry, I mean that will _always_ be true.
1. Glib::ustring lastname = row[LastName];
See the ChangeLog for why this does not work.
It's
Spenser wrote:
I'm trying to use the C++ API (a.k.a. MySQL++).
There's a mailing list dedicated to MySQL++. If you were subscribed,
you would have seen the messages announcing the changes that are causing
you problems.
The on-line manual
...is badly outdated.
when I downloaded the latest
David Brodbeck wrote:
Ext2 has not had a 2 gig filesize limit for a long time.
32-bit file offsets are still the default in Linux on 32-bit systems, so
these systems will still have the 2GB limit by default. You have to
compile your programs with special options to get 64-bit offsets.
I'm
Pascal Francq wrote:
OK, you use a C char* using an UTF-8 encoding.
That's very commmon in the Unix world. 2-byte encodings are very rare
on Unix-like systems, for compatibility reasons.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Carlos wrote:
have got no idea how to uninstall it completely off
the system.
You could try something vaguely like this:
# mkdir -p cd /tmp/mysqluninst
# cd /tmp/mysqluninst
# tar xvzf path-to-mysql-bin.tar.gz
# find . -exec rm /{} \;
DO NOT RUN THIS if you do not understand how it functions.
Steve Marquez wrote:
Does anyone know how to export a FileMaker Pro Database so that MySQL can
use it? Anyone ever do something like this?
If you want a one-time transfer, the simple and cheap way is through
some sort of text file; CVS or tab-delimited, for example.
If you want the two databases
Tuomas Heroja wrote:
I have red hat 8.0, gcc-3.2-7, gcc-c++-3.2-7 and
mysql++-1.7.9-3.rh8x.i386.rpm. When I use the command
g++ -I/usr/include/sqlplus myfirstdatabaseprogram.cpp, I get
several basic errors concerning the include file sqlplus.hh
Right now, MySQL++ isn't very well tuned for modern
76 matches
Mail list logo
