All Questions
Tagged with web-server mysql
10 questions
-1
votes
2
answers
395
views
Creating Tables with the same table names from other databases doesn't have any bad effects?
I have a WordPress website and I cloned it to another website(domain) using a plugin called Duplicator. So in the backend, phpMyAdmin, I've two different databases but all the tables in both databases ...
0
votes
2
answers
63
views
Does my database need to connect to a server? [closed]
I'm very new to SQL and databases. I'm currently following this tutorial for creating a Magento website: https://www.tutorialspoint.com/magento/magento_installation.htm
and I'm on Step 4. It says to ...
- 11
0
votes
1
answer
739
views
Cannot allocate memory for the buffer pool when using remote access MySQL
I tried to separate the webserver and mysql server.
MySQL server = 16GB RAM and the config of Innodb_buffer_pool_size = 10GB. And
my Web server = 4GB RAM
My website connect to my database server ...
0
votes
1
answer
6k
views
Where is the data stored in MySQL databases?
I don't know much about RDBMS but I am interested, I am working on a project which requires a database, I am planning to use MySQL to maintain that database.
I have installed MySQL on macOS and I have ...
user120246
1
vote
1
answer
104
views
Sessionizing Web Log Data using MySQL (perhaps by simulating window functions)
I have a large MySQL Table containing about 15 Million rows of web log data. Depending on the IP, useragent and site_id (different sections on the website) I want to create user sessions. The session ...
- 55
2
votes
1
answer
7k
views
best way to store tags
I'm a university student building a web application for a project with three collegues , I took the database portion.
Our site is basically a link sharing site and supports tags, what is an efficient ...
- 121
3
votes
2
answers
23k
views
mysql connection timeout on small traffic server
How can I set up MySQL so that connections never time out? And how do I even check to see what the current settings for variables such as wait_timeout and interactive_timeout, etc. are? Given that ...
- 487
0
votes
1
answer
634
views
How to get mysql automatically running when I start tomcat apache on Windows?
When starting my Tomcat Apache Server, I've been having to start up mysql before than using the mysqld command. I was wondering if there was a work around this so that I could have mysql start up when ...
- 1
1
vote
1
answer
2k
views
MySQL Tables crashing randomly
This is one of the many random Tables that get corrupted. Any ideas why and what would be causing this?
How do I keep MySQL tables from crashing and MySQL from crashing?
Repairing USR_wp537
...
- 185
3
votes
1
answer
713
views
Does MVC architecture design pattern effect MySQL database performance?
Our current site is entirely developed in the cakePHP framework with the MVC architecture. If we notice more than around 19-20 users viewing the site at once, it begins to crawl to a hault and begin ...
- 227