Bob,
Your questions are really far too broad for this list. I will give
them a shot but you wont find them very helpful, I'm afraid. And the
Kitchen company won't come into it.
a.. What advantages does a database have over flat-file systems ?
This could be the subject of an essay. In fa
Need some facts for a Report ...
For a hypothetical Kitchen Company's shopping Catalogue.
a.. What advantages does a database have over flat-file systems ?
b.. Are there any disadvantages in switching to a database solution ?
c.. What is MySQL, and how does it relate to ASP, Javascript/VBs
Hi,
probably your system is swapping on disk,
immediately reduce the sort_buffer_size, it is a per connection buffer, and
your setting is way too high:
sort_buffer_size=1000M (with 8 client threads you finish your ram)
set it to something between 256K and 8 M
sort_buffer_size=1M
also
read_rn
Memory tables use hash indexes by default instead of b-tree. Try
changing the index, that should help significantly.
regards,
Walter
On Tue, Mar 31, 2009 at 6:47 PM, mos wrote:
> I'm using MySQL 5.1.30 and have several memory tables with indexes on the
> appropriate columns. When I try and join
http://www.daevid.com/content/examples/snippets.php
scroll down to "Automatic Monitoring of remote servers"
You'll need Gnome, ssh keys (for remote execution), .mytop file, wmctrl and
xtrlock.
Helo there guys today ive got a brig problem my server that runs only Mysql
is undegoind a very load, the server is ok but memory and cpu usage are very
high
mys server configuration is a
2x Quad Core Intel® Xeon® E5450, 2x6MB Cache, 3.0GHz, 1333MHz FSB
8GB 800MHz Memory
2x SAS 73GB 15000RPM in RA
You can use this structure with MyISAM tables. It will work fine
except you won't have the advantage of database-level enforcement of
foreign key constraints--do it with code.
Or use InnoDB tables (enable/load the innobase plugin.)
--
MySQL General Mailing List
For list archives: http://li
I'm using MySQL 5.1.30 and have several memory tables with indexes on the
appropriate columns. When I try and join 2 particular memory tables
together to get 5k rows, it takes 90 seconds.
This is incredibly slow considering table1 has 11k rows and table2 has 5k
rows. A table join like this shoul
Hi,
First off, you have to forgive my ignorance, I'm not very savvy with
DBs so I hope that I explain myself correctly.
I have an anomaly on a development system. There are several fields
with the type set as bigint(20) that are meant to store a bit pattern.
The pattern is used to determine count
I have a stored procedure that inserts a record that I call from a
PreparedStatement. When I call #getGeneratedKeys it always returns a
null result set. Is that expected behavior?
Robert DiFalco | Chief Technology Officer (Products)
Direct: 503.276.7564
Mobile: 503.890.4994
Charlotte Caswell
Using MySQL 5.0.67 on OpenSolaris 2008.11, whenever I hit Ctrl-C to
terminate a long-running test query, it hangs while it kills the thread.
No problem here. If I accidentally (or impatiently) hit Ctrl-C again,
it terminates the MySQL CLI. Again, no problem here. What's getting me
is that o
Ladies, gentlemen,
Upscene Productions is proud to announce the next
version of the popular database development tool:
" Database Workbench Pro 3.3 "
Changes Highlights in 3.3
-
- Better Stored Routine Debugger
- Ability to cancel import/export processes
- Mo
Hi,
I have a table 'test'
+-+--+--+-+---
++
| Field | Type | Null | Key | Default |
Extra |
+-+--+--+-+---
++
| id | int(11) | NO |
Hi Andy,
I used the same user.
I list the steps that I made:
on the server MySQL (10.43.249.17) I created the user:
GRANT ALL PRIVILEGES ON *.* TO 'pippo'@'%' IDENTIFIED BY '*';
then, on the same server:
mysql --ssl-ca=/root/openssl/cacert.pem -u pippo -p
Enter password:
Welcome to the
14 matches
Mail list logo