Intel Compiler
I am trying to use my binary Intel installation to compile PHP (which seems to be doing a _very_ simple program). So in a statically linked installation these references are defined in the embedded C library, but if one is linking it with another application, it isn't. Possibly the intel C library would need to be distributed with the binary application for the sake of linking with other applications? Thoughts? To quote the Intel C++ Compiler release notes: The Intel C++ Compiler uses two routines _intel_fast_memcpy and _intel_fast_memset to perform memcpy and memset operations that are not macro expanded to __builtin_memcpy and __builtin_memset in the source code. These are found in libirc. If you use the gcc compiler to link your application or if you directly call the linker, ld, you might find these unresolved symbols. For this reason, Intel recomends using the Intel C++ Compiler for linking, using the same compiler options used during the compilation phase. However, if you see these as undefined externals, either add -lirc to your link line, or change your includes so that memcpy and memset will be macro expanded to the builtin forms and recompile. The Intel C++ Compiler for IA-32 based applications calls a routine intel_proc_init from the main routine of any program to ensure that the processor is correctly set up. This routine is also found in libirc. These routines used further entry points from glibc, so -lirc needs to be placed before -lc on your command line. usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `read_rows': libmysql.o(.text+0xe60): undefined reference to `_intel_fast_memcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `mysql_real_connect.': libmysql.o(.text+0x3044): undefined reference to `_intel_fast_memcpy' /usr/local/mysql/lib/libmysqlclient.a(my_malloc.o): In function `my_memdup': my_malloc.o(.text+0x31): undefined reference to `_intel_fast_memcpy' /usr/local/mysql/lib/libmysqlclient.a(my_malloc.o): In function `my_strdup': my_malloc.o(.text+0x100): undefined reference to `_intel_fast_memcpy' /usr/local/mysql/lib/libmysqlclient.a(my_malloc.o): In function `my_strdup_with_length': my_malloc.o(.text+0x132): undefined reference to `_intel_fast_memcpy' /usr/local/mysql/lib/libmysqlclient.a(my_alloc.o)(.text+0x327): more undefined references to `_intel_fast_memcpy' follow collect2: ld returned 1 exit status configure: failed program was: #line 56453 configure #include confdefs.h /* Override any gcc2 internal prototype to avoid an error. */ /* We use char because int might match the return type of a gcc2 builtin and then its argument prototype would still apply. */ char mysql_error(); int main() { mysql_error() ; return 0; } -Mike _ Add photos to your messages with MSN Premium. Get 2 months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. -Mike From: Peter J Milanese [EMAIL PROTECTED] To: Roy Nasser [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:25:45 -0400 I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out though. I would think that instead of LVS Load Balancing, server failover might be a more viable path for MySQL. P Roy Nasser [EMAIL PROTECTED] 06/18/2004 01:58 PM To: [EMAIL PROTECTED] cc: Subject:MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ MSN Premium with Virus Guard and Firewall* from McAfee® Security : 2 months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
The meaning of that was client-side being sending inserts/updates to the master server. This would be done in the program/script upon an insert query. A daemon could forward insert/update requests to a master and all others round-robin and simply pass packets. This is if you have to make it seamless. Would require some work to make one though. -Mike From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:43:05 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. Daemons? Client side code? Can you explain this please? mysql handles all the replication. Depending on your setup, client won't know the difference. Its really all depends on how your replication is gonna be set up. - -- SUSHIDO--The way of the Tuna. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA0xuZld4MRA3gEwYRAv1EAKCot3j1j16j892FtrTEea8Brlk0NgCcCKou 9K0QzPH4uFz+TYynwdNpxbY= =a/OR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Free yourself from those irritating pop-up ads with MSn Premium. Get 2months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Safe Database Problem
Oh Jeeze- why didn't I think of removing this. When I upgraded the default is to have these two as 'Y', however, for some reason, that means that show databases shows all databases despite no permissions. That doesn't seem logical on one hand (if they don't have permissions to the database nor its tables, how could they create/lock on its tables), but on the other (they need to be able to see the databases to do a tmp table and a lock). In any case, problem fixed. I'm going to add a note to the docs to save people my troubles. Create_tmp_table_priv: Y Lock_tables_priv: Y Cheers; -M From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Safe Database Problem Date: Fri, 13 Feb 2004 13:38:50 +0200 Mike Miller [EMAIL PROTECTED] wrote: Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used the same data directory and ran the fix_privs script as instructed to all all of the required fields to the mysql.* tables as it did. ALl of this is successful and I can see it all there when I browse these tables. I did a flush privs, reloaded the whole daemon a few times to no avail. All users besides root have been revoked (actually they never had) show databases permission, yet all users are still able to execute show databses and receive a list of hundreds of databases. SHOW VARIABLES keeps telling me that skip show database is OFF, yet I can't seem to change it with any combo of startup parameters or set commands due to it being a 'depreciated variable' in all the docs. I don't see what I'm missing. Is there a trick with the new versions which I'm not getting? Check privileges of those users. If they have such global privileges (on all databases) as SELECT, UPDATE etc. or CREATE TEMPORARY TABLES, LOCK TABLES, they also can see databases in the output of SHOW DATABASES. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Safe Database Problem
Hi, I believe I've done everything from the book and have been fighting with the same problem for about 6 hours thus far. I just upgraded from MySQL 3.23.56 to 4.0.17. In the old system, I prevented show databases from ordinary users using skip-show-databases. In order to upgrade I used the same data directory and ran the fix_privs script as instructed to all all of the required fields to the mysql.* tables as it did. ALl of this is successful and I can see it all there when I browse these tables. I did a flush privs, reloaded the whole daemon a few times to no avail. All users besides root have been revoked (actually they never had) show databases permission, yet all users are still able to execute show databses and receive a list of hundreds of databases. SHOW VARIABLES keeps telling me that skip show database is OFF, yet I can't seem to change it with any combo of startup parameters or set commands due to it being a 'depreciated variable' in all the docs. I don't see what I'm missing. Is there a trick with the new versions which I'm not getting? Thanks in advance, -M _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/viruspgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thread Stack
I receive the following warning in my hostname.err file after upgrading from 3.23.56 to 4.0.17. Any ideas what's causing it and how to fix it? Warning: Asked for 196608 thread stack, but got 126976 Trying to find the source- maybe a setting is too high? Linux 2.4.x Thanks in advance, -M _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=dept/bcommpgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Unique IDs
code it within your program. If this is in fact a primary key (whcih you seem to describe it as), then it should be distinct anyway. So do an INSERT IGNORE or even just an INSERT. It will fail upon duplicates. Check the affected rows or the insert_id (using whatever API you use to access MySQL), sleep for a second, then try the insert again. I doubt there's a good way to hang up the database on the issue. Cheers; -M From: Craig Jackson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Keith C. Ivey [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: Unique IDs Date: Thu, 12 Feb 2004 11:57:24 -0600 On Thu, 2004-02-12 at 11:47, Keith C. Ivey wrote: Craig Jackson [EMAIL PROTECTED] wrote: I have a very large web app that uses timestamp for unique IDs. Everything was rolling fine until we started getting many users per second, causing some of the unique IDs to not be unique -- users were being assigned the same timestamp. Since the web app is so large we don't want to change the method of assigning IDs as it would create a major project. I don't understand. If you're getting many users per second, and your timestamps have 1-second resolution, how could you possibly solve the problem without changing the method of assigning IDs? Are the many users per second periods just short bursts, and you're really only getting several hundred users per day? If so, I guess you could keep waiting a second and trying the insert again, but that could lead to indefinite delays if traffic gets high. I think you've got to bite the bullet and change the unique ID to something that's actually unique -- even an AUTO_INCREMENT would work. Thanks for the speedy reply and I have already recommended auto_increment for the solution. We do need that quick fix until the problem is fixed. How would I go about making Mysql wait one second between inserts. We only get about 1000 hits per day, but they tend to be concentrated in short time intervals. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/photospgmarket=en-caRU=http%3a%2f%2fjoin.msn.com%2f%3fpage%3dmisc%2fspecialoffers%26pgmarket%3den-ca -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connect to MySQL via PHP
The _only_ real benefit of Apache2 over Apache1 is it's thread-based model. So why leave a stable, tried-and-true, robust Apache1 platform for no additional benefits at all? Why break compatibility? Why use the Apache2 branch if you don't need it? PHP itself works quite fine in a threaded mode. However, PHP uses an enormous number of libraries (GD, database libs, and many others) which may-or-may-not-be thread-safe. So these libraries can cause some serious problems... and when you're in a threaded model, programs doing funny things is not only difficult to track down, but also can cause serious issues with all of the other threads (due to shared process context on the system and shared memory). Lesson- just avoid it for the time being. Save a headache and additional security patches. -M From: Adam Goldstein [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] CC: Don Read [EMAIL PROTECTED],Eric W.Holzapfel [EMAIL PROTECTED] Subject: Re: Connect to MySQL via PHP Date: Thu, 12 Feb 2004 13:05:00 -0500 Apache2 and php is a buggy combination? Not that I have seen. Or are you referring to trying to use the Apache Worker (mutlithreaded) MPM with php... I believe that is still a bit buggy, though, no rpms or packages seem to install it that way anyways. I'm hoping to get workerMPM working for me, too, as I have been having to use thttpd for serving images recently. I'm not sure how horked up RHES3 is, but, std. RH7-9, Mandrake 7.2-9.2, Debian 3+ (among others) seem to have no problem what so ever connecting php-mysql out of the box, provided you have a user account on mysql to connect to and supply it in your my.cnf, php.ini or mysql_connect statements. keep in mind rh and mdk broke up the portions of php into separate packages... such as php-imap, php-mysql, php-cli, php-ldap, etc. You will need to install the php-mysql package if mysql_connect is not being recognized. Also note, mdk has further separated the php.ini file to use separate php include files, similar to how they broke up apache's module configs... the structure is /etc/php.ini and /etc/php/#_phpmodulename.ini..they load in order of their number... This is good to keep in mind, as the mysql settings are no longer included in the primary php.ini file but in 34_mysql.ini. -- Adam Goldstein White Wolf Networks http://whitewlf.net On Feb 10, 2004, at 10:34 PM, Don Read wrote: On 11-Feb-2004 Eric W. Holzapfel wrote: Hello Listers, I have a problem with my PHP/redhat setup, and possible problem with my Mysql setup. I have Apache (2.0) and PHP (4.3.2) installed on a Red Hat 3.0 ES system. Apache 2.0 + PHP is a known buggy combination. I have MySql installed on a Slackware linux box. Server on a remote host? Gotcha. I want to be able to use Apache/PHP to connect to the mysql database on the slackware box. I think that PHP is set up ok, which may be a lie, because PHP says it does not recognize the commands like - mysql_pconnect and mysql_connect. No, wait, lemme guess. Like 'function not defined' ? (eat your heart out, Miss Cleo) Also if I try to connect to the database using something like this: mysql://user,[EMAIL PROTECTED] demodb this fails and the or die getMessage() returns DB: no such database. (I am trying to use the Pear DB here) Do I need to have mysql installed on the red hat machine? You'll need to compile in the client libs at least. I can connect to the slackware linux box from a Windows machine using ODBC. So your server is working and accepting remote connections. This is a good thing! Any ideas on what I have not done, or what I have done wrong? You haven't configured the Redhat PHP install to build in the MySQL client libraries. To verify this --try this script: --- ?php phpinfo(); ? --- Look for '--with-mysql' in the Configure Command section. Also look for a MySQL Support section. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going tosteal the neighbor's newspaper, that's the time to do it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MERGE tables still gamma?
The manual page for MERGE tables states the code is in gamma since 3.23.25. But it also says you can only SELECT, DELETE, and UPDATE, which isn't true since version 4.0.something. Can anyone verify if the MERGE tables is still in gamma? We occassionally have diskspace issues on our system, and I'd love to split our invoice table into years and use pack on the old years and replace the original table with a MERGE. -- Mike Miller Business Analyst Applications Developer BMG Canada Inc. Tel: 416-586-1646 Fax: 416-586-0454 EMail: [EMAIL PROTECTED]
INDEX not getting used
I get the following results when doing a SELECT off a single table I have. What's bizarre is that the index is no longer used when i expand my list of states to be included. mysql EXPLAIN SELECT * FROM shipping USE INDEX (state) WHERE state IN ('TN','NY'); +--+---+---++-+--+-- ++ | table| type | possible_keys | key| key_len | ref | rows | Extra | +--+---+---++-+--+-- ++ | ship_to_customer | range | state_code| state_code | 3 | NULL | 433 | where used | +--+---+---++-+--+-- ++ mysql EXPLAIN SELECT * FROM shipping USE INDEX (state) WHERE state IN ('TN','NY','MN','LA'); +--+--+---+--+-+--+--+-- --+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +--+--+---+--+-+--+--+-- --+ | ship_to_customer | ALL | state_code| NULL |NULL | NULL | 2298 | where used | +--+--+---+--+-+--+--+-- --+ Anyone have any suggestions as to where I could look to fix this up? -- Mike Miller -- Happy 20'th Birthday, Mr. Smiley :-) http://research.microsoft.com/~mbj/Smiley/Smiley.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to set permissions?
This might not be the best way, but for the people here at my office who aren't familiar with command line interfaces, I've setup MyODBC and MS Access. This let's them add/edit user's account info directly. The only thing you can't do (afaik), is change a user's password. -- Mike Miller -- [EMAIL PROTECTED] -Original Message- From: Yana [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 14, 2002 10:01 AM To: [EMAIL PROTECTED] Subject: RE: How to set permissions? Helo! Is there any other way to set permissions to the list of tables in mysql db (big list!) with similar names (f.e. c%), then running a script on it? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Bug or Misunderstanding
Perhaps I misunderstand how the UNION statement is to be used, but the following query doesn't work as I'd expect: SELECT column_id, SUM(column_a) AS positive_a FROM table_a WHERE column_b = 'positive' UNION SELECT column_id, SUM(column_a) AS negative_a FROM table_a WHERE columb_b = 'negative' I would expect to receive three columns back (column_id, positive_a, negative_a), but what I receive is two columns, with the duplicate column_id's and the negative_a results being lumped under the positive_a column. Can anyone point me in the right direction on this? This is MysQL 4.0.1 FreeBSD binary install. -- Mike Miller, BMG Canada Inc. Tel: 416-586-1646 Fax: 416-586-1661 EMail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Wildcard Hostname's in MySQL 3.23.41
I just made the upgrade from 3.22 to 3.23.41 this weekend and had one little hiccup. I have a few users with host entries with wildcards (hostname = '%'). These users stopped working and were not able to login. When I added one for the hosts they were connecting from, it began to work fine. This is all in the users table of the MySQL database. Is there something I have to do to get wildcard hostnames to work again? Networking is enabled in case that makes a difference. Please help. Thanks in advance; -- Mike query _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php